SQL Server 2008

Module 1: Getting Started with Databases and Transact-SQL in SQL Server 2008
Module 2: Querying and Filtering Data
Module 3: Grouping and Summarizing Data
Module 4: Joining Data from Multiple Tables
Module 5: Working with Subqueries
Module 6: Modifying Data in Tables
Module 7: Querying Metadata, XML, and Full-Text Indexes
Module 8: Using Programming Objects for Data Retrieval
Module 9: Using Advanced Querying Techniques

Module 1: Introduction to SQL Server 2008
Module 2: SQL Server 2008 Manageability Enhancements Lessons
Module 3: SQL Server 2008 Performance Enhancements Lessons
Module 4: SQL Server 2008 Security Enhancements Lessons
Module 5: SQL Server 2008 Database Development Enhancements Lessons
Module 6: SQL Server 2008 Availability Enhancements Lessons
Module 7: SQL Server 2008 Data Warehousing Enhancements Lessons
Module 8: SQL Server 2008 Reporting Services Enhancements Lessons
Module 9: SQL Server 2008 Analysis Services Enhancements Lessons

Module 1: Installing and Configuring SQL Server
Module 2: Managing Databases and Files
Module 3: Disaster Recovery
Module 4: Managing Security
Module 5: Transferring Data
Module 6: Automating Administrative Tasks
Module 7: Implementing Replication
Module 8: Maintaining High Availability
Module 9: Monitoring SQL Server
Module 10: Troubleshooting and Performance Tuning

Module 1: Creating Databases and Database Files
Module 2: Creating Data Types and Tables
Module 3: Creating and Tuning Indexes
Module 4: Implementing Data Integrity by Using Constraints and Triggers
Module 5: Using XML
Module 6: Implementing Views
Module 7: Implementing Stored Procedures
Module 8: Implementing Functions
Module 9: Implementing Managed Code in the Database
Module 10: Managing Transactions and Locks
Module 11: Using Service Broker

Module 1: Introduction to Microsoft SQL Server Analysis Services
Module 2: Creating Multidimensional Analysis Solutions
Module 3: Working with Cubes and Dimensions
Module 4: Working with Measures and Measure Groups
Module 5: Querying Multidimensional Analysis Solutions
Module 6: Customizing Cube Functionality
Module 7: Deploying and Securing an Analysis Services Database
Module 8: Maintaining a Multidimensional Solution
Module 9: Introduction to Data Mining

Module 1: Introduction to SQL Server 2008 Integration Services
Module 2: Developing Integration Services Solutions
Module 3: Implementing Control Flow
Module 4: Implementing Data Flow
Module 5: Implementing Logging
Module 6: Debugging and Error Handling
Module 7: Implementing Checkpoints and Transactions
Module 8: Configuring and Deploying Packages
Module 9: Managing and Securing Packages

Module 1: Introduction to Microsoft SQL Server Reporting Services
Module 2: Authoring Basic Reports
Module 3: Enhancing Basic Reports
Module 4: Manipulating Data Sets
Module 5: Using Report Models
Module 6: Publishing and Executing Reports
Module 7: Using Subscriptions to Distribute Reports
Module 8: Administering Reporting Services
Module 9: Programming Reporting Services