Implementing and Maintaining a Microsoft SQL 2005 Database

All IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for Implementing and maintaining a SQL 2005 database.

Also suitable to any IT Professionals wanting to update their skills from SQL 2000 to SQL 2005

• Install and configure SQL Server 2005
• Manage database files
• Manage security
• Perform administrative tasks
• Backup databases
• Restore databases

• Monitor SQL Server
• Troubleshoot SQL Server
• Transfer Data
• Maintain high availability
• Create databases and database files
• Implement views

• Preparing to install SQL Server
• Installing SQL Server
• Managing a SQL Server 2005 Installation

Managing Databases and Files

• Planning databases
• Creating databases
• Creating Filegroups
• Creating Schemas
• Creating Database Snapshots
• Managing databases

Creating Data Types and Tables

• Creating Data Types
• Creating Tables
• Creating Partitioned Tables

Writing Queries Using Transact-SQL

• Getting started with Transact-SQL.
• Performing basic queries.
• Grouping and summarizing data.
• Joining data from multiple tables.
• Working with subqueries.
• Modifying data.
• Querying metadata, XML, and full-text indexes.
• Using programming objects for data retrieval.
• Using advanced querying techniques.

Implementing Data Integrity

• Data Integrity Overview
• Implementing Constraints
• Implementing Triggers
• Implementing XML Schemas

Implementing Views

• Introduction to Views
• Creating and Managing Views
• Optimising Performance by Using Views

Implementing Stored Procedures and Functions

• Implementing Stored Procedures
• Creating Parameterized Stored Procedures
• Creating Functions
• Handling Errors
• Controlling Execution Context

Managing Security

• Overview of SQL Server Security
• Securing the Server Scope
• Securing the Database Scope
• Implementing Cryptography in SQL Server

Disaster Recovery

• Planning a Backup Strategy
• Backing Up User Databases
• Restoring User Databases
• Recovering Data from Database Snapshots

System Database and Disaster Recovery Monitoring SQL Server

• Viewing Current Activity
• Using System Monitor and SQL Server ProfilerUsing DDL Triggers and Event Notifications

Transferring Data

• Overview of Data Transfer
• Introduction to SQL Server Integration Services (SSIS)
• 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, Database Mirroring and Log Shipping

Introduction to Replication

• Overview of Replication

• M2781 - Designing MS SQL Server 2005 Server-Side Solutions