Request Info

Salutation

First Name

Last Name

Job Title

Department

Mailstop

Company

Address

P.O. Box

City

State

Zip Code

Country
List

Work Phone

Extension

E-mail

Information provided will be used to communicate with you about our products.
Privacy Statement

A representative will contact you to follow up your request.

 

SQL Server® Server-Side Programming with .NET and XML: Hands-On


Course 1334 Days

 E-mail E-mail a Colleague Course Details Course Details Course Details PDF Course Details PDF

Frequently Asked Questions

What is this course about?

This course provides comprehensive coverage of Microsoft SQL Server 2005, 2008 and 2008 R2 for database developers. You learn how to use the power of .NET, and XML combined with Transact-SQL to build truly flexible, scalable and robust applications that meet today's business demands. The extensive hands-on exercises provide you with valuable opportunities to practice solving business problems with Microsoft's Transact-SQL and .NET programming languages. You also gain the skills needed to develop XML-based messaging applications.

What background knowledge do I need?

You should be comfortable with basic features of SQL Server and have experience with T-SQL programming at the level of Course 532, SQL Server Transact-SQL® Programming: Hands-On, or equivalent. You should also have experience with .NET programming ideally in C#.

Who will benefit from this course?

Typical participants include:

  • Programmers, analysts, developers, designers, consultants and others who design and write applications that access Microsoft SQL Server databases

Is XML knowledge required?

No. This course provides background information on XML as well as hands-on experience producing and using XML.

What is SQL Server? What is Transact-SQL?

SQL Server is a key component of Microsoft's Windows Server System. SQL Server is a full-featured relational database management system with support for robust server-side development. It runs on the Windows 2000/ 2003/2008 operating systems. Transact-SQL is Microsoft's dialect of SQL. It is used to manipulate data in databases and to administer databases. Knowledge of this language is essential for anyone developing applications for SQL Server.

Does this course teach Transact-SQL?

No. The main features of T-SQL such as writing stored procedures, functions and triggers are covered in Course 532, SQL Server Transact-SQL® Programming: Hands-On. This course assumes this level of knowledge and covers extensions to those features such as Service Broker, End Points and data encryption.

What versions of SQL Server are covered?

This course covers SQL Server 2005, 2008 and 2008 R2. When a particular part of the course is relevant only to a particular version then this is clearly identified in the course material.

Do I need to know the SQL language prior to attending this course?

Yes. A basic knowledge of SQL is sufficient for this course.

What is .NET CLR?

.NET is Microsoft's virtual execution environment and tool set for programming languages and components. It provides a component-based architecture that is capable of distributing applications across an intranet or the Internet. The Common Language Runtime (CLR) forms the core of the Microsoft .NET framework and provides the execution environment for all .NET code.

Do I need to have experience with C#, VB.NET or Visual Studio .NET? What .NET programming language is used in the course?

Basic experience with a .NET programming language and C# in particular to the level of Course 502, Programming with .NET: A Comprehensive Hands-On Introduction, is assumed. This course presents code examples in the C# programming language.

Is this course useful to me if I have limited SQL Server experience?

No, this course requires T-SQL programming experience. Ideally, you will have T-SQL programming at the level of Course 532, SQL Server Transact-SQL® Programming: Hands-On.

How much time is spent on each topic?

ContentHours
Architecture and tools2.0
Querying and Storing XML 4.5
Encryption1.25
Service Broker4.0
.NET CLR4.0
LINQ2.5
Entity Framework3.0
Times, including the workshops, are estimates; exact times may vary according to the needs of each class.

Is this course useful to me if I have already been developing for SQL Server 7.0 or 2000?

Yes, most of the features discussed in the course are new in SQL Server 2005, 2008 and 2008 R2. Those experienced with earlier versions of SQL Server will benefit.

What platform is used for the hands-on exercises?

This course uses Microsoft SQL Server 2008 R2 running on Windows Server 2008.

How much time is devoted to hands-on exercises?

45 % of class time is spent doing hands-on exercises. Exercises in this course include the following:

  • Retrieving data using LINQ to SQL and LINQ to Entity
  • Developing procedures in .NET CLR
  • Storing and retrieving XML
  • Encrypting data

These and other hands-on exercises provide immediate reinforcement of material covered in the course lectures.

How does this course relate to other Learning Tree courses?

The SQL Server courses you take vary depending on the role you play in your organization. Please refer to the SQL Server Curriculum Q&As for details on which courses are most appropriate to your role and the order in which you should take them. You may be interested in these SQL Server and related courses:

SQL Server is a registered trademark of Microsoft Corporation.

Learning Tree AnyWareTM is a trademark of Learning Tree International, Inc. in the United States and other countries, and is covered by a patent application pending in the United States.
 
SQL Server® Server-Side Programming with .NET and XML: Hands-On

Training Dates

Live online classroom training.Most events below can be taken in-class or live, online from your home or office with AnyWare.
Jul 31 - Aug 3New York enroll

For AnyWare enrollments, please register at least 7 days prior to the start of the course.

More Dates and Locations.

Tuition for Course 133 (4 Days)

Bring this or any Learning Tree Course on-site to your location!

Your Course Tuition
Entitles You to...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Course Completion Certificate awarding Continuing Education Units
  • FREE participation in Professional Certification
  • FREE participation in College Credit programs (including related exams)