Using 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
Khám phá thêm các khoá học cùng chủ đề
Job Ready Programmer
Academind by Maximilian Schwarzmüller
Database Masters | 300,000+ Successful Students Worldwide
Database Masters | 300,000+ Successful Students Worldwide
Phillip Burton • over one million students so far
Amarnath Reddy
Stephen Grider
Carlos DL
Colt Steele
365 Careers
Tim Buchalka's Learn Programming Academy
Edwin Diaz | 900,000+ Students
A Course You'll Actually Finish
Maven Analytics • 1,500,000 Learners
Maven Analytics • 1,500,000 Learners
Al Sweigart
Ardit Sulce • 600,000+ Students Worldwide
Horizon Tech
Dr. Fred Baptiste
Bryson Payne
Colt Steele
Start-Tech Academy
365 Careers
365 Careers
Job Ready Programmer
Tim Buchalka's Learn Programming Academy
Start-Tech Academy
