Microsoft SQL Server 2005 Administration

Length: 5 days | Price: Please contact us for pricing information.

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.

Prerequisites: Familiarity with database concepts, Windows desktop navigation and software installation techniques. Attendance at theSQL Programming course is highly recommended although not required.

Microsoft SQL Server 2005 Administration Training Overview
  • SQL Server 2005 Features and Functionality
  • SQL Server Reporting Services (SSRS)
  • SQL Server Analysis Services (SSAS)
  • SQL Server Notification Services (SSNS)
  • SQL Server Integration Services (SSIS)
  • Understanding Common Language Runtime (CLR)
  • Installing SQL Server 2005
  • SQL Server 2005 Tools
  • Launching SQL Server Management Studio
  • Using the Object Explorer and Setting Properties
  • Using the Query Editor
  • Creating Databases in SQL Server Management Studio
  • Creating and Modifying Tables
  • Populating Tables with Data
  • SQL Management Objects (SMOs)
  • Using Table and ForeignKey SMOs
  • Using the Management Studio and T-SQL
  • Creating and Modifying Stored Procedures
  • Creating Indexed Views
  • Understanding Common Language Runtime
  • Choosing Between T-SQL and .NET Languages
  • Creating the Database Object
  • Full-Text Search Architecture
  • Database Support for XML
  • Retrieving XML from Queries
  • Creating SQL Server Logins
  • How to Assign Permissions
  • SQL Server Maintenance
  • Configuring Profile Security
  • Creating Proxies
  • Database Maintenance
  • Database Backup Overview
  • Restoring Databases
  • Enabling Database Mirroring
  • Setting Up Replication
  • Using SQL Server Logs
  • Monitoring Using Triggers
  • Creating SSIS Packages
  • Breakpoints and Checkpoints
  • Package Security and Deployment
  • Building, Registering and Using the Notification Services Application
Copyright© Mid Atlantic IT Training