Explore performance-based design
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.