Descriptions
MySQL Data Analysis, MySQL is a powerful tool for managing and analyzing relational databases, and a skill that every analyst and BI professional should have in the arsenal. In this course, you’ll play the role of a business owner who just acquired Maven Movies, a brick and mortar DVD rental shop. Using only a MySQL database, your job is to learn everything you can about your new business, including inventory, staff, and customer behavior. We’ll start with a quick intro to the SQL language, address some key database fundamentals, and use MySQL to select, filter, sort and group data from individual tables. From there we’ll shift into more complex use cases, and blend data across multiple tables with JOIN queries. If you’re looking for a hands-on, practical guide to learning data analysis with MySQL, this is the course for you.
What you’ll learn
- Identify key components of the broader SQL landscape, including history, common tools, common flavors, and benefits
- Identify the functionality of the Big 6 SQL statements and clauses: SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY
- Identify and interpret the results of SQL statements, including database queries and error messages
- Identify aggregate functions used to analyze groups of rows in SQL, including COUNT, SUM, MAX, AVG, and COUNT DISTINCT
- Identify MySQL pro tips and their common use cases, including commenting, aliases, pattern matching, and the IN operator
- Identify the proper syntax for the CASE statement, and interpret CASE statement processing and results
Who this course is for
- Analysts or BI professionals looking to quickly retrieve or analyze data stored in relational database systems
- Excel users looking to shift into a broader BI-focused role
- Anyone seeking to learn one of the world’s most popular database programming languages
Specificatoin of MySQL Data Analysis
- Publisher : Maven Analytics
- Teacher : John Pauler
- Language : English
- Level : All Levels
- Duration : 8 hours and 0 minutes
Content of MySQL Data Analysis
Requirements
- MySQL Workbench and Community Server (we’ll walk you through the install process)
- Experience with database fundamentals encouraged, but not required
Pictures
Sample Clip
Installation Guide
Extract the files and watch with your favorite player
Subtitle : English
Quality: 1080p
Download Links
Downloadly
Rapidgator
Password file(s): www.downloadly.ir
File size
912 MB
