Microsoft SQL Server 2008 Advanced Administration Training Course
Our Advanced SQL 2008 Advanced Database Administration
Training Teaches You: Designing, Optimizing and Maintaining a Database Server
Infrastructure and Much More.
Plus, Complete 70-450 Exam Coverage!
If you want to develop hands-on experience as a SQL
Server 2008 Administrator, or prepare for the 70-432 exam, then this course is
for you!
We are excited to announce our long awaited SQL Server 2008 Administration
Training course. Whether you’re a beginner or experienced in SQL Server
administration, this course covers SQL Server 2008 in depth as you install and
configure your own enterprise data integration platform!
- Nearly 12 Hours of SQL Server 2008 Training
Videos on 3 Jam Packed DVDs!
- All Instructor-Led!
- Get certified! Exam Coverage for MCTS 70-450
- Scenario-based training - learn to do the tasks
you do in your job
- Multiple File Formats Make It
Convenient for You To Learn Anywhere You Go! iPod Video, Mp3 Audio, .WMV & high
quality .AVI video
- FREE FULL VERSION of Transcender's MCTS 70-450
Practice Exam! We've partnered with Transcender®, the leading exam
simulation provider in the world! Purchased separately, you would pay $159. But
you get it FREE as the perfect training companion to our SQL 2008 course!
- Learn at your own pace and at a fraction of the price
compared to classroom training!
Free with this course Windows Server 2008 R2
Watch a demo now!
Microsoft SQL Server 2008 Administration
Training Demo
Microsoft SQL Server 2008
Advanced
Administration
Training Course Outline
Video 1
Course Overview
Video 2
SQL Server Setup and Installation
I will show you exactly what SQL Server 2008 is and we will walk through the
scenario we will be using throughout the course.
Video 3
Setup and Installation of SQL Server 2008
- SQL Server 2008 Editions
- Performing a New Installation
- SQL Server Installation Center
- Server Configuration
- Database Engine Configuration & Authentication
- Microsoft SQL Management Studio
- Features of SQL Server
- Hardware, Disk Space, and Software
Video 4
Upgrading to SQL Server 2008.
Video 5
Indexes
- Introduction and Overview
- Indexes in SQL Server 2008
- Clustered and Non Clustered Indexes
- XML Indexes
- Spatial Indexes
- User Account Setup
- Creating a Clustered or Non Clustered Index
- Creating a Spatial Index
- Creating an XML Index
- Using T-SQL for Indexes
- Rebuilding and Dropping Indexes
- Filtered Indexes
- Indexes Views
Video 6
SQL Server Security
- SQL Server Security Landscape
- Physical Security
- Managing User Access
- Logins and Users
- Creating a User Account in AD
- Creating SQL Login and SQL User Account
- Testing SQL User Account
- Setting SQL User Permissions
- Server–Level Role vs. Database–Level Role
- Schemas Overview
- Creating Schemas
- Testing Schemas
- Protecting Your Data Auditing SQL Server
- Remote Access
- File Security and SQL Server Data Encryption
- SQL Server SA Login and Certificat–Based SQL Server
Login
- Public Database Role
- Information_Schema and Sys
- Best Practice
Video 7
Policy Based Management
Video 8
Encryption
Video 9
Backup and Restore
Video 10
High Availability
Video 11
Failover Clustering
Video 12
Database Mirroring
Video 13
Log Shipping
Video 14
Replication
Video 15
Monitoring SQL Server
Video 16
Performance Tuning
Video 17
Resource Governor
Video 18
Using PowerShell with SQL Server 2008
Video 19
Integration Services
Video 20
SQL Server Certification
Here is what you get....
20 videos will be provided in High-Quality AVI & WMV format.
In other words, you get perfect quality and replication of your instructor's
screens. An easy-to-use table of contents allows you to navigate to key areas
you wish to focus on.
20 iPod video files to watch Train Signal on the go!
A
popular request amongst our students who wish to study while they commute (i.e.,
train). These 320x240 .m4v files are compressed versions of the original course,
and play on any iPod that supports video. Also great for reviewing and
refreshing your mind "on the job."
 20
MP3 Files to listen to Train Signal on the go. Some of our students
have requested this option. People would like to be able to listen in their car
or while working out. Can be burnt to a CD or copied to portable device. Great
supplemental training to the videos.
 Instructor
Notes – These PDF documents can be printed out and contain the slides
used by the instructor throughout the videos. These allow the user a quick easy
reference to notes on the slides and make any additional notes for their own
learning process.
 Free
full version of Transcender's SQL Server 2008 Practice Exam! (SAVE $159!)
We've partnered with Transcender, the world's leading exam simulation provider!
Their award-winning simulations look and feel so much like the actual exam,
you'll feel confident on exam day! These Practice Questions are the Perfect
Training Companion to Our SQL Server 2008 Course!
The Complete Train Signal FastTrack Video
CBT Training Library
Buy "Microsoft SQL Server 2008 Administration" as Part of our Complete FastTrack
Video CBT Training Library...
Every Course we Have on a USB Hard Drive
Check it Out Now!
Microsoft SQL
Server 2008 Advanced AdministrationTraining Course
Only £220 (ex 15%
vat & del)
Multi user pricing available - call sales now
Official Purchase orders accepted from
Government, Education, Health & Charity, Times 1000 plc's, Professional
Partnerships and other pre-approved accounts. Want to order more than one course
? Contact sales for a custom quote.
| 