List Price: |
Special Price: |
|
 |
 |
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
Package Includes:
- 9 Sessions featuring live instructor-led classroom sessions with full audio, video and demonstration components
- Printable courseware
- Sample codes
- Step-by-step hands-on-labs
- Exclusive LearningZone Live Mentor (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
Our Training 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
Our training is recognized worldwide for its technology-based IT training curriculums. Upon successful completion of our program, you will be receiving an official Distance Education Certificate of Completion.
Course Introduction
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Dynamic Management Objects
Demo: Viewing Current Activity
Lesson 2: System Monitor
System Monitor
Performance Objects
Monitoring SQL Server
Demo: Using 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
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
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
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
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
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
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
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
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
Creating Job Steps
The Job Activity Monitor
Demo: Jobs and Operators
Lesson 4: Alerts
Introduction
Creating an Alert
Demo: Alerts
Creating an Alert
Demo: Alerts
Lesson 5: Multiple Servers
Master and Target Servers
Considerations
Event Forwarding
Considerations
Event Forwarding
Lesson 6: Managing Security
SQL Server Agent Roles
SQL Server Agent Proxies
Demo: SQL Server Agent Proxies
Module 7 Review
SQL Server Agent Proxies
Demo: SQL Server Agent Proxies
Module 7 Review
Maintaining High Availability
Lesson 1: Introduction
Availability Factors
Considerations
Considerations
Lesson 2: Server Clustering
Introduction
Considerations
Installing SQL Server in a Cluster
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
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 8 Review
Implementing Log Shipping
Switching Server Roles
Demo: Log Shipping
Module 8 Review
Introduction to Replication
Lesson 1: Introduction
Introduction
Replication Roles
Replication Types
Articles, Publications, and Subscriptions
Replication Roles
Replication Types
Articles, Publications, and Subscriptions
Lesson 2: Scenarios
Server to Server Scenarios
Server to Client Scenarios
Module 9 Review
Course Closure
Server to Client Scenarios
Module 9 Review
Course Closure