1 Welcome to the Course (30.18 MB)
1 Transform Data using Serverless SQL Pool (40.94 MB)
2 Lab - Use CETAS to Transform data (147.39 MB)
3 Lab - Synapse pipeline - Script, ForEach, Stored Proc activities with parameters (158.1 MB)
1 Lake Database Introduction (48.12 MB)
2 Lab - Create Lake Database (129.41 MB)
1 Authentication in Serverless SQL Pool (93.36 MB)
2 Access Control Lists (ACLs) (69.56 MB)
3 RBAC in Serverless SQL Pool (53.45 MB)
1 Spark Architecture (112.73 MB)
2 Lab - Create an Apache Spark Pool (22.77 MB)
3 Spark Documentation (26.39 MB)
1 Lab - Read data into a Dataframe (82.99 MB)
2 Lab - Transformations on Customer data (101.97 MB)
3 Lab - Transformations on Product data (140.11 MB)
4 Lab - Transformations on Monthly data (103.53 MB)
5 Lab - Partitioning data (99.19 MB)
6 Lab - Managed Tables Vs External Tables (98.4 MB)
7 Lab - Magic commands (85.55 MB)
8 Lab - TempViews Vs GlobalTempViews (26.82 MB)
1 Lab - Create Database Objects (84.14 MB)
2 Lab - Transformations for Product data (64.61 MB)
3 Lab - Transformations on Monthly data and Partitioning (59.49 MB)
1 Introduction to Delta Lake (45.02 MB)
2 Lab - Create Delta Tables (69.95 MB)
3 Lab - Update Delta Table (40.8 MB)
4 Lab - Time Travel (73.8 MB)
5 Lab - Create Delta Tables using SQL (39.13 MB)
1 Introduction to Data Lakehouse (48.97 MB)
2 Lab - Preparing Environment for Data Lakehouse (68.11 MB)
3 Lab - Populate Silver Zone (169.1 MB)
4 Lab - Populate Gold Zone (158.1 MB)
5 Lab - Create Synapse ELT Pipeline with Parameterized Notebooks (130.23 MB)
1 End of Course (4.87 MB)
1 Introduction to Databases (13.95 MB)
10 Lab - CASE Statement (41.45 MB)
11 Lab - Aggregations in SQL (33.28 MB)
12 Lab - GROUP BY Statement (74.17 MB)
13 Lab - HAVING Statement (32.56 MB)
14 Lab - JOINS in SQL (89.95 MB)
15 Lab - Sub Queries (37.19 MB)
16 Lab - PARTITION BY Statement (51.58 MB)
17 Lab - Create Table using an Existing Table (27.16 MB)
18 Lab - CREATE TABLE and INSERT INTO (40.24 MB)
19 SQL INDEX - Introduction (5.15 MB)
2 OLTP vs OLAP (19.35 MB)
20 Lab - Clustered Index (98.02 MB)
21 Lab - Non-Clustered Index (18.79 MB)
22 Primary key Vs Foreign key (23.47 MB)
23 Dimension Tables and Fact Tables (31.56 MB)
3 Azure Free Account (2.96 MB)
5 Lab - Create Azure SQL Database in Azure Cloud (78.31 MB)
6 Lab - SELECT Statement (44.32 MB)
7 Lab - WHERE Statement (24.87 MB)
8 Lab - ORDER BY Statement (17.09 MB)
9 Lab - ORDER BY Statement (67.92 MB)
1 Introduction to Azure Synapse Analytics (57.91 MB)
3 Lab - Create a Synapse Analytics Workspace (54.39 MB)
4 Lab - Tour in Azure Synapse Analytics (111.57 MB)
1 Introduction to Dedicated SQL Pool (3.94 MB)
1 Data Warehousing and ETL (95.01 MB)
10 Create and Load Staging Tables (42.48 MB)
11 Slowly Changing Dimensions (58.29 MB)
12 Loading Dimension Tables (37.5 MB)
13 Loading Fact Tables and Post Load Optimization (69.26 MB)
2 MPP Architecture of Dedicated SQL Pool (25.67 MB)
3 Distributions in Tables of Dedicated SQL Pool (91.62 MB)
4 Indexing of Tables of the Dedicated SQL Pool (83.75 MB)
5 Lab - Create Dedicated SQL Pool (24.83 MB)
6 Lab - Create Azure SQL DB (57.57 MB)
7 Lab - Popoulate Dedicated SQL pool using Synapse Link (190.4 MB)
8 Lab - Explore Dedicated SQL Pool (27.4 MB)
9 Data Loading Process (ETL) in Dedicated SQL Pool (12.27 MB)
1 Table Partitioning (51 MB)
10 EXPLAIN WITH RECOMMENDATIONS (27.73 MB)
11 Workload Management (43.06 MB)
12 Lab - Workload Management (149.09 MB)
2 Lab - Create a partitioned Table (42.96 MB)
3 Partition splitting and switching (14.2 MB)
4 Partition splitting and switching Example Overview (128.6 MB)
5 Lab-Partition splitting and switching example (125.8 MB)
6 Dynamic Management Views (18.72 MB)
7 Identify Connection Information and activity (28.17 MB)
8 Identify and troubleshoot query performance (50.66 MB)
9 Materialized Views (26.11 MB)
1 Conditional Access (24.39 MB)
2 Dynamic Data Masking (25.42 MB)
3 Lab - Dynamic Data Masking (121.08 MB)
4 Lab - Column Level Security (49.96 MB)
5 Lab - Row Level Security (84.95 MB)
6 Lab - Transparent Data Encryption (26.53 MB)
1 Introduction to Serverless SQL Pool (27.86 MB)
1 The OPENROWSET Function (26.5 MB)
2 Lab - Querying different file formats from Serverless SQL Pool (103.15 MB)
4 Create External Objects in Serverless SQL Pool (25.12 MB)
5 Lab - Create External Objects in Serverless SQL Pool (90.04 MB)