Implementing and Maintaining a Microsoft SQL 2005 Database
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
Implementing and Maintaining a Microsoft SQL 2005 Database

Overview:
This training will provide delegates with the knowledge and skills needed to implement and maintain a Microsoft SQL Server 2005 database.

This course covers the syllabus from both
M2779 and M2780. Delegates must reach the pre-requisites of this course to fully benefit. The course focuses on how to use SQL Server 2005 product features and tools related to implementing and maintaining the database. This event will also give delegates an overview of writing and creating Transact SQL queries.

This is an accelerated training event bringing 10 days training into 5 days, that will use elements from the below courses and it is recommend that ONLY delegates who have prior experience with SQL attend this intensive delivery M2779, Implementing a MS SQL Server 2005 Database M2780, Maintaining a MS SQL Server 2005 Database

Target Audience:
This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for Implementing and maintaining a SQL 2005 database. The course is also suitable to any IT Professionals wanting to update their skills from
SQL 2000 to SQL 2005

Objectives:
At the end of this course delegates will be able to:
- Maintain high availability.
- Install and configure SQL Server 2005 Create databases and database files.
- Manage database files. Create data types and tables.
- Manage security. Use XML-related features in Microsoft SQL Server 2005.
- Perform administrative tasks. Plan, create, and optimize indexes.
- Backup databases Implement data integrity in Microsoft SQL Server 2005 databases by
Using constraints, triggers, and XML schemas
- Rstore databases.
- Implement views.
- Monitor SQL Server.
- Implement stored procedures and functions.
- Troubleshoot SQL Server.
- Implement managed code in the database.
- Transfer data.
- Use Service Broker to build a messaging-based solution.

Prerequisites:
Testing and Certification:
Basic knowledge of the Microsoft Windows operating system and Recommended as preparation for exam(s): its core functionality. Working knowledge of Transact-SQL. Exam 70–431 : TS: Microsoft SQL Server 2005 - Implementation Working knowledge of relational databases. and Maintenance Some experience with database design.

Content:
- Installing and configuring SQL Server 2005 Implementing Managed Code in the Using Notification Services (Optional) line Database line
- Preparing to install SQL Server line Introduction to Notification Services
- Installing SQL Server Introduction to the SQL Server Common Developing Notification Services Solutions
- Managing a SQL Server 2005 Installation Language Runtime
- Importing and Configuring Assemblies Implementing Functions
- Managing Databases and Files Creating Managed Database Objects line line Creating and Using Functions
- Planning databases Using Service Broker Working with Functions
- Creating databases line Controlling Execution Context
- Creating Filegroups Service Broker Overview
- Creating Schemas Creating Service Broker Objects Implementing Stored Procedures
- Creating Database Snapshots Sending and Receiving Messages line
- Managing databases Implementing Stored Procedures
- Managing Security Creating Parameterized Stored
- Creating Data Types and Tables line Procedures line Overview of SQL Server Security Working With Execution Plans
- Creating Data Types Securing the Server Scope Handling Errors
- Creating Tables Securing the Database Scope
- Creating Partitioned Tables Implementing Cryptography in SQL Transferring Data Server line
- Writing Queries Using Transact-SQL Overview of Data Transfer line Disaster Recovery Introduction to SQL Server Integration
- Getting started with Transact-SQL. line Services (SSIS)
- Performing basic queries. Planning a Backup Strategy Using SQL Server Integration Services
- Grouping and summarizing data. Backing Up User Databases
- Joining data from multiple tables. Restoring User Databases Automating Administrative Tasks
- Working with subqueries. Recovering Data from Database line
- Modifying data. Snapshots Automating Administrative Tasks in SQL
- Querying metadata, XML, and full-text Server 2005 indexes. System Database and Disaster Recovery Configuring the SQL Server Agent
- Using programming objects for data Monitoring SQL Server Creating Jobs and Operators retrieval. line Creating Alerts
- Using advanced querying techniques. Viewing Current Activity Managing Multiple Servers
- Using System Monitor and SQL Server Managing SQL Server Agent Security
- Using XML Profiler line Using DDL Triggers and Event Maintaining High Availability
- Retrieving XML by Using FOR XML Notifications line
- Shredding XML by Using OPENXML Introduction to High Availability
- Using the xml Data Type Implementing Replication Implementing Server Clustering, Database
line Mirroring and Log Shipping
- Creating and Tuning Indexes Overview of Replication line Implementing Replication Introduction to Replication
- Planning Indexes Configuring Replication in Some line
- Creating Indexes Common Scenarios Overview of Replication
- Optimizing Indexes
- Creating XML Indexes Creating Databases and Database Files 
- Implementing Data Integrity Creating Databases
- Creating Filegroups
- Data Integrity Overview Creating Schemas
- Implementing Constraints Creating Database Snapshots
- Implementing Triggers
- Implementing XML Schemas Implementing Data Integrity by Using
- Triggers and XML Schemas
- Implementing Views line
- Implementing Triggers
- Introduction to Views Implementing XML Schemas
- Creating and Managing Views
- Optimising Performance by Using Views Managing Transactions and Locks 
- Implementing Stored Procedures and Overview of Transactions and Locks
- Functions Managing Transactions
- Understanding SQL Server Locking
- Implementing Stored Procedures Architecture
- Creating Parameterized Stored Procedures Managing Locks
- Creating Functions
- Handling Errors
- Controlling Execution Context
 
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
My Location
Results for location are highlighted in the table below. Click here to remove highlight
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
Tools
 
Key Details
Duration5 days
 
£1,595
per delegate
 
 
Bookings Helpline: 01933 233884 (Monday to Thursday - 8:00am to 5:30pm and Friday 8:00am to 5:00pm).