2786 - Designing a Microsoft SQL Server 2005 Infrastructure Training

2005 database design developer mcitp microsoft server solution sql

Schedule our instructor led classroom training at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the Best Microsoft-Certified Trainers in the industry to help us develop the ultimate training & certification program which includes everything you will need to succeed.

This instructor-led course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL Server 2005 database infrastructure. The course focuses on the development of strategies for data archiving, consolidation, distribution, and recovery. The course also stresses the importance of capacity analysis and emphasizes the tradeoffs that need to be made during design.

This course is a requirement for the following Exam(s) :

MCITP Exam 70–443: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
MCITP Exam 70–447: MCITP Upgrade for existing MCDBA Database Administrators.

Our reputation speaks for itself! See what others are saying... Testimonials

Package Includes:

7 CD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components
Printable courseware
Step-by-step hands-on-labs Try out one of our labs...
Exclusive LearningZone Live Mentor Click for Details (Value at $195)
Help Whenever you need it! Exclusive LearningZone - Chat Live with our Certified Instructors anytime around the clock (7x24)
Focused on practical solutions to real-world development problems
Proven technique- Actual Exam Secrets Review
Certification Exam Pass Guarantee
Free 1 Year Upgrade Policy

Mark Russell - SQL 2005 Trainer (MCT, MCDBA, MCSD.NET, MCSE Security, CEH, Security+)
Mark Russell has over twenty years total networking and programming experience with a current focus enterprise database development and training using Microsoft SQL Server tools and technologies. Mark is a Certified Technical Trainer. He has taught over 500 Desktop Applications classes and over 500 Technical classes. Mark has completed Microsoft approved Train-the Trainer Program. He was named Instructor of the Year in 1999 with New Horizons Worldwide. As a Microsoft Certified Trainer, Mark has maintained an overall class (Instructor score) average of 9.62 on a 10 scale.

Course Features:

Main Menu
Move through hours of in-depth content - quickly and easily due to the efficient and organized structure.
PowerPoint
Utilizing PowerPoint presentations enhances the delivery by displaying a variety of visual information to the user. This type of representation allows the user to better interpret the material through charts, definitions, graphs, and more...
Exclusive Learning Zone
Train around the clock, around the world. Our certified online instructors are located at global support centers in the U.S., U.K., Australia, and Singapore to provide real-time answers to technology- and soft-skill-related questions 24x7. This means access to a live subject matter expert no matter where you are - day or night. This level of student/instructor interaction provides real-time training specific support and extends training beyond content and instructor-led solutions by providing flexibility to accommodate individual needs and schedules.
Controls
Move forward, back, and repeat entire topics or just a section. A progress bar illuminates as you advance through exercises.
Full Motion Video
All courses feature full-motion videos of instructors teaching the information as if they are speaking directly to you. Our unique delivery simulates a one-on-one classroom environment creating a more personal lesson and learning experience.
Study Guides
Printable study guides for the entire course are available. This allows all material to be viewed, reviewed, and printed for viewing at a later date.
Review Exercises
Each section has a review quiz to aid in the learning process by validating the comprehension of the material covered before moving on to a new section.
Resume
All courses are resumed to where you left off last session allowing you to learn when it is convenient for you without the hassle of remembering where you where.
Microsoft Authorized Practice Exams
CareerAcademy.com includes Authorized Practice Exams from Microsoft Certified Practice Test Provider (MeasureUp) to fully prepare you for the certification exams. Because many companies offer training and practice tests, the Microsoft MCP program has designated MeasureUp as a certified test provider to help IT candidates select the highest quality products and services. Microsoft performs quality reviews on all Practice Test Provider, and only approved practice test vendors bear the Microsoft Certified Practice Test Provider logo.
Live Demonstrations
Demonstrations are a way for the instructor to show and tell the user how to perform a task by actually doing it on screen in front of them. In this format it gives the user the power to see things done by a professional in the intended environment as many times as they would like.
Labs
This course features cutting-edge, interactive labs, which provide a hands-on learning experience. This environment allows you to interact with the software with out the need for purchasing it or having it installed on your computer.
Certificate of Completion
Career Academy is recognized worldwide for its technology-based IT training curriculums. Upon successful completion of our program, you will be receiving a Career Academy Distance Education Certificate of Completion.

Module 1 - Analyzing Capacity Needs

Lesson 1: Storage Requirements

Determining Current Storage Capacity
Determining the Impact of Regulatory Requirements
Estimating Projected Storage Requirements

Lesson 2: CPU Requirements

Analyzing Current CPU Performance
Choosing a Processor Type
Forecasting CPU Needs

Lesson 3: Memory Requirements

Determining Current Memory Usage
Forecasting Memory Needs

Lesson 4: Network Requirements

Identifying the Database Components of the Topology
Analyzing Current Database Network Traffic
Estimating Network Traffic Growth for Database Servers
Lab 1 Introduction
Module 1 - Review

Module 2 - Data Archiving

Lesson 1: Requirements That Affect Data Archiving

Reasons for Archiving Data
Determining How Much Data Can Be Archived
Determining the Accessibility Requirements of Archived Data

Lesson 2: Structure of Archival Data

Structuring Archival Data
Structure of Archival Data

Lesson 3: Creating a Data Archival Plan

Creating a Data Archival Plan
Deciding What Data to Archive
Selecting a Storage Format for Archival Data
Developing an Archival Data Movement Strategy
Lab 2 Introduction
Module 2 - Review

Module 3 - Database Server Consolidation

Lesson 1: Overview

Benefits
Risks

Lesson 2: Strategy for SQL Server Instances

Installing Multiple Instances
Multiple Instance Design

Lesson 3: Database Server Consolidation Plan

Designing a Consolidation Plan
Creating a Consolidation Plan
Lab 3 Introduction
Module 3 - Review

Module 4 - Data Distribution

Lesson 1: Data Distribution Tools

Why Distribute Data?
Considerations
Tools

Lesson 2: Data Distribution Plans Using Replication

Creating a Data Distribution Plan
Gathering Requirements for Data Distribution
Guidelines for Creating a Data Distribution Plan
Lab 4 Introduction
Module 4 - Review

Module 5 - Designing a Database Server Infrastructure

Lesson 1: Determining the Current

Infrastructure
Assessing the Quality of Database Designs
Assessing the Quality of Database Server Configurations
Assessing Database Storage

Lesson 2: Gathering Requirements for Changing an Infrastructure

Technical Requirements
Business Requirements
Gathering Infrastructure Requirements

Lesson 3: Designing Modifications to an Infrastructure

Database Server Infrastructure Design
Selecting Database Server Hardware and Software
Establishing Database Design and Implementation Policies
Establishing Administrative Policies
Lab 5 Introduction
Module 5 - Review

Module 6 - Data Recovery

Lesson 1: Backup and Restore Strategies

Designing a Backup and Restore Strategy
Analyzing Business Requirements for Data Recovery
Categorizing Databases for Backup and Restore
Protecting Backups

Lesson 2: Creating Disaster Recovery Plans

Recommended Components of a Disaster Recovery Plan
Creating a Disaster Recovery Decision Tree
Documenting a Decision Tree
Best Practices
Lab 6 Introduction
Module 6 - Review

Module 7 - Establishing Database Conventions and Standards

Lesson 1: Database Naming Conventions

Problems with Common Naming Conventions
Establishing Database Naming Conventions

Lesson 2: Database Standards

Types of Standards
SQL Coding Standards
Database Access Standards
Deployment Process Standards
Lab 7 Introduction
Module 7 - Review
Closure