SQL Server 2005 Database school

About the SQL Server 2005 School

This SQL Server 2005 Database Programming school is specificaly designed to help database developers to learn the functionality available in SQL Server 2005 and plan business solutions to take advantage of this latest technology.

Prerequisites

This course requires that you have experience with Microsoft SQL Server. 7.0 or SQL Server 2000 in the following areas:

• Database architecture
• Database security
• Transact-SQL
• Query engine
• DDL
• DML
• Optimization
• Schema and objects
• Programming objects
• UDT
• UDF
• Triggers
• Stored procedures
• SQLXML
• ADO.NET

Experience developing with Microsoft Visual Basic .NET or Microsoft Visual C# is useful but not essential.

Course Outline

Lesson 1. SQL Server 2005 Overview
Lesson 2. Overview of SQL Server 2005 Architecture
Lesson 3. Installing SQL Server 2005
Lesson 4. Transact-SQL Enhancements in SQL Server 2005
Lesson 5. XML integration with SQL Server 2005
Lesson 6. Using the .NET CLR in SQL Server 2005
Lesson 7. Developing Client Applications with ADO .NET 2.0
Lesson 8. Using Service Broker
Lesson 9. Using Native HTTP Support
Lesson 10. Using Notification Services

Lesson's Description

Lesson 1. SQL Server 2005 Overview
introduces you to the components, services, and tools in SQL Server 2005. You will learn how to use the enhanced development features that can improve your day-to-day productivity. You will also learn about the security changes in SQL Server 2005.

Lesson 2. Overview of SQL Server 2005 Architecture
introduces you to the components and services of SQL Server 2005. Although you may not be working with all of these components and services on a day-to-day basis, it is important that you are aware of their existence and functionality.

Lesson 3. Installing SQL Server 2005
describes how you should plan and implement a SQL Server 2005 installation. It discusses coexistence issues and procedures for adding and removing individual components of SQL Server.

Lesson 4. Transact-SQL Enhancements in SQL Server 2005
introduces the key enhancements to Transact-SQL in SQL Server 2005. You will learn about the improvements made to both the Data Definition Language (DDL) and the Data Manipulation Language (DML). You will also learn about the new structured exception handling techniques that you can use to improve the stability of your applications.

Lesson 5. XML integration with SQL Server 2005
discusses the XML enhancements in SQL Server 2005 and the new support for XML data and schemas. In addition, you will learn about the use of XQuery in a SQL Server 2005 database application.

Lesson 6. Using the .NET CLR with SQL Server 2005
describes how you can implement SQL Server objects such as stored procedures and triggers by using managed code, and explains the advantages that you can gain from this approach in certain scenarios. The Lesson teaches you how to write managed objects and how to use compiled managed code in a SQL Server database.

Lesson 7. Developing Client Applications with ADO .NET 2.0
provides an introduction to ADO.NET database client development.

Lesson 8. Using Service Broker
describes the concepts of service-oriented architecture and explains how Service Broker lets you build service-oriented database solutions using SQL Server 2005..

Lesson 9. Using Native HTTP Support
introduces the use of HTTP support in SQL Server 2005 to publish Web services to client applications. It describes how Web services can communicate by using the Simple Object Access Protocol (SOAP) and how this lets you expose database objects across the Internet.

Lesson 10. Using Notification Services
discusses how you can create Notification Services applications to automatically send information to subscribers in a specific form.for example, as an e-mail or an SMS message. You will learn how the Notification Service components work together to provide the infrastructure, and how to write applications by using these components.

About the author

I dedicate all my work to my precious (my wife) and my lovely daughter Vamika . Vidya Vrat Agarwal, a Microsoft .NET Purist, and an MCT, MCSD.NET, MCAD.NET and MCSD. He is also a Life Member of Computer Society of India (CSI). He started working on Microsoft.NET with its beta release. He has been involved in software development, consultation, corporate trainings, T3 programs and technical writing for Microsoft .NET for various corporate clients.

He lives with his beloved wife and lovely daughter Vamika (nick named Pearly). He believes that nothing will turn into a reality without them. In technologies the part which really fascinates him is the architecture of that particular technology. He is the follower of the concept No Pain, No Gain and believes that his wife is his greatest strength.

Presently he is working with LioNBridge Technologies in Mumbai - India, where he works with Microsoft Dept. on Visual Studio 2005 (Whidbey) and SQL Server 2005 (Yukon) and his business card reads Subject Matter Expert (SME). His technical profile holds Microsoft .NET Framework, VC#, VB.NET, WebServices, Remoting, SQL Server, COM, DCOM, COM+, MTS, MSMQ. Visual Studio 2005 (Whidbey), SQL Server 2005 (Yukon) and Longhorn.

His blog can be read at http://dotnetpassion.blogspot.com

---