Microsoft SQL Server 2005 for Administrators Training

How To Take This Class:

• Live Instructor-Led Online Class   > View Schedule or Register
• Onsite Group Training   > Request Pricing

Instructor-Led Online Course Tuition:

$1,800.00

Course Duration:

4 Days

Course Description:

In this Microsoft SQL Server 2005 for Administrators Training course, students will learn about available features for the administration of SQL Server, and how to design, create, modify, analyze and tune databases. Students will learn how to build basic queries using Transact-SQL, how to take advantage of the new, user-friendly management console, and how to use SQL Server’s tools for configuring, tuning and monitoring database activity. This course also covers critical topics like integration services, implementing security, disaster prevention and recovery, failover clustering, database mirroring and more.

Course Objectives:

Upon successful completion of this course, students will be able to:

• Install and configure Microsoft SQL Server 2005.
• Understand basic database design principles and how to implement them in SQL Server.
• Understand the fundamentals of writing Transact-SQL queries that retrieve or modify data.
• Understand the SQL Server security model.
• Configure and tune SQL Server, and monitor database activity.
• Support distributed users by implementing SQL Server Replication.
• Implement disaster recovery options.
• Understand high availability concepts.
• Implement SQL Server high-availability features: failover clustering, database mirroring, log shipping, and peer-to-peer replication.
• Explore new techniques for monitoring and troubleshooting SQL Server.
• Implement asynchronous messaging with the new Service Broker.

Course Audience:

This course is designed for students who will be responsible for installing and administering a SQL Server 2005 database.

Course Prerequisites:

This course assumes that students have working experience with SQL Server 2000 or 2005; basic relational database concepts (e.g., tables, queries, and indexing); general knowledge of XML, Transact-SQL, and a fundamental understanding of networking and security concepts.

Course Syllabus:

1. A Tour of SQL Server 2005
• SQL Server 2005 Editions, Components, and Tools
• Using SQL Server Management Studio (SSMS)
• Working with Tables and Queries
• New Transact-SQL Features
• Business Intelligence Services
2. Installing SQL Server 2005
• Preparing for Installation
• Upgrading an Earlier Version
• Installation Steps
• Configuring the Server
3. Designing and Creating a Database
• Relational Database Design Principles
• Implementing the Design
4. Data Selection Queries
• Understanding Transact-SQL
• The SELECT Statement
• The WHERE Clause
• Using ORDER BY to Sort Data
• The GROUP BY Clause
• Joining Tables
5. Modifying Data
• Modifying Data
• Inserting Data
• Updating Data
• Deleting Data
• Understanding Transaction Isolation
6. Working with SQL Server Management Studio
• Getting Started with SSMS
• Exploring the Object Explorer
• Working with the Query Editor
• Using SQL Server Books Online
7. Understanding and Implementing Security
• Security Overview
• Authentication
• Authorization
• Permissions
• Data Encryption
• Security Epilog
8. Analyzing and Tuning Performance
• Evaluating Performance
• Monitoring with SQL Server Profiler
• Tuning Queries
• Indexes and Partitions
• Using the Database Engine Tuning Advisor
• Understanding SQL Server Performance Problems
9. Automating Administrative Tasks
• SQL Server Agent
• Maintenance Plans
• SQL Management Objects (SMO)
10. Programming Replication
• Overview of SQL Server Replication
• Replication Programming Interfaces
• Configuring Replication
• Synchronizing Data
11. Disaster Recovery
• Planning a Backup Strategy
• Backing Up Databases
• Scheduling Your Backups
• Verifying Backup Media
• Restoring Databases
• Using Database Snapshots
12. Failover Clustering
• High Availability Overview
• SQL Server 2005 Failover Cluster
• Preparing a Server Cluster
• Creating a New Cluster
• Installing SQL Server 2005 Failover
• Adding Additional SQL Server Nodes
13. Database Mirroring
• Understanding Mirroring
• Setting Up Database Mirroring
• Setting Up the Mirror Server Database
• Monitoring Database Mirroring
14. Log Shipping
• Overview
• Configuring Log Shipping
• Monitoring Log Shipping Jobs
• Configuring Log Shipping in Transact-SQL
15. Peer-to-Peer Replication
• High-Availablity
• Configuring the Distributor
• Creating the Publisher
• Configuring Peer-to-Peer Subscribers
• Configuring Peer-to-Peer Topology
16. Monitoring & Troubleshooting
• Diagnosing and Resolving Database Server Errors
• Set Up Alerts Using SQL Server Agent
• Monitoring SQL Server Agent Job History
• Gathering Performance Data and Optimization using DMV
17. Implementing Service Brokers
• Understanding Service Brokers
• Designing Service Broker Applications
• Programming Service Broker Applications