SQL Server 2008 course modules index

If you are not sure which course is best suited to your requirements, or you are looking for a tailored course with a "mix and match" of topics from various courses, below is a list of all PTR's SQL Server 2008 and related courses with a summary of the training modules displayed for each course.

By clicking on the module headings you will be taken to the appropriate section of the the full course outline where you will be able to see all the sub-topics covered within individual modules.

Course Title	Summary of Topics Covered
Advanced Queries & Transact SQL Programming	Review of Structured Query Language Advanced Select Statements Advanced Update & Delete Statements Programmability Managing Errors Using Transactions Implementing Cursors Stored Procedures Triggers

Advanced SQL for SQL Server	Review Of The SELECT Statement Using SQL Server Functions Review Of The WHERE Clause Review Of The ORDER BY Clause Multiple Table SELECTs UNION Selects Temporary Tables Advanced Data Organisation Sub Queries Advanced Update & Delete Statements

Advanced SQL, Stored Procedures & Triggers for Microsoft SQL Server	Review of Structured Query Language Advanced Select Statements Advanced Update & Delete Statements Programmability Managing Errors Using Transactions Implementing Cursors Stored Procedures Triggers

Introduction to SQL Server Business Intelligence	INTRODUCTION TO BUSINESS INTELLIGENCE INTRODUCTION TO SQL SERVER INTEGRATION SERVICES (SSIS) INTRODUCTION TO SQL SERVER REPORTING SERVICES (SSRS) INTRODUCTION TO ANALYSIS SERVICES

Introduction to SQL Server Transact SQL	Transact SQL Scripting Error Handling Transaction Logging Locking Implementing Cursors Stored Procedures Views User Defined Functions Common Table Expressions (CTEs) Triggers APPENDIX A (Data types) APPENDIX B (Functions)

Microsoft SQL Server 2008 for Developers	A Tour of SQL Server 2008 Installing SQL Server 2008 Designing and Creating a Database Data Selection Modifying Data Working with SQL Server Management Studio Transact-SQL Programming Understanding and Implementing Security Creating Views Creating Stored Procedures and Triggers Creating User-Defined Functions Transactions and Error Handling Using .NET Code in SQL Server Advanced SQLCLR Code Techniques Advanced Query Techniques Advanced Data Types Implementing Partitions Complex Querying Advanced Techniques Design and Deployment with Visual Studio Working with XML Business Intelligence Services

Microsoft SQL Server Audit & Security	INTRODUCTION TO AUDIT & SECURITY AUDIT & SECURITY THE BIG PICTURE INTRODUCTION TO SQL SERVER SQL SERVER BASIC ARCHITECTURE THE MANAGEMENT TOOLS SQL SERVER LOGS SQL SERVER SECURITY COMPLIANCE SQL SERVER CONFIGURATION DATABASE STORAGE BACKUP DEVICES BACKUP IMAGES IMPORTING AND EXPORTING DATA USER SECURITY LOGIN ACCOUNTS DATABASE USER ACCOUNTS ADMINISTRATIVE PRIVILEGES SQL SERVER PERMISSIONS ASSIGNING PRIVILEGES & PERMISSIONS IMPERSONATION SQL SERVER ENCRYPTION ENCRYPTION HIERARCHY ENCRYPTION & DECRYPTION FUNCTIONS HIGH AVAILABILITY APPLICATION DEVELOPMENT SELECTING THE TRUST MECHANISM SQL SERVER AUDITING SQL SERVER SYSTEM VIEWS & STORED PROCEDURES SQL SERVER 2008 AUDIT POLICY BASED MANAGEMENT THREATS & VULNERABILITIES

SQL for Microsoft SQL Server	Introduction To Relational Databases Microsoft SQL Server Tools Transact-SQL Data Definition Language Loading Data Into A Database Data Manipulation Language Querying The Database Appendices

SQL Server 2008 Advanced Administration	DBA Maintenance Tasks Command Line Administration Tools Advanced Database Design Transferring Data Implementing Replication Advanced Monitoring of SQL Server Performance Tuning Services Policy-Based Management Implementing Service Broker High Availability

SQL Server 2008 Analysis Services	What is Microsoft Business Intelligence? OLAP Modeling Using SSAS in BIDS Intermediate SSAS Advanced SSAS Cube Storage and Aggregation Introduction to MDX Queries MDX Expressions Introduction to Data Mining SSAS Administration Advanced Administration and Optimization Introduction to SSAS Clients

SQL Server 2008 Essential Administration	Installing and Configuring SQL Server Managing Databases and Files Disaster Recovery Managing Security Establishing Client Connectivity Automating Administrative Tasks Monitoring SQL Server An Introduction To Troubleshooting and Performance Tuning An Overview of Other Services

SQL Server 2008 Integration Services	A Guided Tour of Integration Services Control Flow Data Flows Variables and Configurations Advanced Control Flow Error Handling and Logging Advanced Data Flow Package Deployment Package Management Scripting and Custom Components Best Practices Going Beyond ETL

SQL Server 2008 Reporting Services	Introducing SQL Server Reporting Services Creating Tabular and List Reports Calculations and Formatting Grouping and Sorting Working with Parameters Creating Matrix Reports and Charts Managing Reporting Services Security Programming Reporting Services Advanced Reporting Services Programming Snapshots and Subscriptions Ad-Hoc Reporting with Report Builder 2.0 Appendix A – Creating Report Model Projects

SQL Server Performance & Tuning	Performance & Tuning Monitoring Performance SQL Server Internals Process & Thread Management SQL Server & Threads and Processes I/O Management Networking SQL Server Architecture Planning For A SQL Server Database Application System Performance & Tuning Monitoring Tools Optimal Database Design Indexing Locking Query Optimisation Analysing Queries Database Application Tuning SQL Server 2008 Performance Monitoring & Tuning Enhancements The Data Collector Plan Freezing Plan Freezing Maintenance – SQL Server 2005/8

Updating Your SQL Server Administration Skills to SQL Server 2008	An Introduction to SQL Server 2008 Installing and Upgrading to SQL Server 2008 Storage Enhancements in SQL Server 2008 SQL Server 2008 Administration Enhancements Security Enhancements with SQL Server 2008 SQL Server 2008 Disaster Recovery High Availability in SQL Server 2008 Replication Enhancements in SQL Server 2008 SQL Server 2008 Policy-Based Management SQL Server 2008 Monitoring Enhancements SQL Server 2008 Performance