SQL for Data Analysis: Beginner MySQL Business Intelligence

Focused View

Maven Analytics,John Pauler

4:27:33

3 View

01 - Getting Started

001 Course Structure & Outline - MySQL Database for Beginners.mp4

01:36

002 READ ME Important Notes for New Students.html

003 DOWNLOAD Course Resources.html

003 MySQL-Data-Analysis.pdf

003 create-mavenmovies.zip

003 create-mavenmovies-vapril2022.zip

003 mavenmovies-final-course-project.zip

003 mavenmovies-final-course-project-solution.zip

003 mavenmovies-mid-course-project.zip

003 mavenmovies-mid-course-project-solution.zip

004 Introducing the Course Project - Play the Role of Business Analyst.mp4

00:33

005 Setting Expectations - Focus on Business Analysis, NOT MySQL Administration.mp4

01:19

02 - MySQL Intro & Setup

001 Introduction to Installing MySQL and MySQL Workbench for Beginners.mp4

00:19

002 Why Learn SQL From Scratch The Ultimate MySQL Bootcamp is Worth It!.mp4

01:09

003 History & SQL Flavors (MySQL, MS SQL Server, SQL Lite, T SQL, Microsoft SQL).mp4

02:25

004 MySQL Installation Overview.mp4

01:21

005 Mac Download - Community Server.mp4

04:53

006 Mac Download - MySQL Workbench.mp4

02:51

007 PC Download - Community Server + Workbench.mp4

07:41

008 Connecting Workbench to the Server.mp4

01:56

009 MySQL Workbench Interface.mp4

01:37

010 Creating the Maven Movies Database.mp4

01:37

03 - Single Table Analysis (PART 1)

001 Introduction to Databases and SQL Querying.mp4

00:25

002 Getting to Know the Database.mp4

03:52

003 The Big 6 Statements and Clauses of SQL Queries.mp4

02:18

004 The SELECT Statement - Your SQL Querying Starts Here.mp4

00:47

005 The FROM Clause - Tell the Server Which Table Your SQL Query Will Pull Data From.mp4

00:39

006 SELECT FROM.mp4

06:00

007 The USE Statement.mp4

03:19

008 Selecting Specific Columns.mp4

04:18

009 ASSIGNMENT SELECT & FROM.mp4

01:24

010 SOLUTION SELECT & FROM.mp4

02:38

011 SELECT DISTINCT.mp4

02:13

012 ASSIGNMENT SELECT DISTINCT.mp4

00:39

013 SOLUTION SELECT DISTINCT.mp4

02:00

014 The WHERE Clause.mp4

01:30

015 Common WHERE Operators.mp4

04:59

016 ASSIGNMENT The WHERE Clause.mp4

00:35

017 SOLUTION The WHERE Clause.mp4

02:23

018 Combining WHERE & AND.mp4

04:22

019 ASSIGNMENT WHERE & AND.mp4

00:39

020 SOLUTION WHERE & AND.mp4

01:37

021 Combining WHERE & OR.mp4

03:38

022 ASSIGNMENT WHERE & OR.mp4

00:42

023 SOLUTION WHERE & OR.mp4

03:22

024 Combining WHERE & IN.mp4

04:35

025 The LIKE Operator.mp4

02:37

026 LIKE Wildcard Examples.mp4

05:06

027 ASSIGNMENT The LIKE Operator.mp4

00:30

028 SOLUTION The LIKE Operator.mp4

02:28

029 The GROUP BY Clause.mp4

01:43

030 GROUP BY Example.mp4

03:18

031 PRO TIP Using Comments & Aliases.mp4

05:32

032 ASSIGNMENT GROUP BY.mp4

00:37

033 SOLUTION GROUP BY.mp4

02:01

034 Multiple Dimension GROUP BY Clauses.mp4

03:14

035 Grouping with Aggregate Functions.mp4

02:08

036 ASSIGNMENT Aggregate Functions.mp4

00:55

037 SOLUTION Aggregate Functions.mp4

03:23

038 The HAVING Clause.mp4

