|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/introduction-to-data-analysis-and-statistics-using-sql/
课程评论：没有评论
课程名称：使用 SQL 进行数据分析和统计学入门 课程概述：本课程旨在帮助学习者理解数据的整体结构，并利用 SQL 这一广泛使用的数据处理语言进行数据分析。通过学习描述性统计和基本的 SQL 命令，学员能够总结数据集、计算平均值、计数、最大值和最小值，并获取与数据库中数据相关的其他分析和统计信息。 SQL Server 是微软开发的关系数据库管理系统，全球数以千计的公司使用 SQL Server 进行数据解决方案。SQL（结构化查询语言）是一种国际公认的语言，用于与各种数据库系统进行通信和操作，而 T-SQL（Transact SQL）是微软对 SQL 的实现，尽管两者有许多相似之处，但包括特定于 SQL Server 的专有部分。 通过 SQL 进行数据分析，可以将数据库中已经存在的数据转化为有价值的信息，帮助企业和组织做出重要的商业和管理决策。本课程是针对初学者的数据分析和统计学指南，旨在教授如何使用 SQL 对 SQL Server 进行查询以解答数据相关问题。学员将学习编写适用于现实生产环境的有用 SQL 查询。 数据的收集无处不在，包括每次交易、每次网页访问和每次支付，这些都在关系数据库中填充了原始数据，可供分析，进而提供有用的信息。因此，能够利用数据进行报告和分析的人才需求不断增加，帮助企业和组织做出重要和关键的决策。 课程涵盖的主题包括： - 安装 SQL Server 2017 - 加载示例数据库 - 聚合函数简介（AVG、MIN、MAX、SUM、COUNT、GROUPING、VAR、VARP） - 排序函数简介（RANK、NTILE、DENSE_RANK、ROW_NUMBER） - 分析函数简介（LEAD、LAG、LAST_VALUE、FIRST_VALUE、PERCENT_RANK、CUM_DIST、PERCENTILE_DISC、PERCENTILE_CONT）
Descriptive statistics help us understand the overall structure of data, and SQL is the most widely used language for manipulating it. Together, they can help data analysts derive better insights and make far-reaching predictions. This course provides an overview of basic descriptive statistics and analytic SQL commands you need to know to summarise data sets, find averages, count, max and min value and calculate other analytic and statistical information relating to data contained in the database. SQL Server is a relational database management system -RDBMS developed and owned by Microsoft.Thousands of companies all over the world use SQL Server for their data solution. SQL -Structured Query Language is an internationally recognised language used to communicate and manipulate various database systems. T-SQL - Transact SQL is Microsoft's implementation of SQL. There are a lot of similarities between them but also proprietary parts that are specific to SQL Server.SQL can be used for Data Analysis to transform data already present in the database to valuable useful information that help companies and organisations make key business and management decisions.This course is a beginners guide to performing data analysis and statistics using SQL to interrogate SQL Server to provide answers to data related questions. You will learn to write useful SQL queries that is applicable to the Real World production environment.Everywhere data is being collected, every transaction, every web page visit, every payment-all these and much, much more are filling relational databases with raw data that can be analysed to provide useful information. There is a demand for people who can use data to perform reporting and analysis thus helping businesses and organizations make important and critical decisions. Topic covered include: Install SQL Server 2017Load sample databaseIntroduction to Aggregate FunctionsAVGMINMAXSUMCOUNTGROUPINGVARVARPIntroduction to Ranking FunctionsRANKNTILEDENSE_RANKROW_NUMBERIntroduction to Analytic FunctionsLEADLAGLAST_VALUEFIRST_VALUEPERCENT_RANKCUM_DISTPERCENTILE_DISCPERCENTILE-CONT
