Focus on this objective today: Transform and load the data: Create fact tables and dimension tables. Explain it in your own words, apply it to one realistic scenario, and verify the details against the official source. Source context: Read in English Create tables, views, and temporary objects Module 9 Units Feedback Advanced Data Analyst Data Engineer Data Scientist Database Administrator Developer Solution Architect Student Azure SQL Database Azure SQL Managed Instance SQL Server on Azure Virtual Machines Azure SQL Server on Virtual Machines SQL Server Learn how to use Transact-SQL to create tables, views, and temporary objects for your databases. Learning objectives After completing this module, you should be able to: Create and query tables using Transact-SQL Create and query views using Transact-SQL Create queries using Common Table Expressions (CTE) Write queries that use derived tables Add Prerequisites Before starting this module, you should have experience of using Transact-SQL queries to retrieve and filter data from a table in a database. Introduction min Create and query tables min Create and query views min Use temporary tables min Use Common Table Expressions min Write queries that use derived tables min Exercise: Create queries with table expressions min Module assessment min Summary min Take the module assessment Module Assessment Results Assess your understanding of this module.
Objective
Transform and load the data: Create fact tables and dimension tables