Microsoft Fabric: Introducing Data Warehouses

Microsoft Fabric    |    Beginner
  • 15 videos | 1h 49m 10s
  • Includes Assessment
  • Earns a Badge
What are data warehouses and how do they compare to data lakehouses? What are their key differences and when should you choose each of these storage technologies? In this course, you'll learn the answers to these questions while building hands-on experience. First, learn how warehouses handle structured data through T-SQL queries. Then, get hands-on with data ingestion to a warehouse. Upload data to Azure Data Lakehouse Storage Gen2, ingest it into a Fabric data warehouse using the COPY INTO command, and implement strategies to manage potential errors and maintain data integrity. Finally, dive into advanced data management, running T-SQL queries to perform DDL and DML operations in warehouses. Learn about database mirroring in Fabric, which allows data replication within external storage systems and gain a comprehensive understanding of secure and resilient data workflows in Fabric warehouses. This course is part of a series that prepares learners for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Recall the features of data lakehouses and data warehouses
    Choose power bi datamarts and kusto query language (kql) databases as storage services
    Choose between lakehouses and warehouses in fabric
    List techniques to ingest data into warehouses
    Recall the various operations that can be performed in warehouses
    Upload data into an azure data lake storage gen2 container and create a fabric warehouse
    Create a table in a fabric warehouse and generate a shared access signature (sas) token to load data from an azure storage container
  • Use the copy into command to bulk load data into fabric warehouse tables
    Tolerate errors in bulk load using the maxerrors property and write our error files to azure storage
    Run queries to read data in a fabric data warehouse
    Perform ddl and dml operations on warehouse, ingest data using ctas statements, execute transactions
    Run read queries on fabric lakehouses, show that dml operations are not supported using the sql analytics endpoint
    Replicate data using database mirroring
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 27s
    In this video, you will discover the key concepts covered in this course. FREE ACCESS
  • 11m 57s
    After completing this video, you will be able to recall the features of data lakehouses and data warehouses. FREE ACCESS
  • Locked
    3.  Power BI Datamarts and KQL Databases
    4m 31s
    In this video, find out how to choose Power BI datamarts and Kusto Query Language (KQL) databases as storage services. FREE ACCESS
  • Locked
    4.  Choosing Between Lakehouses and Warehouses
    4m 53s
    In this video, you will learn how to choose between lakehouses and warehouses in Fabric. FREE ACCESS
  • Locked
    5.  Ingesting Data Into Warehouses
    8m 58s
    Upon completion of this video, you will be able to list techniques to ingest data into warehouses. FREE ACCESS
  • Locked
    6.  Transforming, Modeling, Querying, and Visualizing Data
    9m 23s
    In this video, you will learn how to recall the various operations that can be performed in warehouses. FREE ACCESS
  • Locked
    7.  Upload Data to ADLS Gen2 and Create a Data Warehouse
    9m 29s
    Find out how to upload data into an Azure Data Lake Storage Gen2 container and create a Fabric warehouse. FREE ACCESS
  • Locked
    8.  Create a Table and Generate a SAS Token to Load Data
    9m 58s
    During this video, discover how to create a table in a Fabric warehouse and generate a Shared Access Signature (SAS) token to load data from an Azure storage container. FREE ACCESS
  • Locked
    9.  Using COPY INTO to Bulk Load Data in Fabric
    7m 59s
    In this video, find out how to use the COPY INTO command to bulk load data into Fabric warehouse tables. FREE ACCESS
  • Locked
    10.  Tolerating Errors in Bulk Load Using COPY INTO
    5m 50s
    After completing this video, you will be able to tolerate errors in bulk load using the MAXERRORS property and write our error files to Azure storage. FREE ACCESS
  • Locked
    11.  Running T-SQL Queries on Data Warehouses
    7m 30s
    In this video, you will learn how to run queries to read data in a Fabric data warehouse. FREE ACCESS
  • Locked
    12.  Performing DDL and DML Operations on Warehouses
    13m 54s
    In this video, learn how to perform DDL and DML operations on warehouse, ingest data using CTAS statements, and execute transactions. FREE ACCESS
  • Locked
    13.  SQL Queries Supported in a Fabric Warehouse
    7m 21s
    In this video, you will learn how to run read queries on Fabric lakehouses and show that DML operations are not supported using the SQL analytics endpoint. FREE ACCESS
  • Locked
    14.  Database Mirroring in Fabric
    3m 43s
    Find out how to replicate data using database mirroring. FREE ACCESS
  • Locked
    15.  Course Summary
    2m 18s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course CompTIA Data+: Data Acquisition & Cleansing
Rating 4.6 of 13 users Rating 4.6 of 13 users (13)
Book Architecting a Modern Data Warehouse for Large Enterprises: Build Multi-cloud Modern Distributed Data Warehouses with Azure and AWS
Book Mastering Microsoft Fabric: SAASification of Analytics