PoÄŤĂ­taÄŤová škola GOPAS  

Gopas CZ 
Gopas SK 
   
     Site map · Advanced search 
Offer of courses » Databases » Microsoft SQL Server » Microsoft SQL Server 2005 » Maintaing a Microsoft SQL Server 2005 Database


   print

MOC 2780 - Maintaing a Microsoft SQL Server 2005 Database

This course provides students with product knowledge and skills needed to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.

Who the course is for

This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database.

What we teach you

  • Install and configure SQL Server 2005
  • Manage database files
  • Manage security
  • Perform administrative tasks
  • Backup databases
  • Restore databases
  • Monitor SQL Server
  • Troubleshoot SQL Server
  • Transfer data
  • Maintain high availability

    Required skills

  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of Transact–SQL
  • Working knowledge of relational databases
  • Some experience with database design

    Teaching methods

    Expert instruction with practical examples, computer practice

    Teaching materials

    The student kit includes a comprehensive workbook.

    Course syllabus

    Installing and Configuring SQL Server 2005

    • Preparing to install SQL Server.
    • Installing SQL Server.
    • Managing a SQL Server 2005 Installation.

    Managing Databases and Files

    • Planning databases.
    • Creating databases.
    • Managing databases.

    Managing Security

    • Overview of SQL Server Security.
    • Securing the Server Scope.
    • Securing the Database Scope.
    • Implementing Cryptography in SQL Server.

    Disaster Recovery

    • Planning a Backup Strategy.
    • Backing Up User Databases.
    • Restoring User Databases.
    • Recovering Data from Database Snapshots.
    • System Database and Disaster Recovery.

    Monitoring SQL Server

    • Viewing Current Activity.
    • Using System Monitor.
    • Using SQL Server Profiler.
    • Using DDL Triggers.
    • Using Event Notifications.

    Transferring Data

    • Overview of Data Transfer.
    • Introduction to SQL Server Integration Services (SSIS).
    • Using SQL Server Integration Services.

    Automating Administrative Tasks

    • Automating Administrative Tasks in SQL Server 2005.
    • Configuring the SQL Server Agent.
    • Creating Jobs and Operators.
    • Create Alerts.
    • Managing Multiple Servers.
    • Managing SQL Server Agent Security.

    Maintaining High Availability

    • Introduction to High Availability.
    • Implementing Server Clustering.
    • Implementing Database Mirroring.
    • Implementing Log Shipping.

    Introduction to Replication

    • Overview of Replication.
    • Creating a Publication.
    • Creating A Subscription

    Recommended subsequent courses

    MOC 2781 - Designing Microsoft SQL Server 2005 Server–Side Solutions
    MOC 2782 - Designing Microsoft SQL Server 2005 Databases
    MOC 2783 - Designing the Data Tier for Microsoft SQL Server 2005
    MOC 2784 - Tuning and Optimizing Queries Using Microsoft SQL Server 2005 – Workshop
    MOC 2786 - Designing Microsoft SQL Server 2005 Infrastructure and Services
    MOC 2787 - Designing Security for Microsoft SQL Server 2005
    MOC 2788 - Designing High Availability Database Solutions Using Microsoft SQL Server 2005
    MOC 2789 - Administering and Automating Microsoft SQL Server– 2005 Databases and Servers
    MOC 2790 - Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 – Workshop

    Catalog price of course and handbook

    Locality Course price ex VAT Price of handbook ex VAT Number IT points
     Praha   17250 Kč  6800 Kč   50 items
     Brno   16250 Kč  6800 Kč   50 items

    Course dates

    Course date Course length Locality Price ex VAT Handbook ex VAT  Speaker language  
     13.09.2010   5   GOPAS Praha  15525 Kč 6800 Kč Course Guaranteed course date
     08.11.2010   5   GOPAS Praha   17250 Kč 6800 Kč Course Guaranteed course date
     10.01.2011   5   GOPAS Praha   17250 Kč 6800 Kč Course
     11.04.2011   5   GOPAS Praha   17250 Kč 6800 Kč Course Guaranteed course date
     17.01.2011   5   GOPAS Brno   16250 Kč 6800 Kč Course
     27.09.2010   5   GOPAS Bratislava   600 EUR 262 EUR Course
     25.10.2010   5   GOPAS Bratislava   600 EUR 262 EUR Course
     27.12.2010   5   GOPAS Bratislava   600 EUR 262 EUR Course
     28.03.2011   5   GOPAS Bratislava   600 EUR 262 EUR Course

    If none of the offered dates suits you, please contact our customer service department on tel. +420 234 064 900-3 (Prague), +420 542 219 935-6 (Brno).