MySQL for Data Analysis (2023)

Complete MySQL Practical Training 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 Subqueries
SQL Aggregate Functions
Grouping and Having Clause
Requirements
Installation of MySQL Workbench
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.In this course, you will learn;How to Import and Export Excel Files in MySQL Workbench: In this lesson, you will learn how to import and export any Excel file in MySQL Workbench without experiencing any error.Basic SQL Queries: This has to do with how to extract data from databases by writing basic SQL queries.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. Aggregate Functions: In this lesson, you will learn how to summarize data with simple functions like SUM, MIN, MAX, AVG, and COUNT.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
Homepage