Live registration reopens October 1, 2026, in 13d 10h 37mNotify me

Fundamentals · Recorded class · Taught by Drew Furgiuele

Fundamentals of Python

Learn the new world standard language for data pros.

$195 one payment · recordings through Dec 31, 2026

Buy the recording See what’s inside ↓

One payment, no auto-renew, no refunds. Or get all 10 Fundamentals recordings for $695: Recorded Class Season Pass: Fundamentals →

Cartoon Brent Ozar teaching, mid-gesture

Curriculum · Every lecture

What’s inside

  • About 9 hours
  • 8 sections
  • 33 lectures
  • Taught by Drew Furgiuele

Before the Class

  • Welcome and Class Roadmap 28:20
  • Setting Up Your Environment 8:35
  • Setup: Linux 17:33
  • Setup: Mac 13:47
  • Setup: Windows
  • Setting Up JupyterLab for Notebooks 40:18
  • Download the Slides and Notebooks

Your First Python, Variables, Numbers, and Strings

  • How to Declare Variables and Manipulate Them 42:57
  • Lab: Working with Variables 3:06
  • Lab: Drew Does It 6:45

Data Structures, Lists, Dicts, Sets, and Tuples

  • Working with Data Structures in Python 42:30
  • Lab: Building Lists and Dictionaries 3:30
  • Lab: Drew Does It 10:03

Logical Processing

  • Using If/Then/Else, While, For 9:11
  • Iterables 10:12
  • Functions 6:59
  • Demo: Putting It Together 22:47
  • Lab: Doing Conditional Logic 2:52
  • Lab: Drew Does It 11:16

Extending Python with Packages and Environments

  • Extending Python with Packages 31:38
  • Using Virtual Environments 14:48
  • Lab: Extending Python 1:45
  • Lab: Drew Does It 6:25

Working with Files and Databases

  • Reading and Writing Files 7:29
  • Reading and Writing Files, Demos 35:17
  • Calling APIs from Python 23:04
  • Connecting to Databases with Python 42:49
  • Lab: Working with Files and APIs 6:27
  • Lab: Drew Does It 12:26

Using Data Analysis Tools in Python

  • Pandas Series and DataFrames 65:39
  • Lab: Working with Pandas 6:51
  • Lab: Drew Does It 12:38

Finishing Up

  • Where to Go Next 10:43

This class is included in…

Or get all of them.

4 bundles contain this class. Every one is cheaper than buying its classes one at a time, and the recorded passes are about half.

Recorded bundle · 10 classes

Recorded Class Season Pass: Fundamentals

All 10 Fundamentals classes

Access through Dec 31, 2026. Every class links to its own page and full curriculum.

$1,950 $695 bought separately · save 64%

Get the pass

Recorded bundle · 13 classes

Recorded Class Season Pass: Fundamentals + Mastering

All 13 recordings

Access through Dec 31, 2026. Every class links to its own page and full curriculum.

$4,335 $2,195 bought separately · save 49%

Get the pass

Fundamentals · Live class

Fundamentals Week

Nov 2–6, 2026 · Mon–Fri

Live Fundamentals of Index, Query, and Server Tuning, plus the Recorded Class Season Pass: Fundamentals (all 10 recordings), through Dec 31, 2027.

$1,495 one payment

Registration opens October 1, 2026

Live Class Season Pass 2027

One pass. Every class. All year.

Every live class, every rotation through Feb 2028

Fundamentals Week and all three Mastering classes, live, every rotation through Feb 2028. Plus the Recorded Class Season Pass: Fundamentals + Mastering (all 13 recordings) the minute you buy, and your name in the alumni directory.

$4,395 one payment

Registration opens October 1, 2026

Prerequisites & logistics

The fine print, in regular-size type.

Labs (optional)
Python and JupyterLab on your own machine (Windows, Mac, or Linux); the first section walks through installing them. No SQL Server needed. Labs are optional; the lectures stand on their own.
Access
Recordings through Dec 31, 2026, on training.brentozar.com. One payment, no auto-renew.
Refunds
None. Watch the free previews and read the curriculum above first; that’s what it’s there for.
Purchase orders
Accepted for 10 or more seats; email help@brentozar.com for a quote. Everything else goes through the website by credit card.

Free, 3× a week

3 posts a week, in your inbox

Plus a Monday roundup of my favorite database news from around the web. No fluff, occasional jokes.

Questions first

Not sure this is the one?

Email help@brentozar.com and tell me what’s slow. It’s me answering, and I’d rather sell you the right class than the biggest one.

Email me