Transform data: Create views, functions, and stored procedures

Build evidence for this objective

Learn the concept across structured materials, then test it through adaptive questions and applied scenarios. Your results contribute to an objective-level mastery view and your next recommended action.

Official references

• Create stored procedures and user-defined functions
• Procedures and functions in PostgreSQL
• Create tables, views, and temporary objects
• Create custom procedures in Dynamics 365 Business Central
• Transform data using T-SQL in Microsoft Fabric
• Summarizing data: Aggregate functions and grouping
• Create and architect with functions in F#
• Load/export data and create data views in Dataverse
• Understand the Transformer architecture and explore large language models in Azure Machine Learning
• Use system catalogs and system views in PostgreSQL