Explanation
SQL and MySQL are very powerful tools for managing and analyzing related data, and skills every Analyst and Business Intelligence Professional should be in the arsenal. In this course, you will play the role of a business owner who has just acquired Maven Movies, a brick and mortar DVD rental store. By using only MySQL databases and MySQL Workbench, your goal is to learn everything you can about your new business; including your products, staff, and customer behavior.
But don’t worry, you’re not alone! We’re here to guide you from start to finish, sharing clear explanations, MySQL pro tips and best practices, and course questions, projects and homework to test your SQL and data analysis skills along the way. This course does NOT cover building, modifying, or maintaining SQL/MySQL databases. Our goal here is to focus on data exploration and data analysis using MySQL and MySQL Workbench (we’ll cover database management tools in a separate course).
What will you learn?
- Write SQL queries to explore and analyze databases in MySQL Workbench
- Learn how to use SQL to retrieve, sort, filter, and group data quickly and efficiently
- Analyze data across multiple tables with powerful MySQL join statements
- Solve practical tasks and real-world business use cases
- Learn exclusive tips, tools and tutorials you won’t find anywhere else
Who is this course for?
- Analysts or BI professionals looking to quickly retrieve or analyze data stored in database systems.
- Excel users looking to transition into a broader business intelligence or data crunching role
- Anyone who wants to learn one of the world’s most popular database programming languages (SQL)
- Students looking for a hands-on and highly engaging introduction to MySQL for database analysis.
- Anyone looking to pursue a career in data analysis or business intelligence
- NOTE: This course is not intended for database administrators (we will not cover tools for building or maintaining databases in this course)
Specificatoin of SQL for Data Analysis: An Introduction to MySQL Business Intelligence
The essence
SQL Requirements for Data Analysis: An Introduction to MySQL Business Intelligence
- MySQL Workbench and Community Server for Mac or Windows/PC (we’ll walk you through the free installation process)
- A basic understanding of database fundamentals is encouraged, but not required
Pictures
Sample Clip
Installation Guide
Extract files and watch your favorite player
Subtitle: English
Quality: 720p
Changes:
Version 2023/9 compared to 2022/4 has increased duration by 1 minute.
Download Links
Password file: www.downloadly.ir
file size
1.21 GB