|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/sas-sql
课程评论：没有评论
课程名称：使用SAS的结构化查询语言（SQL） 课程概述： 在本课程中，您将学习结构化查询语言（SQL）及其在SAS程序中用于创建报告和查询数据的应用。 结课目标： 完成本课程后，学习者将能够： - 查询和子集数据。 - 汇总和展示数据。 - 使用连接和集合运算符合并表格。 - 创建和修改表及视图。 - 使用查询创建数据驱动的宏变量。 - 利用SAS/ACCESS技术访问DBMS数据。 课程大纲： 1. **课程概述和数据设置** 描述：在本模块中，您将了解课程内容，并设置软件和数据以进行活动和实践。 2. **基础知识** 描述：在本模块中，您将学习结构化查询语言（SQL），并开始使用SAS中的SQL过程进行数据探索。 3. **PROC SQL基础** 描述：在本模块中，您将学习SQL的基础知识，使用SELECT、FROM、WHERE、GROUP BY、HAVING和ORDER BY语句生成简单查询，分组和汇总数据，管理表格，并使用DICTIONARY表检索有关SAS会话的信息。 4. **SQL连接** 描述：在本模块中，您将学习如何通过笛卡尔积从多个表中横向连接数据，以及如何执行INNER、OUTER和复杂连接。 5. **子查询** 描述：在本模块中，您将学习如何使用子查询，即查询中的查询。您将学习如何在WHERE或HAVING子句中使用子查询动态筛选数据，在FROM子句中使用查询（内联视图）作为虚拟表，最后在SELECT子句中使用子查询进行动态计算。 6. **集合运算符** 描述：在本模块中，您将学习如何使用INTERSECT、EXCEPT、UNION和OUTER UNION集合运算符纵向连接表格。您将了解集合运算符之间的区别，以及如何使用修饰符来调整默认行为。 7. **在SQL中使用和创建宏变量** 描述：在本模块中，您将学习创建和利用用户定义的宏变量，动态编写易于维护的程序。此外，您还将学习如何使用SQL过程创建数据驱动的宏变量，并将新创建的宏变量应用于您的程序中。 8. **使用SAS/ACCESS访问DBMS数据** 描述：在本模块中，您将学习如何使用SAS/ACCESS技术从第三方数据库管理系统（DBMS）检索数据。您将学习如何通过SQL传递工具访问DBMS数据，使用SAS/ACCESS LIBNAME语句将SAS SQL转换为本机DBMS SQL，最后，您将学习使用FEDSQL过程，利用中立SQL将尽可能多的处理推入DBMS。 9. **案例研究（荣誉）和认证实践考试** 描述：在本案例研究中，您将通过应用在课程中学到的概念来解决一个实际的商业问题。
Name:Course Overview and Data Setup
Description:In this module you get an overview of what you learn in this course and you set up the software and data you use for activities and practices in the course.
Name:Essentials
Description:In this module, you learn about the Structured Query Language (SQL) and begin exploring data using the SQL procedure in SAS.
Name:PROC SQL Fundamentals
Description:In this module, you learn the fundamentals of SQL by using the SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY clauses. You generate simple queries, group and summarize data, create and manage tables, and retrieve information about your SAS session using DICTIONARY tables.
Name:SQL Joins
Description:In this module, you learn about joining data horizontally from multiple tables using the Cartesian product. You learn how to perform INNER, OUTER and complex joins.
Name:Subqueries
Description:In this module, you learn about using subqueries, or a query within a query. You begin by using a subquery in the WHERE or HAVING clause to dynamically subset your data, then you use a query in the FROM clause (In-Line view) to act as a virtual table. Finally, you use a subquery in the SELECT clause to perform dynamic calculations.
Name:Set Operators
Description:In this module, you learn to concatenate tables vertically using the INTERSECT, EXCEPT, UNION and OUTER UNION set operators. You learn the difference between the set operators, as well as how to use modifiers to adjust the default behavior.
Name:Using and Creating Macro Variables in SQL
Description:In this module, you learn about creating and utilizing user-defined macro variables to dynamically write programs that are easily maintained. In addition, you learn to create data-driven macro variables using the SQL procedure, and how to apply the newly created macro variables to your program.
Name:Accessing DBMS Data with SAS/ACCESS
Description:In this module, you learn about SAS/ACCESS technology to retrieve data from third party database management systems (DBMS). You learn about accessing data from a DBMS through the SQL Pass-Through Facility, which allows you to use the specific DBMS implementation of SQL, and the SAS/ACCESS LIBNAME statement, which translates SAS SQL to native DBMS SQL. Finally, you learn about the FEDSQL procedure to use vendor neutral SQL to push as much processing into the DBMS as possible.
Name:Case Study (Honors) and Certification Practice Exam
Description:In this case study, you solve a real-world business problem by applying concepts that you learned in this course.
Course Description In this course, you learn about Structured Query Language (SQL) and how it can be used in SAS programs to create reports and query your data. “By the end of this course, a learner will be able to…” ● Query and subset data. ● Summarize and present data. ● Combine tables using joins and set operators. ● Create and modify tables and views. ● Create data-driven macro variables using a query. ● Access DBMS data with SAS/ACCESS technology.
