Subscribe to Newsletter

Print

SQL Server 2005 Administration Training Course


(This course is offered only on-demand to a private batch and can be customized as per the business requirements)

Overview

This class consists of five days of training that focus on the new features available in SQL Server 2005. Participants 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.

Objectives

At the end of Microsoft SQL Server 2005 administration Training course, participants 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

Suggested Audience - System Administrators who want to gain practical, hands-on SQL Server 2005 administration training.

Duration - 5 Days

Prerequisites - Familiarity with database concepts, Windows desktop navigation and software installation techniques.

Syllabus

1. 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
 2. SQL Server Database Engine
  • Managing Services
  • Managing Servers
  • Database Projects
  • Database Objects
3. SQL Server Replication
  • Types of Replication
  • Replication Agents
  • Security and Monitoring
  • Backup and Restore Considerations
  • Replication Wizards and Tools
 4. SQL Server Maintenance
  • Setting Up Database Mail
  • SQL Server Agent
  • Creating Operators
  • Creating Jobs
  • Creating Alerts
  • Proxies
  • Working with Tasks
5. Controlling Security
  • Overview
  • Catalog Views
  • Security Functions
  • Cryptographic Functions
  • CLR Integration
  • Native XML Web Services
  • Integration Services
  • Analysis Services
  • Replication
  • Reports
  • Notifications
  • Service Broker
 6. Working with XML
  • XML Data Type
  • Indexes
  • Schema Collections
  • Generating XML with the “For XML” Clause
  • OpenXML
  • Native XML Web Services
7. 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
 8. SQL Management Objects (SMO) Overview
  • Table-Related SMOs
  • Index and ForeignKey SMOs
  • Stored Procedure and View SMOs
9. Installing SQL Server 2005
  • Preparing For Installation
  • User Interface Setup
  • Installing Express Edition
  • Configuring an New Instance
 10. SQL Server 2005 Tools
  • Configuration Utilities
  • SQL Server Management Studio
  • Using the Query Editor
  • Books Online
11. SQL Server Service Broker
  • Conversations
  • Message Ordering and Coordination
  • Transactional Asynchronous Programming
  • Loosely Coupled Applications
  • Components
  • Administering
 12. Creating Databases
  • Creating Databases
  • Creating and Modifying Tables
  • Indexes, Constraints, Scripts
  • Populating Databases
13. International Databases
  • Database Internationalization Overview
  • Unicode Data
  • Date and Time Issues
  • Collations
  • International SQL
  • Integration Services
  • Analysis Services
  • Reports
  • Notifications
  • Service Broker
 14. Assuring Data Availability
  • Disaster Recovery
  • Recovery Models
  • High Availability Techniques
  • Backup
  • Restore
  • RAID Arrays
  • Database Mirroring
15. 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
 16. 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