Python 3 Database Programming with MySQL
2.8 (10 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,721 students enrolled
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.
2.8 (10 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,721 students enrolled
Created by Steven Chabotte
Last updated 9/2014
English
Curiosity Sale
Current price: $10 Original price: $30 Discount: 67% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 3 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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
Requirements
  • Basic knowledge of HTML
  • Basic knowledge of Python 3 programming
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.

Notes:

  • 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
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
00:19

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

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

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

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

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

Python Source Code For The Inventory Management Project
00:04
About the Instructor
Steven Chabotte
2.9 Average rating
23 Reviews
2,503 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.