Exam 70-432: SQL Server 2008 Training Course

SQL 2008 MCITP Database Administrator Training Course Introduction :

This Microsoft SQL Server 2008 (Exam 70-432) Implementation and Maintenance Certification Training course contains all the necessary component coverage to prepare for the Microsoft Technical Specialist exam 70-432: Microsoft SQL Server 2008 Implementation and Maintenance.

This new SQL Server 2008 Training Course will provide database and business intelligence developers as well as system administrators with an in-depth look at implementing and maintaining SQL Server 2008 R2. Throughout this course, your instructor, Paul Marquardt (MCSE, MCSA, BCCPA, BCCPP, MSCIS), will first walk through each course topic from a conceptual standpoint. Then, you’ll experience a live, video walkthrough as Paul helps you visualize what’s involved in implementing and managing the many different components of this complex relational database platform.

In other words, this course will contain all the information you need as a SQL 2008 Database Administrator to set up and manage SQL Server 2008 R2 in a production environment and pass the Microsoft Technical Specialist Exam 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance.

Student Level: Beginner to Advanced

SQL 2008 MCITP Database Administrator Training Course Content:

Course Introduction

• An Introduction to SQL Server 2008
• Introduction
• Understanding SQL Server
• New Features in SQL Server
• SQL Server Editions
• Examining the Exam 70-432

• Installing SQL Server 2008
• Introduction
• System Requirements and Prerequisites
• Upgrading to SQL 2008
• Configuring SQL Server Functions and Services
• Using SQL Server Management Studio

• Creating and Managing Databases in SQL Server 2008
• Introduction
• Understanding Databases
• Understanding Database File Structure
• Creating Databases
• Configuring Collation Options

• Configuring SQL Server Security
• Introduction
• Understanding SQL Server Security Architecture
• Creating and Managing Logins
• Managing Database Users and Roles
• Understanding Database Schemas
• Managing Permissions
• Configuring Certificates and Encryption

Supporting Database Clients

• Working with Relational Data
• Introduction
• Using SELECT, INSERT, UPDATE, and DELETE
• Creating and Managing Transactions
• Implementing Error Handling

• Importing and Exporting Data
• Introduction
• Understanding Import and Export Options
• Using BCP
• Using BULKINSERT
• Using OPENROWSET

• Implementing HTTP Endpoints
• Introduction
• Creating and Securing HTTP Endpoints

• Working with XML Data
• Introduction
• Understanding XML
• Using the FOR XML Clause
• Importing XML Data
• Working with XML Schemas and Typed X
• Creating XML Indexes

Creating Database Objects

• Working with Database Objects
• Introduction
• Using System Views
• Managing Objects in SQL Server Management Studio

• Creating Tables
• Introduction
• Designing Tables
• Creating Tables

• Creating Restraints
• Introduction
• Understanding Data Integrity and Constraints
• Creating Constraints

• Creating Views
• Introduction
• Understanding Views
• Creating and Managing Views

• Creating User Defined Types
• Introduction
• Understanding User Defined Types
• Creating Alias Types
• Creating CLR User Defined Types

• Creating Triggers
• Introduction
• Understanding Triggers
• Creating DML Triggers
• Creating DDL Triggers

• Creating Functions
• Introduction
• Understanding User Defined Functions
• Creating Functions

• Creating Stored Procedures
• Introduction
• Understanding Stored Procedures
• Creating Stored Procedures

Maintaining Databases

• Creating and Managing Indexes
• Introduction
• Understanding and Designing Indexes
• Creating Indexes
• Maintaining Indexes
• Maintaining Statistics

• Implementing Full Text Search
• Introduction
• Understanding Full Text Search
• Creating and Populating FTS Indexes
• Performing Full Text Queries

• SQL Server Agent
• Introduction
• Understanding SQL Server Agent
• Configuring SQL Server Agent
• Creating and Scheduling Jobs
• Monitoring SQL Server Agent Jobs
• Defining Alerts
• Configuring Operators
• Configuring Database Mail

• Maintaining Database Files
• Introduction
• Shrinking Database Files
• Verifying Database Integrity using DBCC CHECKDB

Backing Up and Restoring Databases

• Performing Database Backups
• Introduction
• Overview of Backups
• Understanding Recovery Models
• Understanding Backup Types
• Creating Database Backups
• Creating Database Maintenance Plans

• Performing Restore Operations
• Introduction
• Understanding the Restore Process
• Restoring User Databases
• Restoring System Databases

• Managing Backup Media
• Introduction
• Understanding Backup Storage Options
• Working with Backup Devices/Media
• Getting Backup Information

• Moving Databases
• Introduction
• Overview of Database Moves
• Attaching and Detaching Databases
• Copy Database Wizard

Monitoring and Troubleshooting SQL Server

• Monitoring SQL Server Performance
• Introduction
• An Overview of Performance Monitoring
• SQL Profiler
• Creating/Configuring SQL Server Traces
• Using System Monitor/SQL Profiler
• Dynamic Management Views (DMV)
• Viewing SQL Server Management Studio

• Database Engine Tuning Advisor
• Introduction
• Understanding the Database Engine Tuning Advisor
• Analyzing Performance with the Database Engine Tuning Advisor

• Managing Processes, Locking, and Deadlocks
• Introduction
• Managing and Monitoring Processes
• Understanding and Monitoring Locking
• Understanding and Monitoring Deadlocks

• Diagnosing Server Errors
• Introduction
• Dedicated Administrator Connection (DAC)
• Monitoring Logs
• SQL Diag

• Implementing Partitions
• Introduction
• Understanding Partitions
• Implementing Partitions
• Managing Partitions

High Availability and Disaster Recovery

• Implementing Database Mirroring
• Introduction
• Understanding Database Mirroring
• Database Mirror Modes
• Implementing Database Mirroring
• Managing and Monitoring Mirroring

• Log Shipping
• Introduction
• Understanding Log Shipping
• Implementing Log Shipping
• Monitoring Log Shipping

• Implementing Database Snapshots
• Introduction
• Understanding Snapshots
• Creating and Using Snapshots
• Managing Snapshots

Distributed Data and Messaging

• Configuring Linked Servers
• Introduction
• Understanding Linked Servers
• Configuring/Securing Linked Server
• Querying Linked Servers

• Replication
• Introduction
• Understanding Replication
• Replication Roles and Architecture
• Understanding Replication Types
• Creating and Configuring Publications
• Subscribing to a Publication
• Monitoring Replication
• Managing Replication