Mcts Online training

Mcts Course Content

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