Unlock the potential of Power Pages to create dynamic, data-driven web applications with ease. This course is designed for beginners and intermediate users who want to leverage Power Pages to build robust web solutions without extensive coding knowledge.
Overview
COURSE DIFFICULTY
COURSE DURATION
4h 25m
Skills Learned
After completing this online training course, students will be able to:
Apply Excel techniques for data analysis and reporting
Navigate and utilize Microsoft Fabric workspace
Build and manage lakehouses in Fabric
Create data warehouses in Fabric
Data Engineers, SQL Developers, Excel Power Users, Business Analysts
None
01. What You Need to Get Started
02. Introduction
03. What is a Warehouse?
04. What is a Lakehouse?
05. Ingesting Data to Warehouse
06. Connect Warehouse with SSMS
07. Copy Into
08. Cross Warehouse/Lakehouse Queries
09. Schemas, Views, and Stored Procedures
10. T-SQL Limitations in Warehouse
11. Keys and Data Types
12. Time Travel
13. Restore in Place and Closing Tables
14. Spark with Warehouses
15. Warehouse Semantic Models
16. Securing Fabric Warehouses
17. Warehouse Performance
18. Monitoring Fabric Warehouse
19. Class Wrap Up
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Apply Excel techniques for data analysis and reporting
Navigate and utilize Microsoft Fabric workspace
Build and manage lakehouses in Fabric
Create data warehouses in Fabric
WHO SHOULD ATTEND
Data Engineers, SQL Developers, Excel Power Users, Business Analysts
PREREQUISITES
None
COURSE OUTLINE
01. What You Need to Get Started
02. Introduction
03. What is a Warehouse?
04. What is a Lakehouse?
05. Ingesting Data to Warehouse
06. Connect Warehouse with SSMS
07. Copy Into
08. Cross Warehouse/Lakehouse Queries
09. Schemas, Views, and Stored Procedures
10. T-SQL Limitations in Warehouse
11. Keys and Data Types
12. Time Travel
13. Restore in Place and Closing Tables
14. Spark with Warehouses
15. Warehouse Semantic Models
16. Securing Fabric Warehouses
17. Warehouse Performance
18. Monitoring Fabric Warehouse
19. Class Wrap Up
