Introduction to SQL Server Transact SQL Course
Download PDF course outline
Course DescriptionThis course is aimed at SQL Server database developers, administrators and analysts who need a little bit more than SQL can do alone. SQL Server provides a powerful scripting language, Transact SQL, which enables developers to extend the capabilities of the SQL language. Using Transact SQL (TSQL) powerful scripts, stored procedures, functions and triggers can be produced to enable extracted information to be processed further, or to enable complex transformations of data prior to, during or after an insert, update or delete, or to implement automated updates and audit trails.
As well as looking at how to create and maintain scripts, stored procedures, user-defined functions and triggers this course will explore some of the additional TSQL features such as Views and Common Table Expressions (CTEs). |
£895 3 day course Scheduled Dates: 11 January 2012 08 February 2012 07 March 2012 11 April 2012 02 May 2012 27 June 2012 Location: PTR's Training Centre Wokingham, Berkshire. |
Course pre-requisites:
Delegates should have SQL Server SQL language experience to the level of the PTR Advanced SQL for SQL Server course.
Many tasks can be simplified by wrapping them into an SQL script or a Stored Procedure, or performance can be improved by moving away from ad-hoc SQL queries to stored procedures.
Delegates will learn the basics of the Transact SQL programming language and will then utilise those skills to create simple task oriented scripts and stored procedures, through to complex programmed objects that accept input values and output or return calculated and derived values. They will learn how to handle singleton select statements in a Transact SQL program as well as using cursors to handle multiple record sets.
User defined functions provide a powerful way to extend the built-in capabilities of the SQL Language to cater for specific business needs. This course covers both user defined scalar functions returning a single value and table-valued functions which return a set of records (a table variable).
The course will also show delegates how to utilise Stored Procedures, User defined Functions and cursors within database objects such as triggers, which enable automated tasks, business rules and data auditing to be implemented centrally within the database.
Also covered in this course are some of the extended features of SQL, such as Views and Common Table Expressions. Common Table Expressions are particularly useful when working with hierarchical or recursive data.
For further details see the full course outline for this course
Synopsis
This course is aimed at database professionals who wish to build on their SQL Server SQL skills and start to develop scripts, stored procedures and related objects such as user defined functions and triggers.Many tasks can be simplified by wrapping them into an SQL script or a Stored Procedure, or performance can be improved by moving away from ad-hoc SQL queries to stored procedures.
Delegates will learn the basics of the Transact SQL programming language and will then utilise those skills to create simple task oriented scripts and stored procedures, through to complex programmed objects that accept input values and output or return calculated and derived values. They will learn how to handle singleton select statements in a Transact SQL program as well as using cursors to handle multiple record sets.
User defined functions provide a powerful way to extend the built-in capabilities of the SQL Language to cater for specific business needs. This course covers both user defined scalar functions returning a single value and table-valued functions which return a set of records (a table variable).
The course will also show delegates how to utilise Stored Procedures, User defined Functions and cursors within database objects such as triggers, which enable automated tasks, business rules and data auditing to be implemented centrally within the database.
Also covered in this course are some of the extended features of SQL, such as Views and Common Table Expressions. Common Table Expressions are particularly useful when working with hierarchical or recursive data.
For further details see the full course outline for this course
View full course outline and contents
Course Classification:
Technical Training Course
This is an instructor led training course taught in a classroom based environment.
Scheduled course dates
11 January 2012 to 13 January 2012
08 February 2012 to 10 February 2012
07 March 2012 to 09 March 2012
11 April 2012 to 13 April 2012
02 May 2012 to 04 May 2012
27 June 2012 to 29 June 2012
View full schedule of Generic courses
View full schedule of SQL Server 2008 courses
Print / Download PDF Version of full course schedule
If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite SQL Server 2008 Training and bespoke SQL Server 2008 courses