Microsoft SQL Server 2005 Administration

Duration: 5 days | Price: $2495 | Class Dates:

Students Will Learn:

Configuring and Installing SQL
Server 2005
SQL Server Database Engine Architecture
Replication, Backup and Restore
Security Administration
Performance Optimization

Creating and Populating Databases
Automating Procedures Using Scripts
Business Intelligence Services Overview
Full-Text Search Architecture
XML Integration

Course 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); 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; backup and restore; 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 focuses on administration issues and discusses the programmability features at a high level. Students who need a more thorough introduction to the Business Intelligence suite (SSRS, SSIS, SSAS) should attend either the SQL Server Business Intelligence Application Development (SSRS, SSIS, SSAS) course or the SQL Server Business Intelligence: Integration Services and Analysis Services course.

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

Course Prerequisites: Familiarity with database concepts, Windows desktop navigation and software installation techniques. Attendance at HOTT's 3-day SQL Programming/Relational Database Design course is highly recommended although not required.

Microsoft SQL Server 2005 Administration Course Overview:

An Overview of SQL Server 2005 New Features SQL Server Reporting Services (SSRS) SQL Server Analysis Services (SSAS) SQL Server Integration Services (SSIS) Database Roles Client Tools		Installing SQL Server 2005 Preparing For Installation User Interface Setup Installing Express Edition Configuring an New Instance
SQL Server Database Engine Managing Services Managing Servers Database Projects Database Objects		SQL Server 2005 Tools Configuration Utilities SQL Server Management Studio Using the Query Editor Books Online
SQL Server Replication Types of Replication Replication Agents Security and Monitoring Backup and Restore Considerations Replication Wizards and Tools		SQL Server Service Broker Conversations Message Ordering and Coordination Transactional Asynchronous Programming Loosely Coupled Applications Components Administering
SQL Server Maintenance Setting Up Database Mail SQL Server Agent Creating Operators Creating Jobs Creating Alerts Proxies Working with Tasks		Creating Databases Creating Databases Creating and Modifying Tables Indexes, Constraints, Scripts Populating Databases
Controlling Security Overview Catalog Views Security Functions Cryptographic Functions CLR Integration Native XML Web Services Integration Services Analysis Services Replication Reports Notifications Service Broker		International Databases Database Internationalization Overview Unicode Data Date and Time Issues Collations International SQL Integration Services Analysis Services Reports Notifications Service Broker
Working with XML XML Data Type Indexes Schema Collections Generating XML with the “For XML” Clause OpenXML Native XML Web Services		Assuring Data Availability Disaster Recovery Recovery Models High Availability Techniques Backup Restore RAID Arrays Database Mirroring
Monitoring and Performance Windows Performance Monitor SQL Server Profiler Database Engine Tuning Advisor (DTA) Federated Database Servers Partitioned Tables Partitioned Indexes Query Performance Issues Transactions and Locks Best Practices for Native XML Web Services		Programming SQL Server 2005 Scripts Transact-SQL Capabilities CLR Integration Overview Creating and Modifying Stored Procedures User-Defined Functions User-Defined Types DML Triggers DDL Triggers Integration Services Replication Management Objects (RMO) Reports Notifications
SQL Management Objects (SMO) Overview Table-Related SMOs Index and ForeignKey SMOs Stored Procedure and View SMOs		Full-Text Search Architecture Full-Text Search Capabilities Creating a Full-Text Catalog Populating Full-Text Indexes Performing Full-Text Searches FREETEXT FREETEXTTABLE CONTAINS CONTAINSTABLE

Student Testimonials

"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

Multiple Training Locations - Convenience and Cost Control

Regularly Scheduled Courses in more than 75 Cities Across North America and the United Kingdom

Northeast/New England	Southeast	Midwest	West/Southwest	Canada	United Kingdom
CT - Hartford CT - New Haven CT - Stamford DC - Washington MA - Boston MA - Chelmsford MA - Quincy MA - Springfield MA - Waltham MA - Woburn MA - Worcester MD - Baltimore MD - Columbia NH - Manchester NH - Nashua NJ - Jersey City NJ - Newark NJ - Princeton NY - Albany NY - Binghamton NY - Buffalo NY - Ithaca NY - Manhattan NY - Rochester NY - Syracuse PA - Harrisburg PA - Philadelphia PA - Pittsburgh RI - Providence	AL - Huntsville FL - Fort Lauderdale FL - Jacksonville FL - Miami FL - Orlando FL - Pensacola FL - Sarasota FL - Tampa FL - West Palm Beach GA - Atlanta GA - Savannah LA - Shreveport NC - Charlotte NC - Raleigh-Durham NC - Winston-Salem SC - Charleston VA - Alexandria VA - Fairfax VA - Norfolk VA - Richmond VA - Williamsburg	AR - Little Rock IA - Cedar Rapids IA - Des Moines IL - Chicago IL - Schaumburg IL - Springfield IN - Indianapolis KY - Louisville MI - Detroit MI - Lansing MN - Minneapolis MO - Kansas City MO - St. Charles MO - Springfield NE - Omaha OH - Cincinnati OH - Cleveland OH - Columbus OH - Dayton OK - Oklahoma City OK - Tulsa TN - Memphis TN - Nashville WI - Milwaukee	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 ID - Boise NM - Albuquerque NM - Las Cruces NV - Las Vegas OR - Portland TX - Austin TX - Corpus Christi TX - Dallas TX - El Paso TX - Fort Worth TX - Houston TX - San Antonio UT - Salt Lake City WA - Seattle WA - Spokane	AB - Calgary AB - Edmonton BC - Vancouver MB - Winnipeg QC - Montreal QC - Quebec City ON - Kingston ON - Mississauga ON - Ottawa ON - Toronto SK - Regina	Birmingham Bristol Chelmsford Edinburgh Glasgow Leeds Liverpool London Manchester

Hands On Technology Transfer, Inc.
1 Village Square, Suite 8
14 Fletcher Street
Chelmsford, MA 01824
1-800-413-0939 | 1-978-250-4299