Lesson 1: Exploring Transact-SQL
Topic 1A: An Overview of SQL Server and Transact-SQL
Topic 1B: Programming in Transact-SQL
Lesson 2: Querying Data
Topic 2A: Using the SELECT Statement
Topic 2B: Formatting the Results Set
Lesson 3: Changing Data
Through Queries
Topic 3A: Inserting Data
Topic 3B: Deleting Data
Topic 3C: Updating Data
Lesson 4: Summarizing
Data
Topic 4A: Working with Aggregate Functions
Topic 4B: Grouping Data
Lesson 5: Joining
Tables
Topic 5A: Querying Multiple Tables
Topic 5B: Implementing Advanced Table Joins
Lesson 6: Implementing
Subqueries
Topic 6A: Designing Subqueries
Lesson 7: Working with
Full-text Indexes
Topic 7A: Implementing the Microsoft Search Service
Topic 7B: Querying Full-text Indexes
Lesson 8: Programming
Transact-SQL
Topic 8A: Creating and Managing Views
Topic 8B: Implementing Stored Procedures, Triggers, and
User-defined Functions
Appendix A: The Movies
Database Structure
Table DesignTopic