• Foundations of Querying
• Filtering and Sorting Data
• Grouping and Windowing
• Querying and Managing XML Data
• Inserting, Updating, and Deleting Data
• Other Data Modification Aspects
• Implementing Indexes and Statistics
• Implementing Transactions, Error Handling, and Dynamic SQL
• Understanding Further Optimization Aspects

• Getting Started with the SELECT Statement
• Combining Sets
• Querying Full-Text Data
• Creating Tables and Enforcing Data Integrity
• Using Tools to Analyze Query Performance
• Designing and Implementing T-SQL Routines
• Understanding Cursors, Sets, and Temporary Tables
• Designing and Creating Views, Inline Functions, and Synonyms

• Planning and Installing SQL Server 2012
• Configuring SQL Server 2012 Components
• SQL Server Logins, Roles, and Users
• Mirroring and Replication
• Troubleshooting SQL Server 2012
• SQL Server Agent, Backup, and Restore

• Configuring and Managing SQL Server Instances
• Migrating, Importing, and Exporting
• Securing SQL Server 2012
• Clustering and AlwaysOn
• Indexes and Concurrency
• Code Case Studies

Designing and Implementing a Data Warehouse

• Data Warehouse Logical Design
• Implementing a Data Warehouse

Developing SSIS Packages

• Creating SSIS Packages
• Designing and Implementing Control Flow
• Designing and Implementing Data Flow

Enhancing SSIS Packages

• Enhancing Control Flow
• Enhancing Data Flow
• Creating A Robust and RestartablePackage
• Implementing Dynamic Packages
• Auditing and Logging 381

Managing and Maintaining SSIS Packages

• Installing SSIS and Deploying Packages
• Executing and Securing Packages
• Troubleshooting and Performance Tuning

Building Data Quality Solutions

• Installing and Maintaining Data Quality Services
• Implementing Master Data Services
• Managing Master Data
• Creating a Data Quality Project to Clean Data

Advanced SSIS and Data Quality Topics

• SSIS and Data Mining
• Implementing Custom Code in SSIS Packages
• Identity Mapping and De-Duplicating