0 Items | 0.00
Go

Global Knowledge | Courses


Maintaining a MS SQL Server 2005 Database

Course Code: M2780
Duration: 5
Price: €1,795.00 

Add to Favourites | Print
Overview 

This five-day instructor-led course training event provides delegates with the knowledge and skills needed to maintain a Microsoft SQL Server 2005 database and deals with some aspects of implementation. The course focuses on how to use SQL Server 2005 product features and tools related to implementing and maintaining the database.

This is an accelerated training event that will use elements from M2779 and M2780 courses, with the emphasis on M2780.


Pre-Requisites

Write Queries Using Transact SQL



Next Course Dates

Dates available on request. Please contact us





    October
    11 Oct - 15 Oct, 2010Mechelen (Belgium)Request Space
    11 Oct - 15 Oct, 2010Amsterdam (Netherlands)Request Space
    November
    15 Nov - 19 Nov, 2010Hvidovre, Global Knowledge (Denmark)Request Space
    15 Nov - 19 Nov, 2010Stockholm (Sweden)Request Space
    29 Nov - 03 Dec, 2010Mechelen (Belgium)Request Space
    December
    13 Dec - 17 Dec, 2010Nieuwegein (Netherlands)Request Space
    January
    10 Jan - 14 Jan, 2011Mechelen (Belgium)Request Space
    March
    07 Mar - 11 Mar, 2011Zoetermeer - 1 (Netherlands)Request Space
    28 Mar - 01 Apr, 2011Mechelen (Belgium)Request Space
    May
    02 May - 06 May, 2011Mechelen (Belgium)Request Space
    02 May - 06 May, 2011Nieuwegein (Netherlands)Request Space

    More Information

    All IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for implementing and maintaining a SQL 2005 database.

    Also suitable to any IT Professionals wanting to update their skills from SQL 2000 to SQL 2005

    • Install and configure SQL Server 2005
    • Create databases and Manage database files
    • Create data types, tables and views and Implement data integrity
    • Plan, create, and optimize indexes
    • Implement stored procedures, functions and managed code in the database
    • Use XML-related features in Microsoft SQL Server 2005
    • Manage security
    • Perform administrative tasks
    • Backup databases
    • Restore databases
    • Monitor SQL Server
    • Troubleshoot SQL Server
    • Transfer data
    • Maintain high availability

    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.

    Exam 70–431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance.

    M2781 - Designing MS SQL Server 2005 Server-Side Solutions

    In This Section

    Related Links

    Need some help?


    Copyright © 2010 Global Knowledge Network Training Ltd. Registered in Ireland with company no. 242488. VAT no. IE8242488G.
    Sitemap, Accessibility Policy, Privacy Policy, Terms & Conditions, Legal Information.
    RSS. (Srv: 222)