|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-to-use-sql-for-data-analysis/
课程评论：没有评论
**课程名称：** Learn to use SQL for Data Analysis and Reporting **课程概述：** 本课程是为初學者設計的，旨在教授如何使用 SQL（结构化查询语言）进行数据分析和报告。在全球范围内，具备数据分析和报告能力的人才供不应求，他们能够帮助企业和组织做出重要决策。SQL 作为与数据库通信的数据操纵标准语言，在数据分析和报告领域至关重要。 您是否曾好奇如何获取所需数据？是否希望能够亲自提取数据？本课程将指导您通过编写 SQL 代码来检索您需要的数据。您不仅能从数据库中提取数据，还能对其进行一系列操作，如合并、拆分、分组和重命名，从而生成您想要的报告。 课程内容包括： * **数据库环境搭建** * **数据库概念理解** * **SQL 语法学习** * **SQL 数据类型认识** * **使用 SELECT 语句进行数据检索** * **使用 WHERE 子句过滤数据** * **使用 ORDER BY 子句对查询结果进行排序** * **利用字符串函数转换查询结果** * **使用别名（Alias）更改查询结果的标题** * **运用各种函数进行数据报告和分析** * **执行更复杂的查询，例如连接来自不同数据库表的数据** **SQL 在解决商业问题中的应用示例：** * 每个区域的销售额前十名销售代表是谁？ * 组织中有多少员工？ * 组织中有多少员工的收入低于 45,000？ * 过去 18 个月有多少新员工加入公司？ * 超市中哪些商品销量最好？ **目标受众：** 本课程适合对 SQL 数据分析和报告不熟悉的初学者。
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. SQL stands for Structure Query Language. It is an internationally standard language used to communicate with various databases for data manipulation. SQL is vital for data analysis and reporting. Have you wondered how you get the data you need? Do you wish you could retrieve it yourself? This course teaches you how to get the data you want by writing a bit of SQL code. You won't just be able to pull data out of the database; you'll be able to manipulate it: merging it, multiplying it, grouping it, and relabeling it to get just the report you want. You will learn how to design and write simple SQL queries for data reporting and analysis. Also you will learn how to filter, group, and sort data, using built-in SQL functions to format or calculate results. Discover how to perform more complex queries, such as joining data together from different database tables. Topic you will learn include: Setup a Database EnvironmentUnderstand Database ConceptsWrite SQL SyntaxUnderstand SQL Data TypesRetrieve Data using SELECTFilter Data search with SQL WHERE clauseSort SQL query result search with ORDER BYTransform SQL Search results with string functionsUse Alias to change query results headingsUse various functions for data reporting and analysis SQL can be used to help solve business problems like: Who are the top ten sales-reps in each region?How many employees in an organizationHow many employees earn less than 45K in an organizationHow many new employees joined the company in the past 18 monthsWhat goods are flying off the supermarket shelves and so on.. Who is the target audience?This Course is meant for newbies who are not familiar with using SQL for Data Analysis and Reporting.
