Microsoft SQL Server 2005

Course 2936: Installing and Securing Microsoft SQL Server 2005 This course will enable database administrators experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005. This course is a technically deep learning experience for architects, systems engineers, systems administrators, solution developers, and application developers. The course is designed for people who want to learn about either the planning/design phase of technology adoption, or the implementation issues specific to the build, deployment, and management phases. The course provides detailed reference content and in-depth practical and hands-on activities. Understanding the SQL Server 2005 Architecture Overview of SQL Server 2005 Enhancements to SQL Server 2005 Components Understanding SQL Server 2005 Features Introducing SQL Server 2005 Extensibility Components System Enhancements for Administrators Installing SQL Server 2005 Performing a SQL Server 2005 Installation Maintaining a SQL Server 2005 Installation Lab: Installing SQL Server 2005 Securing SQL Server 2005 Managing SQL Server 2005 Security Managing Schemas and Controlling Execution Context Managing Permissions Managing Certificates Lab: Securing a SQL Server 2005 Database Course 2937: Administering and Monitoring Microsoft SQL Server 2005 This course will enable database administrators experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005. This course is a technically deep learning experience for architects, systems engineers, systems administrators, solution developers, and application developers. The course is designed for people who want to learn about either the planning/design phase of technology adoption, or the implementation issues specific to the build, deployment, and management phases. The course provides detailed reference content and in-depth practical and hands-on activities. Exploring SQL Server 2005 Administrative Tools Using SQL Server Management Studio Using SQL Computer Manager Using the sqlcmd Utility Using the SQL Management Objects Lab: Administering SQL Server 2005 Monitoring SQL Server 2005 Using DDL Triggers Using Event Notifications Using Metadata Views Lab: Monitoring SQL Server 2005 Maintaining Databases and Indexes Using the Database Tuning Advisor Lab: Maintaining a Database Course 2938: Data Availability Features in Microsoft SQL Server 2005 This course will enable database administrators experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005. This course is a technically deep learning experience for architects, systems engineers, systems administrators, solution developers, and application developers. The course is designed for people who want to learn about either the planning/design phase of technology adoption, or the implementation issues specific to the build, deployment, and management phases. The course provides detailed reference content and in-depth practical and hands-on activities. Understanding Disaster Recovery Using Database Snapshots Understanding Backup and Restore Operations Lab: Managing Disaster Recovery in SQL Server 2005 Understanding Data Availability in SQL Server 2005 Introduction to Data Availability Introduction to Database Mirroring Configuring Database Mirroring Configuring the Mirror Server and Database Lab: Maintaining Availability in SQL Server 2005 Understanding SQL Server 2005 Replication Features Overview of Replication Enhancements Introducing New Types of Replication in SQL Server 2005 Configuring Replication Course 2939: Programming Microsoft SQL Server 2005 This course will enable database developers experienced with SQL Server 7.0 or SQL Server 2000 to upgrade their skills to SQL Server 2005. This course is a technically deep learning experience for architects, systems engineers, systems administrators, solution developers, and application developers. The course is designed for people who want to learn about either the planning/design phase of technology adoption, or the implementation issues specific to the build, deployment, and management phases. The course provides detailed reference content and in-depth practical and hands-on activities. Working with SQL Server 2005 Exploring Components and Features Using the SQL Server 2005 Developer Tools Implementing the Security Features in SQL Server 2005 Lab: Exploring SQL Server 2005 Exploring Transact-SQL Enhancements in SQL Server 2005 Using Data Definition Language Enhancements Using Data Manipulation Language Enhancements Using Structured Exception Handling Lab: Programming with Transact-SQL Exploring the Use of XML in SQL Server 2005 Using XML Enhancements in SQL Server 2005 Using the xml Data Type Using XQuery Lab: Working with XML Course 2940: Building Services and Notifications Using Microsoft SQL Server 2005 This course will enable database developers experienced in SQL Server 7.0 or SQL Server 2000 to upgrade their skills to SQL Server 2005. This course is a technically deep learning experience for architects, systems engineers, systems administrators, solution developers, or application developers. The course is designed for people who want to learn about either the planning/design phase of technology adoption, or the implementation issues specific to the build, deployment, and management phases. The course provides detailed reference content and in-depth practical and hands-on activities. Using Service Broker Exploring Service Broker Exploring Service Broker Architecture Implementing Service Broker Lab: Using Service Broker Using Native HTTP Support Exploring Native HTTP Support Configuring Native HTTP Support Lab: Implementing a Web Service with HTTP Endpoints Using Notification Services Module Introduction Exploring Notification Services Architecture Exploring the Notification Services Process Configuring Notification Services Solutions Lab: Using Notification Services Course 2941: Creating the Data Access Tier Using Microsoft SQL Server 2005 This course will enable database developers experienced with SQL Server 7.0 or SQL Server 2000 to upgrade their skills to SQL Server 2005. This course is a technically deep learning experience for architects, systems engineers, systems administrators, solution developers, and application developers. The course is designed for people who want to learn about either the planning/design phase of technology adoption, or on the implementation issues specific to the build, deployment, and management phases. The course provides detailed reference content and in-depth practical and hands-on activities. Using the .NET CLR in SQL Server 2005 Exploring SQL Server and the .NET CLR Creating and Registering Managed Database Objects Implementing Managed Code in SQL Server 2005 Creating Managed Code in SQL Server 2005 Using Database Objects with Visual Studio 2005 Lab: Implementing Managed Code in the Database Developing Client Applications Developing Client Applications with ADO.NET ADO.NET Enhancements in the .NET Framework 2.0 Using Data Binding in .NET Framework 2.0 Using SQL Management Objects Exploring the Use of SQL Management Objects Creating and Modifying Objects Using Replication Management Objects Lab: Using SQL Management Objects

