Company: Packt Publishing Author: John Elder Full Title: Using MySQL Databases With Python Year: 2019 Language: English Genre: Educational: Application development Skill Level: - Price: €183.99 - Files: MP4 (+ Exercise Files) Time: 02:02:14 Video: AVC, 1920 x 1080 (1.778) at 30.000 fps, 400 kbps Audio: AAC at 137 Kbps, 2 channels, 48.0 KHz Learn the MySql Database with Python the fast and easy way!. 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 of 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 course, we'll assume you that 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. Style and Approach: A complete course packed with step-by-step instructions, working examples, and helpful advice. 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 ✓ Create a database and table ✓ Put data in and take data out using Python ✓ Update and delete data from the database ✓ Explore what's in the database whenever you want ✓ Create basic reports with the data from your database Features: ✓ Learn to use MySQL Databases with Python ✓ Learn to create databases and tables, add data, sort data, create reports, pull specific data, and more Lessons: 1. Introduction 01. Introduction 02. What Is A Database 03. Install Python 04. Install Git Bash Terminal 05. Download MySQL 06. Install MySQL and Workbench 07. Install MySQL Connector 08. Connect to Database in Python 09. 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. The Like Clause and Wildcards 19. Using AND and OR 20. Updating Records 21. Limit and Ordering 22. Delete Records 23. Delete (Drop) A Table and Backups 24. Bonus Video Our members see more. Join us! ------------- Our members see more. Join us!