SELECT statements in SQL Server 2016 are used to query tables and views. Further, you can manipulate data using SELECT statements to customize the returned results. This course focuses on the fundamentals of using SELECT statements, including how to use aliases and case expressions, as well as the DISTINCT clause. Lastly, this course covers how to query multiple tables using joins. This course is one of a series of courses that cover the objectives for 70-761: Querying Data with Transact-SQL exam.
Database administrators, database developers, and BI professionals