Course 2942: New Features of Microsoft SQL Server 2005 Analysis Services This course will enable business intelligence developers experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005. This course is a technically deep learning experience for architects, systems engineers, systems administrators, solution developers, or application developers. The course is designed for either the planning/design phase of technology adoption, or on implementation issues specific to the build, deployment and management phases. The course provides detailed reference content and in-depth practical and hands-on activities. Exploring SSAS Core Concepts and Architecture SSAS Core Concepts New Features in the SSAS Architecture Designing and Deploying a Unified Dimensional Model Creating an Analysis Services Project The Business Intelligence Development Studio Building a Cube Implementing Advanced Features of a Cube Lab: Building a Cube Administering SSAS Upgrading and Migrating to SSAS 2005 Configuring Roles, Groups, and Permissions Managing SSAS Managing Partitions and Real Time BI Lab: Administering SSAS Programming in SSAS 2005 Exploring SQL Server Management Studio New Features of MDX Scripting with MDX New Programming Features Lab: Programming in SSAS 2005 Working with Data Mining Solutions in SSAS Data Mining Concepts and New Features An Introduction to Data Mining Exploring Data Mining Models Working with Data Mining Tools Lab: Working with Data Mining Solutions

Course 2943: Updating Your Data ETL Skills to Microsoft SQL Server 2005 Integration Services This course will enable business intelligence developers experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005. This course is a technically deep learning experience for architects, systems engineers, systems administrators, solution developers, or application developers. The course is designed for either the planning/design phase of technology adoption, or on implementation issues specific to the build, deployment and management phases. The course provides detailed reference content and in-depth practical and hands-on activities. Exploring SSIS Architecture and Core Concepts SSIS Architecture SSIS Core Concepts Designing and Debugging SSIS Packages Creating Package Control Flow Creating Package Data Flow Designing for Scalability and Performance Debugging SSIS Packages Lab: Creating and Debugging a Package Rich Functionality in SSIS Configuring and Deploying SSIS Packages Enhancing ETL Operations Working with Transformations Lab: Configuring and Deploying a Package Extensibility Programmability Beyond ETL Lab: Transforming an RSS Feed

Course 2944: Updating Your Reporting Skills to Microsoft SQL Server 2005 Reporting Services This course will enable business intelligence developers experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005. This course is a technically deep learning experience for architects, systems engineers, systems administrators, solution developers, or application developers. The Course is designed for either the planning/design phase of technology adoption, or on implementation issues specific to the build, deployment and management phases. The Course provides detailed reference content and in-depth practical and hands-on activities. Exploring the Features and Core Concepts of SSRS Features of SSRS SSRS Core Concepts Designing Reports Using Report Designer Designing Reports Using the Report Wizard Working with Data Regions Lab: Designing a Report Deploying and Managing Reports Deploying Reports Managing Reports Lab: Deploying and Managing a Report Working with Ad Hoc Reports Using Report Model Designer Using Report Builder Lab: Creating an Ad Hoc Report