NEED HELP? TALK TO AN EXPERT (904) 638-5743

Modern Data Warehousing with Azure Databricks

Part Of The On-Demand Courses

WHAT YOU'LL LEARN

  • An understanding of Azure Databricks
  • The fundamentals of creating clusters, developing in notebooks, and leveraging the different languages available
  • How and why Azure Databricks fits perfectly into the design of the “modern” data warehouse
This course includes:

Course Description

The modern data warehouse is capable of ingesting data from various data sources like structured or unstructured data, on-prem data or data in the cloud, and this includes big data. A critical element to making the modern data warehouse applicable is Azure Databricks. Azure Databricks is a managed service built on the backbone of Apache Spark and is capable of not only ingesting data but also preparing and cleaning that data and then loading it. Once the data has been prepared, Databricks can leverage thousands of libraries in Python or R to run predictive analytics and machine learning algorithms. The Modern Data Warehousing with Azure Databricks course is designed to teach the fundamentals of creating clusters, developing in notebooks, and leveraging the different languages available. Specifically, this course is designed to show how and why Azure Databricks fits perfectly into the design of the “modern” data warehouse. Within a single Databricks notebook you can use multiple programming languages and install thousands of libraries extending the capability of what can be achieved.

Outline

 

Module 01 | Course Introduction
149m 59s total

 

Module 01A | Provisioning A Cluster
38m 55s

 

Module 01B | Use Cases
22m 52s

 

Module 01C | Databricks Components Overview
11m 44s

 

Module 01D | Databricks Components Demo
26m 49s

 

Module 01E | Databricks Structure
15m 49s

 

Module 01F | Importing Data
33m 50s

 

Module 02 | Notebooks
109m 15s total

 

Module 02A | Markdown
34m 40s

 

Module 02B | Code Blocks
13m 39s

 

Module 02C | Visualizations
30m 17s

 

Module 02D | Keyboard Shortcuts
16m 51s

 

Module 02E | Dashboards
13m 48s

 

Module 03 | Languages and Libraries
104m 21s total

 

Module 03A | Supported Languages
11m 57s

 

Module 03B | Library Modes
05m 34s

 

Module 03C | Loading Libraries
21m 23s

 

Module 03D | Notebook and Scoped Libraries
17m 32s

 

Module 03E | Importing Notebooks
12m 22s

 

Module 03F | Library Advice
05m 04s

 

Module 03G | Library Management
20m 29s

 

Module 04 | Scheduling Jobs
123m 33s total

 

Module 04A | Scheduling Jobs from Notebooks
19m 35s

 

Module 04B | Scheduling Jobs Outside Notebooks
08m 02s

 

Module 04C | Running Notebooks from ADF
18m 36s

 

Module 04D | Rest APIs
27m 59s

 

Module 04E | Powershell
36m 39s

 

Module 04F | Power BI
12m 42s

 

Module 05 | Administration
105m 38s total

 

Module 05A | Admin Console
27m 04s

 

Module 05B | Table Access Control
26m 46s

 

Module 05C | Databricks Secret API
44m 33s

 

Module 05D | Additional Features
07m 15s

Instructor

MITCHELL PEARSON

Training Content Manager

Mitchell Pearson has been with Pragmatic Works for 8 years as a Data Platform Consultant and the Training Content manager. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform and Microsoft Azure.

 

System Requirements

Microsoft Azure Account (Paid or Trial)

What to Know Before Class

This course assume you have no prior knowledge of Azure Databricks.

REVIEWS

Pending reviews - check back later

Pending reviews - check back later

Pending reviews - check back later

Start With The Free Community Plan

Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses on Power BI, Excel, Power Apps, Azure Synapse, Power Automate, Paginated Reports and Chatbots.

 

Bonus:

• Get preview access to all 70+ courses & custom Learning Paths for 7 days

• Labs and files included

• Access courses from our mobile app or desktop

• Access quizzes to practice while you learn

Get Instant Access Now!