Using MySQL Databases With Python Course

How to Use MySQL Databases With Python! 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

Take $22 off with coupon code: youtube

✅ Get The Full Course On Udemy for $9.99

▶️ Join My Facebook Group:

✅ Subscribe To My YouTube Channel:

[SeamusMcNeil]

Having watched a stack of your videos I shall be subscribing shortly to your paid tutorials. I really like your delivery and style. Simple, easy to follow, you are not doing the usual American style which is normally loud, dont pause to take a breath, and being delivered at a speed only SuperWoman could keep up with. lol ;) All the very best and so glad I found your channel - I can honestly say that MySQL and Python has never sounded so easy.
Cheers
Jim

[nichhikara]

followed the steps, worked like magic. tested on windows 10, python 3.8.10 on Nov 30-2021

[rankzkate]

Thank you so much for this video.I had literally pulled all my hair trying to understand this python-mysql thing in vain.Your video saved me!!!!Thank you so much

[erixgutierrez]

I never thought I could learn so much from Walter White himself, I'm just waiting for the video when we start cooking our own Meth

[danielhenthorn]

I am vey grateful for these courses... It is my best time spent all week!

[mr.problem_solver]

Sir you are a very generous and kind minded person. I really like each of your videos. Sir, would you like to make a tutorial on machine learning using Python in the future?

[parsabahrambeik]

This is an excellent teaching method. Thanks

[elderan]

I iwhsh to say that i'm learning a LOT with your contents! Congrat, Very nica content! Slaude from Brazil!

[abdullahalasfar]

Hi

I tried to connect with database.py but it throws an error saying:
ImportError: No module named mysql.connector

i tried mysql.connector.python and .rf after pip installing all of them.

I googled a lot but no success.

[rayansultan]

hello, when i want to call or write ls or python database.py on my subgit text it shows my that :there is no file call database.py but i have already save it on my computer, so where is the problem??

[mchess]

Thanks for your video. It's really helpful! 💪
I'm wondering if it is safe to put password inside the python code? In the other tutorials I saw it was done the same way. But it seems to me a bit disturbing to use the password as plain text.

[kartavianmacrath]

So I am trying to follow along, even reinstalled mysql, but the server I created will not start and the workbench freezes when trying to start the server, so when I reinstalled, now the installer cannot finish because the server will not start... I am going to uninstall again and reinstall, in a fresh directory and see if that solves my problem

[TheGrandmaster]

I clicked on this thing, and scrubbed through for a total of about 15 seconds. I then went to Udemy and bought the whole damn thing, all within 45 seconds. It was exactly what I needed. This man was exactly what I needed. Will be buying most of his courses.

[aaronphilip]

I love your videos! I just had a doubt. While connecting the python program to the database im running into a few errors. I think it is because my program cannot locate the database which I made using the mySQL workbench. Can i do anything to make it recognize my database?

[HackingElectronics]

how to check if mysql table exists with python

[MrJhalexis]

One question: When I open mysql workbench, it doesn't display schemas on the navigator section. It only shows MANAGEMENT > INSTANCE > PERFORMANCE but SCHEMAS is missing. Why is that? I really appreciate if you could answer this as I am really enjoying this introduction tutorial?

[ABMA]

That is a nice lesson, but please comment about the right mysql-connector that should be installed. Some of them get installed, but generate errors when executed. I think viewers might face some difficulties getting mysql-connector to work from the first try.
I love your videos.

Thanks a lot.

Keep up the good work.

[bochraakrout]

hello, I am facing a problem with paython, Mysql and docx so I have this word document and I am reading from it so my goal is to read from word document(x) and search for (x)in the data base in a specific column and if it existes i copy the next column in another .py file and i am doing all of that with paython so whene i write mycursor.execute("SELECT code FROM table1 WHERE human_code REGEXP i have nothing however gives me the same exact row in the database i have

[jiviteshpandab]

im facing issue while pip install! i tried all the three you said but it still shows error
it says: Collecting mysql
Using cached mysql-0.0.3-py3-none-any.whl (1.2 kB)
ERROR: Could not find a version that satisfies the requirement connector (from versions: none)
ERROR: No matching distribution found for connector

[mahdiolamaei]

i have a problem can someone help me? i have mysql db on cpanel and when i want to use it with python i don't know what to put in host in my python file.. can you help me?