SQL Server 2005 Administration Training: Introduction to SQL Server 2005 for Administrators

Course Number: SQL-112
Duration: 4 days
view class outline

Looking for SQL Server 2008 for Administrators training?

SQL Server 2005 Administration Training Overview

Accelebrate's SQL Server 2005 Administration training teaches administrators how to successfully administer SQL Server 2005.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/?action=category&page=mssql.

SQL Server 2005 Administration Training Prerequisites

No prior experience is presumed.

Hands-on/Lecture Ratio

This class is 65% hands-on, 35% lecture, with the longest lecture segments lasting for 20 minutes.

SQL Server 2005 Administration Training Materials

All students will receive:

More than 400 pages of fully-illustrated courseware
A copy of Apress' Pro SQL Server 2005

Software Needed on Each Student PC

Windows 2003 Server or 2008
SQL Server 2005 with Service Pack 2 or later (SP3 or later preferred) installed
SQL Server 2005 Management Studio

Important Note: If you have purchased this class, please contact us for detailed setup instructions.

SQL Server 2005 Administration Training Objectives

All attendees will learn to:

Install and configure Microsoft SQL Server 2005.
Understand basic database design principles and how to implement them in SQL Server.
Learn 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.
Learn about disaster recovery options.
Understand high availability concepts.
See how to 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.
Learn how to implement asynchronous messaging with the new Service Broker.

SQL Server 2005 Administration Training Outline

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

Installing SQL Server 2005

Preparing for Installation
Upgrading an Earlier Version
Installation Steps
Configuring the Server

Designing and Creating a Database

Relational Database Design Principles
Implementing the Design

Data Selection Queries

Understanding Transact-SQL
The SELECT Statement
The WHERE Clause
Using ORDER BY to Sort Data
The GROUP BY Clause
Joining Tables

Modifying Data

Modifying Data
Inserting Data
Updating Data
Deleting Data
Understanding Transaction Isolation

Working with SQL Server Management Studio

Getting Started with SSMS
Exploring the Object Explorer
Working with the Query Editor
Using SQL Server Books Online

Understanding and Implementing Security

Security Overview
Authentication
Authorization
Permissions
Data Encryption
Security Epilog

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

Automating Administrative Tasks

SQL Server Agent
Maintenance Plans
SQL Management Objects (SMO)

Programming Replication

Overview of SQL Server Replication
Replication Programming Interfaces
Configuring Replication
Synchronizing Data

Disaster Recovery

Planning a Backup Strategy
Backing Up Databases
Scheduling Your Backups
Verifying Backup Media
Restoring Databases
Using Database Snapshots

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

Database Mirroring

Understanding Mirroring
Setting Up Database Mirroring
Monitoring Database Mirroring

Log Shipping

Overview
Configuring Log Shipping
Monitoring Log Shipping Jobs
Using Transact-SQL

Peer-to-Peer Replication

Overview
Configuring the Distributor
Creating the Publisher
Configuring Peer-to-Peer Subscribers
Configuring Peer-to-Peer Topology

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

Implementing Service Brokers

Understanding Service Brokers
Designing Service Broker Applications
Programming Service Broker Applications

Conclusion

VB.NET, C#, ASP, & ASP.NET Training

Java Training

SQL Server Training
SharePoint Training

Adobe Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.