Cheetah.com MySQL video tutorial

• Chapter1 Getting Started with MySQL Basics
• 1-1 Install MySQL and Navicat
• 1-2 Create a Northwind database
• 1-3 Understand SQL
• 1-4 Introduction to MySQL
• 1-5 MySQL data types
• Chapter2 MySQL application
• 2-1 UseMySQL
• 2-2 Retrieve data
• 2-3 Sort retrieval data
• 2-4 Filter data
• 2-5 Data filtering
• 2-6 Filter with wildcards
• 2-7 Search with regular expressions
• 2-8 Create a calculated field
• 2-9 Use data processing functions
• 2-10 Aggregate data
• 2-11 grouped data
• 2-12 Use subquery
• 2-13 join table
• 2-14 Use different types of joins
• 2-15 Combined query
• 2-16 Full text search
• 2-17 Insert data
• 2-18 Update and delete data
• 2-19 Create and manipulate tables
• 2-20 Use views
• 2-21 Use stored procedures
• 2-22 Using cursors
• 2-23 Use triggers
• 2-24 management transactions
• 2-25 Globalization and localization
• 2-26 Security management
• 2-27 database maintenance
• 2-28 Improve performance