Updating Your Database Administration and Development Skills to Microsoft SQL Server 2005

Updating Your Database Administration and Development Skills to Microsoft SQL Server 2005
5-days; Instructor Led

For more information, please visit www.thinkpathtraining.com or speak with one of our Learning Solutions Advisors at 1-212-566-4223.

This course combines two courses into 5 days.
2733 Updating Your Database Administration Skills to Microsoft SQL Server 2005
2734 Updating Your Database Development Skills to Microsoft SQL Server 2005


On This Page Introduction Audience At Course Completion Prerequisites Microsoft Certified Professional Exams Course Materials Course Outline
Introduction
This 5-day combination, instructor-led course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can design, build, query and develop enterprise SQL Server 2005 databases and servers. Provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can support, configure, and maintain enterprise SQL Server 2005 databases and servers. Audience
This course is intended for experienced database developers and database administrators, who are responsible for the design, build, query, and develop enterprise SQL Server 2005 databases and servers. This course is also intended for experienced database administrators and database developers who are responsible for the supporting, configuring, and maintaining enterprise SQL Server 2005 databases and servers. At Course Completion
After completing this course, students will be able to: Use the Development Tools provided with SQL Server 2005. Use Transact-SQL enhancements to perform database development tasks. Develop XML-based Solutions using SQL Server 2005. Build Message-Based Services with the Service Broker. Implement Web Services using Native HTTP Endpoints. Build Notification Services Applications. Implement Database Functionality with Managed (.NET) Code. Build Client Applications with the .NET Framework. Build Administrative Applications with SQL Management Objects (SMO). Describe the architecture of SQL Server 2005. Install SQL Server 2005. Use SQL Server 2005 administrative tools and utilities. Maintain SQL Server 2005 servers and databases. Secure a SQL Server 2005 server and database. Monitor SQL Server 2005. Implement a Backup and Restore solution for SQL Server 2005. Implement a data availability solution with database mirroring or clustering. Use enhanced SQL Server 2005 replication features.
Prerequisites
Microsoft Certified Professional Exams
No Microsoft Certified Professional exams are associated with this course currently. Course Materials
The student kits includes comprehensive workbooks and other necessary materials for this class. Course Outline

PART 1
Module 1: SQL Server 2005 Overview

The information in this module introduces the main new features and enhancements in SQL Server 2005 and describes the new development tools.

Lessons

SQL Server 2005 Components and Architecture SQL Server Developer Tools SQL Server 2005 Security Implementation

Lab 1: Exploring SQL Server 2005

Using SQL Server Management Studio Using Schemas

After completing this module, students will be able to:

Describe the components and architecture of SQL Server 2005. Use SQL Server Management Studio to create a database solution. Use security features of SQL Server 2005.

Module 2: Transact-SQL Enhancements in SQL Server 2005

In this module, students learn about the improvements in Transact-SQL in SQL Server 2005.

Lessons

Data Definition Language Enhancements Data Manipulation Language Enhancements Structured Exception Handling

Lab 2: Programming with Transact-SQL

Partitioning a Table Using Common Table Expressions Using Relational Operators

After completing this module, students will be able to:

Use new Data Definition Language (DDL) features in SQL Server 2005. Use new Data Manipulation Language (DML) features in SQL Server 2005. Implement structured exception handling in Transact-SQL.

Module 3: Using XML in SQL Server 2005

In this module, students learn about the XML-related functionality in the SQL Server 2005 database engine will be described.

Lessons

XML Enhancements in SQL Server 2005 The xml Data Type Using XQuery

Lab 3: Working with XML

Retrieving XML from Relational Data Storing XML Natively in the Databases Using XQuery with xml Methods

After completing this module, students will be able to:

Use enhanced XML features in SQL Server 2005. Use the xml data type for typed and untyped XML. Use XQuery expressions with XML data.

Module 4: Using Service Broker

The information in this module introduces Microsoft SQL Server 2005 Service Broker a message-based platform for building service-oriented database solutions.

Lessons

