Azure Data Fundamentals: Modern Data Warehousing

Azure    |    Intermediate
  • 11 videos | 1h 7m 48s
  • Includes Assessment
  • Earns a Badge
Rating 4.3 of 63 users Rating 4.3 of 63 users (63)
Modern data warehousing lets you bring your data together at any scale and provide insights through analytics. This course, you'll learn about the components of a modern data warehouse and its architecture and how it can benefit your organization. You'll start by learning about modern data warehousing, and then the data warehousing architecture. You'll then learn about Azure Data Factory, Azure Data Lake, and Azure Databricks. You'll then go on to explore Azure Analysis Services and Azure HDInsights. Finally, you'll discover Azure Distributed Data Engineering Toolkit. This course is one in a series that prepares learners for the Microsoft Azure Data Fundamentals (DP-900) exam.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Describe modern data warehousing
    Describe benefits of modern data warehousing
    Describe modern data warehousing architecture
    Describe azure data factory
    Describe azure data lake
  • Describe azure databricks
    Describe azure analysis services
    Describe azure hdinsights
    Describe the distributed data engineering toolkit
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 35s
    In this video, you’ll learn more about your instructor and the course. In this course, you’ll learn the components of a modern data warehouse and its architecture. You’ll discover Azure Data Factory, Azure Data Lake. Azure Data Bricks, Azure Analysis Services, and Azure HDInsights. Finally, you’ll learn more about the Azure Distributed Data Engineering Toolkit. FREE ACCESS
  • 11m 5s
    In this video, you'll learn how to effectively describe Modern Data Warehousing. You'll learn that a data warehouse is a place where a large portion of data is stored in an easily accessible environment and format for analysts and others to use. FREE ACCESS
  • Locked
    3.  Benefits of Data Warehousing
    4m 20s
    In this video, you'll describe the benefits of modern data warehouseing. A data warehouse provides a permanent storage space for the data needed to support reporting, analysis, and other business intelligence functions. With data warehouses, there's no need to make business decisions based on limited data or old data. Additionally, you'll learn about how data warehouses and related business intelligence can be applied directly to business processes. FREE ACCESS
  • Locked
    4.  Modern Data Warehousing Architecture
    6m 13s
    Modern data warehousing lets you bring your data together at any scale and provide insights through analytics. In this video, you'll learn how to describe Modern Data Warehousing Architecture, and how it provides insights through analytical dashboards, operational reports, or advanced analytics for all users. You can combine all structured and unstructured data using Azure Data Factory and put it in Azure blob storage. Once it's in Azure blob storage, it can be leveraged to perform scalable analytics with Azure Data Bricks. FREE ACCESS
  • Locked
    5.  Azure Data Factory
    7m 3s
    In this video, you'll learn how to describe Azure Data Factory, and how it's functions. Azure Data Factory is a data migration and integration service that enables Microsoft Azure users to bring together data from a variety of sources in the Azure Public Cloud. It llows users to integrate both on-premise data in Microsoft SQL server, as well as cloud data in Azure SQL database, Azure Blob Storage, and Azure Table Storage. FREE ACCESS
  • Locked
    6.  Azure Data Lake
    4m 55s
    In this video, you'll learn more about Azure Data Lake Storage Generation 2. Azure Data Lake Storage Gen2 is Microsoft's latest version of cloud-based big data storage. Data Lake Storage Gen2 builds on blob storage and enhances performance, management, and security. It optimizes performance and management is easier because you can organize and manipulate files through directories and subdirectories. FREE ACCESS
  • Locked
    7.  Azure Databricks
    9m 8s
    In this video, you’ll learn more about Azure Databricks Environment. Databricks is an industry-leading cloud-based data engineering tool used for processing and transforming massive quantities of data and exploring that data through machine learning model. You’ll also learn about the Azure Databricks SQL Analytics. It provides an easy-to-use platform for analysts who want to run SQL queries on their data lake FREE ACCESS
  • Locked
    8.  Azure Analysis Services
    8m 49s
    In this video, you'll learn how to describe Azure Analysis Services. This is a fully managed platform as a service that provides enterprise-grade data models in the cloud. The data model provides an easier way for users to perform ad hoc data analysis using tools like Power BI and Microsoft Excel. FREE ACCESS
  • Locked
    9.  Azure HDInsight
    10m 5s
    In this video, you'll learn more about Azure HDInsight. Azure HDInsight is a managed full-spectrum open-source analytics service that provides fast, easy and cost-effective ways to process massive amounts of data. You can use open-source frameworks like Hadoop, Spark, Hive, LLAP, Kafka, Storm, R, and more. You'll learn these frameworks enable a broad range of scenarios such as extract, transform, and load, data warehousing, machine learning, and IoT. FREE ACCESS
  • Locked
    10.  Azure Distributed Data Engineering Toolkit
    4m 1s
    In this video, you'll learn how to describe the Azure Distributed Data Engineering Toolkit. The AZTK is used for provisioning on-demand Spark on your Docker clusters. It's a client-sided tool with a command-line interface and a Python SDK interface that's built on Azure Batch. You'll learn about how this gives you the most control over the infrastructure when deploying a Spark cluster. FREE ACCESS
  • Locked
    11.  Course Summary
    36s
    In this video, you’ll summarize what you’ve learned in this course. In this course, you’ve learned the components of a Modern Data Warehouse. You explored Modern data warehouse architecture, Azure Data Factory, Data Lake and Databricks, Azure Analysis Service, HDInsight, and the Distributed Data Engineering Toolkit. 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

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 161 users Rating 4.6 of 161 users (161)
Rating 4.4 of 186 users Rating 4.4 of 186 users (186)
Rating 4.6 of 15 users Rating 4.6 of 15 users (15)