Completion

CERTIFICATE

Structured Query Language (SQL) using SAS

Name: Structured Query Language (SQL) using SAS
Rating: 4.9 (276 reviews)

This course is part of SAS Advanced Programmer Professional Certificate.

Course Cost

Free course

Intermediate

Skill Level

23 Hours

Self-paced lessons

This course cannot be purchased separately - to access the complete learning experience, graded assignments, and earn certificates, you'll need to enroll in the full SAS Advanced Programmer Professional Certificate program. You can audit this specific course for free to explore the content, which includes access to course materials and lectures. This allows you to learn at your own pace without any financial commitment.

4.9

16,308 Enrolled

Peter Styliadis

English

4.9

16,308 Enrolled

English

Peter Styliadis

What you'll learn

Query and subset data effectively using SQL in SAS

Summarize and present data through reports and visualizations

Combine tables using various join techniques and set operators

Create and modify tables and views for data management

Create data-driven macro variables to develop dynamic programs

Access database management systems with SAS/ACCESS technology

Write efficient subqueries to solve complex data problems

Apply SQL knowledge to solve practical business problems

Skills you'll gain

SQL

SAS Programming

Database Querying

Data Analysis

PROC SQL

SAS/ACCESS

Data Management

Subqueries

Join Operations

Set Operators

This course includes:

26 Hours PreRecorded video

60 assignments

Access on Mobile, Desktop, Tablet

FullTime access

Shareable certificate

Closed caption

Get a Completion Certificate

Share your certificate with prospective employers and your professional network on LinkedIn.

CREATED BY

PROVIDED BY

Get a Completion Certificate

Share your certificate with prospective employers and your professional network on LinkedIn.

CREATED BY

PROVIDED BY

Top companies offer this course to their employees

Top companies provide this course to enhance their employees' skills, ensuring they excel in handling complex projects and drive organizational success.

There are 9 modules in this course

This comprehensive course teaches learners how to use Structured Query Language (SQL) within SAS programs to create reports and effectively query data. Starting with SQL fundamentals, the course progresses through essential concepts including filtering data with WHERE clauses, sorting with ORDER BY, and enhancing reports with calculated columns and conditional logic. Students learn to summarize and group data, create and modify tables, and use DICTIONARY tables for metadata access. Advanced topics cover joining tables using various join types, writing subqueries, employing set operators, and creating data-driven macro variables. The course concludes with practical instruction on accessing third-party database management systems using SAS/ACCESS technology, preparing learners for real-world data analysis challenges.

Course Overview and Data Setup

Module 1 · 50 Minutes to complete

Essentials

Module 2 · 1 Hours to complete

PROC SQL Fundamentals

Module 3 · 6 Hours to complete

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.

Skills you'll gain

SQL Querying

Data Filtering

Data Sorting

Report Creation

Data Summarization

Table Management

DICTIONARY Tables

This course includes:

29 Videos

18 Assignments

5 Reading Materials

SQL Joins

Module 4 · 4 Hours to complete

Subqueries

Module 5 · 4 Hours to complete

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.

Skills you'll gain

SQL Subqueries

WHERE Clause Subqueries

HAVING Clause Subqueries

In-Line Views

Virtual Tables

Dynamic Calculations

Remerging

This course includes:

19 Videos

12 Assignments

2 Reading Materials

Set Operators

Module 6 · 2 Hours to complete

Using and Creating Macro Variables in SQL

Module 7 · 2 Hours to complete

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.

Skills you'll gain

Macro Variables

User-defined Macros

Data-driven Macros

Dynamic Programming

SQL Macro Integration

This course includes:

7 Videos

5 Assignments

2 Reading Materials

Accessing DBMS Data with SAS/ACCESS

Module 8 · 1 Hours to complete

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.

Skills you'll gain

SAS/ACCESS

DBMS Integration

SQL Pass-Through

LIBNAME Statement

PROC FEDSQL

Database Connectivity

This course includes:

15 Videos

2 Assignments

6 Reading Materials

Case Study (Honors) and Certification Practice Exam

Module 9 · 2 Hours to complete

Fee Structure

Individual course purchase is not available - to enroll in this course with a certificate, you need to purchase the complete Professional Certificate Course. For enrollment and detailed fee structure, visit the following: SAS Advanced Programmer Professional Certificate

Reviews

Testimonials and success stories are a testament to the quality of this program and its impact on your career and learning journey. Be the first to help others make an informed decision by sharing your review of the course.

Faculties

These are the expert instructors who will be teaching you throughout the course. With a wealth of knowledge and real-world experience, they're here to guide, inspire, and support you every step of the way. Get to know the people who will help you reach your learning goals and make the most of your journey.

4.8

102

Reviews

2,030

Students

Courses

Peter Styliadis

Peter Styliadis is a Senior Technical Training Consultant at SAS, where he specializes in developing and delivering comprehensive training programs focused on data analytics and visualization. With a strong foundation in programming languages such as SQL, Python, and SAS, Peter has designed and implemented courses that empower users to effectively process and analyze large datasets. His expertise includes leading curriculum development for key courses like SAS SQL Essentials and Data Visualization Using SAS ODS Graphics. In addition to his instructional roles, he actively mentors fellow instructors and collaborates with internal teams to address customer inquiries, leveraging his extensive knowledge of SAS software. Peter's commitment to education is further demonstrated through his involvement in online learning platforms, where he teaches courses that enhance analytical skills for professionals across various industries. Through his innovative training approaches, he plays a vital role in equipping individuals with the tools necessary to harness the power of data for informed decision-making.

Intermediate

Skill Level

23 Hours

Self-paced lessons

Course Cost

Free course

Completion

CERTIFICATE

Frequently asked Questions

Below are some of the most commonly asked questions about this course. We aim to provide clear and concise answers to help you better understand the course content, structure, and any other relevant information. If you have any additional questions or if your question is not listed here, please don't hesitate to reach out to our support team for further assistance.

Structured Query Language (SQL) using SAS

What you'll learn

Skills you'll gain

This course includes:

Get a Completion Certificate

Get a Completion Certificate

Top companies offer this course to their employees

There are 9 modules in this course

Course Overview and Data Setup

Essentials

PROC SQL Fundamentals

SQL Joins

Subqueries

Set Operators

Using and Creating Macro Variables in SQL

Accessing DBMS Data with SAS/ACCESS

Case Study (Honors) and Certification Practice Exam

Fee Structure

Reviews

Faculties

Frequently asked Questions

When will I have access to the lectures and assignments?

What will I get if I subscribe to this Certificate?

What is the refund policy?