Latest Courses
Build a Complete Youtube Video App: Swift2.2 & 3 and XcodeCheck course
Shopify Mastery | Build a Shopify Store in Just 1 HourCheck course
Java Regular Expression FoundationCheck course
Agile Software Testing - Techniques and ToolsCheck course
Python Programming Skills Test With ExplanationCheck course
Beginners Eclipse Java IDE Training CourseCheck course
Xamarin Android - A Master Guide to App Development in C#Check course
Python for beginnersCheck course
Salesforce Integration With External SystemsCheck course
Game Audio 101 & 201: Beginner to Advanced Game Sound DesignCheck course
Build a Complete Youtube Video App: Swift2.2 & 3 and XcodeCheck course
Shopify Mastery | Build a Shopify Store in Just 1 HourCheck course
Java Regular Expression FoundationCheck course
Agile Software Testing - Techniques and ToolsCheck course
Python Programming Skills Test With ExplanationCheck course
- 86% Using MySQL Databases With Python

Using MySQL Databases With Python

$94.99 $12.99Track price

Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare
8.0/10 (Our Score)
Product is rated as #190 in category SQL

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

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.

Specification: Using MySQL Databases With Python

Duration 2 hours
Year 2020
Level Beginner
Certificate Yes
Quizzes No

28 reviews for Using MySQL Databases With Python

4.2 out of 5
17
5
4
2
0
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. Pavan Kumar

    Pavan Kumar

    Expecting more stuff.

    Helpful(0) Unhelpful(0)You have already voted this
  2. Avatar

    Christina Kidd

    in a few videos already learning loads have a good feeling about this course

    Helpful(0) Unhelpful(0)You have already voted this
  3. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  4. Avatar

    Elena cellitti

    Really well explained and easily takes you through the different steps.

    Helpful(0) Unhelpful(0)You have already voted this
  5. Avatar

    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 🙂

    Helpful(0) Unhelpful(0)You have already voted this
  6. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  7. Avatar

    Johan Swan

    Excellent course and well explained will help me with SQL in Python

    Helpful(0) Unhelpful(0)You have already voted this
  8. Avatar

    Tim OBrien

    perfect

    Helpful(0) Unhelpful(0)You have already voted this
  9. Avatar

    Pothen Plackottu Thomas

    Yes . . Good for me

    Helpful(0) Unhelpful(0)You have already voted this
  10. Avatar

    Vaibhav Pharate

    It was basic and helpful.

    Helpful(0) Unhelpful(0)You have already voted this
  11. Avatar

    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!!

    Helpful(0) Unhelpful(0)You have already voted this
  12. Avatar

    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 …

    Helpful(0) Unhelpful(0)You have already voted this
  13. Avatar

    Dr Paul F Hannaford

    Excellent course, clearly explained.

    Helpful(0) Unhelpful(0)You have already voted this
  14. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  15. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  16. Avatar

    Samer Hussein

    Well structured. Dynamic teaching.

    Helpful(0) Unhelpful(0)You have already voted this
  17. Avatar

    Jamel metmati

    yes it is precise for me for the course remember to me what I did before without to restart again Sql Manual

    Helpful(0) Unhelpful(0)You have already voted this
  18. Avatar

    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 : )

    Helpful(0) Unhelpful(0)You have already voted this
  19. Avatar

    Matthew Billman

    Not usable on mac. Accompanying Facebook help group has a lot of toxic commentators.

    Helpful(0) Unhelpful(0)You have already voted this
  20. Avatar

    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…

    Helpful(0) Unhelpful(0)You have already voted this
  21. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  22. Avatar

    Lohith Aditya Kolli

    Yes, I really appreciate the teaching style very handy,interpretable.

    Helpful(0) Unhelpful(0)You have already voted this
  23. Avatar

    Sivasankar P

    ok

    Helpful(0) Unhelpful(0)You have already voted this
  24. Avatar

    Jimmy Haddad

    educator was on point; for a beginner i really was able to grasp what he presented

    Helpful(0) Unhelpful(0)You have already voted this
  25. Avatar

    Rod Jewell

    awesome course!

    Helpful(0) Unhelpful(0)You have already voted this
  26. Avatar

    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

    Helpful(0) Unhelpful(0)You have already voted this
  27. Avatar

    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.

    Helpful(0) Unhelpful(0)You have already voted this
  28. Avatar

    Bretton Holmes

    Jam packed with awesome info in just two hours!

    Helpful(0) Unhelpful(0)You have already voted this

    Add a review

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Using MySQL Databases With Python

    $94.99 $12.99

    Price tracking

    Register New Account
    Reset Password
    Compare items
    • Total (0)
    Compare