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

Academics

CampusCE

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

Catalog > Computers > See All Classes

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.

For more information, please refer to our course outline.

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

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

The Definitive Guide to DAX: Business Intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI (Business Skills), 1st Edition, ISBN-13: 978-0735698352

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

 

SQL Programming Level 2
ID: Y466 11/17/2018 - 11/26/2018
Sessions: 3, M Sa 6:00 PM - 9:00 PM
Location: Auburn Center
Room: Auburn Center 250
Address: 1221 D Street NE, Auburn, WA 98002
Fee: $299.00 Instructor: Anand Injeti
NO CLASS 11/24; includes one Saturday session on 11/17 from 9 am - 3:30 pm.