Introduction to Transact-SQL

Beginner
Data Analyst
Data Engineer
Data Scientist
Database Administrator
Developer
Solution Architect
Student
Technology Manager
Azure SQL Database
SQL Server
Azure SQL Managed Instance
Azure SQL Server on Virtual Machines
SQL Server on Azure Virtual Machines

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.

Learning objectives

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.