Master Using SQL with Python Full Course

Learn to integrate SQL with Python through this comprehensive 8-hour 42-minute course covering everything from basic database operations to advanced enterprise solutions. Start with SQL fundamentals using Pandas and SQLite, then progress through enterprise database connections using ODBC. Explore data analysis techniques with SQLite and PostgreSQL, master SQLite Studio for database management, and build a complete data warehouse using SQLite. Discover advanced SQLite features including JSON handling and upsert operations, then advance to maintaining data across multiple database systems including PostgreSQL, SQL Server, and Oracle using merge and upsert techniques. Conclude with an introduction to scaling analytics using DuckDB with Python, gaining practical skills for both small-scale projects and enterprise-level database management.

Syllabus

Master Using SQL with Python: Lesson 1 - Using SQL with Pandas
Master Using SQL with Python: Lesson 2 - Using SQLite
Master Using SQL with Python: Lesson 3 - Using Enterprise Databases with ODBC
Master Using SQL with Python: Lesson 4 - Using SQLite for Data Analysis
Master Using SQL with Python: Lesson 5 - Using SQLite Studio
Master Using SQL with Python: Lesson 6 - Create a Data Warehouse with SQLite
Master Using SQL with Python: Lesson 7 - Maintaining Data in SQLite
Master Using SQL with Python: Lesson 8 - Introducing PostgreSQL
Master Using SQL with Python: Lesson 9 - Using PostgreSQL for Data Analysis
Master Using SQL with Python: Lesson 10 - Using Advanced SQLite Features
Master Using SQL with Python: Lesson 11 - Using JSON with SQLite
Master SQL with Python: Lesson 12 - Maintaining Data in PostgreSQL using Upsert
Master SQL with Python: Lesson 13 - Maintaining Data in SQL Server using Merge
Master SQL with Python: Lesson 14 - Maintaining Data in Oracle using Merge
Master Using SQL with Python: Lesson 7.2 - Using the SQLite Upsert
Introduction to Scaling Analytics Using DuckDB with Python