Python and MySQL
Learn how Python and SQL, a database query language, can interact and be used for various data analysis uses.Get Started
Getting Started with MySQL
Get started with MySQL, set up your very own MySQL database and then connect to it with Python.
Updating Entries and Limiting Queries
This video will cover updating entries in our MySQL Database as well as limiting the number of entries we get back from a query.
Populating our Database and Table
This video will cover populating our database and table in MySQL with Python. We'll understand how to execute SQL commands to push single and multiple sets of data.
Deleting Entries and Dropping Tables
This video will cover how to delete entries from your table and drop tables from your database for further data manipulation.
Creating our Database and Table
This video will cover learning how to create our own database with Python and then create our first table inside the database.
Selecting and Getting Data
This video will cover selecting and getting data from our table in MySQL using SQL terms in Python syntax.
Ordering Queries and Results
This video will cover how to quickly order our queries utilizing Python and SQL commands.
Query Conditions with WHERE and Wildcards
This video will cover making more advanced queries in Python utilizing the WHERE condition in SQL as well as Wildcards in our queries.