MySQL for Data Analysis

54mBeginner2022-05-20

Authors

Ava Meredith

Information Management and Data Science Professor

Course details

You don’t need to wield high-level tools to start interacting with your data now. With a basic knowledge of MySQL, you’re just about ready to go. In this course, instructor Ava Meredith shows you how to use the MySQL database to manipulate, aggregate, summarize, and analyze data more effectively.

Find out how to get the most out of MySQL from a power user by learning how to retrieve data, join tables, and write subqueries and complex queries. Explore aggregate, numeric, string, and date and time functions, as well as other built-in functions to work with different data types. Get quick tips and expert tricks on best practices for navigating within the database, building up your skill set as a data analyst, and taking your productivity to the next level.

Skills covered

MySQLDatabase DevelopmentDatabase ManagementOpen SourceSoftware DevelopmentOne-Off

Concepts

0. Introduction

01 - Why MySQL
02 - What you should know

1. Exploring Data from a Single Table

03 - Exploring the database
04 - Most common MySQL data types
05 - Selecting column data
06 - Selecting rows of data
07 - Inserting, modifying, and deleting rows of data

2. Exploring Data from Multiple Tables

08 - Coding table joins and table aliases

3. Using Aggregate Functions to Summarize Data

09 - Using aggregate functions to gain summarized data insights

4. Using Subqueries to Refine Your Data Exploration

10 - Coding and when to use subqueries and correlated subqueries

5. Using Built-In Functions to Work with Different Data Types

11 - Working with numeric data
12 - Working with textual data
13 - Working with date and time functions

Conclusion

14 - Explore and keep learning