| Sign in | Sitemap | Feedback
Go To AppexTech

Advanced SQL Server 2005

1 Hour Daily

Duration:- ... Months

SQL Server 2005 topics such as disaster recovery, failover clustering, database mirroring, log shipping, replication, and partitioning.

Advanced SQL Server 2005 Training Objectives

All attendees will learn to:

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

Advanced SQL Server 2005 Training Outline

  1. Disaster Recovery
    1. Planning a Backup Strategy
    2. Backing Up Databases
    3. Scheduling Your Backups
    4. Verifying Backup Media
    5. Restoring Databases
    6. Using Database Snapshots
  2. Failover Clustering
    1. High Availability Overview
    2. SQL Server 2005 Failover Cluster
    3. Preparing a Server Cluster
    4. Creating a New Cluster
    5. Installing SQL Server 2005 Failover
    6. Adding Additional SQL Server Nodes
  3. Database Mirroring
    1. Understanding Mirroring
    2. Setting Up Database Mirroring
    3. Monitoring Database Mirroring
  4. Log Shipping
    1. Overview
    2. Configuring Log Shipping
    3. Monitoring Log Shipping Jobs
    4. Using Transact-SQL
  5. Peer-to-Peer Replication
    1. Overview
    2. Configuring the Distributor
    3. Creating the Publisher
    4. Configuring Peer-to-Peer Subscribers
    5. Configuring Peer-to-Peer Topology
  6. Monitoring & Troubleshooting
    1. Diagnosing and Resolving Database Server Errors
    2. Set Up Alerts Using SQL Server Agent
    3. Monitoring SQL Server Agent Job History
    4. Gathering Performance Data and Optimization using DMV
  7. Implementing Service Brokers
    1. Understanding Service Brokers
    2. Designing Service Broker Applications
    3. Programming Service Broker Applications
  8. Implementing SQL Server Partitions
    1. Overview of Table-based Partitioning
    2. Creating Partitioned Tables
    3. Querying Partitions
    4. Managing Partitions
  9. Complex Querying
    1. Working with NULL Values
    2. Ranking Grouped Data
    3. Writing Correlated Subqueries
    4. Using Common Table Expressions
  10. Advanced Techniques
    1. Complex Data and Structures
    2. Writing More Efficient Queries
    3. Working with Complex Queries
    4. Maintaining Query Files
  11. Working with XML
    1. The XML Data Type
    2. XML Schema Collections
    3. Querying XML
    4. Best Practices

Database Training