Design a Performant Data Model in Azure SQL Database with Azure Data Studio

Solution Architect
Azure SQL Database
Azure SQL Managed Instance
Azure Data Studio
SQL Server

Learn how to create a data model with Azure data studio. Create indexes, tables and use data types to help develop your applications

Learning objectives

By the end of this module, you'll be able to:

  • Design a data model containing tables that have relationships to each other.
  • Understand which data types best fit the type of information an application needs to store in the database.
  • Create specific rules defining what data can be entered into columns and rows in the tables.
  • Apply table indexes and understand how they benefit information retrieval from a database.


  • Knowledge of what (product) is and how it works at the beginner level
  • Beginner database knowledge
  • Basic experience navigating the Visual Studio Code user interface