Customer Service or Enrol: 0800 282 353 or +44 1372 364610
  Professional Certification Programmes

Save 10%

 
SQL Server Application Development
Certified Professional
 
Programme Description
Because of its ease of use, scalability and data warehousing capabilities, many organisations are choosing Microsoft SQL Server for their database needs, fueling the demand for professionals well versed in the development of robust SQL Server applications.

 
Three Core Courses
Please choose one of these Core Courses:
 
SQL Server 2000 Transact-SQL® Programming: Hands-On
(Course 532 - 5 days)
This course provides extensive experience creating stored procedures and triggers, and developing SQL queries that utilise SQL Server to the fullest. You learn to take advantage of AFTER and INSTEAD OF triggers, manage concurrency using transactions and locking options, and exchange data effectively using Transact-SQL's support for XML.
 
SQL Server 2005 Programming: Hands-On Skills Upgrade
(Course 130 - 3 days)
This hands-on skills upgrade course, designed for SQL Server 2000 or SQL Server 7 developers migrating to SQL Server 2005, provides the skills needed to develop applications with the latest .NET, XML and Transact-SQL features. You learn to exploit Transact-SQL features such as common table expressions and snapshot isolation, develop stored procedures with .NET CLR, and build message-based applications using Service Broker.
 
SQL Server 2005 Server-Side Programming: Hands-On
(Course 133 - 5 days)
This course provides experience creating procedural code in Transact-SQL and .NET. You gain the skills needed to develop XML-based messaging applications. You also learn how to handle Transact-SQL runtime errors, access data with user-defined functions and views, and develop functions in .NET CLR.
 
Developing SQL Queries for SQL Server: Hands-On
(Course 534 - 4 days)
In this course, you learn to exploit the full potential of the SELECT statement to write robust queries using the best query method for your application. You also learn to transform data with built-in functions, summarize data using aggregation and grouping, and build simple and correlated subqueries.
 
Developing High-Performance SQL Server Databases: Hands-On
(Course 535 - 5 days)
In this course, you acquire an in-depth knowledge of SQL Server's essential tools - the storage engine, lock manager and query optimizer. Through hands-on exercises, you gain the skills to implement a high-performance SQL Server database solution. You create indexes that optimise different types of queries, interpret the data access plans produced by the query optimizer, and minimize I/O by designing efficient physical data structures.
 
Choose from the following Elective Courses
 
For certification, candidates must successfully complete 3 Core Courses, 1 Elective Course and associated exams.

Each Certification Programme involves the successful completion of four courses - three core courses, plus one elective course, and their associated examinations.

Certifications are FREE. Exams are offered on the last day of each course. Transfer credit is available.







 
Customer Service or Enrol: 0800 282 353 or +44 1372 364610