Is SQL a Programming Language?
October 28, 2024
Article
This course is part of SAS Advanced Programmer Professional Certificate
Instructor: Peter Styliadis
16,165 already enrolled
Included with
(275 reviews)
(275 reviews)
Add to your LinkedIn profile
60 assignments
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
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.
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 video4 readings
In this module, you learn about the Structured Query Language (SQL) and begin exploring data using the SQL procedure in SAS.
8 videos1 reading2 assignments
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 videos5 readings18 assignments
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 videos3 readings14 assignments
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 videos2 readings12 assignments
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 videos4 readings6 assignments
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 videos2 readings5 assignments
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 videos6 readings2 assignments
In this case study, you solve a real-world business problem by applying concepts that you learned in this course.
3 readings1 assignment1 app item
We asked all learners to give feedback on our instructors based on the quality of their teaching style.
Through innovative software and services, SAS empowers and inspires customers around the world to transform data into intelligence. SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS®, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change.
Coursera Project Network
Course
Coursera Project Network
Course
Edureka
Course
275 reviews
89.85%
9.42%
0.36%
0%
0.36%
Showing 3 of 275
Reviewed on Sep 24, 2022
This course was great overview of SQL and it can be used in SAS.
Reviewed on Dec 20, 2021
Really good course for an intermediate user who wants to sharpen their skills. Would probably also be good for a beginner.
Reviewed on Aug 7, 2021
This was very good. Easy to follow and the practices re-enforced my learning.
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Earn a degree from world-class universities - 100% online
Upskill your employees to excel in the digital economy
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:
The course may not offer an audit option. 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. If you only want to read and view the course content, you can audit the course for free.
If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work.
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.
These cookies enable the website to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.