|   Sign In   |   View Cart   |   Help   |   Cart: 0 items



Print Course information
E-mail to a friend
Return to Course Catalog

Catalog > Computers > See All Classes

SQL Programming Level 2  

Take your SQL Server skills to the next level by creating more complicated and well-performing queries to extract the information you need. Topics include implementing complex queries, utilizing subqueries, derived tables, common table expressions and windowing functions; designing views and inline functions; building stored procedures, user-defined functions and triggers; implementing transactions, error handling and dynamic SQL; identifying locking and isolation levels; and creating indexes. Prerequisite: SQL Programming Level 1 or equivalent.

Recommended Textbook (available from Amazon or any other book retailer):

Beginning SQL Server for Developers - 4th Edition, Dewson, ISBN-13: 978-1484202814

Note: Please bring a USB flash drive (minimum 2 GB) to class, so you can save your work.

For more information, please refer to our course outline.

This class is part of our SQL Server Certificate Program.


SQL Programming Level 2
ID: Y475 5/29/2018 - 6/7/2018
Sessions: 4, Tu Th 6:00 PM - 9:00 PM
Location: Kent Campus
Room: Kent Campus 274
Address: 417 Ramsay Way, Suite 112, Kent, WA 98032-4501
Fee: $299.00 Instructor: Anand Injeti
Please Note: The course dates for this program have changed and do not match what was listed in our Spring CE publication. This course is now scheduled on Tuesdays and Thursdays, May 29 through June 7.