Using SQL with Python
1h 39mIntermediate2021-07-12
Authors

Bill Weinman
Tech Advocate, Entrepreneur, Programming Expert
Course details
Are you familiar with SQL? Do you know Python? Are you interested in understanding how these two languages work together? Then join Bill Weinman in this course as he shows the power of these two languages combined. Bill starts with some basics—connecting to a database, performing simple queries, and reading rows from a table. He covers how to use prepared statements and cursors, how to build a wrapper class to streamline the SQL interface and support multiple different database engines, and how to build a CRUD class and a full-featured web application using what you've learned. Many applications require a combination of SQL and Python, and after finishing Bill’s course, you’ll have a better understanding of why and how you can leverage the power of these two languages together.
Skills covered
SQLDatabase AdministrationDatabase DevelopmentPythonDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off
Concepts
0. Introduction
- 01 - Use SQL with Python
- 02 - Using the exercise files
- 03 - What do you need for this course
- 04 - Installing the tools
1. Common Interface
- 05 - The Python DB-API
- 06 - Creating a connection
- 07 - Simple queries
- 08 - Prepared statements
- 09 - Hello, SQLite
- 10 - Hello, MySQL
- 11 - Challenge
- 12 - Solution
2. A CRUD Class
- 13 - The essential four
- 14 - SQL Wrapper
- 15 - Adding CRUD methods
- 16 - Using the module
- 17 - Challenge
- 18 - Solution
3. Final Project - URL Shortener
- 19 - Defining the project
- 20 - Testing a web application
- 21 - Code demonstration
- 22 - Touring the code
- 23 - Challenge
- 24 - Solution
Conclusion
- 25 - Thank you
Related courses
- Complete Guide to Analytics Engineering
- Scala Essential Training for Data Science
- SQL: Data Reporting and Analysis
- Text to SQL: Amazon Redshift Serverless for Generative SQL in Amazon Q
- SQL Databases in Microsoft Fabric
- Hands-On SQL: Building Data Products in Dremio
- Complete Guide to SQL for Data Engineering: from Beginner to Advanced
- Intermediate SQL for Data Scientists