Create tables, views, and temporary objects

  • Module
  • 9 Units
Advanced
Data Analyst
Data Engineer
Data Scientist
Database Administrator
Developer
Solution Architect
Student
Azure SQL Database
Azure SQL Managed Instance
SQL Server on Azure Virtual Machines
Azure SQL Server on Virtual Machines
SQL Server

Learn how to use Transact-SQL to create tables, views, and temporary objects for your databases.

Learning objectives

After completing this module, you should be able to:

  • Create and query tables using Transact-SQL

  • Create and query views using Transact-SQL

  • Create queries using Common Table Expressions (CTE)

  • Write queries that use derived tables

Prerequisites

Before starting this module, you should have experience of using Transact-SQL queries to retrieve and filter data from a table in a database.