MySQL for Data Analysis

Focused View

Joseph Okon

2:08:09

98 View

1. Introduction to SQL for Data Analysis.mp4

13:59

2. How to Import and Export Excel File in MySQL Workbench.mp4

08:30

3.1 Assignment.docx

3.2 Register.csv

3. Extracting Data from a Database with Basic Sequel Queries.mp4

14:04

4. Understanding SQL Joins.mp4

30:44

5. Subqueries in SQL.mp4

28:05

6. SQL Aggregate Functions.mp4

16:29

7. Grouping and Having Clause.mp4

16:18

Description

SQL for Beginners: Complete SQL Training for Data Analysts Who Want to Learn How to Use SQL for Data Analysis

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

Who is this for?

Beginners

More details

Description
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:
Beginners

User Reviews

Rating

average 0

Total votes0

Focused display

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.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.