Upgrading My Skills To SQL Server 2005

At work we are required to get training at least once a year. So I decided to take the Upgrading Your Database Development Skills To Microsoft SQL server 2005

At the end of this post you will see what I should learn. The things that I am most excited about are: Service Broker and Using SQL Management Objects. The new Transact SQL enhancements I know already; I have covered several of them in this blog.

I doubt that I will use the .NET CLR in SQL Server 2005; but I must say that I was amazed at how easy it is to set it up. Notification services could be something I could use but right now I have build my own.
The Native HTTP Support was really cool; it was strange to see WSDL generated from SQL Server. It is something that can be deployed internally since I know that we will never open up our SQL boxes at work to the outside world.

So today is the last day of the class and we have a break now. I must say going to training beats a book anytime. it just saves you so much time. This was a 3 day course. If I had to do it by myself with a book it would take me at least 2 weeks.

Talking about books I am also in the middle of reading Inside Microsoft (r) SQL Server (tm) 2005: The Storage Engine and Pro SQL Server 2005 Database Design and Optimization and both are excellent books

So here is what was covered in this course:


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

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

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

Module 4: Using Service Broker

The information in this module introduces Microsoftr SQL ServerT 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

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

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

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

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

Lab 8: Developing Client Applications
Creating a Data Bound Windows Application
Creating a Data bound ASP.NET Application

Module 9: Using SQL Management Objects

The information in this module introduces the SQL Management Objects (SMO) Application Programming Interface (API) in Microsoftr SQL ServerT 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