SQL Server 2005 Class

Duration: 5 days | Price: $2495 | Class Dates: Choose a CityView All Cities -or-AL - Huntsville AR - Little Rock AZ - Phoenix AZ - Tucson CA - Bakersfield CA - Fresno CA - Irvine CA - Los Angeles CA - Modesto CA - Oakland CA - Riverside CA - Sacramento CA - San Diego CA - San Francisco CA - San Jose CA - Santa Clarita CA - Santa Monica CA - Temecula CO - Denver CT - Hartford CT - New Haven CT - Stamford DC - Washington FL - Fort Lauderdale FL - Jacksonville FL - Miami FL - Orlando FL - Pensacola FL - Sarasota FL - Tampa FL - West Palm Beach GA - Atlanta GA - Savannah IA - Cedar Rapids IA - Des Moines ID - Boise IL - Chicago IL - Schaumburg IL - Springfield IN - Indianapolis KY - Louisville LA - Shreveport MA - Boston MA - Chelmsford MA - Quincy MA - Springfield MA - Waltham MA - Woburn MA - Worcester MD - Baltimore MD - Columbia MI - Detroit MI - Lansing MN - Minneapolis MO - Kansas City MO - Springfield MO - St. Charles NC - Charlotte NC - Raleigh-Durham NC - Winston-Salem NE - Omaha NH - Manchester NH - Nashua NJ - Jersey City NJ - Newark NJ - Princeton NM - Albuquerque NM - Las Cruces NV - Las Vegas NY - Albany NY - Binghamton NY - Buffalo NY - Ithaca NY - Manhattan NY - Rochester NY - Syracuse NY - Watertown OH - Cincinnati OH - Cleveland OH - Columbus OH - Dayton OK - Oklahoma City OK - Tulsa OR - Portland PA - Harrisburg PA - Philadelphia PA - Pittsburgh RI - Providence SC - Charleston TN - Memphis TN - Nashville TX - Austin TX - Corpus Christi TX - Dallas TX - El Paso TX - Fort Worth TX - Houston TX - San Antonio UT - Salt Lake City VA - Alexandria VA - Fairfax VA - Norfolk VA - Richmond VA - Williamsburg WA - Seattle WA - Spokane WI - Milwaukee

Description: This class consists of five days of training that focuses 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. A multitude of new programmability features are covered including integration of the .NET Common Language Runtime (CLR).

Students who are new to database concepts and database 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.

"I really enjoyed the class. It was a very good overview of SQL Server 2005 and components. I gained a lot of knowledge and new ideas on how we can accomplish things better with SQL 2005."
– C.V., Access

"I felt the course was very beneficial. The instructor was professional and knew the material very well. I thought the hands-on portion was excellent. I felt it really tied the class together well."
– N.M., Cardinal 16

"The instructor was excellent! The material was presented in a well thought out, friendly, easily digestible way. I would recommend this class to anyone."
– G.B., Wells Fargo Financial