Explore the quick and easy way to learn the MySQL Database with Python

Today databases are highly valued as they allow users to effectively manage, access, and update data. MySQL is one of the most popular databases and has a wide variety of applications in e-commerce, data warehousing, and website management. When combined with Python, one of the most popular and powerful programming languages today, you'll be able to manage data efficiently and systematically. In this course, you'll get started by understanding the basics of using MySQL with Python. You'll learn how to install MySQL and Python, before going on to develop databases. In addition to this, you'll explore the technique of creating tables for safely storing data. The course will then guide you on how to add, sort, and retrieve data through functions such as INSERT, ORDER BY, and SELECT. As you progress, you'll be equipped with the knowledge of inserting a single record as well as multiple records into a table. Toward the end, you will discover clauses such as WHERE and LIKE, and later learn to update records. By the end of this course, you will have learned how to confidently use Python with MySQL for your database management needs. All code files are placed at https://github.com/PacktPublishing/Using-MySQL-Databases-With-Python

What You Will Learn

Get up to speed with the working of a database
Understand how to install Python, MySQL, Git Bash, and MySQL Connector
Work through creating a table
Explore how to connect to a database in Python
Update and delete data from the database
Discover the technique of inserting a single record as well as multiple records into a table
Create basic reports with the data from your database

Audience

This course is for anyone who wants to use the MySQL Database with Python. Although a basic understanding of Python programming is required, knowledge of databases or MySQL is not necessary.

Approach

A complete course packed with step-by-step instructions, working examples, and helpful advice.

Key Features

Learn to use MySQL databases with Python * Get to grips with adding, sorting and pulling specific data

Github Repo

https://github.com/packtpublishing/using-mysql-databases-with-python

About the Author

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 in over 45 countries. John graduated with honors with a degree in economics from Washington University in St. Louis where he was an artsci scholar. Today he teaches Web Development courses at Codemy the online code school he founded.

Course Outline

1. Introduction

2. What is a Database

3. Install Python

4. Install Git Bash Terminal

5. Download MySQL

6. Install MySQL and Workbench

7. Install MySQL Connector

8. Connect to Database in Python

9. Explore MySQL Workbench

10. Create a Database

11. Create a Table

12. Insert One record into table

13. Insert Many records into Table

14. Understanding Data Types

15. Select Data from Table

16. Format our results

17. The Where Clause

18. Using AND and OR

19. The Like Clause and Wild cards

20. Updating Records

21. Limit and Ordering

22. Delete Records

23. Delete (Drop) a Table and Backups