Database concepts
19 minutes19 secondsmysql entry statement
43 minutes17 secondsIntroduction to add, delete, modify and query statements
20 minutes09 secondsBytes and storage range of integer columns
39 minutes23 secondsOptional attributes for integer columns
22 minutes29 secondsfloating point column
26 minutes11 secondscharacter column
29 minutes45 secondsDatetime column type
46 minutes06 secondsTable creation case
11 minutes13 secondsDetailed explanation of syntax for adding, deleting and modifying
30 minutes53 secondsInstall ecshop and phpMyAdmin
31 minutes45 secondsStage summary (1)
17 minutes24 secondsDetailed explanation of where
31 minutes40 secondsDetailed explanation of group
31 minutes42 secondshaving detailed explanation
19 minutes19 secondsmysql written test questions
09 minutes59 secondsorderby.limit use
35 minutes39 seconds5 pitfalls in using clauses
23 minutes00 secondswhere type subquery
16 minutes28 secondsfrom subquery
18 minutes22 secondsexists subquery
12 minutes48 secondsStage summary (2)
13 minutes31 secondsunion
54 minutes05 secondsJoin query concept and left join syntax
42 minutes22 secondsThe difference between left and right inner joins
37 minutes59 secondsLeft connection written test questions
24 minutes29 secondsAddition, deletion and modification of columns in table management
14 minutes43 secondsview
57 minutes58 secondsCharacter sets and proofreading sets
47 minutes00 secondsStage summary (3)
27 minutes11 secondsBasic concepts of triggers
12 minutes29 secondstrigger syntax
27 minutes41 secondsTrigger practice (order and inventory management)
28 minutes46 secondsThe difference between before and after
14 minutes00 secondsStorage engine and transaction concepts
37 minutes22 secondstransaction syntax
21 minutes21 secondsDatabase backup and recovery
29 minutes47 secondsIndex concept
31 minutes00 secondsIndex management
29 minutes09 secondsFull-text indexing and stop words
32 minutes53 secondsstored procedure
19 minutes47 seconds