This course is designed for those interested to learn the basics of MySQL databases with Python, how to create basic reports, and how to put data in and take data out using Python.
Read more.Instructor
John
John Elder is a the founder and CEO of Codemy.com where he has taught over 50,000 people to code, as well as an Amazon #1 Best-Selling Author.
Only want this course? Buy this course for $199 $29 and keep lifetime access.
Click here
About This Course
Who this course is for:
- Anyone who wants to use the MySQL Database with Python
What you’ll learn:Â
- The basics of using MySQL with Python
- How to create databases and tables
- How to add data
- How to sort data
- How to create reports
- How to pull specific data
- Understand databases
Requirements:Â
- A basic understanding of Python programming would be helpful
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 course, 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.
We’ll download everything you need for this course for free, you don’t need any special tools.
If you’ve ever wanted to understand databases or use them in your Python programs, this is the course for you.
Our Promise to You
By the end of this course, you will have learned MySQL databases with Python.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about MySQL databases.
Course Curriculum
| Section 1 - Using MySQL Databases With Python | |||
| Introduction | 00:00:00 | ||
| What Is A Database | 00:00:00 | ||
| Install Python | 00:00:00 | ||
| Install Git Bash Terminal | 00:00:00 | ||
| Download MySQL | 00:00:00 | ||
| Install MySQL And Workbench | 00:00:00 | ||
| Install MySQL Connector | 00:00:00 | ||
| Connect To Database In Python | 00:00:00 | ||
| Explore MySQL Workbench | 00:00:00 | ||
| Create A Database | 00:00:00 | ||
| Create A Table | 00:00:00 | ||
| Insert One Record Into Table | 00:00:00 | ||
| Insert Many Records Into Table | 00:00:00 | ||
| Understanding Data Types | 00:00:00 | ||
| Select Data From Table | 00:00:00 | ||
| Format Our Results | 00:00:00 | ||
| The Where Clause | 00:00:00 | ||
| The Like Clause And Wildcards | 00:00:00 | ||
| Using AND And OR | 00:00:00 | ||
| Updating Records | 00:00:00 | ||
| Limit And Ordering | 00:00:00 | ||
| Delete Records | 00:00:00 | ||
| Delete Or Drop A Table And Backups | 00:00:00 | ||
Related Courses
