|
More on Single User, Multi User & Network Licences
PACKAGE INCLUDES8 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 INTRODUCTIONSchedule 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.
|
COURSE OUTLINE
|
Module 1What'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 2Installing 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
Module 2 Wrap-up
| Module 3New 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 4New 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 5Tuning 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 6Security 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 7New 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 8New 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
|
|