Course: 24 Videos
Length: 2.0 Hours
Price: $49
These days everything uses a database, and MySQL is one of the most popular databases out there. FREE and Open Source, Mysql is a great database for just about all your needs.
Likewise, Python is one of the most popular and powerful programming languages today. Pairing the two together is a powerful combination!
In this course you’ll learn the basics of using MySQL with Python.
You’ll learn how to create databases and tables, add data, sort data, create reports, pull specific data, and more.
For this courses I’ll assume you already have a basic knowledge of Python programming, but you don’t need to know anything at all about databases or MySQL to take the course.
You’ll learn…
– What Is A Database
– How To Install Python
– How To Install Git Bash Terminal
– How To Download MySQL
– How To Install MySQL and Workbench
– How To Install MySQL Connector
– How To Connect to Database in Python
– How To Explore The MySQL Workbench
– How To Create A Database
– How To Create A Table
– How To Insert One Record Into Table
– How To Insert Many Records Into Table
– Understanding Data Types
– How To Select Data From Table
– How To Format Our Results
– How To Use The Where Clause
– How To Use The Like Clause and Wildcards
– How To Use AND and OR
– How To Updating Records
– How To Limit and Order Results
– How To Delete Records
– How To Delete (Drop) A Table And Backups
– And More!
I’ll walk you through all of this and more, step by step. If you have any question along the way, I’m here to answer them.
If you’ve ever wanted to understand databases or use them in your Python programs, this is the course for you.
We’ll download everything you need for this course for free, you don’t need any special tools!
I’ll see you on the inside!
-John Elder
Course Content…
| Module 1 | Using MySQL Databases With Python |
| Unit 1 | Introduction | Video 1 |
| Unit 2 | What Is A Database | Video 2 |
| Unit 3 | Install Python | Video 3 |
| Unit 4 | Install Git Bash Terminal | Video 4 |
| Unit 5 | Download MySQL | Video 5 |
| Unit 6 | Install MySQL and Workbench | Video 6 |
| Unit 7 | Install MySQL Connector | Video 7 |
| Unit 8 | Connect to Database in Python | Video 8 |
| Unit 9 | Explore MySQL Workbench | Video 9 |
| Unit 10 | Create A Database | Video 10 |
| Unit 11 | Create A Table | Video 11 |
| Unit 12 | Insert One Record Into Table | Video 12 |
| Unit 13 | Insert Many Records Into Table | Video 13 |
| Unit 14 | Understanding Data Types | Video 14 |
| Unit 15 | Select Data From Table | Video 15 |
| Unit 16 | Format Our Results | Video 16 |
| Unit 17 | The Where Clause | Video 17 |
| Unit 18 | The Like Clause and Wildcards | Video 18 |
| Unit 19 | Using AND and OR | Video 19 |
| Unit 20 | Updating Records | Video 20 |
| Unit 21 | Limit and Ordering | Video 21 |
| Unit 22 | Delete Records | Video 22 |
| Unit 23 | Delete (Drop) A Table And Backups | Video 23 |
| Unit 24 | Conclusion | Video 24 |