Microsoft Certified Technology Specialist (MCTS): SQL Server 2005

Many businesses today place a great deal of emphasis on the creation and maintenance of efficient databases. This course will give you the skills you need to provide this service as a database administrator, developer, or business intelligence developer. You'll add to and deepen your current knowledge of SQL Server, including the use of appropriate tools and Transact-SQL language, and explore the user interface.

 

What will I study?

Implementing a Microsoft SQL Server 2005 Database

  • Creating Databases, Filegroups, Schemas, Database Snapshots, Data Types, Tables and Partitioned Tables
  • Retrieving XML by Using FOR XML
  • Shredding XML by Using OPENXML
  • Using the XML Data Type
  • Planning, creating and optomising Indexes
  • Creating XML Indexes
  • Data Integrity Overview
  • Implementing Constraints, triggers and XML schemas
  • Creating and Managing Views
  • Optimising Performance by Using Views
  • Implementing Stored Procedures
  • Creating Parameterised Stored Procedures
  • Creating Functions
  • Handling Errors
  • Controlling Execution Contex
  • Introduction to the SQL Server Common Language Runtime
  • Importing and Configuring Assemblies
  • Creating Managed Database Objects
  • Creating Service Broker Objects
  • Sending and Receiving Messages

Maintaining a Microsoft SQL Server 2005 Database

  • Preparing and installing SQL Server
  • Managing a SQL Server 2005 Installation
  • Planning, creating and managing databases
  • Planning a Backup Strategy
  • Backing up and restoring User Databases
  • Recovering Data from Database Snapshots
  • System Database and Disaster Recovery
  • Securing the Server Scope
  • Securing the Database Scope
  • Managing Keys and Certificates in SQL Server
  • Viewing Current Activity
  • Using System Monitor, SQL Server Profiler, DDL Triggers and Event Notification
  • Using SQL Server Integration Services
  • Automating Administrative Tasks in SQL Server 2005
  • Configuring the SQL Server Agent
  • Creating Jobs and Operators
  • Creating Alerts
  • Managing Multiple Servers and SQL Server Agent Security
  • Introduction to High Availability
  • Implementing Server Clustering, Database Mirroring and Log Shipping
  • Replication Scenarios

Study with ICS in association with Hays

International Correspondence Schools Ltd (ICS) is the world's largest and most experienced distance learning organisation.  ICS is a pioneer in teaching skills by home study, presenting the opportunity to learn while earning and to relate study to everyday work. ICS-Hays-logos.jpg
Join the ICS Student Community

Create a guest account on the student community for free and communicate wwith current students on this course.