Search
Home
Articles
Backup
Books
Certification
FAQ
Products
Replication
Scripts
Seminars
Training
TSQL

MSDN Fourms
Fort Worth SSUG
Oklahoma City SSDG

Resume

Champion Valley Pens

Microsoft SQL Server 2005 Certification Boot Camp 70-443

Class Scheduling

Register for this course: TCU's Extended Education Program.

Overview

Drawing on decades of practical experience, MHS Enterprises courses are a leap forward in content creation and delivery. Each Mentor teaching a course brings years of past and ongoing practical experience on the subject into the classroom to provide a unique perspective on the content delivered. Based on that practical experience, each mentor is equipped to answer any question which should arise and ensure that each delegate attending the class will leave with skills that can be applied immediately in their environment. Only the best content available coupled with the best instructors possible and utilizing the most current knowledge make it into an MHS course.

Certification Boot Camps cover the subject matter for an exam, however, they are not taught directly to the exam. All of the other test prepartion courses focus on students memorizing large amounts of material for the sole purpose of taking a particular exam. Once the exam is completed, most of the knowledge memorized is either forgotten or not useful in the IT world. These courses are designed to teach the subject matter while not teaching specifically to an exam. At the conclusion of the training, attendees come away with a large volume of knowledge which can be immediately applied to their jobs. If a student decides to subsequently take an exam, they are prepared for the material, but first and foremost, they are prepared for the demands of a job working with SQL Server.

This course covers the entire subject matter encompassed by the 70-443 exam.

Course Price

Regular course price: $6000.
Price for TCU's Extended Education Program: $300.

Exam

70-443 exam

Microsoft Certification

Microsoft Certified IT Professional - Database Administrator

Textbook

MCITP Self-Paced Training Kit (Exam 70-443): Designing a Database Server Infrastructure Using Microsoft SQL Server(TM) 2005 (Pro Certification)

Instructors

The primary author and primary instructor of this course, Michael Hotek, brings over a decade and a half of SQL Server experience in some of the largest and most complicated environments in the world. Mike is an accomplished speaker and trainer having delivered over 200 sessions across dozens of training events spanning more than 8 years with more than 2000 people having attended training from him. Mike is certified in both SQL Server 2005 as well as being a Microsoft Certified Trainer.

Course Outline

  • Module 1 - Server Infrastructure
    • Sizing a Server
    • Processor Architecture
    • Disk Subsystem
    • Memory
    • Windows Editions
  • Module 2 - Consolidation
    • Multiple Instances
    • Consolidating Instances
  • Module 3 - SQL Server Security in the Enterprise
    • Assessing Business Requirements
    • Authentication
  • Module 4 - Database Security Policies
    • Security Policies
    • Encrypting Network Traffic
    • Reducing Attack Surface
  • Module 5 - Endpoints
    • Overview
    • TCP Endpoints
    • HTTP Endpoints
  • Module 6 - Database Security
    • Authentication and Authorization
    • Principals
    • Securables
    • Permissions
    • Execution Context
  • Module 7 - Planning High Availability
    • Assessing Requirements
    • Database Storage
    • Migrating to an Availability Solution
  • Module 8 - Failover Clustering
    • Windows Clustering
    • Failover Instances
  • Module 9 - Database Mirroring
    • Overview
    • Components and Roles
    • Initializing
    • Failover and Failback Scenarios
  • Module 10 - Log Shipping
    • Overview
    • Initializing
    • Failover and Failback Scenarios
  • Module 11 - Replication
    • Overview
    • Transaction Replication
    • Merge Replication
    • Failover and Failback Scenarios
  • Module 12 - Physical Database Design
    • Table Design
    • Filegroups
    • Indexes
    • Views
    • Stored Procedures
    • Naming Conventions and Coding Standards
  • Module 13 - Recovery Strategies
    • Assessing Data Recovery Needs
    • Backup Types
    • Database Recovery
    • Backup Media
  • Module 14 - Archiving Data
    • Data Archive Policies
    • Partitioning

Michael R. Hotek

All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.