Using MySQL Databases With Python (Udemy.com)

Learn MySql Database With Python The Fast and Easy Way!

( 98 Reviews )

Created by: John Elder

Produced in 2021

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

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 92 / 100

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

Time: 2h

Instructor Details

John Elder

4.6 Rating
98 Reviews

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.

Python for Everybody Specialization (2014)

4.7 (91 Reviews)

Provider: Coursera
Time: 25h

Free

Python Tutorial for Beginners by Corey Schafer

Python Tutorial for Beginners by Corey Schafer (2017)

4.8 (28 Reviews)

Provider: YouTube
Time: 9h

Free

Google's Python Class (2010)

4.4 (18 Reviews)

Provider: Google
Time: 3h 35m

Free

More Courses

Reviews

4.6

98 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Simone Donati

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

By é˜®åé½Š

éžå¸¸é©åˆï¼å¯¦åšèˆ‡æé…å¾ˆåˆé©

By Marco van der Linde

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.

By Marc Nabil

It was a nice intro course for using MySQL with Python.

The instructor is fun and engaging .

This course might benefit from more exercises and maybe a project to apply all that is learnt.

By Nivedit Batham

It is good to have a basic understanding with MySQL and Python. Would expect more exercises and may be just 1 real app building basis this.

By Sam Rivera

This course provided me with the information I needed: the Python code required to connect to a MySQL database and execute SQL code. In addition, John provides some simple SQL statement examples to demonstrate how you would implement them in a Python environment.

Overall a great, simple & quick course to get you started on utilizing MySQL in your Python applications. Definitely recommend!

By Brent

Very short. could use a project or two. did do a good job explaining

By Kristoffer

Great pace and utilization of the SQL Workbench for a visual of the output.

By Eduard Guiu

The setting up of MySQL and Python is useful and to the point in order to get your feet wet. Short enough to get everything up and running.

By Eric Alexander

Excellent course to understand MySQL!!!

By Michael Evans

Excellent course for working with mysql and python!! Thanks John!

By Adrien Esquerre

The courses they are really smooth, conceptual and fun, its like watching a documentary or a movie, I'll soonly get some certificates for the first time.. Thanks John Elder