Cheetah.com MySQL video tutorial

Install MySQL and Navicat

Create a Northwind database

Understand SQL

Introduction to MySQL

MySQL data types

UseMySQL

Retrieve data

Sort retrieval data

Filter data

Data filtering

Filter with wildcards

Search with regular expressions

Create a calculated field

Use data processing functions

Aggregate data

grouped data

Use subquery

join table

Use different types of joins

Combined query

Full text search

Insert data

Update and delete data

Create and manipulate tables

Use views

Use stored procedures

Using cursors

Use triggers

management transactions

Globalization and localization

Security management

database maintenance

Improve performance