Duration: 5 days | Price: Contact a Career Consultant for pricing

Description: This class consists of five days of training that focus on the new features available in SQL Server 2005. You will learn how to install SQL Server 2005; use the SQL Server 2005 client tools to administer databases and create database applications; administer the database engine; use SQL Server Integration Services (SSIS) to import, export, and transform data; use SQL Server Replication to synchronize data between databases; use SQL Server Reporting Services (SSRS) to create dynamic database reports; perform intelligent and complex queries using SQL Server Full-Text Search (SSFTS); use SQL Server Notification Services (SSNS) to push data updates to subscribing users; and use SQL Server Service Broker to establish asynchronous communications between database applications. You will also learn how to create international database applications; integrate XML with a database; monitor and improve database and server performance; and optimize data availability for an environment.

This course also includes an introduction to using SQL Server Analysis Services (SSAS) to create and manage data warehouse and implement data mining and discusses in detail the new security concepts available in SQL Server 2005. There are several new programmability features available in SQL Server 2005 including integration of the database engine and the .NET Common Language Runtime (CLR). This course discusses the programmability features at a high level.

Students who are new to database concepts and fundamental SQL programming should attend the 3-day course Relational Database Design prior to this course.

Prerequisites: Familiarity with database concepts, Windows desktop navigation and software installation techniques. Attendance at HOTT's 3-day SQL Programming course, or equivalent knowledge, is helpful but not required.

"Overall, the SQL Server training exceeded my expectation. The instructor was well versed in the subject matter. Much better than Global Knowledge."
– D.C., Cato Research Ltd.

"Instructor was excellent! Great knowledge of all aspects of SQL and more. I would recommend him to anyone needing SQL training. Looking forward to using what I learned."
– J.R. , Mayo Clinic

"The course was extremely well run. This is one of the few courses I've ever taken where the workshops and exercises reinforced all of the material covered. I will be able to put this knowledge to immediate use at work."
– J.B., Harvard