|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-for-data-analysts/
课程评论：没有评论
Coursera 课程“SQL 数据分析：终极指南”旨在帮助有志于成为数据分析师的学员，通过掌握 SQL 技能解决实际业务问题。本课程由一位拥有保险和医疗保健行业丰富经验的高级数据分析师讲授。 课程内容涵盖 SQL 的方方面面，从基础知识到高级技巧，共分为十二个模块： * **模块一：创建和管理数据库** - 学习数据库创建、删除、表管理、数据加载及数据完整性验证。 * **模块二：SELECT 语句** - 掌握基本的 SELECT 查询、数据过滤（WHERE）、结果排序（ORDER BY）及 NULL 值处理。 * **模块三：JOIN** - 深入理解并应用 INNER, LEFT/RIGHT, CROSS 等不同类型的 JOIN 来关联多表数据。 * **模块四：集合运算符** - 学习使用 UNION, UNION ALL, INTERSECT, EXCEPT 等运算符合并查询结果。 * **模块五：函数和聚合** - 掌握 SUM, AVG, COUNT 等聚合函数，并学会使用 GROUP BY 和 HAVING 进行数据分组。 * **模块六：子查询** - 学习在 SELECT, WHERE, FROM 子句中使用子查询进行复杂过滤。 * **模块七：公用表表达式 (CTEs)** - 探索 CTE 的强大功能，包括递归 CTE，并结合 JOIN 和子查询使用。 * **模块八：分组集和透视表** - 学习使用分组集、创建和使用透视表以及高级聚合技术。 * **模块九：修改数据** - 掌握使用 SQL 命令进行数据的插入、更新和删除。 * **模块十：T-SQL 编程** - 学习变量、参数和存储过程的编写。 * **模块十一：错误处理** - 学习 SQL 错误管理、查询调试优化、异常处理及数据完整性保障。 * **模块十二：毕业项目** - 完成两个实际项目，包括 Airbnb 数据洞察分析和电子商务销售分析。 学员可以根据兴趣选择特定模块学习，但建议按顺序学习前九个模块以充分准备毕业项目。本课程强调实践操作，通过解决真实世界的业务问题，帮助学员获得宝贵的数据分析经验。
Are you interested in becoming a Data Analyst? Do you want to gain practical skills and solve real-world business problems using SQL? Then this is the perfect course for you! Created by a Senior Data Analyst with extensive experience in the Insurance and Health Care sectors, this course will equip you with foundational knowledge and help you master key SQL functions and techniques for data analysis.I will guide you step-by-step into the world of SQL for data analysis. With every lecture and lab exercise, you will develop a comprehensive understanding of these concepts to tackle real data problems! This course is designed to be engaging and practical, with a logical flow through essential modules:Module 1: Creating and Managing DatabasesLearn how to create and drop databases, manage tables, load data into tables, and verify data integrity.Module 2: SELECT StatementsMaster basic SELECT queries, filter data with WHERE clauses, sort results with ORDER BY, and handle NULL values.Module 3: Joins - INNER, LEFT/RIGHT, CROSS, etc.Understand and apply different types of joins: INNER, LEFT, RIGHT and CROSS joins to combine data from multiple tables.Module 4: Set OperatorsUtilize set operators like UNION, UNION ALL, INTERSECT, and EXCEPT to combine results from multiple queries.Module 5: Functions and AggregationsLearn and apply aggregate functions SUM, AVG, COUNT, and perform grouping of data with GROUP BY and HAVING clauses.Module 6: SubqueriesWrite subqueries in SELECT, WHERE, and FROM clauses and use them for complex filtering.Module 7: Common Table Expressions (CTEs)Discover the power of CTEs, use them for recursion, and combine them with joins and subqueries.Module 8: Grouping Sets and Pivot TablesImplement grouping sets, create and use pivot tables, and apply advanced aggregation techniques.Module 9: Modifying DataPerform data modifications with SQL commands for inserting, updating, and deleting recordsModule 10: Programming T-SQLWrite variables/parameters and stored procedures;Module 11: Error HandlingManage errors in SQL, debug and optimize queries, handle exceptions, and ensure data integrity.Module 12: Capstone Projectso Project 1: Airbnb Data Insights: Analyze listing availability, neighborhood popularity, and pricing variations.o Project 2: E-Commerce Sales Analysis: Analyze sales data by province, compare monthly sales, and identify top products.Each module contains independent content, allowing you to start from the beginning or jump into specific topics of interest. However, it is recommended to follow the course from Module 1 to Module 9 to fully prepare for the capstone project challenge.This course is packed with real-world business problems solved during my career as a senior data analyst. You will not only learn theoretical concepts but also gain practical, hands-on experience. Enroll today and take the first step towards mastering data analysis using SQL.
