SQL for Data Analysis- Beginner MySQL Business Intelligence

SQL for Data Analysis: Beginner MySQL Business Intelligence, available at $199.99, has an average rating of 4.7, with 118 lectures, 4 quizzes, based on 9207 reviews, and has 54270 subscribers.

You will learn about 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 wont find anywhere else Get LIFETIME access to resource files, quizzes, assignments, and expert support This course is ideal for individuals who are Analysts or BI professionals looking to quickly retrieve or analyze data stored in relational database systems or Excel users looking to shift into a broader business intelligence or database analytics role or Anyone seeking to learn one of the world’s most popular and powerful database programming languages (SQL) or Students looking for a hands-on and highly engaging introduction to MySQL for data modeling and analysis or Anyone looking to pursue a career in data analysis or business intelligence or NOTE: This course is NOT for database administrators (we wont cover tools to build or maintain databases in this course) It is particularly useful for Analysts or BI professionals looking to quickly retrieve or analyze data stored in relational database systems or Excel users looking to shift into a broader business intelligence or database analytics role or Anyone seeking to learn one of the world’s most popular and powerful database programming languages (SQL) or Students looking for a hands-on and highly engaging introduction to MySQL for data modeling and analysis or Anyone looking to pursue a career in data analysis or business intelligence or NOTE: This course is NOT for database administrators (we wont cover tools to build or maintain databases in this course).

Enroll now: SQL for Data Analysis: Beginner MySQL Business Intelligence

Summary

Title: SQL for Data Analysis: Beginner MySQL Business Intelligence

Price: $199.99

Average Rating: 4.7

Number of Lectures: 118

Number of Quizzes: 4

Number of Published Lectures: 103

Number of Published Quizzes: 4

Number of Curriculum Items: 122

Number of Published Curriculum Objects: 107

Original Price: $129.99

Quality Status: approved

Status: Live

What You Will 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 wont find anywhere else

Get LIFETIME access to resource files, quizzes, assignments, and expert support

Who Should Attend

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 analytics 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 modeling and analysis

Anyone looking to pursue a career in data analysis or business intelligence

NOTE: This course is NOT for database administrators (we wont cover tools to build or maintain databases in this course)

Target Audiences

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 analytics 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 modeling and analysis

Anyone looking to pursue a career in data analysis or business intelligence

NOTE: This course is NOT for database administrators (we wont cover tools to build or maintain databases in this course)

SQL and MySQL are incredibly powerful tools for managing and analyzing relational databases, and a skill that every Analyst and Business Intelligence 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 and MySQL Workbench, your mission is to learn everything that you can about your new business; including your inventory, staff, and customer behavior.

But don’t worry, you’re not alone! We’ll be right here to guide you from start to finish, sharing crystal clear explanations, MySQL pro tips and best practices, and course quizzes, projects and homework assignments to test your SQL data analysis and database analytics skills along the way.

COURSE OUTLINE:

SQL Intro & MySQL Setup

We’ll start with a quick intro to the SQL landscape and it’s common “flavors” (MySQL, SQLite, PostgreSQL, etc), then download and install the tools that we’ll need to access and explore our MySQL database (MySQL Community Server + MySQL Workbench)

SQL Database Fundamentals (Part 1)

Once we have our tools installed, we’ll quickly review some database fundamentals and begin to explore the 16 tables contained within our MySQL database, containing information about Maven Movies customers, inventory, and transactions.

Analyzing Data from Single Tables with MySQL

In this section we’ll start exploring and extracting information from individual tables in our MySQL database, and practice writing SQL queries to select, filter, sort and group our data for analysis and business intelligence.

[MID-COURSE MYSQL PROJECT]

SQL Database Fundamentals (Part 2)

The second half of the course is all about anayzing data from multiple tables in MySQL, so we’ll begin with a quick review of relational databases, data modeling and database analysis: primary vs. foreign keys, relationship cardinality, normalization, etc.

Analyzing Multiple Tables via MySQL JOINS

In this section, we’ll review the most common types of SQL joins (INNER, LEFT, RIGHT, OUTER, etc), and explore some more complex MySQL queries to analyze data that bridges multiple tables in our database.

[FINAL MYSQL PROJECT]

IMPORTANT NOTE: This course does NOT cover building, altering, or maintaining SQL/MySQL databases. Our goal here is to focus on data exploration and database analysis using MySQL and MySQL Workbench (we’ll cover database administration tools in a separate course).

______________________________

Enroll today and get LIFETIME access to:

5+ hours of high-quality video

Downloadable MySQL ebook

Quizzes and homework assignments

Mid-course and Final SQL projects

30-day money-back guarantee

If you’re looking for a hands-on, practical guide to mastering data analysis with SQL/MySQL, this is the course for you!

Happy analyzing!

-John (Lead SQL Instructor & MySQL Expert,Maven Analytics)

______________________________

Looking for the full business intelligence stack? Search for “Maven Analytics“ to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

See why this is one of the TOP RATED SQL/MySQL Courses on Udemy:

“Clear presentation of information and with enough repetition of important SQL concepts to help make the information memorable. Loved the frequent practice examples and code debugging exercises!”

– Maggi M.

“I totally loved this course! Everything was very easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much about MySQL and had fun doing it. In fact, at the end of the day I didn’t want to stop learning I wanted to keep charging on to the next lesson!”

– Ann S.

“John’s deep understanding of SQL and database analysis and ability to explain those tools to a newcomer with 0 experience, is really unmatched. I’ve taken other SQL and MySQL courses and tried reading books, but this course is by far the easiest way to understand SQL. Excited to see more courses from John!”

– Steven M.

Course Curriculum

Chapter 1: Getting Started

