In this module you will learn about what Transact-SQL is and what its used for. You will learn about querying your database using the select statement and the clauses you can include within a select statement. You will learn about the different datatypes that a database might hold. You will learn about NULL values in your database.

In this module you will learn about the select statement and further ways of refining your select statement. You will learn about removing duplicates from your query results. You will learn about sorting your query’s results using the Order by clause. You will learn about filtering your select statements search using predicates.

In this module you will learn about the concepts and syntax of joins. You will learn about each of the different types of joins you can use in your queries and what each type does. You will learn about combining result of multiple queries using the Union operator. You will learn about Intersect and Except queries.

In this module you will learn about different functions you can include in your queries. You will learn about Scalar functions and what they do. You will learn about logical functions and how they work. You will also learn about window functions and aggregate functions and applying them to your queries. You will learn about filtering using the group by subclause and Having clause.

You must score 80% or more to pass this assessment.