Using Mysql Databases With Python

What you'll learn
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
You'll Learn How To Create a Database and Table
How to put data in and take data out using Python
How to update and delete data from the database
How to explore what's in the database whenever you want
How to create basic reports with the data from your database
Requirements
A Basic Understanding Of Python Programming Would Be Helpful
You don't need any special tools, we'll download everything we need for free. You just need a Windows, Mac, or Linux computer
Description
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 DatabaseHow To Install PythonHow To Install Git Bash TerminalHow To Download MySQLHow To Install MySQL and WorkbenchHow To Install MySQL ConnectorHow To Connect to Database in PythonHow To Explore The MySQL WorkbenchHow To Create A DatabaseHow To Create A TableHow To Insert One Record Into TableHow To Insert Many Records Into TableUnderstanding Data TypesHow To Select Data From TableHow To Format Our ResultsHow To Use The Where ClauseHow To Use The Like Clause and WildcardsHow To Use AND and ORHow To Updating RecordsHow To Limit and Order ResultsHow To Delete RecordsHow To Delete (Drop) A Table And BackupsAnd 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
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 First Things First: How To Get Support Fast!
Lecture 3 What Is A Database
Lecture 4 Install Python
Lecture 5 Install Git Bash Terminal
Lecture 6 Download MySQL
Lecture 7 Install MySQL and Workbench
Lecture 8 Install MySQL Connector
Lecture 9 Connect to Database in Python
Lecture 10 Explore MySQL Workbench
Lecture 11 Create A Database
Lecture 12 Create A Table
Lecture 13 Insert One Record Into Table
Lecture 14 Insert Many Records Into Table
Lecture 15 Understanding Data Types
Lecture 16 Select Data From Table
Lecture 17 Format Our Results
Lecture 18 The Where Clause
Lecture 19 The Like Clause and Wildcards
Lecture 20 Using AND and OR
Lecture 21 Updating Records
Lecture 22 Limit and Ordering
Lecture 23 Delete Records
Lecture 24 Delete (Drop) A Table And Backups
Lecture 25 Bonus Lecture
Anyone who wants to use the MySQL Database with Python


Homepage

https://www.udemy.com/course/using-mysql-databases-with-python/