|
MCTS: SQL Server 2008, Implementation and Maintenance for Exam 70-432
Requirements:
1-2 years experience using SQL 2008 or 2-3 years experience using older version of SQL Server.
Who should take this course?
IT individuals whose job role is database administration or where they work in an environment with databases taking a central part of their role.
Skills measured with Exam 70-432:
- Installing and Configuring SQL Server 2008 (10%)
- Maintaining SQL Server Instances (13%)
- Managing SQL Server Security (15%)
- Maintaining a SQL Server Database (16%)
- Performing Data Management Tasks (14%)
- Monitoring and Troubleshooting SQL Server (13%)
- Optimizing SQL Server Performance (10%)
- Implementing High Availability (9%)
Microsoft SQL Server 2008
Administration Training 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.
- 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 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.
- 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.
- 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. Plus, using our scenario, I will show you exactly how to set up your very own SQL Server Database
- Database Planning
- Creating Databases Overview
- Creating Veronica’s Veronicas Database General Page
- Creating Veronica’s Veronicas Database Options Page
- Creating Veronica's Veronicas Database 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.
- 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.
- 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 make sure you are always running at a high level.
- 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.
- 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.
- 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.
- 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.
- 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 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.
- 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.
- 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
- 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.
- 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.
- The Certification Hierarchy
- Microsoft Certified Technology Specialist (MCTS)
- Microsoft Certified IT Professional (MCITP)
- Microsoft Certified Master (MCM)
|
