What you'll learn
-
Complete literal SELECT statements.
-
Filter data using the WHERE clause
-
Learn about database design and normalization
-
Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN
-
Group data together using the GROUP BY clause
-
Use built-in SQL Server functions
-
Work with Table Expressions: Derived Tables and CTEs
-
Use Subqueries
-
Complete basic SELECT statements querying against a single table
-
Sort data using the ORDER BY clause
-
Using joins, return columns from multiple tables in the same query
-
Complete SQL statements that use aggregate functions
-
Filter groups of data using the HAVING clause
-
Understand SQL Server Data Types and Type Casting
-
Use CASE Statements
