Using MySQL Databases With Python

  • Overview
  • Curriculum
  • Instructor
  • Review

About This Course

Learn MySql Database With Python The Fast and Easy Way!

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



  • 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

Instructor

Profile photo of John Elder
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...

Review
4.9 course rating
4K ratings
ui-avatar of Wongsakorn Watcharananunt
Wongsakorn W.
4.5
7 months ago

very useful for my work. I can do a lot of things from this course.

  • Helpful
  • Not helpful
ui-avatar of Balaji Ganapathy
Balaji G.
4.5
8 months ago

good

  • Helpful
  • Not helpful
ui-avatar of beulah grace
Beulah G.
3.0
8 months ago

good

  • Helpful
  • Not helpful
ui-avatar of Nk
Nk
4.5
8 months ago

Liked the course and teaching style. Thank you.

  • Helpful
  • Not helpful
ui-avatar of Sonasman Roychowdhuri
Sonasman R.
5.0
10 months ago

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

  • Helpful
  • Not helpful
ui-avatar of Guy Birkbeck
Guy B.
4.0
10 months ago

Enjoying the Python side of things.

  • Helpful
  • Not helpful
ui-avatar of Andrea Sansa
Andrea S.
3.0
11 months ago

Troppo rilevante la parte dei programmi iniziali. Tra l'altro un po' confusionale.

  • Helpful
  • Not helpful
ui-avatar of Veeresh K
Veeresh K.
3.5
1 year ago

Thanks, good.

  • Helpful
  • Not helpful
ui-avatar of Joe
Joe
5.0
1 year ago

So far, so good.

  • Helpful
  • Not helpful
ui-avatar of D. K. Adithi Sri Gowri
D. K. A. S. G.
4.0
1 year ago

it was good

  • Helpful
  • Not helpful
Leave A Reply

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

Ratings

Courses You May Like

Lorem ipsum dolor sit amet elit
Show More Courses