|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/introduction-to-data-analysis-and-reporting-with-sql/
课程评论：没有评论
Coursera SQL数据分析与报告入门课程概览 本课程旨在满足市场对能够通过数据进行报告和分析、从而协助企业和组织做出关键决策的人才需求。SQL（结构化查询语言）是国际标准语言，用于与各种数据库进行数据交互和操作，对于数据分析和报告至关重要。 **课程亮点：** * **数据检索能力：** 学习如何通过编写SQL代码轻松获取所需数据。 * **数据处理与转换：** 不仅能从数据库中提取数据，还能进行数据的合并、计算、分组和重命名，以生成定制化报告。 * **SQL基础与进阶：** * 设计和编写简单SQL查询，用于数据报告和分析。 * 掌握过滤（WHERE）、分组（GROUP BY）、排序（ORDER BY）数据。 * 运用内置SQL函数进行数据格式化和计算。 * 学习执行更复杂的查询，如跨表连接（JOIN）。 * **关键主题：** * 数据库环境搭建 * 数据库基本概念 * SQL语法 * SQL数据类型 * SELECT语句进行数据检索 * WHERE子句过滤数据 * ORDER BY子句排序查询结果 * 字符串函数转换搜索结果 * 使用别名（Alias）改变查询结果标题 * 使用各种函数进行数据报告和分析 **SQL在商业问题中的应用示例：** * 找出每个地区的十大销售代表。 * 统计组织中的员工总数。 * 统计组织中薪资低于45K的员工人数。 * 统计过去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 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 BY Transform SQL Search results with string functionsUse Alias to change query results headingsUse various functions for data reporting and analysisSQL 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..
