AI, Data Science & Business Certificates from Google, IBM & Microsoft
Learn Excel & Financial Modeling the Way Finance Teams Actually Use Them
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
Learn how to integrate MySQL databases with Python applications through this comprehensive tutorial series that covers database connectivity, SQL operations, and server deployment. Master the fundamentals of working with relational database management systems by setting up MySQL Connector for Python and executing basic queries to retrieve and manipulate data. Explore essential database design principles including table creation, data insertion, and selection operations while understanding how to modify existing table structures. Discover advanced concepts such as implementing foreign keys to establish relationships between tables and maintain data integrity across your database schema. Gain practical experience in database administration by learning how to host and configure a MySQL server on Linux systems, providing you with the skills needed to deploy database solutions in production environments.
Syllabus
Python MySQL Tutorial - Setup & Basic Queries (w/ MySQL Connector)
Python MySQL Tutorial - Creating Tables, Inserting & Selecting
Python MySQL Tutorial - Selecting Data & Altering Tables
Python MySQL Tutorial - Foreign Keys & Relating Tables
How to Host a MySQL Server on Linux
Taught by
Tech With Tim