Microsoft SQL Server 2005 DBA Program

Training Provided by IntSol India Objective: This course is targeted for those who have good knowledge and hands-on experience on using SQL Server 2000 database environment as it mainly focuses on database administrative tasks that an administrator generally needs to perform in a production environment for maintaining SQL Server 2005 databases and components related to the SQL Server environment. Pre-requisites: SQL Server 2000 Databases and Architecture XML (Optional) Microsoft. NET Framework (Optional)

Microsoft SQL Server 2005 DBA Program Day I
Changes in the Database Paradigm: How SQL Server 2005 Redefines the Role of a DBA
Introduction to SQL Server 2005
SQL Server 2005 and Administrators
A Tour of New Features in SQL Server 2005
Setup Enhancements
Database Administration and Management
Database Engine Enhancements
TSQL Enhancements
SQL Server 2005 Security
Performance Monitoring and Tuning Enhancements
High Availability Features
Business Intelligence Redefined
Notification Services
Full Text Search Enhancements
SQL Server 2005 Database Engine Architectural Changes
The SQL Server Operating System
Non-Uniform Memory Access Architecture Support
Query Optimization and Execution
Row Versioning
System Metadata Access and Security Architecture
Storage Engine and IO Changes
SQL Server 2005 Setup and Deployment
SQL Server 2005 Editions
SQL Server 2005 Setup Enhancements
Upgrading to SQL Server 2005
SQL Server 2005 Tools and Utilities
Tools and Utilities Overview
Management and Authoring
Performance Monitoring, Tuning and Optimization Tools
Operations and Configuration
Management APIs
* includes demonstrations and may have set of practices for participants
TSQL Enhancements*
Common Table Expressions (CTE)
Recursive Queries
Large Object Data Type Enhancements
TSQL Error Handling
DDL Triggers
Event Notifications
Snapshot Transaction Isolation Level
BULK Row Set Provider
SQL Server 2005 Security*
Introduction to SQL Server 2005 Security
Authentication
Authorization
Auditing Enhancements
Cryptography Support
Surface Area Configuration (SAC)
SQL Server Agent Security Overview

Day II

Reliability and High Availability in Database Engine
Reliability Enhancements
Mirrored Backup Media*
Backup and Restore Media Checks**
Checksum IO Validation**
Online, Piecemeal and Page Restorations
The Emergency Database State Option
Attach Rebuild Log Option*
Availability Enhancements
Database Mirroring*
Setting up DB Mirroring
Monitoring Database Mirroring
Configuring DB Mirroring for Automatic Failover
Database Snapshots*
Online and Parallel Index Operations*
Dedicated Administrator Connection*
Early Restore Access
Instant File Initialization*
Table and Index Partitioning
Introduction to SQL Server High Availability
What s Fail-Over Clustering?
Configuring SQL Servers for Fail-Over Clustering*
Configuring for Load Balancing
Performance Analysis and Tuning
Physical Database Design, Analysis and Tuning
Troubleshooting Locking and Blocking
Query Performance Tuning
Designing Applications for Performance
Performance Monitoring and Tuning Tools
Using Database Tuning Advisor
* includes demonstrations and may have set of practices for participants

Day III

Introduction to Linked Servers*
What are these?
How are they used for?
Practical Scenarios
Configuring Linked Servers connecting to
SQL Server, Oracle and Other Databases
Automating Credentials Impersonation
SQL Server Replication*
Replicating Data in a Server to Server Environment
Replicating Data between Server and Clients
Types of Replication
Snapshot Replication
Transactional Replication
Merge Replication
Implementing Replication
Methods of Implementing Replication
Configuring Distribution
Publishing data and database objects
Subscribing to Publications
Initializing a Subscription
Synchronizing Data
Scripting Replication
Removing Replication
Implementing Replication over Internet
Replicating Data to SQL Server Mobile
Pocket PC Devices (LIVE Demonstration)
Peer-to-peer Replication*
Configuring P2P Replication
Bi-Directional Replication
Differentiating Bi-Directional and P2P
SQL Server 2005 Service Broker*
An Introduction to Asynchronous Messaging
Understanding Service Broker Architecture and Components
Service Broker Operations and Troubleshooting
Service Broker Security Overview
SQL Server Integration Services*
The New SSIS Features
SSIS Architecture and Toolkit
Designing SSIS Packages
The World of Wizards
SSIS and Data Warehousing
Deploying SSIS Packages
Debugging SSIS Packages
Developing advanced SSIS Packages including
Fuzzy Lookup
Xml Tasks
Script Tasks
Import and Export Columns

About The Training Provider: IntSol India

More Open House Technical Workshops Training from IntSol India

• JBoss Administration Program
• Microsoft .NET Framework 3.5, C# 3.0, Visual Studio .NET 2008 Workshop
• Microsoft BizTalk Server 2006 R2 Training Program
• Sharepoint Server 2007 (MOSS) Workshop in Bangalore
• Spring Hibernate Workshop - Basic Intermediate Level
• Weblogic 103 Administration