Microsoft

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 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

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: 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: Introduction to SQL Server 2008 Module 2: SQL Server 2008 Manageability EnhancementsLessons Module 3: SQL Server 2008 Performance EnhancementsLessons Module 4: SQL Server 2008 Security EnhancementsLessons Module 5: SQL Server 2008 Database Development EnhancementsLessons Module 6: SQL Server 2008 Availability EnhancementsLessons Module 7: SQL Server 2008 Data Warehousing EnhancementsLessons Module 8: SQL Server 2008 Reporting Services EnhancementsLessons Module 9: SQL Server 2008 Analysis Services EnhancementsLessons

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