List Price: |
Special Price: |
|
 |
 |
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 SQL Trainers in the industry to help us develop the ultimate training & certification program.
This course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can design, build, query and develop enterprise SQL Server 2005 databases and servers.
Package Includes:
- 8 Sessions featuring live instructor-led classroom sessions with full audio, video and demonstration components
- Printable courseware
- 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
- Comprehensive, understandable, and reusable as reference material
- 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. - 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.
Module 1
What's New in SQL Server 2005 for Administrators
SQL Server 2005 Overview
Database Engine Enhancements
Analysis Services Enhancements
Reporting Services Enhancements
Replication Enhancements
Demo - Reporting Services
SQL Server Integration Services
Notification Services
Service Broker
Native HTTP Support
SQL CLR Support
Demo - Creating an HTTP Endpoint
Demo - Common Language Runtime
Lab - Creating An HTTP Endpoint
Module 1 Wrap-up
Database Engine Enhancements
Analysis Services Enhancements
Reporting Services Enhancements
Replication Enhancements
Demo - Reporting Services
SQL Server Integration Services
Notification Services
Service Broker
Native HTTP Support
SQL CLR Support
Demo - Creating an HTTP Endpoint
Demo - Common Language Runtime
Lab - Creating An HTTP Endpoint
Module 1 Wrap-up
Module 2
Installing SQL Server 2005
Editions of SQL Server 2005
Hardware Requirements
Software Requirements
Coexistence with SQL Server 2000
System Consistency Checker
Installing SQL Server 2005
Demo - Installing a 2nd Instance of SQL
Adding or Removing Components
Uninstalling SQL Server 2005
Lab - Installing an SQL Server Instance
Module 2 Wrap-up
Module 3
New SQL Server 2005 Admin Tools
SQL Server Management Studio
Demo - Management Studio
SQL Configuration Manager
Demo - Configuration Manager
Surface Area Configuration
Bus Intelligence Development Studio
Demo - Development Environment
The sqlcmd Utility
Demo - Sequel Command
SQL Management Objects
Lab - Creating a Solution
Module 3 Wrap-up
Demo - Management Studio
SQL Configuration Manager
Demo - Configuration Manager
Surface Area Configuration
Bus Intelligence Development Studio
Demo - Development Environment
The sqlcmd Utility
Demo - Sequel Command
SQL Management Objects
Lab - Creating a Solution
Module 3 Wrap-up
Module 4
New SQL Server Monitoring Features
SQL Profiler Enhancements
DDL Trigger Overview
Creating DDL Triggers
Using DDL Trigger EventData
Demo - Creating a DDL Trigger
Managing DDL Triggers
Event Notifications
Demo - Creating an Event Notification
Management Views
Two Types of Management Views
Demo - Querying System Metadata
Lab - Querying Metadata
Module 4 Wrap-up
DDL Trigger Overview
Creating DDL Triggers
Using DDL Trigger EventData
Demo - Creating a DDL Trigger
Managing DDL Triggers
Event Notifications
Demo - Creating an Event Notification
Management Views
Two Types of Management Views
Demo - Querying System Metadata
Lab - Querying Metadata
Module 4 Wrap-up
Module 5
Tuning SQL Server 2005 Databases
New Index Features
Managing Indexes
XML Indexes
Managing Index Fragmentation
Database Engine Tuning Advisor
Using Database Engine Tuning Advisor
Demo - Database Engine Tuning Advisor
Lab - Tuning a Database
Module 5 Wrap-up
Managing Indexes
XML Indexes
Managing Index Fragmentation
Database Engine Tuning Advisor
Using Database Engine Tuning Advisor
Demo - Database Engine Tuning Advisor
Lab - Tuning a Database
Module 5 Wrap-up
Module 6
Security in SQL Server 2005
SQL 2005 Security Enhancements
SQL 2005 Security Architecture
ANSI Schemas in SQL Server 2005
Demo - Schemas
Managing SQL Server 2005 Logins
Demo - Logins
Managing SQL Server Users and Roles
Managing SQL Server 2005 Permissions
Demo - User ID's in Databases
Managing Execution Context
Demo - Permissions
Demo - Execution Context
Lab - Managing Security
Module 6 Wrap-up
SQL 2005 Security Architecture
ANSI Schemas in SQL Server 2005
Demo - Schemas
Managing SQL Server 2005 Logins
Demo - Logins
Managing SQL Server Users and Roles
Managing SQL Server 2005 Permissions
Demo - User ID's in Databases
Managing Execution Context
Demo - Permissions
Demo - Execution Context
Lab - Managing Security
Module 6 Wrap-up
Module 7
New SQL Server 2005 Disaster Recovery & Availability Features
Disaster Recovery Enhancements
Database Snapshots
Database Snapshots and Recovery
Changes to BACKUP
SQL 2005 Restore Enhancements
Online Restores
Demo - Backup
Recovering the Master Database
SQL 2005 High Availability Options
SQL Server 2005 Database Mirroring
Mirror Server Prerequisites
Partnerships and Witnesses
Lab - Creating a Database Snapshot
Module 7 Wrap-up
Database Snapshots
Database Snapshots and Recovery
Changes to BACKUP
SQL 2005 Restore Enhancements
Online Restores
Demo - Backup
Recovering the Master Database
SQL 2005 High Availability Options
SQL Server 2005 Database Mirroring
Mirror Server Prerequisites
Partnerships and Witnesses
Lab - Creating a Database Snapshot
Module 7 Wrap-up
Module 8
New SQL Server 2005 Replication Features
Replication Architectural Enhancements
Performance and Scalability
Replication Tool Enhancements
Heterogeneous Replication
Peer-to-Peer Replication
HTTP Replication
Demo - Creating a Publication
Lab - Creating a Publication
Module 8 Wrap-up
Course Closure
Performance and Scalability
Replication Tool Enhancements
Heterogeneous Replication
Peer-to-Peer Replication
HTTP Replication
Demo - Creating a Publication
Lab - Creating a Publication
Module 8 Wrap-up
Course Closure