|   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 1  

Microsoft SQL Server has evolved to become a true, enterprise information platform. In this course you will learn the fundamental elements of T-SQL, including the definition of DML, DDL, DCL and TCL; review two and three-valued logic and how to work with NULLs; practice T-SQL programming constructs to query and modify a database in SQL Server Management Studio (SSMS); identify the different forms of the JOIN clause; filter data using logical queries; and define constraints to enforce data integrity. Prerequisite: Business Intelligence Essentials or equivalent. For more information, please refer to our course outline (coming soon). This is the second course in the SQL Server Certificate (4 Class Series). Required Textbook (available from Amazon): 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 1
ID: Y465 10/22/2018 - 11/5/2018
Sessions: 4, M Sa 6:00 PM - 9:00 PM
Location: Auburn Center
Room: Auburn Center 250
Address: 1221 D Street NE, Auburn, WA 98002
Fee: $349.00 Instructor: Anand Injeti
Includes one Saturday session on 11/3 from 9 am - 3:30 pm.