 |
Академия -> Курсы -> Базы данных ->#2723 Microsoft SQL Server 2000 for Experienced Database Professionals Описание курса | | |
| Продолжительность: 3 дн. | Стоимость: 16 000 р. |
|
Назначение курсаThe primary audience for this course is database administrators who are experienced and proficient with enterprise database products such as Oracle, DB2, or Sybase.
It will also help current database administrators who are experienced with Microsoft SQL Server 6.5 and earlier.
This course is not for individuals who are experienced only in desktop database management systems such as Microsoft Access or individuals who are experienced in SQL Server 7.0. ПодготовкаDatabase administrators who are experienced in Oracle, DB2, or Sybase. These database administrators have a technical depth of understanding of the database management systems (DBMS) that they currently administer, implement, and manage, and want to apply their database skills to SQL Server 2000.
Database administrators who are experienced in Microsoft SQL Server 4.2x, 6.0, or 6.5. (Secondary): These database administrators have a technical depth of understanding of the database systems that they currently administer, implement, and manage, and want to apply their current skills to SQL Server 2000.
To be successful in this class, students should have experience in administration and implementation of departmental or enterprise relational database management systems (RDBMS).
Знание английского языка для прочтения методических пособий и выполнения практических заданий. Материалы по курсуСлушателям выдаются учебные материалы, авторизованные Microsoft.
По окончании курса слушатели получают сертификат компании Microsoft международного образца. Дополнительная информацияКурс готовит к экзамену:
70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition
70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise EditionПрограмма курса
Module 1: SQL Server Product Overview |
| Introduction to SQL Server Architecture
SQL Server Programming Environment |
|
Module 2: SQL Server Components |
| Relational Engine
Analyzing Query Plans
Memory and Processes
Client Connectivity |
|
Module 3: SQL Server Storage Subsystems |
| SQL Server Storage Structures
SQL Server Index Architecture
Managing Indexes
Working With Statistics |
|
Module 4: SQL Server Administration |
| Administering SQL Server by Scripting and Using SQL Server Enterprise Manager
Automating Administration by Using SQL Server Agent and Jobs
Creating and Using Alerts
Using Multiserver Jobs |
|
Module 5: Backup and Restore |
| SQL Server Recovery Models
SQL Server Backups
Restoring Backups |
|
Module 6: SQL Server Security |
| SQL Server Security Architecture
Securing SQL Server
Common Security Issues |
|
Module 7: Monitoring SQL Server |
| Monitoring System and Server Activity
Managing Locks
Additional Performance Considerations |
|
Module 8: Transferring and Analyzing Data |
| Distributed Queries
Data Extraction, Transformation, and Loading Tools
Analysis Services |
|
Академия -> Курсы -> Базы данных ->#2723 Microsoft SQL Server 2000 for Experienced Database Professionals
|
|
