Implement programmability objects with SQL

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

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

Learning objectives

In this module, you'll:

  • Create views to simplify data access and provide security boundaries.
  • Build stored procedures to encapsulate complex business logic and data modifications.
  • Develop scalar functions to return single calculated values.
  • Implement table-valued functions to return result sets for use in queries.
  • Configure triggers to automatically respond to data modifications or database events.
  • Choose the right programmability object based on specific requirements.

Prerequisites

  • Experience with SQL Server database development and T-SQL programming.
  • Understanding of basic database concepts like tables, joins, and transactions.
  • Familiarity with SQL Server Management Studio or Azure Data Studio.
Start