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 website. 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.