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.