Udemyallen

Practical SQL With Python In 3 Days: Beginner to Pro

Learn Python & databases! Build 3 projects in 3 days using SQLite, MySQL & PostgreSQL. Hands-on experience for fast development.

4.4(86)
1,237students
17h
Certificate
Andy Bek
Andy BekSoftware Consultant

Course Content

Practical SQL With Python In 3 Days: Beginner to Pro is an all-levels Udemy course taught by Andy Bek. It runs 17h, is taught in English, and includes a certificate of completion. Learners rate it 4.4 out of 5 from 86 reviews, with 1,237 students enrolled. It is a paid course, last updated August 2025.

Unlock the power of data! This comprehensive course teaches you how to effectively use SQL with Python, two of the most sought-after skills in today's job market. You'll gain hands-on experience building real-world projects using popular database systems: SQLite, MySQL, and PostgreSQL.

Over 17+ hours and 50 coding assignments, you'll develop practical mastery of SQL programming and Python programming, alongside essential programming and computer science concepts. Forget copy-pasting – we focus on writing code from scratch to solidify your understanding. Each assignment includes detailed solutions and explanations to ensure you truly grasp the material.

What you'll learn:

  • Database Fundamentals: Solid understanding of database connections, cursors, and transactions.
  • SQL Injection Prevention: Learn best practices to secure your applications.
  • DBAPI: A deep dive into the Python DBAPI for database interaction.
  • Python Database Connectivity: Master connecting to and interacting with various databases.
  • Object-Oriented Programming (OOP): Apply OOP principles to database development.
  • Password Hashing: Implement secure password storage techniques.

Course Structure:

  • Day 1: SQLite
    • Connect to SQLite databases and manage cursors.
    • Understand and utilize transactions.
    • Parameterize and execute SQL queries securely.
    • Prevent SQL injection vulnerabilities.
    • Introduction to the DBAPI.
    • Project: Build the Freight Manager (9 coding assignments).
  • Day 2: MySQL
    • Revisit database connections, cursors, and transactions with mysql-connector.
    • Implement prepared statements for efficient query execution.
    • Explore dictionary, buffered, and namedtuple cursors.
    • Project: Build the School Registrar (19 coding assignments).
  • Day 3: PostgreSQL
    • Revisit connections, cursors, and transactions with psycopg2.
    • Generate dynamic SQL queries from Python code.
    • Project: Build the Guestbook API (22 coding assignments) – incorporating object-oriented programming, password hashing, and more.

By the end of this immersive 3-day course, SQL and Python skills will be ready to boost your resume! This is the ultimate introduction to becoming proficient in these valuable technologies.

$ whoami — the devs behind tutorialsearch.io

Need a web app built? Hire the team behind TutorialSearch.io

We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.

5.0(33)
1h 50m
all
skillshare
5.0(391)
1h 8m
all
skillshare
5.0(766)
2h 58m
intermediate
skillshare