MySQL for Data Analysis and Business Intelligence

SQL is a powerful tool and one you will likely use often as a Data Analyst. It is one of the best skills an aspiring data analyst can learn. If you want to learn SQL for data analysis as a beginner with no experience in SQL, this is the course for you.

Learn SQL and build that boldness you need to apply for any data analyst job position.

Here are what you are going to learn in this course;

Lesson One: Introduction to SQL for Data Analysis

In this lesson, I explained everything you need to know about SQL for data analysis. I talked about why data analyst use SQL, database, how to create a database in My SQL Workbench and different types of databases.

Lesson Two: How to Import and Export Excel Files in MySQL Workbench

Do you know how to export your final results in SQL after your analysis? Do you know how to save SQL script and send to someone remotely in a different location?

This is what I covered in this lesson. You will learn how to import and export an Excel file in MySQL Workbench without experiencing any error.

Lesson Three: Basic SQL Queries

In this lesson, you will learn how to talk to database to extract data and run analysis using different SQL queries.

Lesson Four: SQL Joins

Aspiring Data Analysts need to know how to JOIN data. JOINS allow you to combine two or more tables. In this lesson, you will learn how to use the different types of SQL joins to join tables.

Lesson Five: SQL Data Cleaning

In this lesson, you will learn how to clean data in SQL as a data analyst.

Lesson Six: Subqueries

Subqueries are an excellent feature within SQL, which can save you from writing endless lines of unnecessary code. In this lesson, you will learn how to write subqueries to analyze data as a data analyst.

Lesson Seven: SQL Aggregate Functions

An aggregate function in SQL performs a calculation on multiple values and returns a single value. In this lesson, you will learn how to summarize data with simple functions like SUM, MIN, MAX, AVG, and COUNT.

And so much more!

In this course, the SQL environment used for analysis is MySQL Workbench. So, you will need to have MySQL Workbench on your computer to be able to learn SQL with this course.