Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Python 3 Database Programming with MySQL to your Wishlist.

Add to Wishlist

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,703 students enrolled
Last updated 9/2014
$10 $30 67% off
2 days left at this price!
30-Day Money-Back Guarantee
  • 2 hours on-demand video
  • 3 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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.
View Curriculum
  • Basic knowledge of HTML
  • Basic knowledge of Python 3 programming

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.
Who is the target audience?
  • All people interested in learning how to work with databases in a Python programming environment
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 17 Lectures Collapse All 17 Lectures 01:58:12
How This Course Is Structured
4 Lectures 06:59

Project Specification
1 page

PyMySQL Methods Summary Document
3 pages
Setting Up Your Development Environment
3 Lectures 19:29

Important Note on Live Walkthrough Video Below

Live Walkthrough Of Downloads, Installations And Configurations
Creating Database Tables In Python
2 Lectures 22:45
Set Up Project Database Tables In Python Overview

Code Walkthrough Of Setting Up Project Database Tables In Python
Working With Database Inserts And Selects In Python
2 Lectures 26:26
Database Inserts And Selects In Python Overview

Code Walkthrough Of Project Database Inserts And Selects In Python
Working With Multiple Inserts, Updates And Complex MySQL Selects
2 Lectures 25:42
Multiple Inserts, Updates And Complex MySQL Selects In Python Overview

Code Walkthrough Of Multiple Inserts, Updates And Complex MySQL Selects
Creating Reports With MySQL And Python
2 Lectures 12:28
Overview Of Project Reports

Code Walkthrough Of Creating Reports WIth MySQL And Python
Resources: Powerpoint Downloads and Code Download
2 Lectures 00:11
All Powerpoint Slides For Each Section

Python Source Code For The Inventory Management Project
About the Instructor
3.9 Average rating
16 Reviews
2,466 Students
3 Courses
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.

Report Abuse