SQL Server Training Courses
 m High quality, flexible training.- m Your venue or ours on dates to suit.
- m Fixed price for up to 8 attendees.
- m Laptops for your venue included.
- m All courses can be tailored.m Email your requirements.
- m From £995.00 + vat per day for up to 8 attendees
List of SQL Server Courses
| TSQ-63 |
Querying SQL Server with Transact SQL (T-SQL) details |
(2 day) |
This highly rated course is for Microsoft SQL Server database developers or end users who need to extract data using Transact SQL (T-SQL). While attendees gain much experience designing complex T-SQL queries using standard functions, joins and subqueries, T-SQL action statements which facilitate data or database modification do not form part of this course. So as to master the syntax of the language, the course is highly practical in nature and the focus throughout is on coding T-SQL by hand. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| TSQ-64 |
Introduction to Transact SQL (T-SQL) details |
(2 day) |
This course is for Microsoft SQL Server database developers or end users who need to extract and update data using Transact SQL (T-SQL) up to the level of working with joins (inner and outer), grouping and summarizing results, working with subqueries, creating and using views, and performing action queries with INSERT, UPDATE and DELETE. In order to master the syntax of the language, the course is highly practical in nature and the focus throughout is on coding Transact SQL (T-SQL) by hand. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| TSQ-65 |
A Foundation in Transact SQL (T-SQL) details |
(3 day) |
This course is aimed at Microsoft SQL Server database developers or end users who need to extract and insert data to an in-depth level and who also need to create and modify database objects. The course is highly practical in nature and the focus throughout is on coding T-SQL by hand. On completion, each attendee is given a USB pen drive to take away. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
| TSQ-66 |
T-SQL Programming with SQL Server details |
(2 day) |
This highly practical course is aimed at database developers or power users with existing SQL or T-SQL experience. It teaches how to utilize T-SQL's procedural extensions (variables, conditionals, looping and cursors) to develop solutions with Microsoft SQL Server's programming objects (stored procedures, triggers, views and user defined functions). Processing transactions, basic error handling and working with XML also feature. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
view pricing | view full outline (This course can be tailored)
|
on site training courses available in:
- London
- , Birmingham
- , Edinburgh
- , Manchester
- , Scotland
- , Glasgow
- , Nottingham
- , Midlands
- , Bristol
- , Wales
- , Cardiff
- , Dublin
- , Belfast
- , Leeds
- , Liverpool
- , Sheffield
- , Reading
- , Oxford
- , Cambridge
- , Southampton
- , Newcastle
- , Durham
- , Warrington.
and across the UK and Ireland
|
|
SQL
your venue or ours 
Software Developer - HBP Systems