|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-advanced-queries/
课程评论：没有评论
**课程名称：** SQL for Data Analysis: Advanced SQL Querying Techniques **课程概述：** 本课程是一门实践导向、项目驱动的SQL进阶课程，旨在帮助学员掌握超越SQL基本“6大子句”的高级查询技巧。课程将从SQL基础知识回顾开始，深入讲解多表分析，包括各种JOIN类型（内连接、左连接、右连接、外连接）、自连接、交叉连接以及UNION操作。 随后，课程将教授如何使用子查询（Subqueries）和通用表表达式（CTEs）来处理嵌套查询，并通过具体示例展示子查询在不同子句中的应用，以及如何将子查询重写为CTEs。还将介绍递归CTEs，并将其与临时表和视图等其他技术进行比较。 接着，课程会详细拆解窗口函数（Window Functions）的每个组成部分，并介绍常用的窗口函数，如ROW_NUMBER、RANK、FIRST_VALUE、LEAD和LAG。同时，还将涵盖各类数据类型（数字、日期时间、字符串、NULL）的SQL函数。 最后，课程将把所学概念应用于常见的数据分析场景，包括处理重复值、特殊值过滤、滚动计算等。 **课程项目：** 学员将扮演美国职业棒球大联盟（MLB）的数据分析实习生，运用高级SQL查询技术，追踪球员薪资、身高、体重等统计数据随时间和球队的变化情况。 **课程内容大纲：** * **SQL基础回顾：** 复习SQL查询的6大子句及LIMIT、DISTINCT等常用关键字。 * **多表分析：** 复习JOIN基础，介绍自连接、CROSS JOIN和UNION等。 * **子查询与CTEs：** 学习编写子查询和CTEs，理解不同技术的适用场景。 * **窗口函数：** 学习使用窗口函数进行行集计算，介绍各类窗口函数及其应用。 * **数据类型函数：** 学习SQL中数字、日期时间、字符串和NULL函数的应用。 * **数据分析应用：** 将高级查询技巧应用于数据透视、滚动计算等数据分析场景。 * **期末项目：** 完成MLB球员数据分析项目。 **课程资源：** * 8小时高质量视频 * 21项家庭作业 * 6次测验 * 4部分期末项目 * 150+页的SQL高级查询电子书 * 可下载的项目文件及解决方案 * 专家支持与问答论坛 * 30天Udemy满意度保证 **目标学员：** 希望精通SQL高级查询的分析师、数据科学家或BI专业人士。
This is a hands-on, project-based course designed to help you move beyond the "Big 6" clauses into advanced querying techniques.We'll start by reviewing the basics and conducting multi-table analyses, including basic joins, self-joins, cross-joins, and unions.Next, we'll cover different ways of working with nested queries by writing subqueries and common table expressions, or CTEs. We'll walk through examples of subqueries within the various clauses, rewrite subqueries as CTEs, introduce recursive CTEs, and compare these techniques to other options like temporary tables and views.From there, we'll break down each component of a window function and review common window functions like ROW_NUMBER, RANK, FIRST_VALUE, LEAD, and LAG. We'll also cover general functions for working with different data types in SQL, including numeric, datetime, string, and NULL functions.Last but not least, we'll take the concepts we've learned and use them across a series of common data analysis applications. We'll deal with duplicate values, apply special value filters, perform rolling calculations, and more.To wrap up the course, you'll work on a project as a Data Analyst Intern for Major League Baseball, and use advanced SQL querying techniques to track how player stats like salary, height, and weight have changed over time and across different teams.COURSE OUTLINE:SQL Basics ReviewReview the big 6 clauses of a SQL query along with other commonly used keywords like LIMIT, DISTINCT, and moreMulti-Table AnalysisReview JOIN basics (INNER, LEFT, RIGHT, OUTER) and introduce variations like self joins, CROSS JOINs, and moreSubqueries & CTEsLearn how to write subqueries and Common Table Expressions and understand the best situations for using certain techniquesWindow FunctionsIntroduce window functions to perform calculations across a set of rows and discuss various function options and applicationsFunctions by Data TypeDiscover the many SQL functions that can be applied to fields of numeric, datetime, string, and NULL data typesData Analysis ApplicationsApply advanced querying techniques to common data analysis scenarios, including pivoting data, rolling calculations, and moreFinal ProjectLeverage everything you've learned to track how Major League Baseball (MLB) player statistics have changed over time and across different teams in the league__________Ready to dive in? Join today and get immediate, LIFETIME access to the following:8 hours of high-quality video21 homework assignments6 quizzes4-part final projectAdvanced SQL Querying ebook (150+ pages)Downloadable project files & solutionsExpert support and Q & A forum30-day Udemy satisfaction guaranteeIf you're an analyst, data scientist, or BI professional looking to master advanced querying with SQL, this is the course for you.Happy learning!-Alice Zhao (Author, SQL Pocket Guide and Data Science Instructor, Maven Analytics)__________Looking for our full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, Tableau and Machine Learning courses!See why our courses are among the TOP-RATED on Udemy:"Some of the BEST courses I've ever taken. I've studied several programming languages, Excel, VBA and web dev, and Maven is among the very best I've seen!" Russ C."This is my fourth course from Maven Analytics and my fourth 5-star review, so I'm running out of things to say. I wish Maven was in my life earlier!" Tatsiana M."Maven Analytics should become the new standard for all courses taught on Udemy!" Jonah M.
