  |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
• |
Overview of SQL Server 2005 |
|
• |
System Enhancements for Administrators |
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. |
Module 3: SQL Server 2005 Administrative Tools
This module explains what built-in administration tools and utilities are available in Microsoft SQL Server™ 2005 and how they can be used to help database administrators be successful in managing a SQL Server 2005 solution.
Lessons
|
• |
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. |
Module 4: Monitoring SQL Server 2005
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 |
Lab 4: Monitoring SQL Server 2005
|
• |
Creating DDL Triggers |
|
• |
Creating Event Notifications |
Module 5: Maintaining Databases and Indexes
This module explains the tools and utilities in Microsoft SQL Server™ 2005 that can help you implement database maintenance plans, manage database indexes, and tune databases.
Lessons
|
• |
Managing Indexes |
|
• |
Using the Database Tuning Advisor |
Lab 5: Maintaining a Database
|
• |
Defining Indexes |
|
• |
Tuning a Database |
Module 6: Securing SQL Server 2005
This module explains the changes and enhancements to the Microsoft SQL Server™ security model in SQL Server 2005.
Lessons
|
• |
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. |
Module 7: Disaster Recovery
This module you will learn about the enhanced backup and restore functionality in Microsoft SQL Server™ 2005.
Lessons
|
• |
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 |
Module 8: Data Availability in SQL Server 2005
This module teaches you how to take advantage of the high availability features found in SQL Server 2005
Lessons
|
• |
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 |
Module 9: SQL Server 2005 Replication
This module explains the new and enhanced replication features in SQL Server 2005
Lessons
|
• |
Overview of Replication Enhancements |
|
• |
New Types of Replication |
|
• |
Configuring Replication |
This course may also available as an online course. Click here to see our online courses.
Links:
Implementing SQL Server 2005 Database | Maintaining SQL Server 2005 | MCAD Training | MCDBA | MCDST | MCITP Database Administration | MCITP Enterprise Administration | MCITP Server Administration | MCITP Training | MCPD Course Cape Town | MCPD Course | MCPD Training South Africa | MCPD Training | MCSA | MCSA Boot Camp | MCSA Self Study | MCSA Training (2) | MCSA Training | MCSA Training | MCSD Bootcamp | MCSD Self Study bak | MCSD Self Study | MCSE2K3 old | MCSE2K3 | MCSE Cape Town | MCSE Course Cape Town | MCSE Course Information | MCSE Course SA | MCSE Course Durban | MCSE East London | MCSE George | MCSE JHB | MCSE Nelspruit | MCSE Polokwane | MCSE Port Elizaeth | MCSE Pretoria | MCSE Training | MCSE Training Cape Town | MCSE Training SA | MCSE Boot | MCTS SQL Server 2005 | MCTS Windows Server 2008 Active Directory Configuration | MCTS Windows Server 2008 Application Infrastructure Configuration | MCTS Windows Server 2008 Network Infrastructure | Microsoft.NET | Microsoft Exchange Server 2003 Training Course | Microsoft Office Specialist | Microsoft Training | MSExcel | MS Office | MS Word | SQL Programming | SQL Programming 2005 | SQL Server 2005 Upgrade | SQL Server Administration | SQL Server Administration 2005 |
(c) 2KO International 2009, seo by 1st Place SEO, a division of 2KO International