Publisher Course Outline
SQL Server 2005: Level 1: Installing and Configuring SQL Server 2005
1.0 An Introduction to SQL Server 2005
1.1 Understanding SQL Server
1.2 New Features in SQL Server 2005
1.3 Editions of the SQL Server Platform
1.4 About Exam 70-431
2.0 Installing SQL Server 2005
2.1 System Requirements and Prerequisites
2.2 Installing a New Instance
2.3 Upgrading to SQL Server 2005
2.4 Configuring SQL Server Features and Services
2.5 Using SQL Server 2005 Management Studio
3.0 Creating and Managing Databases
3.1 Understanding Databases
3.2 Understanding Database File Structure
3.3 Creating Databases
3.4 Configuring Collation Options
4.0 Configuring SQL Server Security
4.1 Understanding SQL Server�s Security Architecture
4.2 Creating and Managing Logins
4.3 Managing Database Users and Roles
4.4 Understanding Database Schemas
4.5 Managing Permissions
4.6 Configuring Certificates and Encryption
5.0 Recap
5.1 Recap of Level 1
SQL Server 2005: Level 2: Supporting Database Clients
1.0 Working with Relational Data
1.1 Writing Queries using SQL Server Management Studio
1.2 Using SELECT, INSERT, UPDATE, and DELETE Commands
1.3 Creating and Managing Transactions
1.4 Implementing Error Handling
2.0 Importing and Exporting data
2.1 Understanding Import and Export Optionsv
2.2 Using SQL Server Integration Services (SSIS)v
2.3 Using bcp
2.4 Using BULK INSERT
2.5 Using OPENROWSET
3.0 Implementing HTTP Endpoints
3.1 Creating HTTP Endpoints
3.2 Securing HTTP Endpoints
4.0 Working with XML Data
4.1 Understanding XML
4.2 Using the FOR XML clause
4.3 Importing XML Data
4.4 Working with XML Schemas and Typed XML
4.5 Creating XML Indexes
5.0 Recap
5.1 Recap of Level 2
SQL Server 2005: Level 3: Creating Database Objects
1.0 Working with Database Objects
1.1 Using System Views
1.2 Managing Objects in SQL Server Management Studio
2.0 Creating Tables
2.1 Designing Tables
2.2 Creating Tables
3.0 Creating Constraints
3.1 Understanding Data Integrity and Constraints
3.2 Creating Constraints
4.0 Creating Views
4.1 Understanding Views
4.2 Creating and Managing Views
5.0 Creating User-Defined Typesv
5.1 Understanding User-Defined Types
5.2 Creating Alias Types
5.3 Creating CLR User-Defined Types
6.0 Creating Triggers
6.1 Understanding Triggers
6.2 Creating DML Triggers
6.3 Creating DDL Triggers
7.0 Creating Functions
7.1 Understanding User-Defined Functions
7.2 Creating Functions
8.0 Creating Stored Procedures
8.1 Understanding Stored Procedures
8.2 Creating Stored Procedures
9.0 Recap
9.1 Recap of Level 3
SQL Server 2005: Level 4: Maintaining Databases
1.0 Creating and Managing Indexes
1.1 Understanding and Designing Indexes
1.2 Creating Indexes
1.3 Maintaining Indexes
1.4 Maintaining Statistics
2.0 Implementing Full-Text Search
2.1 Understanding Full-Text Search
2.2 Creating and Populating FTS Indexes
2.3 Performing Full-Text Queries
3.0 SQL Server Agent
3.1 Understanding SQL Server Agent
3.2 Configuring SQL Server Agent
3.3 Creating and Scheduling Jobs
3.4 Monitoring SQL Server Agent Jobs
3.5 Defining Alerts
3.6 Configuring Operators
3.7 Configuring DatabaseMail
4.0 Maintaining Database Files
4.1 Shrinking Database Files
4.2 Verifying Database Integrity using DBCC CHECKDB
5.0 Recap
5.1 Recap of Level 4
SQL Server 2005: Level 5: Backing Up and Restoring Databases
1.0 Performing Database Backups
1.1 Overview of Backups
1.2 Understanding Recovery Models
1.3 Understanding Backup Types and Options
1.4 Creating Database Backups
1.5 Creating Database Maintenance Plans
2.0 Performing Restore Operations
2.1 Understanding the Restore Process
2.2 Restoring User Databases
2.3 Restoring System Databases
3.0 Managing Backup Media
3.1 Understanding Backup Storage Options
3.2 Working with Backup Devices and Media
3.3 Getting Backup-Related Information
4.0 Moving Databases
4.1 Overview of Moving Databases
4.2 Attaching and Detaching Databases
4.3 Using the Copy Database Wizard
5.0 Recap
5.1 Recap of Level 5
SQL Server 2005: Level 6: Monitoring and Troubleshooting SQL Server Performance
1.0 Monitoring SQL Server Performance
1.1 An Overview of Performance Monitoring
1.2 Understanding SQL Profiler
1.3 Creating and Configuring SQL Server Profiler Traces
1.4 Using System Monitor with SQL Profiler
1.5 Using Dynamic Management Views (DMVs)
1.6 Viewing SQL Server Management Studio Reports
2.0 Using the Database Engine Tuning Advisor
2.1 Understanding the Database Engine Tuning Advisor
2.2 Analyzing Performance with the Database Engine Tuning Advisor
3.0 Managing Processes, Locking, and Deadlocksv
3.1 Monitoring and Managing Processes
3.2 Understanding and Monitoring Locking
3.3 Understanding and Monitoring Deadlocks
4.0 Diagnosing Server Errors
4.1 Using the Dedicated Administrator Connection (DAC)
4.2 Monitoring SQL Server Logs
4.3 Using SQLDiag
5.0 Implementing Partitions
5.1 Understanding Partitions
5.2 Implementing Partitions
5.3 Managing Partitions
6.0 Recap
6.1 Recap of Level 6
SQL Server 2005: Level 7: Implementing High Availability and Disaster Recovery
1.0 Implementing Database Mirroring
1.1 Understanding Database Mirroring
1.2 Database Mirroring Modes
1.3 Implementing Database Mirroring
1.4 Monitoring and Managing Database Mirrors
2.0 Implementing Log Shipping
2.1 Understanding Log Shipping
2.2 Implementing Log Shipping
2.3 Monitoring Log Shipping
3.0 Implementing Database Snapshots
3.1 Understanding Snapshots
3.2 Creating and Using Snapshots
3.3 Managing Snapshots
4.0 Recap
4.1 Recap of Level 7
SQL Server 2005: Level 8: Working with Distributed Data
1.0 Configuring Linked Servers
1.1 Understanding Linked Servers
1.2 Configuring and Securing Linked Servers
1.3 Querying Linked Servers
2.0 Managing Replication
2.1 Understanding Replication
2.2 Replication Roles and Architecture
2.3 Understanding Replication Types
2.4 Creating and Configuring Publications
2.5 Subscribing to a Publication
2.6 Monitoring Replication
2.7 Managing Replication
3.0 Implementing Service Broker
3.1 Understanding Service Broker
3.2 Understanding Service Broker Components
3.3 Implementing Service Broker
3.4 Enabling Distributed Messaging
4.0 Recap
4.1 Recap of Level 8
5.0 The End
5.1 Course Recap
