English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 103 lectures (4h 31m) | 1.17 GB
Learn SQL database querying w/ MySQL Workbench. Perfect for SQL beginners and first-time coders.
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]
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
MySQL Intro & Setup
6 Introduction to Installing MySQL and MySQL Workbench for Beginners
7 Why Learn SQL From Scratch The Ultimate MySQL Bootcamp is Worth It!
8 History & SQL Flavors (MySQL, MS SQL Server, SQL Lite, T SQL, Microsoft SQL)
9 MySQL Installation Overview
10 Mac Download – Community Server
11 Mac Download – MySQL Workbench
12 PC Download – Community Server + Workbench
13 Connecting Workbench to the Server
14 MySQL Workbench Interface
15 Creating the Maven Movies Database
Single Table Analysis (PART 1)
16 Introduction to Databases and SQL Querying
17 Getting to Know the Database
18 The Big 6 Statements and Clauses of SQL Queries
19 The SELECT Statement – Your SQL Querying Starts Here
20 The FROM Clause – Tell the Server Which Table Your SQL Query Will Pull Data From
21 SELECT FROM
22 The USE Statement
23 Selecting Specific Columns
24 ASSIGNMENT SELECT & FROM
25 SOLUTION SELECT & FROM
26 SELECT DISTINCT
27 ASSIGNMENT SELECT DISTINCT
28 SOLUTION SELECT DISTINCT
29 The WHERE Clause
30 Common WHERE Operators
31 ASSIGNMENT The WHERE Clause
32 SOLUTION The WHERE Clause
33 Combining WHERE & AND
34 ASSIGNMENT WHERE & AND
35 SOLUTION WHERE & AND
36 Combining WHERE & OR
37 ASSIGNMENT WHERE & OR
38 SOLUTION WHERE & OR
39 Combining WHERE & IN
40 The LIKE Operator
41 LIKE Wildcard Examples
42 ASSIGNMENT The LIKE Operator
43 SOLUTION The LIKE Operator
44 The GROUP BY Clause
45 GROUP BY Example
46 PRO TIP Using Comments & Aliases
47 ASSIGNMENT GROUP BY
48 SOLUTION GROUP BY
49 Multiple Dimension GROUP BY Clauses
50 Grouping with Aggregate Functions
51 ASSIGNMENT Aggregate Functions
52 SOLUTION Aggregate Functions
53 The HAVING Clause
54 HAVING Example
55 ASSIGNMENT The HAVING Clause
56 SOLUTION The HAVING Clause
57 The ORDER BY Clause
58 ORDER BY Example
59 ASSIGNMENT The ORDER BY Clause
60 SOLUTION The ORDER BY Clause
61 RECAP The Big 6
Single Table Analysis (PART 2)
62 The CASE Statement
63 CASE Example
64 Common CASE Operators
65 ASSIGNMENT The CASE Statement
66 SOLUTION The CASE Statement
67 PRO TIP Pivoting with COUNT & CASE
68 COUNT & CASE Demo
69 ASSIGNMENT COUNT & CASE
70 SOLUTION COUNT & CASE
MID-COURSE PROJECT
71 Mid-Course Project Intro
72 SOLUTION Mid-Course Project
Analyzing Multiple Tables with Joins
73 Introduction to SQL JOINs and Querying Multiple Tables
74 Normalization & Cardinality
75 Relationship Diagrams
76 Multi-Table Querying
77 Reviewing the Maven Movies Database
78 Common JOIN Types
79 INNER JOIN
80 INNER JOIN Example
81 ASSIGNMENT INNER JOIN
82 SOLUTION INNER JOIN
83 LEFT JOIN
84 LEFT JOIN Example
85 ASSIGNMENT LEFT JOIN
86 SOLUTION LEFT JOIN
87 RIGHT JOIN
88 LEFT vs. INNER vs. RIGHT JOIN
89 FULL OUTER JOIN
90 PRO TIP Bridging Unrelated Tables
91 ASSIGNMENT Bridging Tables
92 SOLUTION Bridging Tables
93 Multi-Condition Joins
94 ASSIGNMENT Multi-Condition Joins
95 SOLUTION Multi-Condition Joins
96 The UNION Operator
97 UNION Example
98 ASSIGNMENT The UNION Operator
99 SOLUTION The UNION Operator
FINAL PROJECT
100 Final Project Intro
101 SOLUTION Final Project
Wrapping Up
102 Resources & Next Steps – After this SQL for Beginners Course
103 BONUS LESSON
Resolve the captcha to access the links!