Microsoft SQL Server has evolved to become a true, enterprise information platform. In this course you'll learn the fundamental elements of T-SQL, including the definition of DML, DDL, DCL and TCL; use control of flow statements like IF and WHILE; work with NULLs; practice T-SQL programming constructs to query and modify a database in SSMS; identify the different forms of the JOIN clause; filter data using logical queries; and define constraints to enforce data integrity.

Prerequisites: Relational Database Concepts and Design

Recommended Textbook (available from Amazon)

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

For more information, please refer to our course outline.

This is the second required course in the SQL Server Certificate (4 Class Series) and the Data Analyst Certificate Part 1: SQL Server (4 Class Series).

The SQL Server Certificate is a prerequisite for the Data Analyst Certificate.

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