本课程是 SAS Advanced Programmer 专业证书 的一部分
位教师：Peter Styliadis
17,381 人已注册
包含在 
中
添加到您的领英档案
60 项作业
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.
1个视频5篇阅读材料
In this module, you learn about the Structured Query Language (SQL) and begin exploring data using the SQL procedure in SAS.
8个视频1篇阅读材料2个作业
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.
29个视频5篇阅读材料18个作业
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.
22个视频3篇阅读材料14个作业
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.
19个视频2篇阅读材料12个作业
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.
12个视频4篇阅读材料6个作业
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.
7个视频2篇阅读材料5个作业
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.
15个视频6篇阅读材料2个作业
In this case study, you solve a real-world business problem by applying concepts that you learned in this course.
3篇阅读材料1个作业1个应用程序项目
将此证书添加到您的 LinkedIn 个人资料、简历或履历中。在社交媒体和绩效考核中分享。
University of Colorado Boulder
University of Michigan
285 条评论
89.82%
9.12%
0.35%
0.35%
0.35%
显示 3/285 个
已于 Sep 24, 2022审阅
This course was great overview of SQL and it can be used in SAS.
已于 Dec 27, 2020审阅
Phenomenal course. Best I have used on Coursera. I did 3 hours per day and completed it in a week. The honors project really ties all the lessons together.
已于 Jun 7, 2022审阅
It was a great learning experience. practice questions and assignments were structured nicely to check the learning pattern.
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
提供助学金，
