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

Academics

CampusCE

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

Catalog > SQL Server

SQL Programming Level 2  

Learn to streamline and extract relevant information for data analysis. Topics include implementing complex queries, utilizing sub queries, 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.

Recommended Textbook - Available from Amazon or any other online retailer

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

For more information, please refer to our course outline (coming soon).

This is the third course in the SQL Server Certificate (4 Class Series).

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

 

SQL Programming Level 2
Item #: Y961
Date: 2/28/2019 - 3/12/2019
Time: 6:00 PM - 9:00 PM
Sessions: 4, Tu Th
Location: Kent Campus
Room: Kent Campus 274
Address: 417 Ramsay Way, Suite 112, Kent, WA 98032-4501
Fee: $299.00
Instructor: Christian Osborn
 

SQL Programming Level 2
Item #: Y467
Date: 5/23/2019 - 6/4/2019
Time: 6:00 PM - 9:00 PM
Sessions: 4, Tu Th
Location: Kent Campus
Room: Kent Campus 274
Address: 417 Ramsay Way, Suite 112, Kent, WA 98032-4501
Fee: $299.00
Instructor: Christian Osborn