Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Practical SQL With Python In 3 Days: Beginner to Pro

Name: Practical SQL With Python In 3 Days: Beginner to Pro
Rating: 4.4 (94 reviews)

Build 3 Python Projects In 3 Days Using SQLite, MySQL, and PostgreSQL

Created byAndy Bek

Last updated 1/2026

English

What you'll learn

Work with SQL databases confidently in python applications
Build and deploy a web-based API using FastAPI and PostgreSQL
Understand cursors, transactions, connections, and query execution in depth
Explore more advanced topics around dynamic SQL generation, prepared statements, and non-tuple cursors

Course content

5 sections • 201 lectures • 17h 2m total length

2-min Introduction2:22
All Course Resources - Lectures + Project Challenges0:04

Section Overview0:39
Lecture Resources0:03
Introduction to SQLIite2:31
sqlite3 In Python4:16
DBAPI 2.02:57
Connections And Cursors7:07
Inserts3:13
DML vs DDL (and DCL and DQL)3:42
Fetching7:27
Show how to fetch data from a database using a cursor with fetch one, fetch many, and fetch all, including iteration, stop iteration handling, and lazy evaluation.
Column Names Would Be Nice11:22
The Transaction Lifecycle3:48
Parameterized Statements7:46
A Different Flavor3:00
Various Ways To Execute7:26
Database Dump6:03
Context Managed Connections4:58
Let's Build!1:28
Project Resources - All Solution Challenges0:11
Creating A Virtual Environment4:35
Challenge 1 - Interface1:34
The Interface5:46
Sketching Out The Basics1:52
Challenge 2 - DDL0:45
Executing the DDL9:48
Foreign Key Gotcha3:13
The Add Box Menu7:12
Challenge 3 - Add Box To Database0:39
Add Box Helper5:53
Challenge 4 - Displaying Box Types1:49
Displaying All Boxes5:55
A Prettier Display4:11
Challenge 5 - Loading Boxes With Validation2:08
Load Box Menu10:53
The Containers Database View5:55
Container Constraints8:36
The Final Stretch5:31
Quick Note0:14
Challenge 6 - Seed Data0:37
Seeding Some Boxes4:41
Challenge 7 - Containers0:32
Displaying Containers4:25
Business Summary2:22
The Bottom Line13:02
Challenge 9 - Configurable Constants1:41
Refactoring Configuration11:10

Section Overview0:42
Extend database skills by starting with MySQL, building on SQLite concepts like connections, cursors, and transactions, and explore MySQL connector nuances, cursor types, and repair statements.
Lecture Resources0:05
Welcome To MySQL2:59
Local Vs Cloud MySQL4:54
Connecting From Python5:20
URL Parsing4:14
Cursors Again6:16
Context Managers Revisited8:33
Parameterized Inserts4:16
Prepared Statements5:58
Let's Fetch4:04
Buffering3:07
Dict Cursors3:32
A Named Alternative4:23
Learn to use the name tuple cursor to access fields by name or position, switch from dictionary cursor, create a name tuple type like user, and embrace its immutable structure.
.executescript() Please?9:46
Best: Multi With Autocommit11:23
Let's Build!2:17
Project Resources - All Challenge Solutions0:15
Setting Up1:18
The Interface8:54
Challenge 1 - Connection Helper0:25
Writing The Helper8:33
Challenge 2 - Prepare The DDL1:25
Wiring Up The DDL9:11
Challenge 3 - The Reset Command0:57
Resetting The Database5:14
Challenge 4 - Add Student0:39
Adding New Students7:22
Challenge 5 - Add Course0:37
Adding New Courses3:24
Challenge 6 - Prerequisites2:13
Prereq DDL And Command10:51
Define the prereq data model with a prerequisites table linked by foreign keys to the courses table, enforce a 0–100 grade check, and implement add prereq command in the interface.
Addressing A Small Inconsistency4:12
Challenge 7 - Querying2:15
The Query Helper8:09
Challenge 8 - Seeding Data2:25
Initializing Data13:19
—no-with-data2:33
Challenge 9 - Show Prerequisites For Course1:12
Displaying Prereqs4:56
Pretty Tables9:14
Challenge 10 - Show Students And Courses1:36
Displaying Students And Courses8:09
Challenge 11 - Course Enrollment Part I2:31
Add a student_course enrollment table with foreign keys to students and courses, capturing year and grade, validating grade 0–100, enforcing unique yearly enrollments, and enabling enroll command with a UI.
Naive Enrollment10:29
Challenge 12 - Grading1:46
The Grade Command4:15
Challenge 13 - Course Enrollment Part II0:55
Prereq-aware Enrollment20:33
Hiding Internals, Colorizing Externals6:57
Verbose Query Execution6:05
Challenge 14 - Unenroll0:34
Unenrolling Students3:29
Challenge 15 - Courses By Student0:39
Current Enrollment Report4:28
Challenge 16 - Transcripts1:00
Generating Transcripts7:26
Challenge 17 - Letter Grades0:46
Approach9:49
Implementation5:28
Challenge 18 - Most Popular Courses0:51
Most Enrolled Courses6:18
Challenge 19 - Top Students0:41
Top Performers5:39

