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