Complete set of MySQL basic introduction, basic + advanced-Free online video tutorial-php.cn

Chapter1Complete collection of MySQL basics (1): Get to know the MySQL database
28 minutes16 seconds; MySQL basic operation commands
32 minutes47 seconds; Data types in MySQL
21 minutes02 seconds; Type constraints and operations in MySQL
18 minutes01 seconds; Detailed explanation of MySQL data table operations
31 minutes01 seconds; Table engine in MySQL database
23 minutes34 seconds; Character set utf8 in MySQL
11 minutes29 seconds; MySQL DML operation-data addition, deletion and modification
08 minutes16 seconds; MySQL query statement-retrieve data select
11 minutes46 seconds; MySQL data query-OrderBy sorting
04 minutes31 seconds
Chapter2Complete collection of MySQL basics (2): Where condition for MySQL data query
15 minutes54 seconds; MySQL query statement-Like and wildcards
09 minutes47 seconds; Calculation of fields in MySQL query
02 minutes33 seconds; Introduction to common functions of MySQL query
14 minutes36 seconds; Aggregation function and GroupBy grouping of MySQL query statements
27 minutes43 seconds; Import and export of MySQL database data
09 minutes28 seconds; MySQL database permission management
10 minutes45 seconds; Python operates mysql
20 minutes21 seconds; Code optimization and other manipulation of data
12 minutes52 seconds; Basic implementation of Flask framework
12 minutes29 seconds
Chapter3Complete collection of MySQL basics (3): Design and creation of message board database
10 minutes26 seconds; Web message board list display
18 minutes42 seconds; Add form for web message board
15 minutes32 seconds; Messages from the web message board are stored in the database
10 minutes40 seconds; Deletion of messages on web message boards
06 minutes51 seconds; Subquery and table join-use of subquery
23 minutes55 seconds; Subquery with table join - using subquery as calculated field
11 minutes19 seconds; Table relationship - what is a relationship table
08 minutes51 seconds; Table relationship-one-to-one relationship and foreign key
16 minutes37 seconds; Table relationship-one-to-many relationship
08 minutes11 seconds
Chapter4Complete collection of MySQL basics (4): Table relationship-many-to-many relationship
12 minutes11 seconds; Table join - usage of table join where and join
25 minutes01 seconds; Table join - self join in join query
19 minutes49 seconds; Table join-outer join-left join and right join
21 minutes24 seconds; UNION joint query
13 minutes35 seconds; SQL advanced exercises-01.SQL exercises
20 minutes48 seconds; SQL advanced exercises-02.SQL exercises
03 minutes24 seconds; SQL advanced exercises-03.SQL exercises
02 minutes06 seconds; SQL advanced exercises-04.SQL exercises
03 minutes34 seconds; SQL advanced exercises-05.SQL exercises
05 minutes32 seconds; SQL advanced exercises-06-07.SQL exercises
05 minutes07 seconds
Chapter5Complete collection of MySQL basics (5): SQL advanced exercises-08-11.SQL exercises
08 minutes27 seconds; SQL advanced exercises-12.SQL exercises
09 minutes32 seconds; SQL advanced exercises-detailed explanation of sql_mode
17 minutes23 seconds; SQL advanced exercises-13-16sql exercises
09 minutes58 seconds; SQL advanced exercises-16.sql exercises-scores of all students
11 minutes57 seconds; SQL advanced exercises-17.sql exercises-CASE WHEN usage
18 minutes57 seconds; SQL advanced exercises-18-19.sql exercises-subject ranking
27 minutes41 seconds; SQL advanced exercises-remaining sql exercises
09 minutes01 seconds; SQL advanced interview questions-1. Students with a score greater than 80
11 minutes30 seconds; SQL advanced interview questions-2. ID with a higher temperature than yesterday
09 minutes58 seconds
Chapter6Complete collection of MySQL basics (6): SQL advanced interview questions-3. The maximum level of the anchor
08 minutes27 seconds; SQL advanced interview questions-4. Course data row to column conversion
09 minutes15 seconds; SQL advanced interview questions-SQL query in 5.update
16 minutes16 seconds; MySQL Transaction-1. Basic overview and operations of transactions
28 minutes47 seconds; MySQL Transaction-2. Different isolation levels of transactions
34 minutes24 seconds; MySQL advanced extension-stored procedure
20 minutes34 seconds; MySQL advanced extension-trigger
12 minutes47 seconds; MySQL advanced extension-view
14 minutes45 seconds; MySQL Index and SQL Optimization-Overview and Classification of Indexes
18 minutes05 seconds; MySQL index principle-index and B+Tree
37 minutes39 seconds; MySQL slow query and SQL optimization
32 minutes51 seconds; Software tool installation-Mac system
10 minutes51 seconds; Software tool installation-win10 system
14 minutes48 seconds

Complete set of MySQL basic introduction, basic + advanced

About Instructor

php.cn