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.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: How This Course Is Structured|
Overview Of How This Course Is StructuredPreview
Description Of The Inventory Management ProjectPreview
PyMySQL Methods Summary Document
|Section 2: Setting Up Your Development Environment|
Overview Of Setting Up Your Environment: Python, XAMPP PyMySQL & MySQLPreview
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
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.