001 IMPORTANT - How we are going to approach the exam objectives.mp4 (20.01 MB)
MP4
002 OPTIONAL - Overview of Azure.mp4 (10.77 MB)
MP4
003 OPTIONAL - Concepts in Azure.mp4 (20.26 MB)
MP4
004 Azure Free Account.mp4 (39.75 MB)
MP4
005 Creating an Azure Free Account.mp4 (30.88 MB)
MP4
006 OPTIONAL - Quick tour of the Azure Portal.mp4 (40.97 MB)
MP4
001 Section Introduction.mp4 (47.26 MB)
MP4
002 Understanding data.mp4 (24.15 MB)
MP4
003 Example of data storage.mp4 (8.36 MB)
MP4
004 Lab - Azure Storage accounts.mp4 (31.64 MB)
MP4
005 Lab - Azure SQL databases.mp4 (81.31 MB)
MP4
006 A quick note when it comes to the Azure Free Account.mp4 (26.06 MB)
MP4
007 Lab - Application connecting to Azure Storage and SQL database.mp4 (66.48 MB)
MP4
008 OPTIONAL - Installing Visual Studio 2019.mp4 (15.78 MB)
MP4
010 Different file formats.mp4 (55.89 MB)
MP4
011 Azure Data Lake Gen-2 storage accounts.mp4 (18 MB)
MP4
012 Lab - Creating an Azure Data Lake Gen-2 storage account.mp4 (63.22 MB)
MP4
013 Using PowerBI to view your data.mp4 (65.96 MB)
MP4
014 Lab - Authorizing to Azure Data Lake Gen 2 - Access Keys - Storage Explorer.mp4 (32.77 MB)
MP4
015 Lab - Authorizing to Azure Data Lake Gen 2 - Shared Access Signatures.mp4 (45.6 MB)
MP4
016 Azure Storage Account - Redundancy.mp4 (63.3 MB)
MP4
017 Azure Storage Account - Access tiers.mp4 (52.49 MB)
MP4
018 Azure Storage Account - Lifecycle policy.mp4 (19.97 MB)
MP4
019 Note on Costing.mp4 (37.09 MB)
MP4
001 Section Introduction.mp4 (46.8 MB)
MP4
002 The internals of a database engine.mp4 (13.88 MB)
MP4
003 Lab - Setting up a new Azure SQL database.mp4 (18.25 MB)
MP4
005 Lab - T-SQL - SELECT clause.mp4 (17.38 MB)
MP4
006 Lab - T-SQL - WHERE clause.mp4 (17.97 MB)
MP4
007 Lab - T-SQL - ORDER BY clause.mp4 (8.27 MB)
MP4
008 Lab - T-SQL - Aggregate Functions.mp4 (9.35 MB)
MP4
009 Lab - T-SQL - GROUP BY clause.mp4 (20.88 MB)
MP4
010 Lab - T-SQL - HAVING clause.mp4 (4.1 MB)
MP4
011 Quick Review on Primary and Foreign Keys.mp4 (21.21 MB)
MP4
012 Lab - T-SQL - Creating Tables with Keys.mp4 (30.58 MB)
MP4
013 Lab - T-SQL - Table Joins.mp4 (34.38 MB)
MP4
001 Section Introduction.mp4 (33.81 MB)
MP4
003 Why do we need a data warehouse.mp4 (44.37 MB)
MP4
004 Welcome to Azure Synapse Analytics.mp4 (8.19 MB)
MP4
005 Lab - Let's create a Azure Synapse workspace.mp4 (23.09 MB)
MP4
006 Azure Synapse - Compute options.mp4 (20.77 MB)
MP4
007 Using External tables.mp4 (18.89 MB)
MP4
008 Lab - Using External tables - Part 1.mp4 (81.4 MB)
MP4
009 Lab - Using External tables - Part 2.mp4 (93.6 MB)
MP4
010 Lab - Creating a SQL pool.mp4 (49.44 MB)
MP4
011 Lab - SQL Pool - External Tables - CSV.mp4 (76 MB)
MP4
012 Data Cleansing.mp4 (17.51 MB)
MP4
013 Lab - SQL Pool - External Tables - CSV with formatted data.mp4 (26.84 MB)
MP4
014 Lab - SQL Pool - External Tables - Parquet - Part 1.mp4 (34.53 MB)
MP4
015 Lab - SQL Pool - External Tables - Parquet - Part 2.mp4 (75.04 MB)
MP4
016 Loading data into the Dedicated SQL Pool.mp4 (8.03 MB)
MP4
017 Lab - Loading data into a table - COPY Command - CSV.mp4 (88.26 MB)
MP4
018 Lab - Loading data into a table - COPY Command - Parquet.mp4 (24.55 MB)
MP4
019 Pausing the Dedicated SQL pool.mp4 (28.76 MB)
MP4
020 Lab - Loading data using PolyBase.mp4 (36.63 MB)
MP4
021 Lab - BULK INSERT from Azure Synapse.mp4 (36.93 MB)
MP4
022 My own experience.mp4 (42.3 MB)
MP4
023 Designing a data warehouse.mp4 (54.23 MB)
MP4
024 More on dimension tables.mp4 (25.95 MB)
MP4
025 Lab - Building a data warehouse - Setting up the database.mp4 (39.19 MB)
MP4
026 Lab - Building a Fact Table.mp4 (64.69 MB)
MP4
027 Lab - Building a dimension table.mp4 (51.27 MB)
MP4
028 Lab - Transfer data to our SQL Pool.mp4 (97.62 MB)
MP4
029 Other points in the copy activity.mp4 (11.81 MB)
MP4
030 Lab - Using Power BI for Star Schema.mp4 (35.99 MB)
MP4
031 Understanding Azure Synapse Architecture.mp4 (36.22 MB)
MP4
032 Understanding table types.mp4 (37.57 MB)
MP4
033 Understanding Round-Robin tables.mp4 (32.88 MB)
MP4
034 Lab - Creating Hash-distributed Tables.mp4 (37.16 MB)
MP4
035 Note on creating replicated tables.mp4 (9.73 MB)
MP4
036 Designing your tables.mp4 (18.32 MB)
MP4
037 Designing tables - Review.mp4 (19.35 MB)
MP4
038 Lab - Example when using the right distributions for your tables.mp4 (75.32 MB)
MP4
039 Points on tables in Azure Synapse.mp4 (10.57 MB)
MP4
040 Lab - Windowing Functions.mp4 (26.8 MB)
MP4
041 Lab - Reading JSON files.mp4 (43.24 MB)
MP4
042 Lab - Surrogate keys for dimension tables.mp4 (44.51 MB)
MP4
043 Slowly Changing dimensions.mp4 (21.08 MB)
MP4
044 Type 3 Slowly Dimension dimension.mp4 (6.53 MB)
MP4
045 Creating a heap table.mp4 (16.56 MB)
MP4
046 Snowflake schema.mp4 (3.69 MB)
MP4
047 Lab - CASE statement.mp4 (39.37 MB)
MP4
048 Partitions in Azure Synapse.mp4 (7.43 MB)
MP4
049 Lab - Creating a table with partitions.mp4 (74.33 MB)
MP4
050 Lab - Switching partitions.mp4 (43.21 MB)
MP4
051 Indexes.mp4 (35.63 MB)
MP4
052 Quick Note - Modern Data Warehouse Architecture.mp4 (6.94 MB)
MP4
053 Quick Note on what we are taking forward to the next sections.mp4 (10.74 MB)
MP4
054 What about the Spark Pool.mp4 (33.23 MB)
MP4
001 Section Introduction.mp4 (18.55 MB)
MP4
003 Extract, Transform and Load.mp4 (12.62 MB)
MP4
004 What is Azure Data Factory.mp4 (22.37 MB)
MP4
005 Starting with Azure Data Factory.mp4 (11.05 MB)
MP4
006 Lab - Azure Data Lake to Azure Synapse - Log csv file.mp4 (81.79 MB)
MP4
007 Lab - Azure Data Lake to Azure Synapse - Parquet files.mp4 (83.67 MB)
MP4
008 Review on what has been done so far.mp4 (28.56 MB)
MP4
009 Lab - Generating a Parquet file.mp4 (34.36 MB)
MP4
010 Lab - What about using a query for data transfer.mp4 (38.51 MB)
MP4
011 Deleting artefacts in Azure Data Factory.mp4 (23.21 MB)
MP4
012 Mapping Data Flow.mp4 (23.23 MB)
MP4
013 Lab - Mapping Data Flow - Fact Table.mp4 (101.33 MB)
MP4
014 Lab - Mapping Data Flow - Dimension Table - DimCustomer.mp4 (104.17 MB)
MP4
015 Lab - Mapping Data Flow - Dimension Table - DimProduct.mp4 (85.39 MB)
MP4
016 Lab - Surrogate Keys - Dimension tables.mp4 (27.59 MB)
MP4
017 Lab - Using Cache sink.mp4 (61.84 MB)
MP4
018 Lab - Handling Duplicate rows.mp4 (53.57 MB)
MP4
019 Note - What happens if we don't have any data in our DimProduct table.mp4 (25.04 MB)
MP4
020 Changing connection details.mp4 (5.25 MB)
MP4
021 Lab - Changing the Time column data in our Log csv file.mp4 (62.88 MB)
MP4
022 Lab - Convert Parquet to JSON.mp4 (35.5 MB)
MP4
023 Lab - Loading JSON into SQL Pool.mp4 (39.24 MB)
MP4
024 Self-Hosted Integration Runtime.mp4 (13.84 MB)
MP4
025 Lab - Self-Hosted Runtime - Setting up nginx.mp4 (56.7 MB)
MP4
026 Lab - Self-Hosted Runtime - Setting up the runtime.mp4 (43.01 MB)
MP4
027 Lab - Self-Hosted Runtime - Copy Activity.mp4 (44.42 MB)
MP4
028 Lab - Self-Hosted Runtime - Mapping Data Flow.mp4 (103.83 MB)
MP4
029 Lab - Processing JSON Arrays.mp4 (55.29 MB)
MP4
030 Lab - Processing JSON Objects.mp4 (40.61 MB)
MP4
031 Lab - Conditional Split.mp4 (54.19 MB)
MP4
032 Lab - Schema Drift.mp4 (80.84 MB)
MP4
033 Lab - Metadata activity.mp4 (97.86 MB)
MP4
034 Lab - Azure DevOps - Git configuration.mp4 (65.88 MB)
MP4
035 Lab - Azure DevOps - Release configuration.mp4 (68.46 MB)
MP4
036 What resources are we taking forward.mp4 (6.38 MB)
MP4
002 Batch and Real-Time Processing.mp4 (27.98 MB)
MP4
003 What are Azure Event Hubs.mp4 (24.96 MB)
MP4
004 Lab - Creating an instance of Event hub.mp4 (40.84 MB)
MP4
005 Lab - Sending and Receiving Events.mp4 (70.68 MB)
MP4
006 What is Azure Stream Analytics.mp4 (9.11 MB)
MP4
007 Lab - Creating a Stream Analytics job.mp4 (18.36 MB)
MP4
008 Lab - Azure Stream Analytics - Defining the job.mp4 (59.05 MB)
MP4
009 Review on what we have seen so far.mp4 (45.84 MB)
MP4
010 Lab - Reading database diagnostic data - Setup.mp4 (23.22 MB)
MP4
011 Lab - Reading data from a JSON file - Setup.mp4 (50.77 MB)
MP4
012 Lab - Reading data from a JSON file - Implementation.mp4 (39.81 MB)
MP4
013 Lab - Reading data from the Event Hub - Setup.mp4 (46.34 MB)
MP4
014 Lab - Reading data from the Event Hub - Implementation.mp4 (57.51 MB)
MP4
015 Lab - Timing windows.mp4 (75.42 MB)
MP4
016 Lab - Adding multiple outputs.mp4 (30.09 MB)
MP4
017 Lab - Reference data.mp4 (36.8 MB)
MP4
018 Lab - OVER clause.mp4 (43.11 MB)
MP4
019 Lab - Power BI Output.mp4 (64.72 MB)
MP4
020 Lab - Reading Network Security Group Logs - Server Setup.mp4 (22.51 MB)
MP4
021 Lab - Reading Network Security Group Logs - Enabling NSG Flow Logs.mp4 (69.5 MB)
MP4
022 Lab - Reading Network Security Group Logs - Processing the data.mp4 (101.07 MB)
MP4
023 Lab - User Defined Functions.mp4 (64.32 MB)
MP4
024 Custom Serialization Formats.mp4 (25.58 MB)
MP4
025 Lab - Azure Event Hubs - Capture Feature.mp4 (41.29 MB)
MP4
026 Lab - Azure Data Factory - Incremental Data Copy.mp4 (70.74 MB)
MP4
027 Demo on Azure IoT Devkit.mp4 (40.93 MB)
MP4
028 What resources are we taking forward.mp4 (4.57 MB)
MP4
001 Section Introduction.mp4 (42.1 MB)
MP4
003 Introduction to Scala.mp4 (4.76 MB)
MP4
004 Installing Scala.mp4 (43.7 MB)
MP4
005 Scala - Playing with values.mp4 (8.76 MB)
MP4
006 Scala - Installing IntelliJ IDE.mp4 (29.32 MB)
MP4
007 Scala - If construct.mp4 (16.37 MB)
MP4
008 Scala - for construct.mp4 (6.41 MB)
MP4
009 Scala - while construct.mp4 (5.31 MB)
MP4
010 Scala - case construct.mp4 (3.63 MB)
MP4
011 Scala - Functions.mp4 (6.41 MB)
MP4
012 Scala - List collection.mp4 (24.41 MB)
MP4
013 Starting with Python.mp4 (16.01 MB)
MP4
014 Python - A simple program.mp4 (7.54 MB)
MP4
015 Python - If construct.mp4 (4.58 MB)
MP4
016 Python - while construct.mp4 (3.76 MB)
MP4
017 Python - List collection.mp4 (9.64 MB)
MP4
018 Python - Functions.mp4 (11.35 MB)
MP4
019 Quick look at Jupyter Notebook.mp4 (19.91 MB)
MP4
020 Lab - Azure Synapse - Creating a Spark pool.mp4 (44.33 MB)
MP4
021 Lab - Spark Pool - Starting out with Notebooks.mp4 (61.63 MB)
MP4
022 Lab - Spark Pool - Spark DataFrames.mp4 (19.23 MB)
MP4
023 Lab - Spark Pool - Sorting data.mp4 (39.71 MB)
MP4
024 Lab - Spark Pool - Load data.mp4 (69.66 MB)
MP4
025 Lab - Spark Pool - Removing NULL values.mp4 (65.93 MB)
MP4
026 Lab - Spark Pool - Using SQL statements.mp4 (25.21 MB)
MP4
027 Lab - Spark Pool - Write data to Azure Synapse.mp4 (102.68 MB)
MP4
028 Spark Pool - Combined Power.mp4 (7.23 MB)
MP4
029 Lab - Spark Pool - Sharing tables.mp4 (26.9 MB)
MP4
030 Lab - Spark Pool - Creating tables.mp4 (38.34 MB)
MP4
031 Lab - Spark Pool - JSON files.mp4 (47.15 MB)
MP4
002 What is Azure Databricks.mp4 (17.52 MB)
MP4
003 Clusters in Azure Databricks.mp4 (30.13 MB)
MP4
004 Lab - Creating a workspace.mp4 (18.75 MB)
MP4
005 Lab - Creating a cluster.mp4 (78.27 MB)
MP4
006 Lab - Simple notebook.mp4 (13.92 MB)
MP4
007 Lab - Using DataFrames.mp4 (29.41 MB)
MP4
008 Lab - Reading a CSV file.mp4 (27.5 MB)
MP4
009 Databricks File System.mp4 (11.67 MB)
MP4
010 Lab - The SQL Data Frame.mp4 (22.35 MB)
MP4
011 Visualizations.mp4 (9.34 MB)
MP4
012 Lab - Few functions on dates.mp4 (18.62 MB)
MP4
013 Lab - Filtering on NULL values.mp4 (18.66 MB)
MP4
014 Lab - Parquet-based files.mp4 (13.02 MB)
MP4
015 Lab - JSON-based files.mp4 (23.17 MB)
MP4
016 Lab - Structured Streaming - Let's first understand our data.mp4 (24.13 MB)
MP4
017 Lab - Structured Streaming - Streaming from Azure Event Hubs - Initial steps.mp4 (59.16 MB)
MP4
018 Lab - Structured Streaming - Streaming from Azure Event Hubs - Implementation.mp4 (83.76 MB)
MP4
019 Lab - Getting data from Azure Data Lake - Setup.mp4 (49.28 MB)
MP4
020 Lab - Getting data from Azure Data Lake - Implementation.mp4 (29.51 MB)
MP4
021 Lab - Writing data to Azure Synapse SQL Dedicated Pool.mp4 (44.74 MB)
MP4
022 Lab - Stream and write to Azure Synapse SQL Dedicated Pool.mp4 (42.68 MB)
MP4
023 Lab - Azure Data Lake Storage Credential Passthrough.mp4 (64.67 MB)
MP4
024 Lab - Running an automated job.mp4 (38.54 MB)
MP4
025 Autoscaling a cluster.mp4 (7.26 MB)
MP4
026 Lab - Removing duplicate rows.mp4 (25.83 MB)
MP4
027 Lab - Using the PIVOT command.mp4 (39.45 MB)
MP4
028 Lab - Azure Databricks Table.mp4 (33.34 MB)
MP4
029 Lab - Azure Data Factory - Running a notebook.mp4 (43.25 MB)
MP4
030 Delta Lake Introduction.mp4 (8.07 MB)
MP4
031 Lab - Creating a Delta Table.mp4 (42.63 MB)
MP4
032 Lab - Streaming data into the table.mp4 (29.04 MB)
MP4
033 Lab - Time Travel.mp4 (15.74 MB)
MP4
034 Quick note on the deciding between Azure Synapse and Azure Databricks.mp4 (14.01 MB)
MP4
035 What resources are we taking forward.mp4 (3.12 MB)
MP4
001 Section Introduction.mp4 (17.55 MB)
MP4
003 What is the Azure Key Vault service.mp4 (18.97 MB)
MP4
004 Azure Data Factory - Encryption.mp4 (31.62 MB)
MP4
005 Azure Synapse - Customer Managed Keys.mp4 (18.69 MB)
MP4
006 Azure Dedicated SQL Pool - Transparent Data Encryption.mp4 (21.75 MB)
MP4
007 Lab - Azure Synapse - Data Masking.mp4 (70.27 MB)
MP4
008 Lab - Azure Synapse - Auditing.mp4 (40.1 MB)
MP4
009 Azure Synapse - Data Discovery and Classification.mp4 (23.87 MB)
MP4
010 Azure Synapse - Azure AD Authentication.mp4 (9.78 MB)
MP4
011 Lab - Azure Synapse - Azure AD Authentication - Setting the admin.mp4 (24.75 MB)
MP4
012 Lab - Azure Synapse - Azure AD Authentication - Creating a user.mp4 (45.13 MB)
MP4
013 Lab - Azure Synapse - Row-Level Security.mp4 (57.26 MB)
MP4
014 Lab - Azure Synapse - Column-Level Security.mp4 (28.07 MB)
MP4
015 Lab - Azure Data Lake - Role Based Access Control.mp4 (49.64 MB)
MP4
016 Lab - Azure Data Lake - Access Control Lists.mp4 (39.1 MB)
MP4
017 Lab - Azure Synapse - External Tables Authorization via Managed Identity.mp4 (55.74 MB)
MP4
018 Lab - Azure Synapse - External Tables Authorization via Azure AD Authentication.mp4 (43.97 MB)
MP4
019 Lab - Azure Synapse - Firewall.mp4 (41.13 MB)
MP4
020 Lab - Azure Data Lake - Virtual Network Service Endpoint.mp4 (46.38 MB)
MP4
021 Lab - Azure Data Lake - Managed Identity - Data Factory.mp4 (45.99 MB)
MP4
002 Best practices for structing files in your data lake.mp4 (13.99 MB)
MP4
003 Azure Storage accounts - Query acceleration.mp4 (23.4 MB)
MP4
004 View on Azure Monitor.mp4 (44.42 MB)
MP4
005 Azure Monitor - Alerts.mp4 (54.1 MB)
MP4
006 Azure Synapse - System Views.mp4 (16.55 MB)
MP4
007 Azure Synapse - Result set caching.mp4 (39.13 MB)
MP4
008 Azure Synapse - Workload Management.mp4 (25.4 MB)
MP4
009 Azure Synapse - Retention points.mp4 (13.42 MB)
MP4
010 Lab - Azure Data Factory - Monitoring.mp4 (51.19 MB)
MP4
011 Azure Data Factory - Monitoring - Alerts and Metrics.mp4 (27.85 MB)
MP4
012 Lab - Azure Data Factory - Annotations.mp4 (16.41 MB)
MP4
013 Azure Data Factory - Integration Runtime - Note.mp4 (43.16 MB)
MP4
014 Azure Data Factory - Pipeline Failures.mp4 (20.6 MB)
MP4
015 Azure Key Vault - High Availability.mp4 (9.91 MB)
MP4
016 Azure Stream Analytics - Metrics.mp4 (14.29 MB)
MP4
017 Azure Stream Analytics - Streaming Units.mp4 (9.16 MB)
MP4
018 Azure Stream Analytics - An example on monitoring the stream analytics job.mp4 (80.4 MB)
MP4
019 Azure Stream Analytics - The importance of time.mp4 (37.11 MB)
MP4
020 Azure Stream Analytics - More on the time aspect.mp4 (36.63 MB)
MP4
021 Azure Event Hubs and Stream Analytics - Partitions.mp4 (23.79 MB)
MP4
022 Azure Stream Analytics - An example on multiple partitions.mp4 (50.02 MB)
MP4
023 Azure Stream Analytics - More on partitions.mp4 (22.26 MB)
MP4
024 Azure Stream Analytics - An example on diagnosing errors.mp4 (32.2 MB)
MP4
025 Azure Stream Analytics - Diagnostics setting.mp4 (44.43 MB)
MP4
026 Azure Databricks - Monitoring.mp4 (49.44 MB)
MP4
027 Azure Databricks - Sending logs to Azure Monitor.mp4 (27.4 MB)
MP4
028 Azure Event Hubs - High Availability.mp4 (35.83 MB)
MP4