technifyedWeekly list

Microsoft

Design and implement data modeling with Azure Databricks

via Microsoft Learn

Overview

Learn how to design and implement data modeling strategies in Azure Databricks with Unity Catalog, including ingestion patterns, table formats, partitioning, slowly changing dimensions, and clustering strategies.

Syllabus 14

  1. Introduction 5 minutes
  2. Design ingestion logic and data source configuration 10 minutes
  3. Choose a data ingestion tool 10 minutes
  4. Choose a data table format 10 minutes
  5. Design and implement a data partitioning scheme 10 minutes
  6. Choose a slowly changing dimension (SCD) type 10 minutes
  7. Implement a slowly changing dimension (SCD) type 2 5 minutes
  8. Design and implement a temporal (history) table to record changes over time 5 minutes
  9. Choose granularity on a column or table based on requirements 10 minutes
  10. Choose managed vs external tables 5 minutes
  11. Design and implement a clustering strategy 10 minutes
  12. Exercise - Design and Implement Data Modeling with Azure Databricks 45 minutes
  13. Knowledge check 5 minutes
  14. Summary 5 minutes

Skills you'll practise

Azure Databricks

Advantages and disadvantages

Advantages

  • Free, official and kept up to date by Microsoft.
  • Free sandbox environments for many Azure exercises, no credit card needed.
  • Counts toward Microsoft certification exams (AZ-900, AI-900, PL-300…).
  • From Microsoft, a well-regarded name.
  • Free digital badge you can add to LinkedIn.
  • Completely free.
  • Self-paced: start any time.
  • A clear syllabus (14 parts) you can see before you start.

Disadvantages

  • Mostly reading, not video.
  • Focused on Microsoft products.

Some points apply to every course of this kind; see how we rank.

Free, with a free credential

  • Free: Sign in with any Microsoft account.
  • Badge: Finish it to earn a free badge on your Microsoft Learn profile.

Microsoft is in Tier 2: excellent universities and the companies that build the technology of our institution ranking (86/100).

Similar courses

Compare these

Massachusetts Institute of Technology

MIT 15.S12 Blockchain and Money, Fall 2018

Instructor: Prof. Gary Gensler View the complete course: https://ocw.mit.edu/15-S12F18 This course is for students wishing to explore blockchain technology’s potential use - by entrepreneurs & incumbents - to change the world of money and finance. License: Creative Commons BY-NC-SA More information…

  • Free video
  • 23 videos, 29 hours

Massachusetts Institute of Technology

MIT 6.006 Introduction to Algorithms, Fall 2011

This course provides an introduction to mathematical modeling of computational problems. It covers the common algorithms, algorithmic paradigms, and data structures used to solve these problems. The course emphasizes the relationship between algorithms and programming, and introduces basic performa…

  • Free video
  • 47 videos, 42 hours

Harvard University

CS50's Introduction to Programming with Python (CS50P) 2022

This is CS50P, CS50's Introduction to Programming with Python. Register for free at https://cs50.edx.org/python. Slides and source code at https://cs50.harvard.edu/python. Playlist at https://www.youtube.com/playlist?list=PLhQjrBD2T3817j24-GogXmWqO5Q5vYy0V. An introduction to programming using a la…

  • Free video
  • 11 videos, 16 hours

Harvard University

CS50x 2023 Lectures

This is CS50, Harvard University's introduction to the intellectual enterprises of computer science and the art of programming, for concentrators and non-concentrators alike, with or without prior programming experience. (Two thirds of CS50 students have never taken CS before.) This course teaches…

  • Free video
  • 12 videos, 26 hours

Massachusetts Institute of Technology

MIT 6.100L Introduction to CS and Programming using Python, Fall 2022

Instructor: Ana Bell View the complete course: https://ocw.mit.edu/courses/6-100l-introduction-to-cs-and-programming-using-python-fall-2022/ *Note: Lectures 6, 10 have been updated! This subject is aimed at students with little to no programming experience. It aims to provide students with an under…

  • Free video
  • 26 videos, 28 hours

Stanford University

Stanford Online Courses and Programs

Get more information about the courses and programs we offer. In this playlist you can learn more about course content, pricing, credentials and more!

  • Free video
  • 154 videos, 139 hours