MEAPSA

Explore performance-based design

Explore normalization for relational databases. Investigate the impact of proper datatype usage. Compare types of indexes. Determine where data compression can be useful.

Data Analyst

Database Administrator

Data Engineer

Developer

SQL Server

SQL Database

Module 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
Investigate the value of data compression

Units

Introduction min
Describe normalization min
Choose appropriate data types min
Design indexes min
Describe data compression min
Knowledge check min
Summary min

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.