Microsoft SQL Server 2005 For Developers Training Classes

Do you want to harness the power that MS SQL 2005 offers to application developers? Let us show you how. The 2005 edition of SQL Server comes with a variety of new features and enhancements specially suited for database developers. These features are designed to increase scalability, productivity, flexibility, and performance. By taking the Microsoft SQL 2005 for Developers training class, you will learn about these features such as .NET integration, SQL Service Broker, Native XML Datatype, Native Data Encryption, Web Services, Notification Services, ADO.NET 2.0, Business Intelligence Development Studio, SQL Server Management Studio, and how to integrate with Visual Studio 2005.

The Microsoft SQL 2005 for Developers training class is a hands-on course that examines the existing features as well as the new features of SQL Server 2005. The course allows you to develop representative applications serving as a solution-based training model.

For those of you seeking certification, this course is also designed to help you in your preparation for the Microsoft IT Professional: Database Developer certification exams.

CBT Planet also offers a cost effective solution for companies with at least six students who need this training. Our onsite Microsoft SQL 2005 for Developers training class allows your group to remain onsite during their studies. Instead, our instructor comes to you and presents the course at your location.

Number of Days:	5 Days
Course Price:	$2,895

What You'll Learn

By taking this Microsoft SQL 2005 for Developers training class, you will learn about the new features and enhancements included in the SQL Server 2005 for the Database Developer, how to use SQL Server Management Studio, how to create databases, how to create database objects such as stored procedures, triggers, and functions, and how to create indexes for performance. In addition, you will look at transact-SQL enhancements, XML technologies, transact SQL versus CLR-based stored procedures, and work with .NET framework hosting and visual studio 2005. Other topics include working with SQL service broker, using ADO.NET 2.0, developing XML web services, native data encryption, notification services, and how to work with the new full text index features.

Who Needs to Attend

If you want to learn how to develop applications with SQL Server 2005, update your skills from the 2000 version of SQL Server, or if you are trying to earn your MCITP: Database Developer certification, this course is an excellent choice. Everything you need to know is presented in just five days of high-quality, hands-on, instructor-led instruction.

Course Schedule:

View Class Schedule
Request Onsite Microsoft SQL Training

Course Outline:

New Features of SQL Server 2005 for the Developer
SQL Server Management Studio and Database Creation
Designing and Implementing Database Objects
Transact-SQL and Data Manipulation
Performance Tuning a Database and a Database Application
Stored Procedures
Triggers and User-Defined Functions
Security - Native Data Encryption
ADO.NET 2.0
Designing a Transaction Strategy
Develop an XML Web Service in the Database Tier
SQL Server Service Broker
Set Up and Use Notification Services

Locations:

San Francisco, CA
Rockville, MD
Ottawa, ONT
Toronto, ONT
Orlando, FL
Washington, DC
New York, NY
Los Angeles, CA
Chicago, IL
Houston, TX
Dulles, VA
Raleigh, NC
Dallas, TX
Boston, MA
Sacramento, CA
San Jose, CA
Morristown, NJ
Atlanta, GA
Philadelphia, PA
Orlando, FL
Denver, CO