Shopping Cart
Your Cart is currently empty.
|
Updating Your Database Administration Skills to Microsoft SQL Server
|
 View Full-Size Image
|
|
|
|
Updating Your Database Administration Skills to Microsoft SQL Server 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 support, configure, and maintain enterprise SQL Server 2005 databases and servers. Before taking this course, students must have: MCDBA certification or equivalent knowledge, Administration experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0, Knowledge of SQL Server 2000/7.0: Database and Server Architecture. In addition, students must have experience with: Installation and configuration, Database security, Database recovery (backup and restore), SQL Server technologies used for database availability such as log shipping and clustering, Job automation, Database and server monitoring, Troubleshooting and Replication. This course is intended for experienced database administrators and database developers who are responsible for the supporting, configuring, and maintaining enterprise SQL Server 2005 databases and servers. Package Includes - The Online course features live instructor-led classroom sessions with full audio, video and demonstration components
- Printable Courseware
- Step-by-step hands-on-labs Try out one of our labs...*
- Exclusive LearningZone Live Mentor Click for Details (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
- *These product options are only available in the DVD/CD CBT format and not available in the On-Line Delivery
 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 were. | | | 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. |  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
- Consistency Checker
- Installing SQL Server 2005 Demo
- 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
|
|
|
|
|
You may also be interested in this/these product(s)
Microsoft SQL Server 2005 Training Suite
$3,995.00
$1,795.00
You Save: $2,200.00 |
|
|
Last Updated: Friday, 30 July 2010 17:53
|