Компьютерная Академия СофтДжойс Компьютерная Академия СофтДжойс Компьютерная Академия СофтДжойс

#2733 Updating Your Database Administration Skills to Microsoft SQL ServerT 2005

Академия -> Курсы -> Базы данных ->#2733 Updating Your Database Administration Skills to Microsoft SQL ServerT 2005

Описание курса

Записаться на курс
Продолжительность: 3 дн.
Стоимость: 16 000 р.

Назначение курса

This course is intended for experienced database administrators and database developers who are responsible for the supporting, configuring, and maintaining enterprise SQL Server 2005 databases and servers.

Подготовка

Before attending this course, students must have:
 MCDBA certification or equivalent knowledge.
 Administration experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0.
 Knowledge of SQL Server 2000/7.0:
 Database and server architecture.
 Installation and configuration.
 Database security.
 Database recovery (backup and restore).
 SQL Server technologies used for database availability such as log shipping and clustering.
 Job automation.
 Database and server monitoring.
 Troubleshooting.
 Replication.
In addition, it is recommended, but not required, that students have completed:
 Course 2072, Administering a Microsoft SQL Server 2000 Database.

Цель курса

This three-day instructor-led course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can support, configure, and maintain enterprise SQL Server 2005 databases and servers.

Программа курса

Module 1: Overview of SQL Server 2005 Architecture

 Overview of SQL Server 2005
 System Enhancements for Administrators
After completing this module, students will be able to:
 Describe the components of SQL Server 2005.
 Describe new and enhanced features for administrators in SQL Server 2005.

Module 2: Installing SQL Server 2005

 Preparing to Install SQL Server 2005
 Performing a SQL Server 2005 Installation
 Maintaining a SQL Server 2005 Installation
Lab 2: Installing SQL Server 2005
 Installing a SQL Server Instance.
After completing this module, students will be able to:
 Plan a SQL Server 2005 installation.
 Install SQL Server 2005.
 Maintain a SQL Server 2005 installation.

Module 3: SQL Server 2005 Administrative Tools

 Using SQL Server Management Studio
 Using SQL Server Computer Manager
 Using the sqlcmd Utility
 Using the SQL Management Objects
Lab 3: Administering SQL Server 2005
 Creating the Personnel database.
 Populating the Personnel database.
 Backing Up the Personnel Database.
After completing this module, students will be able to:
 Choose the appropriate tool or utility to perform an administrative task.
 Use SQL Server Management Studio to manage databases.
 Use SQL Server Computer Manager to manage a server.
 Use the sqlcmd utility to execute Transact-SQL from the command prompt.
 Use SQL Management Objects to script common administrative tasks.

Module 4: Monitoring SQL Server 2005

 Using SQL Profiler
 Using DDL Triggers
 Using Event Notifications
 Using Metadata Views
Lab 4: Monitoring SQL Server 2005
 Creating DDL Triggers
 Creating Event Notifications
After completing this module, students will be able to:
 Use SQL Profiler to monitor SQL Server 2005.
 Use DDL triggers to respond to DDL events.
 Use event notifications to respond to database events.
 Query SQL Server metadata.

Module 5: Maintaining Databases and Indexes

 Managing Indexes
 Using the Database Tuning Advisor
Lab 5: Maintaining a Database
 Defining Indexes  Tuning a Database
After completing this module, students will be able to:
 Maintain indexes in a SQL Server 2005 database.
 Use the Database Tuning Advisor to assist with database design.
 Maintain SQL Server 2005 databases.

Module 7: Disaster Recovery

 Disaster Recovery in SQL Server 2005
 Using Database Snapshots
 Backup and Restore Operations
Lab 7: Managing Disaster Recovery
 Creating a Database Snapshot
 Backing up a Database
After completing this module, students will be able to:
 Describe common disaster recovery enhancements in SQL Server 2005.
 Use database snapshots.
 Perform backup and restore operations.

Module 6: Securing SQL Server 2005

 SQL Server 2005 Security Overview
 Managing SQL Server 2005 Security
 Managing Permissions
 Managing Certificates
Lab 6: Securing a SQL Server 2005 Database
 Managing securables
 Managing principals
 Managing Permissions
 Dropping a User that Created Objects.
After completing this module, students will be able to:
 Describe the security architecture of SQL Server 2005.
 Manage securables and principals.
 Manage permissions.
 Use certificates in SQL Server 2005.

Module 9: SQL Server 2005 Replication

 Overview of Replication Enhancements
 New Types of Replication
 Configuring Replication
After completing this module, students will be able to:
 Describe the enhancements to replication functionality in SQL Server 2005.
 Describe the new types of replication available in SQL Server 2005.
 Configure replication using SQL Server 2005.

Module 8: Data Availability in SQL Server 2005

 Introduction to Data Availability
 Introduction to Database Mirroring
 Configuring Database Mirroring
Lab 8: Maintaining Availability
 Preparing the Principal and Mirror Server
 Establishing a Mirroring Session
 Establishing a Witness Server
 Executing Transactions
 Simulating Principal Server Failure
 Restarting the Failed Server
 Terminating the Mirror Session
After completing this module, students will be able to:
 Describe the data availability technologies included in SQL Server 2005.
 Describe the concepts of database mirroring.
 Configure database mirroring.

Академия -> Курсы -> Базы данных ->#2733 Updating Your Database Administration Skills to Microsoft SQL ServerT 2005

  
Компьютерная Академия СофтДжойс
   Ваш e-mail: 
Компьютерная Академия СофтДжойс
 
группа вКонтакте Яндекс.Метрика