Using MySQL Databases With Python

Using MySQL Databases With Python, available at $64.99, has an average rating of 4.41, with 29 lectures, based on 1313 reviews, and has 10576 subscribers.

You will learn about 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 This course is ideal for individuals who are Anyone who wants to use the MySQL Database with Python It is particularly useful for Anyone who wants to use the MySQL Database with Python.

Enroll now: Using MySQL Databases With Python

Summary

Title: Using MySQL Databases With Python

Price: $64.99

Average Rating: 4.41

Number of Lectures: 29

Number of Published Lectures: 25

Number of Curriculum Items: 29

Number of Published Curriculum Objects: 25

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Anyone who wants to use the MySQL Database with Python

Target Audiences

Anyone who wants to use the MySQL Database 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

Course Curriculum

Chapter 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

Instructors

John Elder
Founder of Codemy

Rating Distribution

1 stars: 14 votes
2 stars: 31 votes
3 stars: 182 votes
4 stars: 458 votes
5 stars: 628 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu