Structured Query Language (SQL) using SAS

Course Overview and Data Setup provides learners with the necessary prerequisites and setup to start the course, including accessing SAS software and setting up data for the course.

Essentials module covers the basics of SQL, including an overview of SQL and PROC SQL, exploring tables, and comparing SQL with the DATA step.

PROC SQL Fundamentals module delves into filtering rows, sorting output, enhancing reports, creating tables, using DICTIONARY tables, and working with date and time data, among other topics.

SQL Joins module focuses on joining tables, types of joins, handling missing values, using table aliases, and identifying nonmatching rows, among other important concepts related to SQL joins.

Subqueries module covers the use of subqueries in the WHERE and HAVING clauses, using temporary tables, creating views, and controlling remerging, among other subquery-related topics.

Set Operators module explores combining data using set operators, including the use of INTERSECT, EXCEPT, and UNION operators, and the differences between using set operators, joins, and subqueries.

Using and Creating Macro Variables in SQL module teaches learners how to create user-defined and data-driven macro variables, concatenate values into one macro variable, and use formats with macro variables.

Accessing DBMS Data with SAS/ACCESS module provides an overview of SAS/ACCESS technology, the SQL Pass-Through Facility, PROC FEDSQL, and considerations when accessing DBMS data, among other related topics.

The Case Study (Honors) and Certification Practice Exam module enables learners to apply their skills and knowledge gained throughout the course to a practical case study, preparing them for certification exams.