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.
- 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
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.
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
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
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
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
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
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
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
