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

Academics

CampusCE

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

Catalog > 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: GRC Staff
    Includes one Saturday session on 11/17 from 9 am - 3:30 pm. NO CLASS 11/24
     

    SQL Programming Level 2
    ID: Y961 2/28/2019 - 3/12/2019
    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: GRC Staff