|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-for-data-analysis-course/
课程评论：没有评论
课程名称：SQL 数据分析 课程概述：本课程旨在介绍 SQL 数据分析的不同功能，内容以通俗易懂的方式呈现，适合没有技术背景的学员。课程内容包括： 1. **SQL 基础知识**：学习 SQL 的基本概念，熟悉 SQL 的基本命令和操作。 2. **JOIN 操作**：以最简单的方式学习 INNER JOIN 和 OUTER JOIN，掌握如何在多个表之间进行连接。 3. **聚合函数**：了解 NULL 的重要性和 SQL 中最常用的聚合函数，掌握使用 GROUP BY、HAVING 和 CASE 语句。 4. **子查询**：通过实际示例学习如何编写和使用子查询。 5. **数据清理**：学习两种实用案例中的数据清理技巧。 随着 LinkedIn 上超过50万个与 SQL 相关的职位，许多角色如产品分析师、数据分析师、数据科学家、业务分析师、产品经理、软件工程师等都需要 SQL 技能。如今，雇主对具备 SQL 技能的专业人才需求旺盛，SQL 已成为需求最高的技能之一，超越其他编程语言。 本课程适合任何能够基本操作计算机并具备一定 Excel 表格使用理解的人士。完成本课程后，学员将能够掌握 SQL 的基本知识，为数据分析奠定坚实的基础。准备好开始你的 SQL 数据分析之旅了吗？让我们开始吧！
Introducing, the SQL For Data Analysis.In this official course you will be guided on different functionalities in SQL that are specific to Data analysis and videos are developed in easy terms and less technical so that any one without technical capabilities, can easily get through this course.Introduction to SQLLearn very basics in SQL JOINSLearn INNER and OUTER join in the most easiest way.AggregationsImportance of NULLMost commonly used aggregations in SQLGROUP BY, HAVING, CASE statements in SQLWith practical demonstrationSub QueriesLearn sub queries with practical examplesData cleaningLearn how to clean data in two useful use cases.There are currently over more than half a million jobs related to SQL on LinkedIn. Many roles like product analyst, data analyst, data scientist, business analyst, product manager, software engineer, and more require SQL to perform their day to day tasks. Nowadays employers are eager to get professionals with SQL skillset. SQL is the most in-demand skill, higher than other programming languages. This course is for anyone who can basically operate computers and have some basic understanding on how to use excel spreadsheets. By the end of this course you will get yourself skilled up with a good basic foundations of SQL.Ready to embark on your SQL data analysis journey? Let's get started!
