Design and implement database objects with SQL

  • Module
  • 11 Units
Intermediate
Advanced
Data Engineer
Database Administrator
Developer
Solution Architect
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Microsoft Fabric

This module covers designing and implementing various database objects including tables with different data types, specialized table types, indexes, constraints, and partitioning strategies. You'll learn how to create and optimize database objects for modern SQL platforms.

Learning objectives

After completing this module, you'll be able to:

  • Design and implement tables with appropriate data types, sizes, and columns
  • Implement specialized tables including in-memory, temporal, external, LEDGER, and GRAPH tables
  • Design and implement JSON columns and indexes
  • Design and implement database constraints including primary key, foreign key, unique key, CHECK, and DEFAULT
  • Design and implement SEQUENCES
  • Design and implement partitioning strategies for tables and indexes

Prerequisites

Before starting this module, you should have:

  • Experience writing T-SQL queries
  • Basic understanding of database concepts
  • Familiarity with relational database design principles
Start