SQL Server 2008 Administration (70-432) (Program Details)
COURSE OUTLINE
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
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
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 Centre Overview
* New SQL Server Stand?Alone Installation
* Launching SQL Server 2008
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
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
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
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
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
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
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
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
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 Governor
* Resource Pools
* Creating a Resource Pool
* Workload Groups
* Creating a Workload Group
* Classification
* Creating a Classifier Function
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
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
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
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
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)
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... Transcender's "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.
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.
Return To Main Product Page
Price: £299.00
(incl. VAT and Delivery)
for Single User Licence
