John Elder
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
Instructor Details
Courses : 46
Specification: Using MySQL Databases With Python
|
31 reviews for Using MySQL Databases With Python
Add a review
| Price | $17.99 |
|---|---|
| Provider | |
| Duration | 2 hours |
| Year | 2021 |
| Level | Beginner |
| Language | English |
| Certificate | Yes |
| Quizzes | No |
$17.99
Pavan Kumar –
Expecting more stuff.
Christina Kidd –
in a few videos already learning loads have a good feeling about this course
Doug Sigman –
I’m an old programmer looking to update my skills. I was distracted when he didn’t know basic stuff like the difference between CHAR and VARCHAR (VARCHAR is Variable length text, so it stores a length value and the trimmed data CHAR uses the same number of characters every time). There were other examples. I did learn what I wanted to learn, but I could have quit about half way through I use SQL every day at work and didn’t learn anything from the last half.
Elena cellitti –
Really well explained and easily takes you through the different steps.
Janusz Bibi –
Straight to the point and very useful. Used it as a supplementary course for my databases course at the university. Would recommend to anyone 🙂
Renata Bade –
John did a really good job in breaking down the basics. The explanations allowed me to follow along and give me a strong base to dive deeper.
Johan Swan –
Excellent course and well explained will help me with SQL in Python
Tim OBrien –
perfect
Pothen Plackottu Thomas –
Yes . . Good for me
Vaibhav Pharate –
It was basic and helpful.
Michael Eilers –
12/31/19 Overall this course was great. This course taught me the skills I needed to be able to develop code utilizing MySQL with Python, which was what I wanted out of the course. It pertains to the basics of using a database: create a database, create a table, update records, delete records and tables, read from the database, and a few extras along the way. I did have some small issues with installation, but I was able to figure it out on my own. With Sublime, you have to specify .py in the filename or it won’t acknowledge it as a python program even after setting the language. Also, it is recommended to restart your computer once you install GitBash because when you do the MySQL connector implementation, it won’t recognize the ‘pip’ command. Everything else was great as mentioned. I look foward to another course by John. Thanks!!
Matan Altman –
i think its great so far ,but i wish it will be longer that its deals with import data to table for excel sheet for example .and i think the format of sublime isn’t the best. usually python goes with Jupiter,spider, visual studio …
Dr Paul F Hannaford –
Excellent course, clearly explained.
Kenneth Beaty –
Great class. I had a small amount of Python, and no mySQL experience. I like John’s pace and approach to this class. I feel like I got a great introduction, and I am ready to handle more complex sql databases. The bonus was learning about mySQL workbench.
Hulk Smash –
at first I was kinda nervous because I have entry level knowledge of both python and sql but I learned so much. it was easy to follow.
Samer Hussein –
Well structured. Dynamic teaching.
Jamel metmati –
yes it is precise for me for the course remember to me what I did before without to restart again Sql Manual
Keith K –
John’s a very good teacher. This is a pretty basic course when it comes to mysql depth but if you don’t know anything about integration between python and mysql then you will definitely learn something here, plus I found out about git bash so thank you for that : )
Matthew Billman –
Not usable on mac. Accompanying Facebook help group has a lot of toxic commentators.
Matt Bunker –
I recently learn a little Python for HTML but needed to know how to connect this new language in my WebDev toolbox to a Mysql database… this course was a great introduction to how Python and Mysql communicate… the only thing missing was a project to work on throughout the class… but the examples were good enough that they covered the same information a project would… so I wouldn’t really say that the lack of one was a flaw…
Sanket Mehta –
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.
Lohith Aditya Kolli –
Yes, I really appreciate the teaching style very handy,interpretable.
Sivasankar P –
ok
Jimmy Haddad –
educator was on point; for a beginner i really was able to grasp what he presented
Rod Jewell –
awesome course!
Balanarayanan PV –
If you know atleast a little bit of python atleast the for loop part this course is a gift for you. This guy is very funny in his videos and breraks down all the parts and explains it beautifully. I genuinly liked this course very much. Thanks Jhon for provinding me such an amazing course
Vishnu Rajendran –
Nice course, kept it simple and not tried to make too lengthy. Helps in interview preparation where we don’t have much time for a 10 or 20 hour course.
Bretton Holmes –
Jam packed with awesome info in just two hours!
William Philip C. Herico –
Detailed explanation. Great tool as an addition to anybody’s python knowledge.
Aviv Goldgamer –
great course’ great going over fundamentals, i think this course could go deeper into more complicated things. i liked the course very much and it did help me a lot 🙂
Santhanamuthu Nagarajan –
Nice so far