MySQL for Data Analysis – SQL Database for Beginners

MySQL for Data Analysis – SQL Database for Beginners
MySQL for Data Analysis – SQL Database for Beginners
English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 6 Hours | 2.44 GB

Learn SQL for Business Intelligence w/ MySQL Workbench. Intro to Relational Databases (apply to PostgreSQL & Oracle SQL)

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

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
Table of Contents

Getting Started
1 Course Structure Outline – MySQL Database for Beginners
2 READ ME Important Notes for New Students
3 DOWNLOAD Course Resources
4 Introducing the Course Project – Play the Role of Business Analyst
5 Setting Expectations – Focus on Business Analysis NOT MySQL Administration
6 Looking to become a MySQL Specialist

MySQL Intro Setup
7 Introduction to Installing MySQL and MySQL Workbench for Beginners
8 Why Learn SQL From Scratch The Ultimate MySQL Bootcamp is Worth It
9 History SQL Flavors (MySQL MS SQL Server SQL Lite T SQL Microsoft SQL)
10 MySQL Installation Overview
11 MAC Download Community Server
12 MAC Download MySQL Workbench
13 PC Download Community Server Workbench
14 Connecting Workbench to the Server
15 MySQL Workbench Interface
16 Creating the Maven Movies Database

Single Table Analysis (PART 1)
17 Introduction to Databases and SQL Querying
18 Getting to Know the Database
19 The Big 6 Statements and Clauses of SQL Queries
20 The SELECT Statement – Your SQL Querying Starts Here
21 The FROM Clause – Tell the Server Which Table Your SQL Query Will Pull Data From
22 SELECT FROM
23 The USE Statement
24 Selecting Specific Columns
25 ASSIGNMENT SELECT FROM
26 SOLUTION SELECT FROM
27 SELECT DISTINCT
28 ASSIGNMENT SELECT DISTINCT
29 SOLUTION SELECT DISTINCT
30 The WHERE Clause
31 Common WHERE Operators
32 ASSIGNMENT The WHERE Clause
33 SOLUTION The WHERE Clause
34 Combining WHERE AND
35 ASSIGNMENT WHERE AND
36 SOLUTION WHERE AND
37 Combining WHERE OR
38 ASSIGNMENT WHERE OR
39 SOLUTION WHERE OR
40 Combining WHERE IN
41 The LIKE Operator
42 LIKE Wildcard Examples
43 ASSIGNMENT The LIKE Operator
44 SOLUTION The LIKE Operator
45 The GROUP BY Clause
46 GROUP BY Example
47 PRO TIP Using Comments Aliases
48 ASSIGNMENT GROUP BY
49 SOLUTION GROUP BY
50 Multiple Dimension GROUP BY Clauses
51 Grouping with Aggregate Functions
52 ASSIGNMENT Aggregate Functions
53 SOLUTION Aggregate Functions
54 The HAVING Clause
55 HAVING Example
56 ASSIGNMENT The HAVING Clause
57 SOLUTION The HAVING Clause
58 The ORDER BY Clause
59 ORDER BY Example
60 ASSIGNMENT The ORDER BY Clause
61 SOLUTION The ORDER BY Clause
62 RECAP The Big 6

Single Table Analysis (PART 2)
63 The CASE Statement
64 CASE Example
65 Common CASE Operators
66 ASSIGNMENT The CASE Statement
67 SOLUTION The CASE Statement
68 PRO TIP Pivoting with COUNT CASE
69 COUNT CASE Demo
70 ASSIGNMENT COUNT CASE
71 SOLUTION COUNT CASE

MID-COURSE PROJECT
72 Mid-Course Project Intro
73 SOLUTION Mid-Course Project

Analyzing Multiple Tables with Joins
74 Introduction to SQL JOINs and Querying Multiple Tables
75 Normalization Cardinality
76 Relationship Diagrams
77 Multi-Table Querying
78 Reviewing the Maven Movies Database
79 Common JOIN Types
80 INNER JOIN
81 INNER JOIN Example
82 ASSIGNMENT INNER JOIN
83 SOLUTION INNER JOIN
84 LEFT JOIN
85 LEFT JOIN Example
86 ASSIGNMENT LEFT JOIN
87 SOLUTION LEFT JOIN
88 RIGHT JOIN
89 LEFT vs. INNER vs. RIGHT JOIN
90 FULL OUTER JOIN
91 PRO TIP Bridging Unrelated Tables
92 ASSIGNMENT Bridging Tables
93 SOLUTION Bridging Tables
94 Multi-Condition Joins
95 ASSIGNMENT Multi-Condition Joins
96 SOLUTION Multi-Condition Joins
97 The UNION Operator
98 UNION Example
99 ASSIGNMENT The UNION Operator
100 SOLUTION The UNION Operator

FINAL PROJECT
101 Final Project Intro
102 SOLUTION Final Project

Wrapping Up
103 Resources Next Steps – After this SQL for Beginners Course
104 More from Maven Analytics

SNEAK PEEK Advanced SQL for Analytics Business Intelligence
105 SNEAK PEEK Whats Next Advanced Databases and SQL Querying
106 SNEAK PEEK Analyzing Top Traffic Sources
107 SNEAK PEEK Assignment – Finding Top Traffic Sources
108 SNEAK PEEK Solution – Finding Top Traffic Sources
109 SNEAK PEEK Analyzing Bounce Rates Landing Page Tests
110 SNEAK PEEK Assignment – Analyzing Landing Page Tests
111 SNEAK PEEK Solution – Analyzing Landing Page Tests
112 SNEAK PEEK Final Project – Advanced SQL for Analytics Business Intelligence

SNEAK PEEK MySQL Database Administration – SQL Database for Beginners
113 SNEAK PEEK Creating a Table Using a SQL Query
114 SNEAK PEEK Creating Enhanced Entitity Relationship Models