Practical SQL With Python In 3 Days: Beginner to Pro

Practical SQL With Python In 3 Days: Beginner to Pro, available at $79.99, has an average rating of 4.55, with 201 lectures, based on 63 reviews, and has 873 subscribers.

You will learn about 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 This course is ideal for individuals who are Anyone interested in learning how to work with SQL productively in python or Anyone interested in building python applications that use relational databases It is particularly useful for Anyone interested in learning how to work with SQL productively in python or Anyone interested in building python applications that use relational databases.

Enroll now: Practical SQL With Python In 3 Days: Beginner to Pro

Summary

Title: Practical SQL With Python In 3 Days: Beginner to Pro

Price: $79.99

Average Rating: 4.55

Number of Lectures: 201

Number of Published Lectures: 201

Number of Curriculum Items: 201

Number of Published Curriculum Objects: 201

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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!

Course Curriculum

Chapter 1: Day 0 – Two Minute Welcome

Lecture 1: 2-min Introduction

Lecture 2: All Course Resources – Lectures + Project Challenges

Chapter 2: Day 1 – Freight Manager

Lecture 1: Section Overview

Lecture 2: Lecture Resources

Lecture 3: Introduction to SQLIite

Lecture 4: sqlite3 In Python

Lecture 5: DBAPI 2.0

Lecture 6: Connections And Cursors

Lecture 7: Inserts

Lecture 8: DML vs DDL (and DCL and DQL)

Lecture 9: Fetching

Lecture 10: Column Names Would Be Nice

Lecture 11: The Transaction Lifecycle

Lecture 12: Parameterized Statements

Lecture 13: A Different Flavor

Lecture 14: Various Ways To Execute

Lecture 15: Database Dump

Lecture 16: Context Managed Connections

Lecture 17: Let's Build!

Lecture 18: Project Resources – All Solution Challenges

Lecture 19: Creating A Virtual Environment

Lecture 20: Challenge 1 – Interface

Lecture 21: The Interface

Lecture 22: Sketching Out The Basics

Lecture 23: Challenge 2 – DDL

Lecture 24: Executing the DDL

Lecture 25: Foreign Key Gotcha

Lecture 26: The Add Box Menu

Lecture 27: Challenge 3 – Add Box To Database

Lecture 28: Add Box Helper

Lecture 29: Challenge 4 – Displaying Box Types

Lecture 30: Displaying All Boxes

Lecture 31: A Prettier Display

Lecture 32: Challenge 5 – Loading Boxes With Validation

Lecture 33: Load Box Menu

Lecture 34: The Containers Database View

Lecture 35: Container Constraints

Lecture 36: The Final Stretch

Lecture 37: Quick Note

Lecture 38: Challenge 6 – Seed Data

Lecture 39: Seeding Some Boxes

Lecture 40: Challenge 7 – Containers

Lecture 41: Displaying Containers

Lecture 42: Business Summary

Lecture 43: The Bottom Line

Lecture 44: Challenge 9 – Configurable Constants

Lecture 45: Refactoring Configuration

Chapter 3: Day 2 – Course Registrar

Lecture 1: Section Overview

Lecture 2: Lecture Resources

Lecture 3: Welcome To MySQL

Lecture 4: Local Vs Cloud MySQL

Lecture 5: Connecting From Python

Lecture 6: URL Parsing

Lecture 7: Cursors Again

Lecture 8: Context Managers Revisited

Lecture 9: Parameterized Inserts

Lecture 10: Prepared Statements

Lecture 11: Let's Fetch

Lecture 12: Buffering

Lecture 13: Dict Cursors

Lecture 14: A Named Alternative

Lecture 15: .executescript() Please?

Lecture 16: Best: Multi With Autocommit

Lecture 17: Let's Build!

Lecture 18: Project Resources – All Challenge Solutions

Lecture 19: Setting Up

Lecture 20: The Interface

Lecture 21: Challenge 1 – Connection Helper

Lecture 22: Writing The Helper

Lecture 23: Challenge 2 – Prepare The DDL

Lecture 24: Wiring Up The DDL

Lecture 25: Challenge 3 – The Reset Command

Lecture 26: Resetting The Database

Lecture 27: Challenge 4 – Add Student

Lecture 28: Adding New Students

Lecture 29: Challenge 5 – Add Course

Lecture 30: Adding New Courses

Lecture 31: Challenge 6 – Prerequisites

Lecture 32: Prereq DDL And Command

Lecture 33: Addressing A Small Inconsistency

Lecture 34: Challenge 7 – Querying

Lecture 35: The Query Helper

Lecture 36: Challenge 8 – Seeding Data

Lecture 37: Initializing Data

Lecture 38: —no-with-data

Lecture 39: Challenge 9 – Show Prerequisites For Course

Lecture 40: Displaying Prereqs

Lecture 41: Pretty Tables

Lecture 42: Challenge 10 – Show Students And Courses

Lecture 43: Displaying Students And Courses

Lecture 44: Challenge 11 – Course Enrollment Part I

Lecture 45: Naive Enrollment

Lecture 46: Challenge 12 – Grading

Lecture 47: The Grade Command

Lecture 48: Challenge 13 – Course Enrollment Part II

Lecture 49: Prereq-aware Enrollment

Lecture 50: Hiding Internals, Colorizing Externals

Instructors

Andy Bek
Software Consultant

Rating Distribution

1 stars: 2 votes
2 stars: 1 votes
3 stars: 7 votes
4 stars: 17 votes
5 stars: 36 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu