Instructor Led SQL Server Database Training Classes

Maintaining a Microsoft SQL Server 2005 Database ...r Transact-SQL.   Course 2779, Implementing a Microsoft SQL Server Database.   Course Outline Module 1: Installing and Configuring SQL Server 2005 This module explains how to plan for and install SQL Server 2005, how to manage a SQL Server 2005 installation, and how to use the SQL Server 2005 administrative tools. Lessons Preparing to install SQL Server.   Installing SQL Server.   more...

Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 ...hree or more years of on-the-job experience administering SQL Server database solutions in an enterprise environment.   Prerequisites Before attending this course, students must have: Working knowledge of SQL Server 2005 architecture including indexing, SQL execution plans, and SQL Server basic configuration.   Basic monitoring and troubleshooting skills. For example, students should more...

Designing the Data Tier for Microsoft SQL Server 2005 ...e three or more years of on-the-job experience developing SQL Server database solutions in an enterprise environment. At Course Completion After attending this clinic, students will be able to: Choose data access technologies and an object model to support an organization's business needs.   Design an exception handling strategy.   Choose a cursor strategy.   Design query strategies more...

Designing Microsoft SQL Server 2005 Server-Side Solutions ...e three or more years of on-the-job experience developing SQL Server database solutions in an enterprise environment. At Course Completion After attending this course, students will be able to: Select SQL Server services to support an organization's business needs.   Design a security strategy for a SQL Server 2005 solution.   Design a data modeling strategy.   Design a transaction more...