1-1 Database concepts

1-2 mysql entry statement

1-3 Introduction to add, delete, modify and query statements

1-4 Bytes and storage range of integer columns

1-5 Optional attributes for integer columns

1-6 floating point column

1-7 character column

1-8 Datetime column type

1-9 Table creation case

1-10 Detailed explanation of syntax for adding, deleting and modifying

1-11 Install ecshop and phpMyAdmin

1-12 Stage summary (1)

1-13 Detailed explanation of where

1-14 Detailed explanation of group

1-15 having detailed explanation

1-16 mysql written test questions

1-17 orderby.limit use

1-18 5 pitfalls in using clauses

1-19 where type subquery

1-20 from subquery

1-21 exists subquery

1-22 Stage summary (2)

1-23 union

1-24 Join query concept and left join syntax

1-25 The difference between left and right inner joins

1-26 Left connection written test questions

1-27 Addition, deletion and modification of columns in table management

1-28 view

1-29 Character sets and proofreading sets

1-30 Stage summary (3)

1-31 Basic concepts of triggers

1-32 trigger syntax

1-33 Trigger practice (order and inventory management)

1-34 The difference between before and after

1-35 Storage engine and transaction concepts

1-36 transaction syntax

1-37 Database backup and recovery

1-38 Index concept

1-39 Index management

1-40 Full-text indexing and stop words

1-41 stored procedure