Section1 UseMySQL

10 minutes33 seconds

Section2 Retrieve data

17 minutes12 seconds

Section3 Sort retrieval data

09 minutes11 seconds

Section4 Filter data

09 minutes21 seconds

Section5 Data filtering

13 minutes28 seconds

Section6 Filter with wildcards

14 minutes57 seconds

Section7 Search with regular expressions

26 minutes27 seconds

Section8 Create a calculated field

11 minutes15 seconds

Section9 Use data processing functions

21 minutes53 seconds

Section10 Aggregate data

13 minutes08 seconds

Section11 grouped data

12 minutes35 seconds

Section12 Use subquery

14 minutes00 seconds

Section13 join table

20 minutes08 seconds

Section14 Use different types of joins

25 minutes52 seconds

Section15 Combined query

11 minutes37 seconds

Section16 Full text search

21 minutes35 seconds

Section17 Insert data

16 minutes57 seconds

Section18 Update and delete data

11 minutes42 seconds

Section19 Create and manipulate tables

17 minutes17 seconds

Section20 Use views

17 minutes33 seconds

Section21 Use stored procedures

22 minutes40 seconds

Section22 Using cursors

16 minutes19 seconds

Section23 Use triggers

22 minutes18 seconds

Section24 management transactions

13 minutes42 seconds

Section25 Globalization and localization

11 minutes56 seconds

Section26 Security management

16 minutes35 seconds

Section27 database maintenance

24 minutes00 seconds

Section28 Improve performance

06 minutes23 seconds