Lesson 1: Advanced Querying Using Subqueries

• Search Based on an Unknown Value
• Search Based on Multiple Unknown Values
• Compare a Value with Unknown Values
• Search Based on the Existence of Records
• Generate Output Using Correlated Subqueries
• Filter Grouped Data Within Subqueries
• Perform Multiple-level Subqueries

Lesson 2: Manipulating Table Data

• Insert Data
• Modify Data
• Delete Data

Lesson 3: Manipulating the Table Structure

• Create a Simple Table
• Create a Table with Constraints
• Add or Drop Table Columns
• Add or Drop Constraints
• Modify the Column Definition
• Delete Tables

Lesson 4: Working with Views

• Create a View
• Manipulate Data in Views
• Modify and Drop Views

Lesson 5: Indexing Data

• Create Indexes
• Drop Indexes