Design and develop database solutions

  • Learning Path
  • 4 Modules

At a glance

Build database solutions across SQL Server, Azure SQL, and Microsoft Fabric. You learn to create well-structured database objects and indexes. You encapsulate business logic with stored procedures and functions. You write advanced T-SQL using techniques such as Common Table Expressions (CTE), window functions, and error handling. You also accelerate your development workflow with AI-assisted tools including GitHub Copilot and Fabric Copilot.

Prerequisites

Before starting this learning path, you should have experience writing T-SQL queries, a basic understanding of database concepts such as tables, joins, and transactions, and familiarity with SQL Server, Azure SQL Database, or SQL databases in Microsoft Fabric.

Modules in this learning path

Design and implement database objects with SQL

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.

Implement programmability objects with SQL

Learn how to create and use views, stored procedures, scalar functions, table-valued functions, and triggers to build maintainable, secure, and efficient database solutions.

Write advanced T-SQL code

Learn advanced T-SQL techniques including CTEs, window functions, JSON, regular expressions, fuzzy matching, graph queries, and error handling for SQL Server, Azure SQL, and Fabric.

Implement SQL solutions by using AI-assisted tools

Learn how to leverage GitHub Copilot and Fabric Copilot for AI-assisted database development across SQL Server, Azure SQL, and SQL databases in Microsoft Fabric.

Start