Welcome     About Us     Services     Clients     Careers     Training     Contact Us      


SQL Server 2005 DBA Training 

 

In this On-site training class, students will learn the basics of developing and administrating SQL Server 2005 databases. The topics to be covered include, installing, configuring, maintaining, monitoring, tracking and replicating Microsoft SQL Server 2005 databases.

 

Schedule

  • Six(6) weekends
  • Saturdays:  9:00 A.M. - 5.00 P.M.  
  • Sundays  :  9:00 A.M. - 5.00 P.M. 

 

Requirements

  • Laptop with windows XP basic or Vista and Microsoft Office 2003 or 2007

  

Course Fee

  • Training Course Fee: $1000.00 US.

 

Additional Information:

 

This course is limited to 10 participants. Your place in the course is confirmed by an initial deposit of $400.00 which will be applied towards the course fee.

 

Refund Policy: All deposit payments are fully refundable till the start of the second session of the class.Course fees is required to be paid in full by the start of the second day and is non refundable.

Additional Cost: Book(s) and software may be required for the course. Read the Requirements and Book section for more information. Course fee does not include the cost of any book(s)

and/or any required software.

Start Date: Saturday, July 11th, 2009
Location: Bingham Farms, Michigan.

 

Prerequisites

  • A good working knowledge of SQL Server 2000
  • A good understanding of the concepts of Relational Engine, Storage Engine, Integration, Analysis and Reporting Services of SQL Server Technology.
  • A familiarity with features, tools and technologies of SQL Server 2005

Course Outline

Module 1: Installing and Configuring SQL Server 2005

      Preparing to install SQL Server.

      Installing & Pre-forming SQL Server 2005.

      Managing a SQL Server 2005 Installation process.

 

 Module 2: Managing Databases and Files

      Planning Databases

      Creating Databases

      Managing & Monitoring Databases and File Groups.

 

 Module 3: Disaster Recovery

       Planning and Implementing a Backup Strategy

      Backing Up User Databases

      Restoring User Databases

      Performing Online Restore Operations

      Recovering Data from Database Snapshots

      System Database and Disaster Recovery.

      Quiz - 1

 

 Module 4: Managing Security

       Overview of SQL Server Security

       Protecting and assigning the Server Scope permissions

       Protecting the Databse Scope

       Managing Keys and Certificates in SQL Server

       Creating and Managing Users

       Using a Certificate to Protect Data

 

 Module 5: Monitoring SQL Server

       Viewing Current Activity

       Using System Monitor

       Using SQL Server Profiler

       Using DDL Triggers

       Using Event Notifications

       Monitoring SQL Server Performance

       Tracking SQL Server Activity

       Implementing DDL Triggers

       Examine the current activity in a SQL Server instance

 

 Module 6: Transferring Data

       Overview of Data Transfer

       Introduction to SQL Server Integration Services

       Using SQL Server Integration Services

       Creating an SSIS Package

       Deploying an SSIS Package

       Using SSIs to extract, split and sort Data & Lookups.

       Quiz - 2

 

 Module 7: Automating Administrative Tasks

       Automating Administrative Tasks in SQL Server 2005

       Configuring the SQL Server Agent

       Creating Jobs and Operators

       Creating Alerts

       Managing Multiple Servers

       Managing SQL Server Agent Security

 

 Module 8: Implementing Replication

        Overview of Replication

       Implementing Replication

       Configuring Replication in Some Common Scenarios

       Creating Publication & Subscription

 

 Module 9: Maintaining High Availability

         Introduction to High Availability

       Implementing Server Clustering 

       Implementing Database Mirroring 

       Implementing Log Shipping 

       Implementing Peer-to-Peer Replication

       Quiz - 3.

 


For additional information please contact us at:

training@pegasync.net