Our SQL Server 2008 Training Teaches You:
SQL Profiler, SQL Server Agent, Replication, Optimized Use of SQL Server FileGroups and Much More.
Plus, Complete 70-432 Exam Coverage!
A Letter from Mel Haynes
(MCP, MS)
If you want to develop hands-on experience as an 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 configure and maintain your own enterprise data management system!
Database Administration is one of the few jobs that seem to always be in demand. Follow along with the many real world examples in this course to work with your own database and lay the foundation towards becoming a DBA.
Windows Server 2008 Server Administrator Training Course FAQs
"Am I qualified to take this course?"
YES! If you are a complete beginner to SQL Server, have used previous versions of the software, or have some experience with SQL Server 2008, you'll benefit from this in-depth course!
"Do I need any special equipment to complete this training course?"
NO! All you need is a computer with Internet Explorer and a media player; however, working hands-on with a SQL Server 2008 may enhance your training experience.
"Is this course part of any Microsoft certification track?"
YES! This course will help you prepare for the 70-432 Microsoft SQL Server 2008 Implementation and Maintenance exam.
SQL Server 2008 Administration Course Outline
Video 1
Introduction
Learn what's in the course and who your instructor is.
Key Topics:
* About Your Instructor and Train Signal
* What's Covered in this Course
* Hardware
Video 2
Welcome to Microsoft SQL Server 2008
I will show you exactly what SQL Server 2008 is and we will walk through the scenario we will be using throughout the course.
Key Topics:
* What is SQL Server 2008?
* SQL Server 2008 Solutions
* A Brief History of SQL Server
* Scenario Veronica's Veronicas Overview
Video 3
Installing SQL Server 2008
There is more to configuring an SQL Server installation than you might think. I will show you exactly what you need to do to prepare for installation and the requirements you will need to meet before installing SQL Server, so that your installation goes smoothly.
Key Topics:
* SQL Server 2008 Editions
* SQL Server 2008 Requirements
* Downloading SQL Software
* SQL Server Security 101
* Installing SQL Server 2008
* SQL Server Installation Center Overview
* New SQL Server Stand–Alone Installation
* Launching SQL Server 2008
Video 4
An Introduction to SQL Server 2008 Tools
To fully make use of all of the features of SQL Server you need to know how to use the many tools it has to offer. In this video I will show you an in depth overview of the several tools available in SQL Server 2008.
Key Topics:
* SQL Server Business Intelligence Development Studio Overview
* Analysis Services and Configuration Tools Overview
* Documentation and Tutorial Overview
* Integration Services and Performance Tools Overview
* Windows PowerShell 1.0 Overview
* System Databases
* SQL Server Management Studio Overview
* Query Interface Overview
Video 5
Creating SQL Server 2008 Databases
In this video I will walk you through the planning process needed to create your database to meet your specific business and database management needs. Plus, using our scenario, I will show you exactly how to set up your very own SQL Server Database.
Key Topics:
* Database Planning
* Creating Databases Overview
* Creating General Page
* Creating Options Page
* Creating Filegroups Page
* Creating a New Table
* Database Diagrams
* Creating Database Diagrams
* Database Views
* Creating a New View
* Creating a Synonym
* Recommendations
Video 6
Configuring SQL Server 2008 Security
As a DBA, one of your most important responsibilities will be securing company data resources against unauthorized access and modification. In this video we will tackle SQL Server Security from physical security to permissions and schemas; and everything in between.
Key Topics:
* 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 Practices
Video 7
SQL Server 2008 Implementing Disaster Recovery
Having a disaster recovery plan is a necessity in today’s computing landscape. I will show you the different disaster recovery models you can implement to make sure you are protected against data corruption, hardware failures, and anything else that would destroy data.
Key Topics:
* SQL Server Recovery Models
* Full Recovery Model
* Bulk Logged Recovery Model
* Simple Recovery Model
* Backup Types
* Full Database Backups
* Restoring a Database
* Full File Backups
* Partial Backups
* Recovery Requirements
* Best Practices
Video 8
SQL Server 2008 Performance
In this video I will show you the many tools you can use to monitor your SQL Server performance to anticipate problems before they occur.
Key Topics:
* SQL Profiler/SQL Trace (T–SQL)
* Windows System Monitor
* Activity Monitor
* Transact–SQL
* Windows Logs
* Default Trace
* Dynamic Management Views
* Monitoring Tools Comparison
Video 9
SQL Server 2008 Automating Administrative Tasks
In this video I will show you how to use the SQL Server Agent to automate administrative tasks, saving you time and allowing you to move on to more important work.
Key Topics:
* SQL Server Agent
* Configuring SQL Server Agent
* Key Fixed Database Roles
* Creating and Running Jobs
* Subsystem
* Proxy
* Security Guidelines
Video 10
SQL Server 2008 High Availability
Learn the benefits of the various high availability options and why you would use each one. Plus, I'll show you how to keep your database always available by having multiple servers ready to go, so you're not depending on just one server.
Key Topics:
* SQL Server Failover Clustering
* SQL Server Database Mirroring
* SQL Server Log Shipping
* SQL Server Replication
* Comparisons
Video 11
SQL Server 2008 Replication
Learn to implement SQL Server replication, making the necessary data available to various locations as it’s needed; in real time. Plus, see how to configure the necessary security including: user accounts, firwall settings, and administrative access.
Key Topics:
* What’s the Problem to Solve?
* What is SQL Replication?
* SQL Server Replication Concepts
* Types of Replication
* SQL Server Roles
* Pieces of SQL Replication Model
* Players of SQL Replication Model
* Creating Replication Admin Account
* Creating Agent Accounts
* Changing Firewall Settings
* Giving Replication Admin Access to the SQL Server
* Installing SQL Server Replication Feature
* Adding Replication Accounts to Database
* Creating Publication
* Creating Push Subscription
* Best Practices
Video 12
Resource Governor
In this video I will show you how to manage server resources and control application access to system resources.
Key Topics:
* Troubleshooting SQL Server
* Managing Resource Utilization
* Resource Govenor
* Resource Pools
* Creating a Resource Pool
* Workload Groups
* Creating a Workload Group
* Classification
* Creating a Classifier Function
Video 13
Performing Data Management Task
In this video you will learn several data management skills focused on "rounding out" your SQL Server 2008 administration knowledge. A primary focus will be understanding and managing indexes.
Key Topics:
* Importing and Exporting
* Permissions for Importing and Exporting
* Maintaining Indexes
* Clustered vs. Nonclustered Indexes
* Creating Indexes
* Full–Text Indexing
Video 14
Data Compression
Learn how you can slow the effect of the data storage explosion by compressing SQL Server data while still maintaining performance requirements.
Key Topics:
* Row Compression
* Page Compression
* Data Partitions
* Table Compression via T–SQL
* Compressing Backups
Video 15
SQL Server 2008 Common Commands
As a database administrator you will find the DBCC ‘family’ of commands and the myriad of applications for the sp_configure system stored procedure to be invaluable. These two commands touch every aspect of the DBA role and provide you with access to every configuration option available within SQL Server 2008.
Key Topics:
* Database Console Commands (DBCC)
* Running DBCC CHECKTABLE and DBCC CHECKDB Commands
* Setting Server Configuration Options
* sp_configure clr enable Command
* sp_configure c2 audit mode Command
* sp_configure fill factor Command
* Final Thoughts on sp_configure
Video 16
Database Mail
In this video I will show you how to use SQL Server Database Mail and Microsoft’s “built–in” SMTP server to send email notifications to operators, from SQL Server 2008.
Key Topics:
* The Players...
* Simple Mail Transfer Protocol (SMTP) Server
* Database Mail Profiles and Accounts
* Configuring Database Mail
* Database Mail SMTP Authentication
Video 17
Certification 101
The path to certification will be clear once you watch this SQL Server 2008 certification road map. I cover all the certification levels, tracks and exams to get you certified in SQL Server 2008.
Key Topics:
* The Certification Hierarchy
* Microsoft Certified Technology Specialist (MCTS)
* Microsoft Certified IT Professional (MCITP)
* Microsoft Certified Master (MCM)
Here is what you get....
17 videos (Over 10 Hours) 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.
17 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."
17 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.
PLUS... FREE FULL VERSION of Transcender's Award-Winning "SQL Server 2008
Implementation and Maintenance" Practice Exam!
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! Best of All, They're FREE!
Save time by focusing your studying efforts on topics that will actually be on the exam!
Comprehensive references explain the reasoning behind the correct answers!
Detailed reports and custom exam features help identify and strengthen your weak areas!
Transcender Live Update ensures your study materials are always up-to-date!
Even if you're not studying for an exam, this comprehensive exam simulator is a great tool for testing and reinforcing your SQL Server 2008 skills & knowledge!
The Complete Train Signal FastTrack Video CBT Training Library
Buy "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!
