MySQL for Data Analysis and Business Intelligence
What you'll learn
- Introduction to SQL for Data Analysis
- How to Import and Export Excel File in MySQL Workbench
- Extracting Data from a Database with Basic Sequel Queries
- Understanding SQL Joins
- SQL Data Cleaning
- SQL Data Cleaning 2
- SQL Subqueries
- SQL Aggregate Functions
- Grouping and Having Clause
- Installation of MySQL Workbench
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.
Who this course is for:
Joseph Okon is a Data Analyst with years of experience. He is a mentor and a coach. He has trained more than 500 students in the field of Data Analysis.
He also share video tutorials and guides on how to use Microsoft Excel and SQL for data analysis via his YouTube channel.