Learn how to explore and analyze relational databases with MySQL, by solving real-world assignments and exercises.

In this course, you'll play the role of a business owner who just acquired Maven Movies, a brick and mortar DVD rental shop.

Using only a MySQL database, your job is to learn everything you can about your new business, including inventory, staff, and customer behavior.

We'll start with a quick intro to the SQL language, address some key database fundamentals, and use MySQL to select, filter, sort and group data from individual tables.

From there we'll shift into more complex use cases, and blend data across multiple tables with JOIN queries.

If you're looking for a hands-on, practical guide to learning data analysis with SQL, this is the course for you.

WHO SHOULD TAKE THIS COURSE?

• Excel users who want to query and analyze data stored in a relational database
• Anyone looking to build foundational database skills and learn one of the world's most popular database programming languages

WHAT ARE THE COURSE REQUIREMENTS?

• MySQL Workbench and Community Server (we'll walk you through the install process)
• Experience with database fundamentals encouraged, but not required