Section1 Database concepts

19 minutes19 seconds

Section2 mysql entry statement

43 minutes17 seconds

Section3 Introduction to add, delete, modify and query statements

20 minutes09 seconds

Section4 Bytes and storage range of integer columns

39 minutes23 seconds

Section5 Optional attributes for integer columns

22 minutes29 seconds

Section6 floating point column

26 minutes11 seconds

Section7 character column

29 minutes45 seconds

Section8 Datetime column type

46 minutes06 seconds

Section9 Table creation case

11 minutes13 seconds

Section10 Detailed explanation of syntax for adding, deleting and modifying

30 minutes53 seconds

Section11 Install ecshop and phpMyAdmin

31 minutes45 seconds

Section12 Stage summary (1)

17 minutes24 seconds

Section13 Detailed explanation of where

31 minutes40 seconds

Section14 Detailed explanation of group

31 minutes42 seconds

Section15 having detailed explanation

19 minutes19 seconds

Section16 mysql written test questions

09 minutes59 seconds

Section17 orderby.limit use

35 minutes39 seconds

Section18 5 pitfalls in using clauses

23 minutes00 seconds

Section19 where type subquery

16 minutes28 seconds

Section20 from subquery

18 minutes22 seconds

Section21 exists subquery

12 minutes48 seconds

Section22 Stage summary (2)

13 minutes31 seconds

Section23 union

54 minutes05 seconds

Section24 Join query concept and left join syntax

42 minutes22 seconds

Section25 The difference between left and right inner joins

37 minutes59 seconds

Section26 Left connection written test questions

24 minutes29 seconds

Section27 Addition, deletion and modification of columns in table management

14 minutes43 seconds

Section28 view

57 minutes58 seconds

Section29 Character sets and proofreading sets

47 minutes00 seconds

Section30 Stage summary (3)

27 minutes11 seconds

Section31 Basic concepts of triggers

12 minutes29 seconds

Section32 trigger syntax

27 minutes41 seconds

Section33 Trigger practice (order and inventory management)

28 minutes46 seconds

Section34 The difference between before and after

14 minutes00 seconds

Section35 Storage engine and transaction concepts

37 minutes22 seconds

Section36 transaction syntax

21 minutes21 seconds

Section37 Database backup and recovery

29 minutes47 seconds

Section38 Index concept

31 minutes00 seconds

Section39 Index management

29 minutes09 seconds

Section40 Full-text indexing and stop words

32 minutes53 seconds

Section41 stored procedure

19 minutes47 seconds