Creating Databases and Database Files
- Creating Databases
- Creating Filegroups
- Creating Schemas
- Creating Database Snapshots
Creating Data Types and Tables
- Creating Data Types
- Creating Tables
- Creating Partitioned Tables
Using XML
- the xml data type and its methods
- Retrieving XML by Using FOR XML
- Shredding XML by Using OPENXML
- Using the xml Data Type
Creating and Tuning Indexes
- Planning Indexes
- Creating Indexes
- Optimizing Indexes
- Creating XML Indexes
Implementing Data Integrity
- Data Integrity Overview
- Implementing Constraints
- Implementing Triggers
- Implementing XML Schemas
Implementing Views
- Introduction to Views
- Creating and Managing Views
- Optimizing Performance by Using Views
Implementing Stored Procedures and Functions
- Implementing Stored Procedures
- Creating Parameterized Stored Procedures
- Creating Functions
- Handling Errors
Controlling Execution Context
- This module explains how to implement managed database objects
- Introduction to the SQL Server Common Language Runtime
- Importing and Configuring Assemblies
- Creating Managed Database Objects
Using Service Broker
- Service Broker Overview
- Creating Service Broker Objects
- Sending and Receiving Messages
Installing and Configuring SQL Server 2005
- installation, and how to use the SQL Server 2005 administrative tools
- Preparing to install SQL Server
- Installing SQL Server
- Managing a SQL Server 2005 Installation
Managing Databases and Files
- Planning databases
- Creating databases
- Managing databases
Disaster Recovery
- Planning a Backup Strategy
- Backing Up User Databases
- Restoring User Databases
- Recovering Data from Database Snapshots
- System Database and Disaster Recovery
Managing Security
- cryptography in a SQL Server database
- Overview of SQL Server Security
- Securing the Server Scope
- Securing the Database Scope
- Managing Keys and Certificates in SQL Server
Monitoring SQL Server
- Viewing Current Activity
- Using System Monitor
- Using SQL Server Profiler
- Using DDL Triggers
- Using Event Notifications
Transferring Data
- Overview of Data Transfer
- Introduction to SQL Server Integration Services
- Using SQL Server Integration Services
Automating Administrative Tasks
- Automating Administrative Tasks in SQL Server 2005
- Configuring the SQL Server Agent
- Creating Jobs and Operators
- Creating Alerts
- Managing Multiple Servers
- Managing SQL Server Agent Security
Maintaining High Availability
- Introduction to High Availability
- Implementing Server Clustering
- Implementing Database Mirroring
- Implementing Log Shipping
Introduction to Replication
- This module explains considerations for implementing replication
- Overview of Replication
- Replication Scenarios