MySQL for Data Analysis
MySQL for Data Analysis
Published 02/2023
Duration: 02:08:09 | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 904 MB
Genre: eLearning | Language: English
Published 02/2023
Duration: 02:08:09 | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 904 MB
Genre: eLearning | Language: English
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
More Info