| |
MOC 2780: Maintaining a MS SQL Server 2005 Database
Training Package Includes
- 9 CD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components
- Printable courseware
- Step-by-step hands-on-labs
- Comprehensive, understandable, and reusable as reference material
- Focused on practical solutions to real-world development problems
Course Introduction
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.
List of Course Features
MOC 2780: Maintaining a MS SQL Server 2005 Database Course Contents
|
| |
Installing and Configuring SQL Server 2005
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
Installing
Overview of the Installation Process
System Consistency Checker?
Options
Performing an Unattended Installation
Demo: Managing Comp Installations
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
Planning
Data Storage
Transaction Logging
File Placement
What Are Filegroups?
Filegroup Considerations
Capacity Planning Considerations
Creating
Considerations
Syntax for Creating a Database
Schemas
Syntax for Creating a Schema
Name Resolution
Demo: Creating Databases
Managing
Options
Finding Information about Databases
Demo: Finding Information
Module 2 Review
Disaster Recovery
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
Back Up User Databases
Full Database Backup
Transaction Log Backup
Differential Backup
File and Filegroup Backups
Ensuring Backup Integrity
Demo: Back Up a Database
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
Recover Data -DB Snapshots
Database Snapshots
How Database Snapshots Work
Recovering Data from a DB Snapshot
Disaster Recovery
Backing Up System Databases
Restoring System Databases
Restoring the Master Database
Module 3 Review
Managing Security
Overview
Principals
Securables
Permissions
Server Scope
Authentication Modes
Password Policies
Managing SQL Server Logins
Fixed Server Roles
Delegation
Credentials
Server-Scope Permissions
Demo: Managing Logins
Database Scope
Managing Users
Special Users
Database Roles
Application Roles
Database-Scope Permissions
Schema-Scope Permissions
Demo: Managing Users
Managing Keys & Certificates Keys
Certificates?
Cryptography Architecture
Keys and Certificates
Demo: Using Certificates
Module 4 Review
|
Monitoring SQL Server
Current Activity
Activity Monitor
Dynamic Management Objects
Demo: Viewing Current Activity
System Monitor
System Monitor
Performance Objects
Monitoring SQL Server
Demo: Using System Monitor
SQL Server Profiler
SQL Server Profiler
Profiler Trace Options
Categories, Events, and Columns
Demo: Using SQL Server Profiler
DDL Triggers
Introduction
Creating DDL Triggers
Managing DDL Triggers
Demo: Creating a DDL Trigger
Event Notifications
Introduction
Creating Event Notifications
Processing Event Notifications
Managing Event Notifications
Demo: Implementing Event Notifications
Module 5 Review
Transfering Data
Introduction to Data Transfer
Data Transfer
Data Transformation
Tools for Transferring Data
SQL Server Integration Srvcs
Introduction to SSIS
SSIS Task Processing
SSIS Tools
Demo: Import and Export Wizard
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
Overview
Benefits
The Maintenance Plan Wizard
The SQL Server Agent
Demo: The Maintenance Plan Wizard
Configuring SQL Server Agent
Considerations
SQL Server Agent Mail Options
Demo: Database Mail
Jobs and Operators Jobs
Operators
Creating Job Steps
The Job Activity Monitor
Demo: Jobs and Operators
Alerts
Introduction
Creating an Alert
Demo: Alerts
Multiple Servers
Master and Target Servers
Considerations
Event Forwarding
Managing Security
SQL Server Agent Roles
SQL Server Agent Proxies
Demo: SQL Server Agent Proxies
Module 7 Review
Maintaining High Availability
Introduction
Availability Factors
Considerations
Server Clustering
Introduction
Considerations
Installing SQL Server in a Cluster
Database Mirroring
Introduction
Options
Database Mirroring Endpoints
Preparing Servers for Database Mirroring
Establishing a Mirror Session
Handling Failover
Log Shipping
Introduction
Implementing Log Shipping
Switching Server Roles
Demo: Log Shipping
Module 8 Review
Introduction to Replication
Introduction
Introduction
Replication Roles
Replication Types
Articles, Publications, and Subscriptions
Scenarios
Server to Server Scenarios
Server to Client Scenarios
Module 9 Review
Course Closure |
