Design a Performant Data Model in Azure SQL Database with Azure Data Studio
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.
Prerequisites
- 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