01:44

039 HAVING Example.mp4

02:54

040 ASSIGNMENT The HAVING Clause.mp4

00:55

041 SOLUTION The HAVING Clause.mp4

03:11

042 The ORDER BY Clause.mp4

01:31

043 ORDER BY Example.mp4

04:16

044 ASSIGNMENT The ORDER BY Clause.mp4

00:30

045 SOLUTION The ORDER BY Clause.mp4

01:47

046 RECAP The Big 6.mp4

02:08

04 - Single Table Analysis (PART 2)

001 The CASE Statement.mp4

02:43

002 CASE Example.mp4

05:44

003 Common CASE Operators.mp4

04:18

004 ASSIGNMENT The CASE Statement.mp4

00:39

005 SOLUTION The CASE Statement.mp4

03:47

006 PRO TIP Pivoting with COUNT & CASE.mp4

02:54

007 COUNT & CASE Demo.mp4

07:35

008 ASSIGNMENT COUNT & CASE.mp4

00:52

009 SOLUTION COUNT & CASE.mp4

03:15

05 - MID-COURSE PROJECT

001 Mid-Course Project Intro.mp4

01:42

002 SOLUTION Mid-Course Project.mp4

06:05

06 - Analyzing Multiple Tables with Joins

001 Introduction to SQL JOINs and Querying Multiple Tables.mp4

00:30

002 Normalization & Cardinality.mp4

03:47

003 Relationship Diagrams.mp4

01:11

004 Multi-Table Querying.mp4

01:09

005 Reviewing the Maven Movies Database.mp4

01:44

006 Common JOIN Types.mp4

02:30

007 INNER JOIN.mp4

01:35

008 INNER JOIN Example.mp4

05:49

009 ASSIGNMENT INNER JOIN.mp4

00:42

010 SOLUTION INNER JOIN.mp4

04:13

011 LEFT JOIN.mp4

01:44

012 LEFT JOIN Example.mp4

04:43

013 ASSIGNMENT LEFT JOIN.mp4

00:43

014 SOLUTION LEFT JOIN.mp4

03:57

015 RIGHT JOIN.mp4

01:41

016 LEFT vs. INNER vs. RIGHT JOIN.mp4

03:18

017 FULL OUTER JOIN.mp4

01:27

018 PRO TIP Bridging Unrelated Tables.mp4

06:51

019 ASSIGNMENT Bridging Tables.mp4

00:57

020 SOLUTION Bridging Tables.mp4

04:25

021 Multi-Condition Joins.mp4

02:40

022 ASSIGNMENT Multi-Condition Joins.mp4

00:44

023 SOLUTION Multi-Condition Joins.mp4

04:43

024 The UNION Operator.mp4

02:15

025 UNION Example.mp4

03:51

026 ASSIGNMENT The UNION Operator.mp4

00:32

027 SOLUTION The UNION Operator.mp4

02:41

07 - FINAL PROJECT

001 Final Project Intro.mp4

02:04

002 SOLUTION Final Project.mp4

14:54

08 - Wrapping Up

001 Resources & Next Steps - After this SQL for Beginners Course.html

002 BONUS LESSON.html

Description

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

Who is this 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 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)

What You Need to Know?

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

More details

Description
**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Â and database analysis 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.

[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 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.
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 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)

User Reviews

Rating

average 0

Total votes0

Focused display

Maven Analytics helps individuals and teams build expert-level analytics & business intelligence skills. We've helped more than 1,000,000 students around the world build job-ready skills, master sought-after tools like Excel, SQL, Power BI, Tableau & Python, and build the foundation for a successful career in data. At Maven Analytics, we empower everyday people to change the world with data.

John Pauler

Instructor's Courses

Over a decade of Analytics experience for companies ranging from Fortune 500 to early stage startups. I work with data from websites, customers, marketing channels, and software products. I have been a pure play Analyst, and I have also led large Marketing P&Ls and served as a Product Owner. Throughout it all, I've made data mastery a pillar of my career, and am excited to share my experience on Udemy.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.