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
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
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
Instructor Details
- 4.6 Rating
1,718 Reviews
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.
More courses by John Elder
Intro To PostgreSQL Databases With PgAdmin For Beginners (2023)
4.5 (7,751 Reviews)
Provider: Udemy
Time: 2h
$54.99
Build An API With The Django Rest Framework Using Python (2023)
4.5 (1,229 Reviews)
Provider: Udemy
Time: 1.4h
$54.99
Top Node and Javascript Bundle: Learn Node and JS (2023)
4.3 (1,126 Reviews)
Provider: Udemy
Time: 8.2h
$11.99
Build a Stock Market Web App With Python and Django (2023)
4.6 (946 Reviews)
Provider: Udemy
Time: 3.8h
$11.99
Reviews
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.
Quality Score
Overall Score : 92 / 100









