SQL Querying: Advanced

Lesson 1: Using Nested Queries

• Topic A: Search Based on Values from a Subquery
• Topic B: Compare Values from a Subquery
• Topic C: Search Based on the Existence of Records
• Topic D: Generate Output Using Correlated Subqueries
• Topic E: Filter Grouped Data Within Subqueries
• Topic F: Perform Multiple-Level Subqueries

Lesson 2: Manipulating Table Data

• Topic A: Insert Rows
• Topic B: Modify and Delete Data

Lesson 3: Manipulating Table Structure

• Topic A: Create a Table
• Topic B: Create a Table with Constraints
• Topic C: Modify a Table's Structure
• Topic D: Delete Tables

Lesson 4: Working with Views

• Topic A: Create a View
• Topic B: Manipulate Data in Views
• Topic C: Modify and Delete Views

Lesson 5: Indexing Data

• Topic A: Create Indexes
• Topic B: Drop Indexes

Lesson 6: Managing Transactions

• Topic A: Define Transactions
• Topic B: Commit Transactions
• Appendix A: The Pub2 Database