Design a Performant Data Model in Azure SQL Database with Azure Data Studio
In this module, you'll learn how to create a data model with Azure data studio. You'll create indexes and 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