Service Broker Architecture Using the Service Broker

Lab 4: Using Service Broker

Creating Service Broker Objects Implementing the Customer Service Implementing the E-mail Service

After completing this module, students will be able to:

Describe the Service Broker architecture. Use Service Broker for message-based communication.

Module 5: Using Native HTTP Support

In this module, students learn how to create HTTP endpoints that make database services available to Web services clients.

Lessons

Native HTTP Support in SQL Server 2005 Configuring Native HTTP Support

Lab 5: Implementing a Web Service with HTTP Endpoints

Create an HTTP Endpoint Test the HTTP Endpoint Secure the HTTP Endpoint

After completing this module, students will be able to:

Describe the native HTTP support features in Microsoft SQL Server 2005. Implement a Web service using native HTTP endpoints.

Module 6: Using Notification Services

The information in this module introduces Notification Services and how to develop Notification Services applications.

Lessons

Notification Services Architecture Building Notification Services Solutions

Lab 6: Using Notification Services

Creating a Notification Services Application Creating a Subscription Management Application Creating an Event Provider

After completing this module, students will be able to:

Describe the architecture of a Notification Services solution. Design and implement a simple Notification Services solution.

Module 7: Using the .NET CLR in SQL Server 2005

In this module, students learn how to implement managed code in a SQL Server 2005 database.

Lessons

SQL Server and the .NET CLR Implementing Managed Code in SQL Server 2005

Lab 7: Implementing Managed Code in the Database

Creating a Managed Stored Procedure Creating a Managed Function Creating a Managed User-Defined Type

After completing this module, students will be able to:

Identify appropriate scenarios for using managed code in the database. Implement managed database objects.

Module 8: Developing Client Applications

The information in this module introduces database developers to client application development techniques that use the data access classes provided in the .NET Framework.

Lessons

Developing Client Applications with ADO.NET Data Binding in the .NET Framework 2.0

After completing this module, students will be able to:

Use ADO.NET to build a database client application. Use data binding in a client application.

Module 9: Using SQL Management Objects

The information in this module introduces the SQL Management Objects (SMO) Application Programming Interface (API) in Microsoft SQL Server 2005, which provides classes that you can use to manage SQL Server. SQL Server 2005 also introduces Replication Management Objects (RMO) to allow automation of replication.

Lessons

Introduction to SQL Management Objects Replication Management Objects

Lab 9: Using SQL Management Objects

Using SMO to Retrieve Server Information Using SMO to Create Database Objects Using SMO to Modify Database Objects

After completing this module, students will be able to:

Use SMO to manage SQL Server. Use RMO to manage replication.

PART 2

Module 1: Overview of SQL Server 2005 Architecture

This module introduces students to the various components and services that comprise SQL Server. Database administrators are often required to manage multiple aspects of the database server not just the relational database engine, so an awareness of the components and functionality available in SQL Server 2005 is essential in order to prepare database administrators for SQL Server 2005 deployments and management.

Lessons

Overview of SQL Server 2005 System Enhancements for Administrators

After completing this module, students will be able to:

Describe the components of SQL Server 2005. Describe new and enhanced features for administrators in SQL Server 2005.

Module 2: Installing SQL Server 2005

This module explains how to plan for a SQL Server 2005 installation, install SQL Server 2005 and maintain a SQL Server 2005 installation.

Lessons

Preparing to Install SQL Server 2005 Performing a SQL Server 2005 Installation Maintaining a SQL Server 2005 Installation

Lab 2: Installing SQL Server 2005

Installing a SQL Server Instance.

After completing this module, students will be able to:

Plan a SQL Server 2005 installation. Install SQL Server 2005. Maintain a SQL Server 2005 installation.

Module 3: SQL Server 2005 Administrative Tools

This module explains what built-in administration tools and utilities are available in Microsoft SQL Server 2005 and how they can be used to help database administrators be successful in managing a SQL Server 2005 solution.

Lessons

Using SQL Server Management Studio Using SQL Server Computer Manager Using the sqlcmd Utility Using the SQL Management Objects