Section Overview0:55
Lecture Resources0:05
PostgreSQL2:55
The Precompiled Alternative4:20
Database Server3:07
Connecting4:40
Query Execution9:19
Parametrization9:33
Dynamic Query Generation10:22
Dynamic Queries Part II14:15
Quick Refactor3:12
Let's Build!2:24
Project Resources - All Challenge Solutions0:16
New Virtual Env2:10
The Web-based API7:49
Automatic Documentation2:40
Our Database2:26
Object-Oriented Helper Part I8:20
Object-Oriented Helper Part II4:27
Connection URL As Env Variable4:31
Dependency Injection9:54
Challenge 1 - DDL1:45
Creating Our First Tables3:42
The Register Endpoint6:24
Data Validation With Pydantic4:39
User Registration Data Validation7:38
Hashing Passwords10:36
Registration With Hashed Passwords4:49
Challenge 2 - Persisting To Database0:44
Inserting Users5:56
Adding The UNIQUE Constraint5:10
HTTPExceptions And Status Codes6:32
Challenge 3 - Object-Oriented Refactor3:07
OOP Write Returning Id13:54
Challenge 4 - Registration Tokens1:14
Saving Tokens3:20
The Activate Endpoint + Cleanup6:22
Challenge 5 - Get One2:27
Implementing Database get_one()15:16
Challenge 6 - Get One As Special Case Of Get2:10
Implementing A Generalized Get6:41
Challenge 7 - Update2:47
Implementing Database .update()10:02
Challenge 8 - Endpoint Integration1:10
The Activate Flow7:45
Challenge 9 - Activate Once0:59
Enforcing One Time Activation7:07
Messages Prep5:33
Form vs Query Params4:09
Code Reorg Using Routers11:43
Challenge 10 - Messages DDL + Path1:53
Persisting Messages10:14
Fixing A Typo0:35
Authentication12:46
Authenticated POST /messages8:20
Fixing An Old Bug3:29
Challenge 11 - Updating Messages1:19
PATCH /messages11:29
Challenge 12 - Get Message By Id1:44
Getting Public + Own Messages8:29
Challenge 13 - Get All Messages1:17
Getting Public And Own Messages6:01
or_where Refactor9:19
Challenge 14 - Database Delete1:21
Implementing .delete()4:16
Refactoring Database Methods11:21
Challenge 15 - Integrating Delete0:50
Deleting Messages From The Interface6:22
Challenge 16 - New Get Contains3:45
Implementing Get With Like Operator10:39
Challenge 17 - Get With Contains4:40
Refactoring Get4:55
Challenge 18 - Search Messages0:54
Implementing Message Search14:30
A More Coherent Database .get()11:36
The Final .get() Refactor17:48
Challenge 19 - Upvotes0:56
Upvotes DDL3:31
Challenge 20 - Upvoting0:56
The Upvote Interface12:57
Quick Bug Fix1:47
Challenge 21 - Most Popular Messages1:45
Most Upvoted10:34
Preparing To Send Emails8:06
Sending Generated Tokens13:32
Two Little Tweaks2:52
Preparing To Deploy5:58
Deployment6:26

Requirements

Some basic familiarity with python and SQL would help, though advanced concepts will be explained in detail as needed

Description

Welcome to the best resource online for learning to work with SQL in python.

Python and SQL are two of the most in-demand skills in any data-related or data-adjacent role today.

In this course, we'll use SQLite, MySQL and PostreSQL to build three projects of increasing complexity that will give you a solid foundation in using SQL in python applications.

Over 17 hours and 50 coding assignments, you will gain practical mastery of, not only SQL and python, but also tens of programming and computer science concepts.

In building these projects, you won’t be copy/pasting code. Instead, we will be writing code from scratch, and we will be writing lots of it.

This "forced" practice will help solidify your understanding of the concepts and techniques we cover. Each assignment will be followed by a detailed solution and explanation.

By the end of the course, after 3 immersive days, SQL and python will be on your resume!

––––– Structure & Curriculum –––––

· Day 1: SQLite

· understanding connections, cursors, transactions in sqlite3

· parameterizing and executing queries

· understanding and preventing SQL injections

· introduction to DBAPI

· building the Freight Manager (9 coding assignments)

· Day 2: MySQL

· revisiting connections, cursors, transactions with mysql-connector

· building prepared statements

· exploring dictionary, buffered and namedtuple cursors

· building the School Registrar (19 coding assignments)

· Day 3: PostgreSQL

· revisiting connections, cursors, transactions with psycopg2

· generating dynamic SQL from python code

· building the Guestbook API (22 coding assignments)

· with object oriented programming, password hashing, and more

This is the ultimate, immersive introduction to two of the most valuable skills today.

I'll see you inside!

Who this course is for:

Anyone interested in learning how to work with SQL productively in python
Anyone interested in building python applications that use relational databases

Practical SQL With Python In 3 Days: Beginner to Pro

What you'll learn

Explore related topics

Course content

Day 0 - Two Minute Welcome2 lectures • 2min

Day 1 - Freight Manager45 lectures • 3hr 23min

Day 2 - Course Registrar64 lectures • 5hr 2min

Day 3 - Guestbook API88 lectures • 8hr 31min

Thank you!2 lectures • 5min

Requirements

Description

Who this course is for: