MySQL Workbench and Community Server for Mac or Windows/PC (we’ll walk you through the free install process) Basic understanding of database fundamentals encouraged, but not required Who this course is for. MySQL Cheat Sheet. Help with SQL commands to interact with a MySQL database. MySQL Locations. Mac /usr/local/mysql/bin; Windows /Program Files/MySQL/MySQL version/bin.
SQL for Data Analysis: Beginner MySQL Business Intelligence
Learn SQL database querying w/ MySQL Workbench. Perfect for SQL beginners and first-time coders.
What you’ll learn
- Write SQL queries to explore and analyze databases with MySQL Workbench
- Learn how to use SQL to extract, sort, filter, and group data quickly and efficiently
- Analyze data across multiple tables with powerful MySQL JOIN statements
- Solve practical hands-on assignments and real-world business use cases
- Master unique tips, tools and case studies that you won’t find anywhere else
- Get LIFETIME access to resource files, quizzes, assignments, and expert support
Requirements
- MySQL Workbench and Community Server for Mac or Windows/PC (we’ll walk you through the free install process)
- Basic understanding of database fundamentals encouraged, but not required
Who this course is for:
Mysql Administrator Mac
- Analysts or BI professionals looking to quickly retrieve or analyze data stored in relational database systems
- Excel users looking to shift into a broader business intelligence or database-focused role
- Anyone seeking to learn one of the world’s most popular and powerful database programming languages (SQL)
- Students looking for a hands-on and highly engaging introduction to MySQL for data analysis
- Anyone looking to pursue a career in data analysis or business intelligence
- NOTE: This course is NOT for database administrators (we won’t cover tools to build or maintain databases in this course)