MySQL with Python and MySQLdb

Learn to integrate MySQL databases with Python programming through hands-on tutorials covering database operations and real-world applications. Master the MySQLdb module to establish database connections, create tables, and insert data into MySQL databases. Explore essential database operations including UPDATE, DELETE, and SELECT statements while discovering how to safely insert Python variables as data. Apply your skills to practical projects by streaming tweets from the Twitter API v1.1 directly into MySQL databases, combining social media data collection with database management techniques for web development applications.

Syllabus

MySQL Database with Python Tutorial Part 1 - Intro
MySQL Database with Python Tutorial Part 2 - creating tables and inserting data
MySQL Database with Python Tutorial Part 3 - UPDATE, DELETE, AND SELECT
MySQL Database with Python Tutorial Part 4 - Inserting Variables as Data
Streaming Tweets from Twitter API v1.1 into MySQL Database with Python
How to use the Twitter API v1.1 with Python to stream tweets