Please ensure Javascript is enabled for purposes of website accessibility
Using MySQL Databases With Python
0( 0 REVIEWS )
32 STUDENTS
2h
John
John

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.
Course Skill Level
Beginner
Time Estimate
2h

Instructor

John
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
3954196

Get LIFETIME ACCESS to ALL courses 

Enter your Name and Email for a chance to win Lifetime Access to all courses!
Promotion ends today.

3954197

Get LIFETIME ACCESS to ALL courses 

Enter your Name and Email for a chance to win Lifetime Access to all courses!
Promotion ends today.

Success! You are now entered to win lifetime access to all courses. Winners are selected at the beginning of each month. 

P.S. Look out for our exclusive sales only shown to students on our email list!