Lecture 1: Course Structure & Outline – MySQL Database for Beginners

Lecture 2: READ ME: Important Notes for New Students

Lecture 3: DOWNLOAD: Course Resources

Lecture 4: Introducing the Course Project – Play the Role of Business Analyst

Lecture 5: Setting Expectations – Focus on Business Analysis, NOT MySQL Administration

Chapter 2: MySQL Intro & Setup

Lecture 1: Introduction to Installing MySQL and MySQL Workbench for Beginners

Lecture 2: Why Learn SQL From Scratch? The Ultimate MySQL Bootcamp is Worth It!

Lecture 3: History & SQL Flavors (MySQL, MS SQL Server, SQL Lite, T SQL, Microsoft SQL)

Lecture 4: MySQL Installation Overview

Lecture 5: Mac Download – Community Server

Lecture 6: Mac Download – MySQL Workbench

Lecture 7: PC Download – Community Server + Workbench

Lecture 8: Connecting Workbench to the Server

Lecture 9: MySQL Workbench Interface

Lecture 10: Creating the Maven Movies Database

Chapter 3: Single Table Analysis (PART 1)

Lecture 1: Introduction to Databases and SQL Querying

Lecture 2: Getting to Know the Database

Lecture 3: The Big 6 Statements and Clauses of SQL Queries

Lecture 4: The SELECT Statement – Your SQL Querying Starts Here

Lecture 5: The FROM Clause – Tell the Server Which Table Your SQL Query Will Pull Data From

Lecture 6: SELECT * FROM

Lecture 7: The USE Statement

Lecture 8: Selecting Specific Columns

Lecture 9: ASSIGNMENT: SELECT & FROM

Lecture 10: SOLUTION: SELECT & FROM

Lecture 11: SELECT DISTINCT

Lecture 12: ASSIGNMENT: SELECT DISTINCT

Lecture 13: SOLUTION: SELECT DISTINCT

Lecture 14: The WHERE Clause

Lecture 15: Common WHERE Operators

Lecture 16: ASSIGNMENT: The WHERE Clause

Lecture 17: SOLUTION: The WHERE Clause

Lecture 18: Combining WHERE & AND

Lecture 19: ASSIGNMENT: WHERE & AND

Lecture 20: SOLUTION: WHERE & AND

Lecture 21: Combining WHERE & OR

Lecture 22: ASSIGNMENT: WHERE & OR

Lecture 23: SOLUTION: WHERE & OR

Lecture 24: Combining WHERE & IN

Lecture 25: The LIKE Operator

Lecture 26: LIKE Wildcard Examples

Lecture 27: ASSIGNMENT: The LIKE Operator

Lecture 28: SOLUTION: The LIKE Operator

Lecture 29: The GROUP BY Clause

Lecture 30: GROUP BY Example

Lecture 31: PRO TIP: Using Comments & Aliases

Lecture 32: ASSIGNMENT: GROUP BY

Lecture 33: SOLUTION: GROUP BY

Lecture 34: Multiple Dimension GROUP BY Clauses

Lecture 35: Grouping with Aggregate Functions

Lecture 36: ASSIGNMENT: Aggregate Functions

Lecture 37: SOLUTION: Aggregate Functions

Lecture 38: The HAVING Clause

Lecture 39: HAVING Example

Lecture 40: ASSIGNMENT: The HAVING Clause

Lecture 41: SOLUTION: The HAVING Clause

Lecture 42: The ORDER BY Clause

Lecture 43: ORDER BY Example

Lecture 44: ASSIGNMENT: The ORDER BY Clause

Lecture 45: SOLUTION: The ORDER BY Clause

Lecture 46: RECAP: The Big 6

Chapter 4: Single Table Analysis (PART 2)

Lecture 1: The CASE Statement

Lecture 2: CASE Example

Lecture 3: Common CASE Operators

Lecture 4: ASSIGNMENT: The CASE Statement

Lecture 5: SOLUTION: The CASE Statement

Lecture 6: PRO TIP: Pivoting with COUNT & CASE

Lecture 7: COUNT & CASE Demo

Lecture 8: ASSIGNMENT: COUNT & CASE

Lecture 9: SOLUTION: COUNT & CASE

Chapter 5: MID-COURSE PROJECT

Lecture 1: Mid-Course Project Intro

Lecture 2: SOLUTION: Mid-Course Project

Chapter 6: Analyzing Multiple Tables with Joins

Lecture 1: Introduction to SQL JOINs and Querying Multiple Tables

Lecture 2: Normalization & Cardinality

Lecture 3: Relationship Diagrams

Lecture 4: Multi-Table Querying

Lecture 5: Reviewing the Maven Movies Database

Lecture 6: Common JOIN Types

Lecture 7: INNER JOIN

Lecture 8: INNER JOIN Example

Lecture 9: ASSIGNMENT: INNER JOIN

Lecture 10: SOLUTION: INNER JOIN

Lecture 11: LEFT JOIN

Lecture 12: LEFT JOIN Example

Lecture 13: ASSIGNMENT: LEFT JOIN

Lecture 14: SOLUTION: LEFT JOIN

Lecture 15: RIGHT JOIN

Lecture 16: LEFT vs. INNER vs. RIGHT JOIN

Lecture 17: FULL OUTER JOIN

Lecture 18: PRO TIP: Bridging Unrelated Tables

Lecture 19: ASSIGNMENT: Bridging Tables

Instructors

Maven Analytics
Empowering everyday people with life-changing data skills

John Pauler
Analytics Expert

Rating Distribution

1 stars: 32 votes

2 stars: 36 votes

3 stars: 447 votes

4 stars: 2825 votes

5 stars: 5870 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!