MySQL Database Development Mastery

Preview this course
30-Day Money-Back Guarantee
Full Lifetime Access.

- OR -

Get this course, plus 250+ of our top-rated AI & Data courses, with a Subscription.
Enjoy a Free Trial. Cancel Anytime.
33 on-demand videos & exercises
Level: Intermediate
English
4hrs 19mins
Access on mobile, web and TV

Who's this course for?

Whether you are a beginner-level or an experienced database administrator or developer looking to get familiar with MySQL Server and MySQL Workbench database development techniques, this course is for you. You can get started with this course without any prior knowledge of database concepts.

What you'll learn

  • Familiarize yourself with MySQL Server and MySQL Workbench.
  • Find out how to create a database from scratch.
  • Manipulate data and tables with CRUD operations.
  • Create relationships with the Workbench table design tool.
  • Use aggregate functions to perform quick mathematical operations.
  • Export your query results to an Excel sheet using MySQL Workbench.

Key Features

  • Discover how to create and manage databases in MySQL Server and MySQL Workbench.
  • Gain a comprehensive understanding of SQL queries, statements, and structures.
  • Build a small school management database to understand the development principles of a database.

Course Lessons

What to know about this course

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

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.