Skip to content
UdemyPythonPaid courseBeginner levelCertificate

Using MySQL Databases With Python (Udemy.com)

Learn MySql Database With Python The Fast and Easy Way!

Created by: John Elder

Last updated November 2023

icon
What you will learn

  • 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

How it compares

Against the other 388 rated Udemy courses in Python on CourseDuck:

  • Rating4.6 out of 5higher than 70% of them
  • Reviews1,718#143 of 389 by number of reviews
  • Length2.2 hoursshorter than 91% of them
  • Last updatedNovember 2023more recently than 51% of them

icon
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



icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

John Elder

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. 

Today he teaches Web Development courses at Codemy the online code school he founded. 

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

icon
More courses by John Elder

$54.99

$54.99

$11.99

$11.99

$13.99

$11.99

icon
Reviews

4.6

1,718 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Sonasman Roychowdhuri on 8/28/2024

It was good. Last time I saw what was created for the python which I have done to earn myself for congratulated already which already exists for me to do a python in my assignment that I already completed. Meanwhile, now it is time for my work to do for MySQL. I have downloaded but when and I don't know where to see but I will manage a few options to focus for what I've created. So far so good, then it is time for me to go ahead and I'll do again for some preparations. I'll catch up for another courses. So thank you!!!

By Cassandra Hoyland on 11/28/2020

I really enjoyed this course. I have used SQL in the past but am fairly new to Python. The most challenging part of the course for me was downloading all the software, especially MySQL because of prerequisite software missing from my rather old PC! Once I'd sorted this out, all went really well and it was a great refresher about SQL. I loved connecting to the database using Python. Many thanks.

By Sanket Mehta on 7/16/2020

I was new to mysql and then did this course. Now I got a hang of MySql. Nice way to start MySql. Loved the short and sweet course. Cheers and thank you John for preparing this course. One more thing about John is - he replies to all the queries asap. So, we don't have to wait for more time getting our answers.

By shuvodip Saha on 4/7/2020

It covers all the basic details about MySql and how to interact MySql workbench using Python. But I was expecting more data handling and interaction. The use of foreign keys, inner, outer join and stuff like that. Although the overall content of this course was very compact and to the point, also I like the pace of the content delivery, pretty smooth. Thanks for the knowledge sharing. :)

By W. Plantinga on 8/17/2019

There have been some confusion about the additional apps used like Git Bash. It took a while to get my connections in order, but succeeded. The course is basic, very limited, but gives a short overview how to connect to Mysql and Python, make a DB and update and retrieve data in a simple way. Sometimes it looked like the instructor saw presented data for the first time (video over world.db). I got what I was looking for and it see it as a first step to continue.

By Ted Semon on 6/30/2019

I needed a quick intro into how Python hooks up with MySQL and this course delivered it. No fluff, just knowledge. The teacher is engaging and doesn't bore you with personal anecdotes or irrelevant data, he just teaches you how to do basic MySQL stuff in Python.

By Ephraim Ulmer on 4/6/2019

Great course! John did a great job putting together a training how to setup a MYSQL database and connecting it to Python and getting started with the key and basic database operations using Python. It meet my expectations completely and is a stepping stone for more advanced database programming using Python.

By Andrew Tink on 3/19/2019

This course was a good 'kick starter', by which I mean it showed me what I could do with Python and MySQL if I was prepared to follow the instructions 'parrot fashion' - useful as a quick means of 'getting into' the topic. But it did not provide any real depth or understanding - that I had to get myself from other sources on the net. So, in my opinion this is very much a course for a beginner to get you started, but only useful if you are prepared to do the homework afterwards to properly understand what the course has enabled you to do.

By Nalini on 2/24/2019

The videos are very clear and simple. When you execute the program things work out well for you, but for us beginners we get errors. So it would be great if you could address some of the common mistakes that are made and also how to interpret the error messages that we usually see. Thanks

By Simone Donati on 12/4/2018

ottimo corso davvero, ero neofita nell'utilizzo di msql e di come si interfacciasse con python, ottimo corso introduttivo davvero, complimenti al sig. john elder, veramente bravo insegnante, consigliatissimo, MAGARI UNA LEZIONE SU COME INNESTARE QUERY ALL'INTERNO DEI LOOP SAREBBE IL MASSIMO

非常適合!實做與搭配很合適

Powerful tools that are taught quickly and easily. I believe this course should form part of any data user or pyhton/mysql user's education. The instructor is easy to understand and each Lecture is well thought out and paced.

Showing 12 of 96 reviews

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 92 / 100