Video Description
Learn the MySql Database with Python the fast and easy way!
About This Video
- Learn to use MySQL databases with Python
- Get to grips with adding, sorting and pulling specific data
In Detail
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.
Publisher Resources
Table of Contents
-
Chapter 1 : Introduction
- Introduction 00:02:16
- What Is A Database 00:05:15
- Install Python 00:04:53
- Install Git Bash Terminal 00:04:21
- Download MySQL 00:04:12
- Install MySQL and Workbench 00:07:48
- Install MySQL Connector 00:04:16
- Connect to Database in Python 00:05:39
- Explore MySQL Workbench 00:07:34
- Create A Database 00:07:13
- Create A Table 00:08:54
- Insert One Record into Table 00:05:39
- Insert Many Records into Table 00:05:40
- Understanding Data Types 00:04:52
- Select Data from Table 00:05:19
- Format Our Results 00:07:30
- The Where Clause 00:04:06
- The Like Clause and Wildcards 00:02:50
- Using AND and OR 00:03:41
- Updating Records 00:05:23
- Limit and Ordering 00:04:37
- Delete Records 00:02:44
- Delete (Drop) A Table and Backups 00:05:57
- Bonus Video 00:01:44
Product Information
- Title: Using MySQL Databases with Python
- Author(s):
- Release date: May 2019
- Publisher(s): Packt Publishing
- ISBN: 9781838984670