Course Content
Subtitle Guide – Hướng dẫn thêm phụ đề
0/1
Set up subtitle for video – Hướng dẫn thêm phụ đề
01 – Getting Started
0/6
Subtitle File Resource
001 Course Structure Outline MySQL Database for Beginners
01:36
002 READ ME Important Notes for New Students
003 DOWNLOAD Course Resources
004 Introducing the Course Project – Play the Role of Business Analyst
00:33
005 Setting Expectations – Focus on Business Analysis, NOT MySQL Administration
01:19
02 – MySQL Intro & Setup
0/11
Subtitle File Resource
001 Introduction to Installing MySQL and MySQL Workbench for Beginners
00:19
002 Why Learn SQL From Scratch The Ultimate MySQL Bootcamp is Worth It
01:09
003 History SQL Flavor
02:25
004 MySQL Installation Overview
01:21
005 Mac Download – Community Server
04:53
006 Mac Download – MySQL Workbench
02:51
007 PC Download Community Server
07:41
008 Connecting Workbench to the Server
01:56
009 MySQL Workbench Interface
01:37
010 Creating the Maven Movies Database
01:37
03 – Single Table Analysis (PART 1)
0/47
Subtitle File Resource
001 Introduction to Databases and SQL Querying
00:25
002 Getting to Know the Database
03:52
003 The Big 6 Statements and Clauses of SQL Queries
02:18
004 The SELECT Statement Your SQL Querying Starts Here
00:47
005 The FROM Clause
00:39
006 SELECT FROM
06:00
007 The USE Statement
03:19
008 Selecting Specific Columns
04:18
009 ASSIGNMENT SELECT
01:24
010 SOLUTION SELECT
02:38
011 SELECT DISTINCT
02:13
012 ASSIGNMENT SELECT DISTINCT
00:39
013 SOLUTION SELECT DISTINCT
02:00
014 The WHERE Clause
01:30
015 Common WHERE Operators
04:59
016 ASSIGNMENT The WHERE Clause
00:35
017 SOLUTION The WHERE Clause
02:23
018 Combining WHERE AND
04:22
019 ASSIGNMENT WHERE AND
00:39
020 SOLUTION WHERE AND
01:37
021 Combining WHERE OR
03:38
022 ASSIGNMENT WHERE OR
00:42
023 SOLUTION WHERE OR
03:22
024 Combining WHERE IN
04:35
025 The LIKE Operator
02:37
026 LIKE Wildcard Examples
05:06
027 ASSIGNMENT The LIKE Operator
00:30
028 SOLUTION The LIKE Operator
02:28
029 The GROUP BY Clause
01:43
030 GROUP BY Example
03:18
031 PRO TIP Using Comments Aliases
05:32
032 ASSIGNMENT GROUP BY
00:37
033 SOLUTION GROUP BY
02:01
034 Multiple Dimension GROUP BY Clauses
03:14
035 Grouping with Aggregate Functions
02:08
036 ASSIGNMENT Aggregate Functions
00:55
037 SOLUTION Aggregate Functions
03:23
038 The HAVING Clause
01:44
039 HAVING Example
02:54
040 ASSIGNMENT The HAVING Clause
00:55
041 SOLUTION The HAVING Clause
03:11
042 The ORDER BY Clause
01:31
043 ORDER BY Example
04:16
044 ASSIGNMENT The ORDER BY Clause
00:30
045 SOLUTION The ORDER BY Clause
01:47
046 RECAP The Big 6
02:08
04 – Single Table Analysis (PART 2)
0/10
Subtitle File Resource
001 The CASE Statement
02:43
002 CASE Example
05:44
003 Common CASE Operators
04:18
004 ASSIGNMENT The CASE Statement
00:39
005 SOLUTION The CASE Statement
03:47
006 PRO TIP Pivoting with COUNT
02:54
007 COUNT CASE Demo
07:35
008 ASSIGNMENT COUNT CASE
00:52
009 SOLUTION COUNT CASE
03:15
05 – MID-COURSE PROJECT
0/3
Subtitle File Resource
001 Mid Course Project Intro
01:42
002 SOLUTION Mid Course Project
06:05
06 – Analyzing Multiple Tables with Joins
0/28
Subtitle File Resource
001 Introduction to SQL JOINs and Querying Multiple Tables
00:30
002 Normalization Cardinality
03:47
003 Relationship Diagrams
01:11
004 Multi-Table Querying
01:09
005 Reviewing the Maven Movies Database
01:44
006 Common JOIN Types
02:30
007 INNER JOIN
01:35
008 INNER JOIN Example
05:49
009 ASSIGNMENT INNER JOIN
00:42
010 SOLUTION INNER JOIN
04:13
011 LEFT JOIN
01:44
012 LEFT JOIN Example
04:43
013 ASSIGNMENT LEFT JOIN
00:43
014 SOLUTION LEFT JOIN
03:57
015 RIGHT JOIN
01:41
016 LEFT INNER RIGHT JOIN
03:18
017 FULL OUTER JOIN
01:27
018 PRO TIP Bridging Unrelated Tables
06:51
019 ASSIGNMENT Bridging Tables
00:57
020 SOLUTION Bridging Tables
04:25
021 Multi Condition Joins
02:40
022 ASSIGNMENT Multi Condition Joins
00:44
023 SOLUTION Multi Condition Joins
04:43
024 The UNION Operator
02:15
025 UNION Example
03:51
026 ASSIGNMENT The UNION Operator
00:32
027 SOLUTION The UNION Operator
02:41
07 – FINAL PROJECT
0/3
Subtitle File Resource
001 Final Project Intro
02:04
002 SOLUTION Final Project
14:54
08 – Wrapping Up
0/1
001 Resources & Next Steps – After this SQL for Beginners Course
SQL for Data Analysis: Beginner MySQL Business Intelligence
About Lesson

Please download the course resource files below, including:

  • MySQL_Data_Analysis.pdf (these are the course slides)

  • create_mavenmovies.sql (this is the SQL script you will use to create the database in Lecture 15)

  • Maven Movies Mid Course and Final Project Files (4 files, each containing SQL scripts that you’ll use to complete the mid-course and final projects)

NOTE: If you have trouble downloading the files, right-click and open the link in a new tab. If you continue to experience issues (i.e. 403 errors) please click here to download the files.

Exercise Files
Resource.zip
Size: 9.58 MB
Join the conversation
Previous
Next

Please contact me via telegram

DMCA.com Protection Status