Structured Query Language (SQL) using SAS
Course DescriptionIn 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.
None
Syllabus
Syllabus - What you will learn from this course
Week 1
Course Overview and Data Setup
Essentials
Week 2
PROC SQL Fundamentals
Week 3
SQL Joins
Week 4
Subqueries
Week 5
Set Operators
Using and Creating Macro Variables in SQL
Week 6
Accessing DBMS Data with SAS/ACCESS
Case Study (Honors) and Certification Practice Exam
FAQ
When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
What will I get if I subscribe to this Certificate?
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. If you only want to read and view the course content, you can audit the course for free.
Reviews
Very easy to understand, even for some one who never know what is an SQL in his entire Life.
Graet detail and very clear presentations, useful practices and easy exams; great documentation and in-depth orientation.
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.
It was a great learning experience. practice questions and assignments were structured nicely to check the learning pattern.
