Microsoft SQL for Beginners

A comprehensive course to teach you how to complete SQL queries using Microsoft SQL Server and the T-SQL language.

English Development
3/2017 3144
Microsoft SQL for Beginners

Complete literal SELECT statements.

Complete basic SELECT statements querying against a single table

Filter data using the WHERE clause

Sort data using the ORDER BY clause

Learn about database design and normalization

Using joins, return columns from multiple tables in the same query

Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN

Complete SQL statements that use aggregate functions

Group data together using the GROUP BY clause

Filter groups of data using the HAVING clause