Au cours de cette formation, vous vous retrouverez face à face avec les nouveautés du serveur Microsoft SQL 2005.Vous découvrirez comment SQL Server 2005 transforme les paradigmes de programmation traditionnels appuyé par une complète intégration avec Visual Studio 2005 (.NET IDE).Ce cours introduit l’ensemble des nouvelles techniques de programmation et de conception en matière de base de données.

Les plus gros changements avec SQL Server 2005 sont aux niveaux des fonctionnalités de la base de données et du Storage native XML. Nous discuterons de quand et comment utiliser Service Broker, Notification Services et les services natives web avec SQL Server 2005 afin de bâtir de riches applications.  La Sécurité et les améliorations au niveau du moteur relationnel seront également au rendez-vous.

L’introduction du cadre de programmation .NET à même l’engin de base de données représente un avancement important. Couplé par l’ajout d’un nouveau type de données « XML » et une syntaxe de requête correspondante. L’ensemble de ces fonctionnalités sera présenté avec l’objectif de permettre aux programmeurs de déterminer non seulement comment elles fonctionnent mais aussi quand les utiliser.

                           Description de Cours  / Course Outline

Day 1: Using .NET inside SQL Server

            SQLCLR - SQL Server as a .NET runtime host 
 This module covers what it means to be a .NET runtime host. Topics include how SQL Server differs from other runtime hosts such as IIS or IE and how it is similar with respect to loading  and running code. Finally, we'll contrast .NET integration with the extended stored procedure concept in previous SQL Server versions.

            Using .NET stored procs, user-defined functions, and triggers 
One of the most exciting features from a developer’s point of view in SQL Server 2005 is the ability to write procedural SQL Server code in any managed language. In this module we will  cover in detail how to write procedures, functions and triggers using a managed language, and discuss when to use managed code and when to use Transact-SQL.

Using the .NET SqlServer data provider inside the database 
 As we can write code to run in-proc in SQL Server from we also need a provider that runs in the same process space as SQL Server. This section covers the new provider,  system.Data.SqlServer, and discusses how connections, variable mappings and other functions that are built in to Transact-SQL are handled when a .NET language is used.

Day 2: New Types, New Security, New Engine Features

.NET user-defined types and user-defined aggregates 
 In addition to using .NET object types in procedure code, we can use them inside the         database, as, for example, columns in a SQL Server table. In this module we'll look at user-       defined types and how we can use then from our code.

            SQL Server 2005 security improvements and security for .NET data items
 This module covers security enhancements in SQL Server 2005. In addition, as the CLR is hosted in the SQL Server Engine it means that we can use CLR’s security features. In this   module we will look at how we can utilize CAS etc., from within the SQL Server engine. We’ll      also take a look at how .NET types fit into the SQL Server permissions scheme.

            New engine features in SQL Server 2005 
 SQL Server Yukon includes new features inside the engine. The biggest change of interest to  developers will be the ability to use versioning to ensure transaction isolation, in addition to  locking. We’ll discuss this topic and its effect on application development in depth. In addition,  we’ll cover DDL triggers, Event Notifications, the new LOB data types and Bulk Insert   enhancements.

Day 3: Transact-SQL Enhancements, XML data type and Query

            New Transact-SQL features in SQL Server 2005 
 Although Transact-SQL is not exposed as a managed language; new features such as        exception handling make it more like a traditional programming language. We'll cover the new    DML features such as recursive queries, PIVOT supports, ranking and partitioning functions,      TOP enhancements and more.

            Using the XML data type in SQL Server 2005 
 A new type of data has gained popularity in recent years, XML. XML has evolved from a      simple data transfer format to a data storage format that includes its own schema-definition        vocabulary, XSD, as well as query languages. In this module, we'll look at the XML data type      and see how it differs from conventional CLOB (TEXT field) storage of an XML document.

Day 4: Enhancements to the SQL Server Programming Platform

Using XQuery functions with the XML data type 
XML brings with it some powerful query languages for dealing with the hierarchical format that  it typical of an XML document. This module covers XQuery integration, as well as discussing      the fundamentals of XQuery itself.

            SQL Server Service Broker
 With the inclusion of SQL Server message broker services and asynchronous messaging, SQL Server becomes a more visible part of a multi-tier service based application architecture. We'll look at the Broker and the architecture and see what new application possibilities open up.

            HTTP Endpoints and web services inside the database 
  Since SQLXML 3.0, we've been able to expose SQL Server output directly as a Web Service. Now, with the tighter integration of SQL Server and XML, Web Service architectural     possibilities are enhanced. We'll look at how to best expose SQL Server as a Web Service, for  both query and data manipulation aspects.

Day 5: Enhancements to ADO.NET, ADO, and XML on the client

            SqlClient provider, ADO, and support of the new data types 
With the advent of new features due to inclusion of the CLR as well as improved XML support,   the client API’s needs to be enhanced in order to utilize the new features. This chapter will look   at what enhancements there are both in ADO “classic” as well as ADO.NET.   

            SqlClient enhancements for the ADO.NET 2.0 release    

 SQL Server has had a restriction that only one active result set is allowed on a connection at      any given time. In SQL Server 2005 this is now longer the case. In this chapter we’ll look at         how this works and what we can do with this feature. We’ll also look at a host of other             ADO.NET enhancements that are part of the SQL Server 2005 era SqlClient data provider.

Developmentor is a high-quality developer education company with a unique combination of exceptional staff, content delivery options, and a developer-centric learning environment that sets it apart from other training organizations in the software development industry. They provide in-depth training for experienced developers looking to expand their knowledge while gaining new skills efficiently and effectively. Their training courses and events feature the most current information available; all course materials are written by their own independent technical staff, so there is no vendor bias or marketing hype.

Kent Tegels is the Database Curriculum Lead for Developmentor, where he is responsible for developing and teaching classes in database technologies, programming and Microsoft .NET. Since 2004, Kent has been recognized by Microsoft with Most Valuable Professional (MVP) status in SQL Server for his community involvement with SQL Server and .NET. Kent holds Microsoft Certifications in Database Administration and Systems Engineering. He has contributed to several books on data access programming and .NET and is well known industry speaker.

Essential SQL Server 2005 for Developers brings you face-to-face with the exciting changes in SQL Server 2005, both in the database itself and in the client-side APIs that will change the way programmers design and write both database and .NET applications. This course introduces all of the new server and client programming techniques enabled by SQL Server 2005 and Visual Studio 2005/.NET 2.0.

Within SQL Server, the biggest changes are the in-database .NET functionality and native XML storage and query. We discuss how and when to use Service Broker, Notification Services, and native Web services with SQL Server 2005 to build rich applications. Security and relational enhancements are covered as well. Outside of the database, the client side has been greatly enhanced with support for new data types, functional enhancements in SqlClient, client-side XQuery functionality, and additions to the .NET XML stack.

The course covers all of these topics at both a low level and a functional level, enabling programmers to determine not only how they work, but when to use them. We’ll also discuss the new features to support platform integration. 

This course is designed for experienced SQL Server developers who want to take advantage of the latest features and functions in the new SQL Server 2005 release.