your venue or ours 
| home | | | contact | | |  | email us | | | enquire | | | times etc | | | comments | | | find us |
T-SQL Programming with SQL Server
Course Description ( TSQ-66: a 2 day course )
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.
Suggested Prerequisites
Some prior SQL or T-SQL experience is assumed. Ideally, (though not mandatory), attendees will have either attended, or have the skill set from, Querying SQL Server with Transact SQL (T-SQL) , Introduction to Transact SQL (T-SQL), A Foundation in Transact SQL (T-SQL) or any of the SQL courses.
view the full course outline here
 2 to 8 attendees your venue or ours laptops for your venue all-inclusive price course can be tailored | £1095.00 + vat p/day (This is the total price for all attendees) |
1-to-1 price: £995.00 + vat per day.
About the Pricing
- The price you see is the price you pay.
- You can include up to 8 attendees per course.
- All expenses are included in the price (wherever the course is run).
- We are able to deliver most courses at either your venue or ours (anywhere in the UK).
- For courses at your venue, included in the price, we supply ThinkPad laptops (one per attendee) already setup for the course.
- You may choose the dates to suit your organisation.
2-to-8 Pricing
- The price for 2 to 8 attendees is £1095.00 + vat per day (the total price per day).
- This is a 2 day course.
- The total charge for 2 to 8 attendees on the course is therefore: £2190.00 + vat.
- For 8 attendees, the total 'per attendee' price would be around: £274.00 + vat.
1-to-1 Pricing
- The special one-to-one price for this course is £995.00 + vat per day.
- This is a 2 day course.
- The total one-to-one charge for the course is therefore: £1990.00 + vat.
On Site Requirements
Remember, we provide all equipment and software required to deliver a course at your premises. Aside from this, we need a suitably quiet and equipped room with enough work space for each attendee and a whiteboard or flipchart. Most courses involve the use of a PC projector and we bring our own. But either a projector screen, or usually just a clear wall, would be very helpful.
Other Courses to Consider
- TSQ-63: Querying SQL Server with Transact SQL (T-SQL)
For those needing to use T-SQL to extract data from SQL Server (Action queries which modify data or objects not included). - TSQ-64: Introduction to Transact SQL (T-SQL)
Using T-SQL to extract data from, and update data in, SQL Server (for developers and end users). - TSQ-65: A Foundation in Transact SQL (T-SQL)
Developing Transact-SQL (T-SQL) solutions which extract data from, and manipulate data (and database objects) in, Microsoft SQL Server.