SQL Server 2005 training: Advanced Topics in SQL Server 2005 Administration and Development

Course Number: SQL-114
Duration: 3 days
view class outline

Advanced SQL Server 2005 Training Overview

In this three-day course, attendees examine additional SQL Server 2005 topics such as disaster recovery, failover clustering, database mirroring, log shipping, replication, and partitioning.

Important Note: Individual units from this course can be included in other SQL Server 2005 courses we teach, if desired. Please let us know the details of your needs when you contact us.

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.

Advanced SQL Server 2005 Training Prerequisites

No prior experience is presumed.

Hands-on/Lecture Ratio

This class is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 10 minutes.

Advanced SQL Server 2005 Training Materials

All students will receive:

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

Software Needed on Each Student PC

Windows Server 2003 or Windows Server 2008
SQL Server 2005 full install with latest service packs applied
At least 2GB RAM (3GB recommended)
Sample databases and related tools - please contact us for a detailed setup sheet

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

Advanced SQL Server 2005 Training Objectives

All attendees will learn to:

Implement a backup and disaster recovery strategy
Set up SQL Server 2005 clusters
Implement database mirroring
Configure log shipping
Set up SQL Server 2005 replication
Build and tune advanced queries, including queries that use XML

Advanced SQL Server 2005 Training Outline

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

Implementing SQL Server Partitions

Overview of Table-based Partitioning
Creating Partitioned Tables
Querying Partitions
Managing Partitions

Complex Querying

Working with NULL Values
Ranking Grouped Data
Writing Correlated Subqueries
Using Common Table Expressions

Advanced Techniques

Complex Data and Structures
Writing More Efficient Queries
Working with Complex Queries
Maintaining Query Files

Working with XML

The XML Data Type
XML Schema Collections
Querying XML
Best Practices

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.