Lessons 1: Executing a Simple Query

• Lesson Objectives
• Lesson Introduction
• TOPIC A: Connect to the SQL Database
• TOPIC B: Query a Database
• TOPIC C: Save a Query
• TOPIC D: Modify and Execute a Saved Query

Lessons 2: Performing a Conditional Search

• TOPIC A: Search Using One or More Conditions
• TOPIC B: Search for a Range of Values and NULL Values
• TOPIC C: Search Data Based on Patterns

Lessons 3: Working with Functions

• TOPIC A: Perform Date Calculations
• TOPIC B: Calculate Data Using Aggregate Functions
• TOPIC C: Manipulate String Values

Lessons 4: Organising Data

• TOPIC A: Sort Data
• TOPIC B: Rank Data
• TOPIC C: Group Data
• TOPIC D: Filter Grouped Data
• TOPIC E: Summarise Grouped Data
• TOPIC F: Use PIVOT and UNPIVOT Operators

Lessons 5: Retrieving Data from Multiple Tables

• TOPIC A: Combine the Results of Two Queries
• TOPIC B: Compare the Results of Two Queries
• TOPIC C: Retrieve Data by Joining Tables

Lessons 6: Exporting Query Results

• TOPIC A: Generate a Text File
• TOPIC B: Generate an XML File

Lessons 7: Using Subqueries to Perform Advanced Querying

• TOPIC A: Search Based on Unknown Values
• TOPIC B: Compare a Value with Unknown Values
• 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

Lessons 8: Manipulating Table Data

• TOPIC A: Insert Data
• TOPIC B: Modify and Delete Data

Lessons 9: Manipulating the Table Structure

• TOPIC A: Create a Table
• TOPIC B: Create a Table with Constraints
• TOPIC C: Modify a Table's Structure
• TOPIC D: Back Up Tables
• TOPIC E: Delete Tables

Lessons 10: Working with Views

• TOPIC A: Create a View
• TOPIC B: Manipulate Data in Views
• TOPIC C: Create Aliases
• TOPIC D: Modify and Delete Views

Lessons 11: Indexing Data

• TOPIC A: Create Indexes
• TOPIC B: Drop Indexes

Lessons 12: Managing Transactions

• TOPIC A: Create Transactions
• TOPIC B: Commit Transactions

Appendix A

• The FullerAckerman Database
• Schema

Executing a Simple Query

• Connecting to a Database
• Saving a Query and Modifying and Executing the Saved Query

Performing a Conditional Search

• Comparing Column Values in a Table
• Searching Using Simple and Multiple Conditions
• Searching for a Range of Values and NULL Values
• Retrieving Data Based on Patterns

Working with Functions

• Performing Date Calculations
• Using Aggregate Functions
• Manipulating String Values in a Table

Organising Data

Retrieving Data from Multiple Tables

Exporting Query Results

Using Subqueries to Perform Advanced Querying

Manipulating Table Data

Manipulating the Table Structure

Working with Views

Indexing Data

Managing Transactions