This module provides an introduction to relational databases, the SQL language and Transact-SQL. You'll learn what kinds of statements make up the SQL language and look at the SELECT statement in detail.

After completing this module, you'll be able to:

• Understand what SQL is for
• Identify database objects in schemas
• Identify SQL statement types
• Use the SELECT statement
• Work with data types
• Handle NULLs

Prerequisites

Before starting this module, it's helpful to have experience of working with tables with data; for example in a spreadsheet.