Using MySQL Databases With Python

person icon John Elder

Using MySQL Databases With Python

Learn MySql Database With Python The Fast and Easy Way!

updated on icon Updated on Sep, 2023

language icon Language - English

person icon John Elder

architecture icon MySQL,Database Design & Development


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description

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

Who this course is for:

  • Anyone who wants to use the MySQL Database with Python


What will you learn in this course:

  • Understand how to use MySQL Databases With Python
  • Understand the basics of what a Database can do.
  • Install Python, MySQL, Git Bash, and MySQL Connector
  • You'll Learn How To Create a Database and Table
  • How to put data in and take data out using Python
  • How to update and delete data from the database
  • How to explore what's in the database whenever you want
  • How to create basic reports with the data from your database


What are the prerequisites for this course?

  • A Basic Understanding Of Python Programming Would Be Helpful
  • You don't need any special tools, we'll download everything we need for free. You just need a Windows, Mac, or Linux computer
Using MySQL Databases With Python


Check out the detailed breakdown of what’s inside the course

24 Lectures
  • play icon Introduction 02:34 02:34
  • play icon What Is A Database 05:14 05:14
  • play icon Install Python 04:53 04:53
  • play icon Install Git Bash Terminal 04:20 04:20
  • play icon Download MySQL 04:11 04:11
  • play icon Install MySQL and Workbench 07:48 07:48
  • play icon Install MySQL Connector 04:16 04:16
  • play icon Connect to Database in Python 05:38 05:38
  • play icon Explore MySQL Workbench 07:34 07:34
  • play icon Create A Database 07:13 07:13
  • play icon Create A Table 08:54 08:54
  • play icon Insert One Record Into Table 05:39 05:39
  • play icon Insert Many Records Into Table 05:39 05:39
  • play icon Understanding Data Types 04:51 04:51
  • play icon Select Data From Table 05:18 05:18
  • play icon Format Our Results 07:29 07:29
  • play icon The Where Clause 04:06 04:06
  • play icon The Like Clause and Wildcards 02:50 02:50
  • play icon Using AND and OR 03:40 03:40
  • play icon Updating Records 05:23 05:23
  • play icon Limit and Ordering 04:37 04:37
  • play icon Delete Records 02:44 02:44
  • play icon Delete (Drop) A Table And Backups 05:57 05:57
  • play icon Conclusion 01:41 01:41

Instructor Details

John Elder

John Elder

Founder of Codemy

John Elder is a pioneer in Web Development who created one of the first Internet advertising networks back in 1997. He sold it to a publicly traded company at the height of the dot com boom and then went on to create the best-selling Submission-Spider search engine submission software that's been used by over 3 million individuals and small businesses in over 45 countries. 

John graduated with honors with a degree in Economics from Washington University in St. Louis where he was an ArtSci Scholar. 

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us