用于数据分析的SQL-初级的MySQL商业智能 SQL for Data Analysis Beginner MySQL Business Intelligence

课程介绍

在本课程中，您将扮演刚收购实体 DVD 租赁店Maven Movies的企业主。仅使用 MySQL 数据库和 MySQL Workbench，您的任务就是尽可能了解您的新业务；包括您的库存、员工和客户行为。

但别担心，你并不孤单！我们将在这里从头到尾为您提供指导，分享清晰的解释、MySQL 专业技巧和最佳实践，以及课程测验、项目和家庭作业，以测试您的 SQL 和数据库分析技能。

用于数据分析的SQL-初级的MySQL商业智能 SQL for Data Analysis Beginner MySQL Business Intelligence

课程目录

├──01 – Getting Started
| ├──001 Course Structure & Outline – MySQL Database for Beginners.mp4 31.45M
| ├──002 READ ME Important Notes for New Students.html 4.80kb
| ├──003 create-mavenmovies-vApril2022.sql 3.23M
| ├──003 create-mavenmovies.sql 3.23M
| ├──003 DOWNLOAD Course Resources.html 0.98kb
| ├──003 MavenMovies-Final-Course-Project-SOLUTION.sql 5.15kb
| ├──003 MavenMovies-Final-Course-Project.sql 2.46kb
| ├──003 MavenMovies-Mid-Course-Project-SOLUTION.sql 2.44kb
| ├──003 MavenMovies-Mid-Course-Project.sql 1.62kb
| ├──003 MySQL-Data-Analysis.pdf 9.25M
| ├──004 Introducing the Course Project – Play the Role of Business Analyst.mp4 2.57M
| └──005 Setting Expectations – Focus on Business Analysis, NOT MySQL Administration.mp4 8.23M
├──02 – MySQL Intro & Setup
| ├──001 Introduction to Installing MySQL and MySQL Workbench for Beginners.mp4 1.90M
| ├──002 Why Learn SQL From Scratch The Ultimate MySQL Bootcamp is Worth It!.mp4 1.90M
| ├──003 History & SQL Flavors (MySQL, MS SQL Server, SQL Lite, T SQL, Microsoft SQL).mp4 10.31M
| ├──004 MySQL Installation Overview.mp4 2.27M
| ├──005 Mac Download – Community Server.mp4 26.77M
| ├──006 Mac Download – MySQL Workbench.mp4 9.22M
| ├──007 PC Download – Community Server + Workbench.mp4 48.89M
| ├──008 Connecting Workbench to the Server.mp4 5.92M
| ├──009 MySQL Workbench Interface.mp4 3.30M
| └──010 Creating the Maven Movies Database.mp4 11.10M
├──03 – Single Table Analysis (PART 1)
| ├──001 Introduction to Databases and SQL Querying.mp4 2.46M
| ├──002 Getting to Know the Database.mp4 26.33M
| ├──003 The Big 6 Statements and Clauses of SQL Queries.mp4 4.38M
| ├──004 The SELECT Statement – Your SQL Querying Starts Here.mp4 1.61M
| ├──005 The FROM Clause – Tell the Server Which Table Your SQL Query Will Pull Data From.mp4 1.29M
| ├──006 SELECT FROM.mp4 16.79M
| ├──007 The USE Statement.mp4 7.76M
| ├──008 Selecting Specific Columns.mp4 17.30M
| ├──009 ASSIGNMENT SELECT & FROM.mp4 4.22M
| ├──010 SOLUTION SELECT & FROM.mp4 6.94M
| ├──011 SELECT DISTINCT.mp4 13.25M
| ├──012 ASSIGNMENT SELECT DISTINCT.mp4 1.51M
| ├──013 SOLUTION SELECT DISTINCT.mp4 18.14M
| ├──014 The WHERE Clause.mp4 2.62M
| ├──015 Common WHERE Operators.mp4 29.32M
| ├──016 ASSIGNMENT The WHERE Clause.mp4 3.78M
| ├──017 SOLUTION The WHERE Clause.mp4 8.10M
| ├──018 Combining WHERE & AND.mp4 18.10M
| ├──019 ASSIGNMENT WHERE & AND.mp4 1.56M
| ├──020 SOLUTION WHERE & AND.mp4 3.71M
| ├──021 Combining WHERE & OR.mp4 21.37M
| ├──022 ASSIGNMENT WHERE & OR.mp4 1.79M
| ├──023 SOLUTION WHERE & OR.mp4 10.57M
| ├──024 Combining WHERE & IN.mp4 24.25M
| ├──025 The LIKE Operator.mp4 12.88M
| ├──026 LIKE Wildcard Examples.mp4 34.93M
| ├──027 ASSIGNMENT The LIKE Operator.mp4 1.30M
| ├──028 SOLUTION The LIKE Operator.mp4 7.43M
| ├──029 The GROUP BY Clause.mp4 3.53M
| ├──030 GROUP BY Example.mp4 17.18M
| ├──031 PRO TIP Using Comments & Aliases.mp4 18.60M
| ├──032 ASSIGNMENT GROUP BY.mp4 1.49M
| ├──033 SOLUTION GROUP BY.mp4 11.13M
| ├──034 Multiple Dimension GROUP BY Clauses.mp4 11.79M
| ├──035 Grouping with Aggregate Functions.mp4 5.43M
| ├──036 ASSIGNMENT Aggregate Functions.mp4 2.34M
| ├──037 SOLUTION Aggregate Functions.mp4 15.44M
| ├──038 The HAVING Clause.mp4 2.98M
| ├──039 HAVING Example.mp4 17.43M
| ├──040 ASSIGNMENT The HAVING Clause.mp4 2.17M
| ├──041 SOLUTION The HAVING Clause.mp4 14.69M
| ├──042 The ORDER BY Clause.mp4 3.14M
| ├──043 ORDER BY Example.mp4 25.74M
| ├──044 ASSIGNMENT The ORDER BY Clause.mp4 1.26M
| ├──045 SOLUTION The ORDER BY Clause.mp4 9.53M
| └──046 RECAP The Big 6.mp4 9.41M
├──04 – Single Table Analysis (PART 2)
| ├──001 The CASE Statement.mp4 5.68M
| ├──002 CASE Example.mp4 21.55M
| ├──003 Common CASE Operators.mp4 22.62M
| ├──004 ASSIGNMENT The CASE Statement.mp4 1.67M
| ├──005 SOLUTION The CASE Statement.mp4 23.25M
| ├──006 PRO TIP Pivoting with COUNT & CASE.mp4 17.42M
| ├──007 COUNT & CASE Demo.mp4 23.33M
| ├──008 ASSIGNMENT COUNT & CASE.mp4 2.06M
| └──009 SOLUTION COUNT & CASE.mp4 23.85M
├──05 – MID-COURSE PROJECT
| ├──001 Mid-Course Project Intro.mp4 3.75M
| └──002 SOLUTION Mid-Course Project.mp4 26.28M
├──06 – Analyzing Multiple Tables with Joins
| ├──001 Introduction to SQL JOINs and Querying Multiple Tables.mp4 10.85M
| ├──002 Normalization & Cardinality.mp4 9.13M
| ├──003 Relationship Diagrams.mp4 3.27M
| ├──004 Multi-Table Querying.mp4 2.40M
| ├──005 Reviewing the Maven Movies Database.mp4 6.71M
| ├──006 Common JOIN Types.mp4 5.36M
| ├──007 INNER JOIN.mp4 2.99M
| ├──008 INNER JOIN Example.mp4 18.46M
| ├──009 ASSIGNMENT INNER JOIN.mp4 1.83M
| ├──010 SOLUTION INNER JOIN.mp4 20.97M
| ├──011 LEFT JOIN.mp4 3.42M
| ├──012 LEFT JOIN Example.mp4 15.90M
| ├──013 ASSIGNMENT LEFT JOIN.mp4 1.79M
| ├──014 SOLUTION LEFT JOIN.mp4 10.73M
| ├──015 RIGHT JOIN.mp4 3.42M
| ├──016 LEFT vs. INNER vs. RIGHT JOIN.mp4 31.21M
| ├──017 FULL OUTER JOIN.mp4 2.93M
| ├──018 PRO TIP Bridging Unrelated Tables.mp4 29.17M
| ├──019 ASSIGNMENT Bridging Tables.mp4 3.04M
| ├──020 SOLUTION Bridging Tables.mp4 18.40M
| ├──021 Multi-Condition Joins.mp4 7.76M
| ├──022 ASSIGNMENT Multi-Condition Joins.mp4 1.91M
| ├──023 SOLUTION Multi-Condition Joins.mp4 20.18M
| ├──024 The UNION Operator.mp4 4.67M
| ├──025 UNION Example.mp4 12.31M
| ├──026 ASSIGNMENT The UNION Operator.mp4 1.32M
| └──027 SOLUTION The UNION Operator.mp4 8.10M
├──07 – FINAL PROJECT
| ├──001 Final Project Intro.mp4 6.48M
| └──002 SOLUTION Final Project.mp4 107.07M
└──08 – Wrapping Up
| ├──001 Resources & Next Steps – After this SQL for Beginners Course.html 1.14kb
| └──002 BONUS LESSON.html 8.98kb