SAS
Structured Query Language (SQL) using SAS
SAS

Structured Query Language (SQL) using SAS

This course is part of SAS Advanced Programmer Professional Certificate

Taught in English

Peter Styliadis

Instructor: Peter Styliadis

14,269 already enrolled

Included with Coursera Plus

Course

Gain insight into a topic and learn the fundamentals

4.9

(251 reviews)

|

95%

26 hours (approximately)
Flexible schedule
Learn at your own pace

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

60 quizzes

Course

Gain insight into a topic and learn the fundamentals

4.9

(251 reviews)

|

95%

26 hours (approximately)
Flexible schedule
Learn at your own pace

See how employees at top companies are mastering in-demand skills

Placeholder

Build your Data Analysis expertise

This course is part of the SAS Advanced Programmer Professional Certificate
When you enroll in this course, you'll also be enrolled in this Professional Certificate.
  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate from SAS
Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

There are 9 modules in this course

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.

What's included

1 video4 readings

In this module, you learn about the Structured Query Language (SQL) and begin exploring data using the SQL procedure in SAS.

What's included

8 videos1 reading2 quizzes

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.

What's included

29 videos5 readings18 quizzes

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.

What's included

22 videos3 readings14 quizzes

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.

What's included

19 videos2 readings12 quizzes

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.

What's included

12 videos4 readings6 quizzes

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.

What's included

7 videos2 readings5 quizzes

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.

What's included

15 videos6 readings2 quizzes

In this case study, you solve a real-world business problem by applying concepts that you learned in this course.

What's included

3 readings1 quiz1 app item

Instructor

Instructor ratings
4.8 (98 ratings)
Peter Styliadis
SAS
5 Courses18,231 learners

Offered by

SAS

Recommended if you're interested in Data Analysis

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

Showing 3 of 251

4.9

251 reviews

  • 5 stars

    89.68%

  • 4 stars

    9.52%

  • 3 stars

    0.39%

  • 2 stars

    0%

  • 1 star

    0.39%

SO
5

Reviewed on Sep 24, 2022

FD
4

Reviewed on Aug 7, 2021

HA
5

Reviewed on Dec 20, 2021

New to Data Analysis? Start here.

Placeholder

Open new doors with Coursera Plus

Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions