| home | | | contact | | | ![]() | email us | | | enquire | | | times etc | | | comments | | | find us |
T-SQL Programming with SQL ServerCourse 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 PrerequisitesSome 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. Programming with Transact SQL (T-SQL)
Working with Views
Variables and Temporary Tables
Using Control of Flow Statements
Working with Cursors
Developing Stored Procedures
Error Handling
Transaction Processing
Enforcing Data Integrity with DML Triggers
On Site RequirementsRemember, 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
|
|
SQL
Transact SQL
SQL Server
Oracle SQL
IBM DB2
MySQL
PostgreSQL
XSLT
XML
XML Schema
VBScript
Full List
your venue or ours
London - Midlands - Scotland
and across the UK 01785 223253instant written quotations | lumia development | "Excellent course." (Home Office attendee) |