Explore performance-based design

Intermediate
Data Analyst
Data Engineer
Database Administrator
Developer
SQL Database
SQL Server

Explore normalization for relational databases. Investigate the impact of proper datatype usage. Compare types of indexes.

Learning objectives

After completing this module, you will be able to:

  • Explore normal forms and how they affect database design
  • Choose appropriate datatypes for your data
  • Evaluate appropriate index types

Prerequisites

  • Ability to use tools for running queries against a Microsoft SQL database, either on-premises on cloud-based.
  • Ability to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level.
  • Basic understanding of structure and usage of SQL Server indexes.
  • Basic understanding of relational database concepts.