SQL 2008 MCITP Database Administrator
SQL Server 2008 Training: Level 1 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
SQL Server 2008 Training: Level 2 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
SQL Server 2008 Training: Level 3 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
SQL Server 2008 Training: Level 4 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
SQL Server 2008 Training: Level 5 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
SQL Server 2008 Training: Level 6 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
SQL Server 2008 Training: Level 7 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
SQL Server 2008 Training: Level 8 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