Get to know the MySQL database

MySQL basic operation commands

Data types in MySQL

Type constraints and operations in MySQL

Detailed explanation of MySQL data table operations

Table engine in MySQL database

Character set utf8 in MySQL

MySQL DML operation-data addition, deletion and modification

MySQL query statement-retrieve data select

MySQL data query-OrderBy sorting

Where condition for MySQL data query

MySQL query statement-Like and wildcards

Calculation of fields in MySQL query

Introduction to common functions of MySQL query

Aggregation function and GroupBy grouping of MySQL query statements

Import and export of MySQL database data

MySQL database permission management

Python operates mysql

Code optimization and other manipulation of data

Basic implementation of Flask framework

Design and creation of message board database

Web message board list display

Add form for web message board

Messages from the web message board are stored in the database

Deletion of messages on web message boards

Subquery and table join-use of subquery

Subquery with table join - using subquery as calculated field

Table relationship - what is a relationship table

Table relationship-one-to-one relationship and foreign key

Table relationship-one-to-many relationship

Table relationship-many-to-many relationship

Table join - usage of table join where and join

Table join - self join in join query

Table join-outer join-left join and right join

UNION joint query

SQL advanced exercises-01.SQL exercises

SQL advanced exercises-02.SQL exercises

SQL advanced exercises-03.SQL exercises

SQL advanced exercises-04.SQL exercises

SQL advanced exercises-05.SQL exercises

SQL advanced exercises-06-07.SQL exercises

SQL advanced exercises-08-11.SQL exercises

SQL advanced exercises-12.SQL exercises

SQL advanced exercises-detailed explanation of sql_mode

SQL advanced exercises-13-16sql exercises

SQL advanced exercises-16.sql exercises-scores of all students

SQL advanced exercises-17.sql exercises-CASE WHEN usage

SQL advanced exercises-18-19.sql exercises-subject ranking

SQL advanced exercises-remaining sql exercises

SQL advanced interview questions-1. Students with a score greater than 80

SQL advanced interview questions-2. ID with a higher temperature than yesterday

SQL advanced interview questions-3. The maximum level of the anchor

SQL advanced interview questions-4. Course data row to column conversion

SQL advanced interview questions-SQL query in 5.update

MySQL Transaction-1. Basic overview and operations of transactions

MySQL Transaction-2. Different isolation levels of transactions

MySQL advanced extension-stored procedure

MySQL advanced extension-trigger

MySQL advanced extension-view

MySQL Index and SQL Optimization-Overview and Classification of Indexes

MySQL index principle-index and B+Tree

MySQL slow query and SQL optimization

Software tool installation-Mac system

Software tool installation-win10 system