2780B - Maintaining a SQL Server 2005 Database Training

Maintaining a Microsoft SQL Server 2005 Database

The Technology Specialist certifications enable professionals to target specific technologies and distinguish themselves by demonstrating in-depth knowledge and expertise in their specialized technologies.

This video-based course will provide students with product knowledge and skills needed to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database. This course is intended for IT Professionals wanting to learn SQL Server 2005 product features and technologies.

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

Exam 70–431 : Microsoft SQL Server 2005 - Implementation and Maintenance

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

Package Includes:

9 CD-ROMs or 3 DVDs featuring live instructor-led classroom sessions with full audio, video and demonstration components
Printable courseware
Sample codes
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
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.

Course Introduction

Installing and Configuring SQL Server 2005

Lesson 1: Preparing to Install

SQL Server 2005 Editions
Hardware Requirements
Software Requirements
SQL Server Instances
Licensing Options
Security Considerations
Collation Considerations
Considerations for Upgrading
Demo - Finding Pre-Installation Info

Lesson 2: Installing

Overview of the Installation Process
System Consistency Checker?
Options
Performing an Unattended Installation
Demo: Managing Comp Installations

Lesson 3: Managing an Installation

Surface Area Configuration Tool
SQL Server Configuration Manager
SQL Server Management Studio
Demo: SQL Server Management Studio
sqlcmd
Demo: sqlcmd
Server-Level Options?
Module 1 Review

Managing Databases and Files

Lesson 1: Planning

Data Storage
Transaction Logging
File Placement
What Are Filegroups?
Filegroup Considerations
Capacity Planning Considerations

Lesson 2: Creating

Considerations
Syntax for Creating a Database
Schemas
Syntax for Creating a Schema
Name Resolution
Demo: Creating Databases

Lesson 3: Managing

Options
Finding Information about Databases
Demo: Finding Information
Module 2 Review

Disaster Recovery

Lesson 1: Backup Strategy

Backup Types
Recovery Models?
Full Database Backup Strategy
DB & Transaction Log Backup Strategy
Differential Backup Strategy
File or Filegroup Backup Strategy
Backup Operators
Backup Media

Lesson 2: Back Up User Databases

Full Database Backup
Transaction Log Backup
Differential Backup
File and Filegroup Backups
Ensuring Backup Integrity
Demo: Back Up a Database

Lesson 3: Restore User Databases

The Restore Process
Restoring a Database
Restoring a Transaction Log Backup
Restoring Pages, Files, and Filegroups
Piecemeal Restore
Demo: Restoring a Database

Lesson 4: Recover Data -DB Snapshots

Database Snapshots
How Database Snapshots Work
Recovering Data from a DB Snapshot
Lesson 5: Disaster Recovery
Backing Up System Databases
Restoring System Databases
Restoring the Master Database
Module 3 Review

Managing Security

Lesson 1: Overview

Principals
Securables
Permissions

Lesson 2: Server Scope

Authentication Modes
Password Policies
Managing SQL Server Logins
Fixed Server Roles
Delegation
Credentials
Server-Scope Permissions
Demo: Managing Logins

Lesson 3: Database Scope

Managing Users
Special Users
Database Roles
Application Roles
Database-Scope Permissions
Schema-Scope Permissions
Demo: Managing Users

Lesson 4: Managing Keys & Certificates Keys

Certificates?
Cryptography Architecture
Keys and Certificates
Demo: Using Certificates
Module 4 Review

Monitoring SQL Server

Lesson 1: Current Activity

Activity Monitor
Dynamic Management Objects
Demo: Viewing Current Activity

Lesson 2: System Monitor

System Monitor
Performance Objects
Monitoring SQL Server
Demo: Using System Monitor

Lesson 3: SQL Server Profiler

SQL Server Profiler
Profiler Trace Options
Categories, Events, and Columns
Demo: Using SQL Server Profiler

Lesson 4: DDL Triggers

Introduction
Creating DDL Triggers
Managing DDL Triggers
Demo: Creating a DDL Trigger

Lesson 5: Event Notifications

Introduction
Creating Event Notifications
Processing Event Notifications
Managing Event Notifications
Demo: Implementing Event Notifications
Module 5 Review

Transferring Data

Lesson 1: Introduction to Data Transfer

Data Transfer
Data Transformation
Tools for Transferring Data

Lesson 2: SQL Server Integration Srvcs

Introduction to SSIS
SSIS Task Processing
SSIS Tools
Demo: Import and Export Wizard

Lesson 3: How to use SSIS

Data Sources and Data Source Views
Connection Manager
Package Control Flow
Data Flow Tasks
Deploying Packages
Module 6 Review

Automating Administrative Tasks

Lesson 1: Overview

Benefits
The Maintenance Plan Wizard
The SQL Server Agent
Demo: The Maintenance Plan Wizard

Lesson 2: Configuring SQL Server Agent

Considerations
SQL Server Agent Mail Options
Demo: Database Mail

Lesson 3: Jobs and Operators Jobs

Operators
Creating Job Steps
The Job Activity Monitor
Demo: Jobs and Operators

Lesson 4: Alerts

Introduction
Creating an Alert
Demo: Alerts

Lesson 5: Multiple Servers

Master and Target Servers
Considerations
Event Forwarding

Lesson 6: Managing Security

SQL Server Agent Roles
SQL Server Agent Proxies
Demo: SQL Server Agent Proxies
Module 7 Review

Introduction to Replication

Lesson 1: Introduction

Introduction
Replication Roles
Replication Types
Articles, Publications, and Subscriptions

Lesson 2: Scenarios

Considerations
SQL Server Agent Mail Options
Demo: Database Mail
Server to Server Scenarios
Server to Client Scenarios
Replication Agents
Implementing Replication
Creating a Publication
Creating a Subscription
Managing and Monitoring Replication
Replication Scenarios
Server-to-Server Scenarios
Server-to-Client Scenarios
HTTP Replication
Peer-to-Peer Replication
Oracle Publishing
Module 8 Review

Maintaining High Availability

Lesson 1: Introduction

Availability Factors
Considerations

Lesson 2: Server Clustering

Introduction
Considerations
Installing SQL Server in a Cluster

Lesson 3: Database Mirroring

Introduction
Options
Database Mirroring Endpoints
Preparing Servers for Database Mirroring
Establishing a Mirror Session
Handling Failover

Lesson 4: Log Shipping

Introduction
Implementing Log Shipping
Switching Server Roles
Demo: Log Shipping
Module 9 Review