Complete set of MySQL basic introduction, basic + advanced

• Chapter1 Complete collection of MySQL basics (1)
• 1-1 Get to know the MySQL database
• 1-2 MySQL basic operation commands
• 1-3 Data types in MySQL
• 1-4 Type constraints and operations in MySQL
• 1-5 Detailed explanation of MySQL data table operations
• 1-6 Table engine in MySQL database
• 1-7 Character set utf8 in MySQL
• 1-8 MySQL DML operation-data addition, deletion and modification
• 1-9 MySQL query statement-retrieve data select
• 1-10 MySQL data query-OrderBy sorting
• Chapter2 Complete collection of MySQL basics (2)
• 2-1 Where condition for MySQL data query
• 2-2 MySQL query statement-Like and wildcards
• 2-3 Calculation of fields in MySQL query
• 2-4 Introduction to common functions of MySQL query
• 2-5 Aggregation function and GroupBy grouping of MySQL query statements
• 2-6 Import and export of MySQL database data
• 2-7 MySQL database permission management
• 2-8 Python operates mysql
• 2-9 Code optimization and other manipulation of data
• 2-10 Basic implementation of Flask framework
• Chapter3 Complete collection of MySQL basics (3)
• 3-1 Design and creation of message board database
• 3-2 Web message board list display
• 3-3 Add form for web message board
• 3-4 Messages from the web message board are stored in the database
• 3-5 Deletion of messages on web message boards
• 3-6 Subquery and table join-use of subquery
• 3-7 Subquery with table join - using subquery as calculated field
• 3-8 Table relationship - what is a relationship table
• 3-9 Table relationship-one-to-one relationship and foreign key
• 3-10 Table relationship-one-to-many relationship
• Chapter4 Complete collection of MySQL basics (4)
• 4-1 Table relationship-many-to-many relationship
• 4-2 Table join - usage of table join where and join
• 4-3 Table join - self join in join query
• 4-4 Table join-outer join-left join and right join
• 4-5 UNION joint query
• 4-6 SQL advanced exercises-01.SQL exercises
• 4-7 SQL advanced exercises-02.SQL exercises
• 4-8 SQL advanced exercises-03.SQL exercises
• 4-9 SQL advanced exercises-04.SQL exercises
• 4-10 SQL advanced exercises-05.SQL exercises
• 4-11 SQL advanced exercises-06-07.SQL exercises
• Chapter5 Complete collection of MySQL basics (5)
• 5-1 SQL advanced exercises-08-11.SQL exercises
• 5-2 SQL advanced exercises-12.SQL exercises
• 5-3 SQL advanced exercises-detailed explanation of sql_mode
• 5-4 SQL advanced exercises-13-16sql exercises
• 5-5 SQL advanced exercises-16.sql exercises-scores of all students
• 5-6 SQL advanced exercises-17.sql exercises-CASE WHEN usage
• 5-7 SQL advanced exercises-18-19.sql exercises-subject ranking
• 5-8 SQL advanced exercises-remaining sql exercises
• 5-9 SQL advanced interview questions-1. Students with a score greater than 80
• 5-10 SQL advanced interview questions-2. ID with a higher temperature than yesterday
• Chapter6 Complete collection of MySQL basics (6)
• 6-1 SQL advanced interview questions-3. The maximum level of the anchor
• 6-2 SQL advanced interview questions-4. Course data row to column conversion
• 6-3 SQL advanced interview questions-SQL query in 5.update
• 6-4 MySQL Transaction-1. Basic overview and operations of transactions
• 6-5 MySQL Transaction-2. Different isolation levels of transactions
• 6-6 MySQL advanced extension-stored procedure
• 6-7 MySQL advanced extension-trigger
• 6-8 MySQL advanced extension-view
• 6-9 MySQL Index and SQL Optimization-Overview and Classification of Indexes
• 6-10 MySQL index principle-index and B+Tree
• 6-11 MySQL slow query and SQL optimization
• 6-12 Software tool installation-Mac system
• 6-13 Software tool installation-win10 system