All Material from Chapter 1 to 22, including:
 

Part I:
RDBMS history.
Noramlization.
Parts of a RDBMS: Attributes, Entities, Relationships: 1 to 1, 1 to Many, Many to Many (how to implement)
Primary & Foreign Keys: What they are, why they are important, and best practices.  LAST_INSERT_ID()
Client/Server concepts & architecture
Data Types. Case sensistivity, i.e. BINARY vs. NON-BINARY, character sets.
Basic DDL Commands: CREATE, ALTER, DROP
Parts of the SELECT COMMAND: (rows vs. groups), UNION, Pattern Matching, BOOLEAN logic (AND/OR)
Other Basic DML INSERT, DELETE, UPDATE.
Indexes: What they are and why they are important.
SQL Expressions & Functions, see Chapter 10: truncate, concat / ||, CASE, IF, convert, TEMPORAL Functions. ISNULL & IFNULL.

Part II:

• Chapter 12 -- Table Joins: Full, Inner, Outer, Cross, Self, etc.
• Chapter 13 -- Sub Queries:  Correlated, All, Any, Exists, In, etc.
• Chapter 14 -- Views:  Creating, Altering, Dropping, Strategies, etc.
• Chapter 17 -- Prepared Statements.
• Chapter 18 -- Stored Procedures and Functions.
• Chapter 19 -- Triggers
• Chapter 20 -- Meta Data
• Chapter 21 -- Basic Debugging.
• Chapter 22 -- Basic Optimization