|
| Course Number | MCITPBootcamp |
|
| Availability and Discounts | Please call 1-(800) 482-2233 or Sales@academyflorida.com to arrange for a
special delivery of this course. Most classes require a minimum of 2 to be
taught. Group discounts are available for larger groups at client’s request.
On-site or private classes are also available at clients request in Florida or
throughout the entire US. Clients may also qualify for free training through our
state funded programs. If you do not see a class listed in our schedules, please
contact THE ACADEMY with your request.
|
|
| Introduction | Microsoft Certified IT Professional: Database Administrator (MCITP: Database Administrator) is the premier certification for database server administrators. This certification demonstrates that you can keep up with your enterprise business solutions 24 hours a day, 7 days a week. |
|
| At Course Completion | After completing this course, students will be able to:
• Describe the architecture of SQL Server 2005.
• Install SQL Server 2005.
• Use SQL Server 2005 administrative tools and utilities.
• Maintain SQL Server 2005 servers and databases.
• Secure a SQL Server 2005 server and database.
• Monitor SQL Server 2005.
• Implement a Backup and Restore solution for SQL Server 2005.
• Implement a data availability solution with database mirroring or clustering.
• Use enhanced SQL Server 2005 replication features. |
|
| Course Materials | The student kit includes a comprehensive workbook and other necessary materials for this class. |
|
| Projected Days | 7 |
|
| Course Outline | Module 1: Overview of SQL Server 2005 Architecture
This module introduces students to the various components and services that comprise SQL Server. Database administrators are often required to manage multiple aspects of the database server – not just the relational database engine, so an awareness of the components and functionality available in SQL Server 2005 is essential in order to prepare database administrators for SQL Server 2005 deployments and management.
Lessons
• 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
This module explains how to plan for a SQL Server 2005 installation, install SQL Server 2005 and maintain a SQL Server 2005 installation.
Lessons
• 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
This module discusses the various tools and techniques you can use to monitor Microsoft® SQL Server™ 2005.
Lessons
• Using SQL Profiler
• Using DDL Triggers
• Using Event Notifications
• Using Metadata Views |
|
| |
![](src="/design/1058003/b.gif"){kind=small}
Enroll Online
