Azure Data Fundamentals: Modern Data Warehousing

IN THIS COURSE

• 1.  Course Overview
  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
• 2.  Modern Data Warehousing
  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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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