your venue or ours 
| home | | | contact | | |  | email us | | | enquire | | | times etc | | | comments | | | find us |
Introduction to Transact SQL (T-SQL)
Course Description ( TSQ-64: a 2 day course )
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.
Suggested Prerequisites
No prior SQL training or relational database experience is assumed. But while the course is for those with little or no experience of working with T-SQL, it is a course for IT Professionals.
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 | £995.00 + vat p/day (This is the total price for all attendees) |
1-to-1 price: £895.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 £995.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: £1990.00 + vat.
- For 8 attendees, the total 'per attendee' price would be around: £249.00 + vat.
1-to-1 Pricing
- The special one-to-one price for this course is £895.00 + vat per day.
- This is a 2 day course.
- The total one-to-one charge for the course is therefore: £1790.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-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. - TSQ-66: T-SQL Programming with SQL Server
Developing solutions with SQL Server's programming objects and T-SQL's procedural extensions.
Information Adviser - Learning and Skills Council