|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-for-audit-revenue-assurance-and-data-science/
课程评论：没有评论
**Coursera 课程总结：面向审计、营收保证和数据科学的 SQL** 本课程旨在帮助您掌握使用 SQL (Structured Query Language) 进行数据分析、管理和可视化的能力。您将学习如何自行安装 Oracle 数据库和客户端，并亲手实践 SQL 的各项功能。 课程内容涵盖： * **SQL 基础入门**：理解 SQL 的基本概念和语法。 * **工具安装与配置**：学习下载和安装课程所需的分析工具。 * **数据库设计与关系**：掌握数据库的设计原理，以及如何在表中建立关联。 * **SQL 查询与函数**：学习编写 SQL 查询语句，并灵活运用各种内置函数。 * **SQL JOIN 的应用**：掌握如何使用 JOIN 语句合并不同表的数据进行分析。 * **SQL 在营收保证领域的应用**：了解 SQL 如何应用于保险和银行等行业的营收保证工作中。 * **SQL 数据导出到 Power BI**：学习如何将 SQL 分析的数据导出到 Microsoft Power BI 进行可视化展示。 课程中提供的所有数据和 SQL 脚本都包含在第一部分，方便您随学随用。本课程强调理论与实践相结合，致力于让您真正掌握“如何完成工作”。
Have you ever wanted to learn Data analysis on your own but all to no avail?. Have you ever thought of having a Database platform on your system?. This course answers all your questions. In this course, you will learn how to install oracle database and client on your system, Write SQL (Structured Query Language) to analyze, manipulate and visualize data. You will not only learn THEORIES, but you will also learn how to GET IT DONE.In the first section, you will be introduced to SQL fundamentals. After that, you will learn how to download and install the analytic tools for the course. In the third section, you will learn how to design database and establish relationships amongst the tables in the Database. Furthermore, in the fourth section, you will begin to write queries and use Functions in SQL, after that, you will learn how to use SQL JOINS to combine tables together and analyse them. This course will not be ended without application of SQL - you will learn how to use it for Revenue assurance as applicable in the Insurance and Banking Sectors. Finally, you will be imparted with the knowledge of how to use SQL to download data to Microsoft Power BI for Visualizations. The Data and SQL Scripts used in the course are attached in the FIRST SECTION of the course. Wish you a great learning experience!!.
