|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-for-data-science-a/
课程评论：没有评论
课程名称：数据科学的SQL 课程概述：本课程将为您介绍结构化查询语言（SQL）、数据库、数据库管理系统（DBMS）等概念，并通过实践演示，使您不仅理解这些概念，还能实际掌握它们。该课程专为SQL和数据库管理系统初学者设计，旨在帮助您理解SQL如何用于存储、访问和检索数据，从而进行数据分析。在当今数据驱动决策的重要性日益增强的背景下，SQL成为数据分析的基础语言之一，广泛应用于MySQL、Postgres、SQLite、Microsoft SQL Server、Oracle及Hive、Cassandra等大数据解决方案中。 随着大数据和数据科学的兴起，我们面临着海量数据的挑战。本课程的一个核心秘密是，许多大型科技公司的高级营销人员和产品经理都懂得如何操作数据以获取重要洞见。您将不再需要等待软件工程师的答复，而是能够直接通过SQL自己找到答案。 课程内容包括： - 数据库基础 - 安装Postgres - 创建表 - SELECT语句 - WHERE子句 - AND与OR - 过滤操作符 - ORDER BY - LIMIT - DISTINCT - 重命名列 - 函数 - GROUP BY与HAVING子句 - 聚合查询 - 子查询 - CASE子句 - 关联子查询 - 表连接（INNER和OUTER连接） - UNION、UNION ALL和EXCEPT子句 本课程旨在为您提供必要的SQL技能，以便在数据分析领域取得成功。
This SQL for data science course will introduce you to concepts of Structured Query Language (SQL), Databases, DBMS, etc. with practical demonstrations, so that you not only understand the concepts but also master it practically.The course is designed for beginners to SQL and database management systems. This SQL for Data Science course will help you understand how SQL can be used to store, access and retrieve data to perform data analysis.It is becoming ever more important that companies make data-driven decisions.With big data and data science on the rise, we have more data than we know what to do with.One of the basic languages of data analytics is SQL, which is used for many popular databases including MySQL, Postgres, SQLite, Microsoft SQL Server, Oracle, and even big data solutions like Hive and Cassandra.I'm going to let you in on a little secret. Most high-level marketers and product managers at big tech companies know how to manipulate data to gain important insights. No longer do you have to wait around the entire day for some software engineer to answer your questions - now you can find the answers directly, by yourself, using SQL!Topics covered in this course:What is a DatabaseInstalling PostgresCreating TablesSELECT StatementWHERE ClauseAND & ORFiltering OperatorsORDER BYLIMITDISTINCTRenaming ColumnsFunctionsGROUP BY & HAVING ClausesAggregation QueriesSubqueriesCASE ClauseCorrelated SubqueriesTable JoinsINNER and OUTER JoinsUNION, UNION ALL and EXCEPT Clauses
