9.4 IMBD dataset

9.5 Installing MySQL

9.6 Load IMBD data

9.7 USE, DESCRIBE, SHOW TABLES

9.8 SELECT

9.9 LIMIT, OFFSET

9.10 ORDER BY

9.11 DISTINCT

9.12 WHERE, COMPARISON OPERATORS, NULL

9.13 Logical Operators

9.14 Aggregate Functions: COUNT, MIN, MWX, AVG, SUM

9.15 GROUP BY

9.16 HAVING

9.17 ORDER OF KEYWORDS

9.18 Join and Natural Join

9.19 Inner, Left, Right and Outer joins

9.20 Sub Queries/Nested Queries/Inner Queries

9.21 DML: Insert

9.22 DML:UPDATE, DELETE

9.23 DDL: CREATE TABLE