Python 3 Database Programming with MySQL

Learn how to work with databases in Python 3 in a web environment by developing a web based inventory/sales project.
3.5 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,697 students enrolled
Take This Course
  • Lectures 17
  • Length 2 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2014 English

Course Description

Python 3 Database Programming with MySQL is a learn by doing course. It will teach you how to set up a web centric client server based development environment on your computer.

The course teaches you how to set up and work in the XAMPP environment - which is a web server environment that runs on Windows, Macintosh and Linux based computers that comes complete with MySQL and a variety of tools that make it an ideal platform for developing web sites on your personal computer.

The course will then teach you how to create a web based MySQL application in Python by guiding you through the development of a basic inventory management and customer purchase system.

This project will teach you how to use the Python Database API and a wide variety of MySQL statements - enough to develop pretty sophisticated database centric Python programs.


  • Even though the course and code is presented in Python 3, the actual Python Database API works in both Python 2.7 and Python 3. Also, the API is generic across databases. So once you learn the API by withing with MySQL, you will know how to use it with other database platforms.
  • We use PMySQL as our Python DBI adapter module. If you use another adapter, the interface to MySQL will be the same.
  • We use XAMPP as our development environment. Feel free to use another environment or even a web server it you have the ability to install Python modules on it.

What are the requirements?

  • Basic knowledge of HTML
  • Basic knowledge of Python 3 programming

What am I going to get from this course?

  • Learn how to access and work with the Python database interface.
  • Learn how to build a web based Python/MySQL application on your computer.
  • Learn the basics of the MySQL statement structure.

Who is the target audience?

  • All people interested in learning how to work with databases in a Python programming environment

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: How This Course Is Structured
Overview Of How This Course Is Structured
Description Of The Inventory Management Project
Project Specification
1 page
PyMySQL Methods Summary Document
3 pages
Section 2: Setting Up Your Development Environment
Overview Of Setting Up Your Environment: Python, XAMPP PyMySQL & MySQL
Important Note on Live Walkthrough Video Below
Live Walkthrough Of Downloads, Installations And Configurations
Section 3: Creating Database Tables In Python
Set Up Project Database Tables In Python Overview
Code Walkthrough Of Setting Up Project Database Tables In Python
Section 4: Working With Database Inserts And Selects In Python
Database Inserts And Selects In Python Overview
Code Walkthrough Of Project Database Inserts And Selects In Python
Section 5: Working With Multiple Inserts, Updates And Complex MySQL Selects
Multiple Inserts, Updates And Complex MySQL Selects In Python Overview
Code Walkthrough Of Multiple Inserts, Updates And Complex MySQL Selects
Section 6: Creating Reports With MySQL And Python
Overview Of Project Reports
Code Walkthrough Of Creating Reports WIth MySQL And Python
Section 7: Resources: Powerpoint Downloads and Code Download
All Powerpoint Slides For Each Section
Python Source Code For The Inventory Management Project

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Steven Chabotte, Entrepreneur and Professional Programmer

Steven Chabotte is an entrepreneur and programmer. He wrote his first computer program in 1979 in a very primitive version of basic on a teletype machine and was immediately hooked by the creative world ad magical world that was offered by writing lines of code to run on a computer.

He then went on to write a teaching system for special needs students at his high school before going off to college to study Astronomy - and the fascinating language of Fortran which opened the world of statistical analysis of Astronomy - an interest that persist to this day but with Python as the main programming language.

Since that time, Steven has tackled many complex projects - from nuclear power plant control systems to real time operating system development and process control systems to complex web applications in a wide variety of high level and machine languages.

He has also run several programming development companies focused on web development tools such as search engine development and email marketing tools as well as web enabled mail order companies.

Steven currently runs two thriving online ecommerce businesses. One is a publish on demand business based on public domain works and one is a more traditional web based mail order business focusing on eBay (since 1997) and Amazon (since 2005) as the marketing platforms.

Ready to start learning?
Take This Course