Lab 3: Administering SQL Server 2005

Creating the Personnel database. Populating the Personnel database. Backing Up the Personnel Database.

After completing this module, students will be able to:

Choose the appropriate tool or utility to perform an administrative task. Use SQL Server Management Studio to manage databases. Use SQL Server Computer Manager to manage a server. Use the sqlcmd utility to execute Transact-SQL from the command prompt. Use SQL Management Objects to script common administrative tasks.

Module 4: Monitoring SQL Server 2005

This module discusses the various tools and techniques you can use to monitor Microsoft SQL Server 2005.

Lessons

Using SQL Profiler Using DDL Triggers Using Event Notifications Using Metadata Views

Lab 4: Monitoring SQL Server 2005

Creating DDL Triggers Creating Event Notifications

After completing this module, students will be able to:

Use SQL Profiler to monitor SQL Server 2005. Use DDL triggers to respond to DDL events. Use event notifications to respond to database events. Query SQL Server metadata.

Module 5: Maintaining Databases and Indexes

This module explains the tools and utilities in Microsoft SQL Server 2005 that can help you implement database maintenance plans, manage database indexes, and tune databases.

Lessons

Managing Indexes Using the Database Tuning Advisor

Lab 5: Maintaining a Database

Defining Indexes Tuning a Database

After completing this module, students will be able to:

Maintain indexes in a SQL Server 2005 database. Use the Database Tuning Advisor to assist with database design. Maintain SQL Server 2005 databases.

Module 6: Securing SQL Server 2005

This module explains the changes and enhancements to the Microsoft SQL Server security model in SQL Server 2005.

Lessons

SQL Server 2005 Security Overview Managing SQL Server 2005 Security Managing Permissions Managing Certificates

Lab 6: Securing a SQL Server 2005 Database

Managing securables Managing principals Managing Permissions Dropping a User that Created Objects.

After completing this module, students will be able to:

Describe the security architecture of SQL Server 2005. Manage securables and principals. Manage permissions. Use certificates in SQL Server 2005.

Module 7: Disaster Recovery

This module you will learn about the enhanced backup and restore functionality in Microsoft SQL Server 2005.

Lessons

Disaster Recovery in SQL Server 2005 Using Database Snapshots Backup and Restore Operations

Lab 7: Managing Disaster Recovery

Creating a Database Snapshot Backing up a Database

After completing this module, students will be able to:

Describe common disaster recovery enhancements in SQL Server 2005. Use database snapshots. Perform backup and restore operations.

Module 8: Data Availability in SQL Server 2005

This module teaches you how to take advantage of the high availability features found in SQL Server 2005

Lessons

Introduction to Data Availability Introduction to Database Mirroring Configuring Database Mirroring

Lab 8: Maintaining Availability

Preparing the Principal and Mirror Server Establishing a Mirroring Session Establishing a Witness Server Executing Transactions Simulating Principal Server Failure Restarting the Failed Server Terminating the Mirror Session

After completing this module, students will be able to:

Describe the data availability technologies included in SQL Server 2005. Describe the concepts of database mirroring. Configure database mirroring.

Module 9: SQL Server 2005 Replication

This module explains the new and enhanced replication features in SQL Server 2005

Lessons

Overview of Replication Enhancements New Types of Replication Configuring Replication

After completing this module, students will be able to:

Describe the enhancements to replication functionality in SQL Server 2005. Describe the new types of replication available

For more information, please visit www.thinkpathtraining.com or speak with one of our Learning Solutions Advisors at 1-212-566-4223.

http://www.thinkpathtraining.com/courses/CourseDetails.asp?crsID=2733X

Thinkpath Training LLC - Thinkpath Training has focused on training solutions for advanced technologies since 1993. We have trained thousands of IT professionals from hundreds of major corporations throughout North America. Our current emphasis includes training for: Microsoft Back Office | Microsoft .NET Framework Microsoft Windows | Visual Basic | Active Directory Microsoft SQL Server | C# & C++ | SMS |...