Course Name:	Maintaining a SQL Server 2005 Database Training
Deployment Options:	Interactive CDs with Exclusive LearningZone 7x24 Live Mentor
Course Price:	$795.00
Purchase Training Online:

Detailed Description

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.NET Trainers in the industry to help us develop the ultimate training & certification program which includes everything you will need to fully prepare for and pass your certification exams. 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.

Included with this Program:

9 CD-ROMs 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 7x24 Live Mentor Click for More Details 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

Course Outline:

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 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 8 Review Introduction to Replication Lesson 1: Introduction Introduction Replication Roles Replication Types Articles, Publications, and Subscriptions Lesson 2: Scenarios Server to Server Scenarios Server to Client Scenarios Module 9 Review Course Closure

Please contact E&A Education and Consulting Services Group for details and a complete course outline.You can also order by calling sales at 888-742-3214

Other Expertise:

CBT's and Online Training Catalog Oracle Applications Training and Consulting Peoplesoft Applications Training and Consulting SAP Applications Training and Consulting Security Technologies Training and Consulting Telecommunications Training and Consulting Wireless Technology Training and Consulting