Structured Query Language (SQL) using SAS

BY
SAS Institute via Coursera

Develop your expertise in SQL to improve your skills for the Statistical Analytical System(SAS) program in this course.

Mode

Online

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

The ‘Structured Query Language (SQL) using SAS’ online certification program is designed for the students to develop their knowledge on the aspects of SQL programming language to make effective reports and queries of the data through the Statistical Analytical System programs. This certification course is provided by the Coursera education portal. The students of this free online course can complete this online training with a total period of twenty-six hours in a span of three weeks.

This course is a part of the SAS Advanced Programmer Professional Certificate training and is led by the course instructor, Peter Styliadis who is a senior associate technical training consultant at SAS Education. The course enables students to engage themselves in hands-on learning methodologies such as videos, reading exercises, practical activities, quizzes, case studies, and other resources. 

The ‘Structured Query Language (SQL) using SAS’ online training program enables students to receive a course certificate that can be shared online for their career development. 

The highlights

  • Online mode
  • Twenty-six hours course
  • Flexible deadlines
  • Free training
  • Financial aid
  • Shareable certificate
  • Subtitles in Arabic, French, Portuguese,  Italian, Vietnamese, German, Russian, English, Spanish

Program offerings

  • Videos
  • Reading
  • Practice exercises
  • Case studies
  • Quizzes
  • Graded assignments
  • Feedback
  • Tests
  • Final exam
  • Certificate
  • Financial support
  • Free classes.

Course and certificate fees

The ‘Structured Query Language (SQL) using SAS’ certification fee is required for the students to get access to the graded assignments, tests, and the certificate, and the students can also pay the course fee through EMI options.

Structured Query Language (SQL) using SAS fee structure

Audit mode

Nil

One month(20 hours/week)

₹4,117

Three months(7 hours/week)

₹8,234

Six months(3 hours/week)

₹12,352

certificate availability

Yes

certificate providing authority

Coursera

Who it is for

The ‘Structured Query Language (SQL) using SAS’ online certification course is delivered for the students and individuals who wish to secure the SAS advanced programmer professional certificate or who are keen on enhancing their knowledge on the SQL for reports and queries from data.

Eligibility criteria

Certificate qualifying details

The students of the ‘Structured Query Language (SQL) using SAS’ certification by Coursera will qualify for the certificate from SAS after completing the course study, graded assignments, quizzes, and tests.

What you will learn

Sql knowledge Knowledge of data visualization Programming skills Data science knowledge Statistical skills Database management

The students of this online program are equipped with the ‘Structured Query Language (SQL) using SAS’ certification syllabus to learn about the following,

  • Queries and data subsets.
  • The techniques for summarization and data presentation.
  • The concepts of putting together tables with joins and set operators.
  • Form and alter views and tables.
  • Make data-driven macro variables with a query.
  • Get to the DBMS data using the SAS or ACCESS technology.

The syllabus

Module 1: Course Overview and Data Setup

Video
  • Course Overview
Readings
  • Learner Prerequisites
  • Using Forums and Getting Help
  • Access SAS Software for this Course
  • Set Up Data for This Course

Module 2: Essentials

Videos
  • Overview
  • What Is SQL?
  • What Is PROC SQL?
  • PROC SQL Syntax
  • Exploring Tables
  • Demo: Exploring the Customer Table
  • SQL Options
  • Comparing SQL and the DATA Step
Reading
  • Learning More (Optional)
Quiz
  • Activity 
  • Essentials Review Quiz

Module 3: PROC SQL Fundamentals

Videos
  • Overview
  • Filtering Rows Using the WHERE Clause
  • Special WHERE Operators: Missing Values
  • Additional Special WHERE Operators
  • Sorting the Output with the ORDER BY Clause
  • Ordering Columns by Position
  • Enhancing Reports
  • Demo: Creating Simple Reports
  • Creating a New Column
  • Subsetting Calculated Values
  • Assigning Values Conditionally with the CASE Expression
  • Demo: Assigning Values Conditionally
  • Eliminating Duplicate Rows with the DISTINCT Keyword
  • Summarizing Data
  • Demo: Using Summary Functions to Analyze a Table
  • Summarizing Data Using the COUNT Function
  • Grouping Data
  • Demo: Analyzing Groups of Data
  • Summarizing Date and Time Data
  • Counting Rows Using a Boolean Expression
  • Demo: Summarizing Data Using a Boolean Expression
  • Creating Tables
  • Creating Tables from a Query
  • Creating Table Structures
  • Inserting Rows into Tables
  • Dropping Tables in PROC SQL
  • Scenario3
  • DICTIONARY Tables
  • Demo: Using DICTIONARY Tables
Readings
  • Date, Time, and Datetime Values
  • Commonly Used Summary Functions
  • Additional Statements to Maintain Tables
  • SQL Order of Execution Cheat Sheet (optional)
  • Learning More (optional)
Quiz
  • Activity 2.01
  • Activity 2.02
  • Activity 2.03
  • Activity 2.04
  • Activity 2.05
  • Level 1 Practice: Querying a Table
  • Level 2 Practice: Working with Datetime Values
  • Activity 2.06
  • Activity 2.07
  • Activity 2.08
  • Level 1 Practice: Eliminating Duplicates
  • Level 2 Practice: Grouping and Summarizing Data
  • Activity 2.09
  • Activity 2.10
  • Activity 2.11
  • Practice Level 1: Counting the Number of Tables in a Library
  • Practice Level 2: Counting the Number of Tables in All Libraries
  • PROC SQL Fundamentals Review Quiz

Module 4: SQL Joins

Videos
  • Overview
  • Joining Tables
  • Types of Joins
  • Joining Two Tables with an Inner Join
  • Demo: Performing an Inner Join with PROC SQL
  • Alternative SQL Inner Join Syntax
  • Using Table Aliases
  • Matching Rows with a Natural Join
  • Selecting Data from More Than Two Tables
  • Demo: Performing an Inner Join with Four Tables
  • Handling Missing Values
  • Creating Non-Equijoins
  • SQL Outer Joins
  • Performing Left and Right Outer Joins
  • Joining Two Tables with a Full Join
  • Demo: Performing a Full Join with Proc SQL
  • Identifying Nonmatching Rows
  • Using Reflexive Joins
  • Demo: Performing a Reflexive Join
  • Using Functions to Join Tables
  • Using Functions to Join When Column Types Are Different
  • Converting Column Values with Functions
Readings
  • Table Relationships
  • SQL Join Summary Cheat Sheet (optional)
  • Learning More (optional)
Quizzes
  • Activity 3.01
  • Activity 3.02
  • Activity 3.03
  • Activity 3.04
  • Practice Level 1: Performing an Inner Join
  • Practice Level 2: Joining on Inequality
  • Activity 3.05
  • Activity 3.06
  • Practice Level 1: Using Outer Joins to Find Nonmatches
  • Practice Level 2: Using Outer Joins to Summarize Data
  • Activity 3.07
  • Activity 3.08
  • Activity 3.09
  • SQL Joins Review

Module 5: Subqueries

Videos
  • Overview
  • What Is a Subquery?
  • Using a Subquery in the WHERE Clause
  • Demo: Using a Subquery That Returns a Single Value
  • Using a Subquery in the HAVING Clause
  • Subquery That Returns Multiple Values
  • Demo: Using a Subquery That Returns Multiple Values
  • Using the ANY Keyword
  • Using Correlated Subqueries
  • Using Temporary Tables
  • What Is an In-Line View?
  • Demo: Using an In-Line View
  • Creating a View
  • Making a View Portable
  • Using a Subquery in the SELECT Clause
  • Remerging Summary Statistics in PROC SQL
  • Demo: Remerging Summary Statistics
  • Controlling Remerging
  • Remerging GROUP BY Summary Statistics
Readings
  • Advantages/Disadvantage of Views
  • Learning More (optional)
Quiz
  • Activity 4.01
  • Activity 4.02
  • Activity 4.03
  • Practice Level 1: Using a Subquery That Returns a Single Value
  • Practice Level 2: Using a Subquery with Multiple Functions
  • Activity 4.04
  • Practice Level 1: Using an In-Line View
  • Practice Level 2: Building a Complex Query Using In-Line Views
  • Activity 4.05
  • Practice Level 1: Remerging Summary Statistics
  • Practice Level 2: Using a Subquery in the SELECT Clause with an In-Line Views
  • Subqueries Review

Module 6: Set Operators

Videos
  • Overview
  • Combining Data Using Set Operators
  • What Are Set Operators?
  • Using Set Operators
  • Using the INTERSECT Operator
  • Using the EXCEPT Operator
  • Using the UNION Operator
  • Demo: Using the UNION Operator to Find All Unique Rows
  • Default Behavior of the UNION Operator
  • Combining Set Operators
  • Using the OUTER UNION Operator
  • Demo: Using the OUTER UNION Operator to Combine Tables
Readings
  • Using a Set Operator Versus a Join
  • Using a Set Operator Versus a Subquery
  • SQL Versus Traditional SAS Programming
  • Learning More (optional)
Quiz
  • Activity 5.01
  • Activity 5.02
  • Practice Level 1: Using the EXCEPT Set Operator
  • Practice Level 2: Using the EXCEPT Set Operator with the DISTINCT keyword
  • Practice: Using the OUTER UNION Set Operator
  • Set Operators Review

Module 7: Using and Creating Macro Variables in SQL

Videos
  • Overview
  • Creating User-Defined Macro Variables
  • Creating Data-Driven Macro Variables
  • Demo: Using a PROC SQL Data-Driven Macro Variable
  • Creating Multiple Macro Variables
  • Concatenating Values into One Macro Variable
  • Demo: Using PROC SQL to Concatenate Multiple Values into One Macro Variable
Readings
  • Using Formats with Macro Variables
  • Learning More (optional)
Quiz
  • Activity 6.01
  • Activity 6.02
  • Practice Level 1: Creating a Macro Variable from an SQL Query
  • Practice Level 2: Creating a Macro Variable with a List of Values from an SQL Query
  • Using and Creating Macro Variables in SQL Review

Module 8: Accessing DBMS Data with SAS/ACCESS

Videos
  • Overview
  • Defining SAS/ACCESS Technology
  • Connection Options
  • Overview of the SQL Pass-Through Facility
  • Steps for Using the SQL Pass-Through Facility
  • Demo: Using an SQL Pass-Through Query
  • SQL Pass-Through Facility Considerations
  • Overview of the SAS/ACCESS LIBNAME Statement
  • Demo: Using the SAS/ACCESS LIBNAME Statement
  • SAS/ACCESS LIBNAME Considerations
  • What Is PROC FEDSQL?
  • Comparing PROC SQL to PROC FEDSQL
  • PROC FEDSQL Syntax
  • Examining the Submitted SQL Code
  • FedSQL and SAS Viya
Readings
  • Note about the Demos that Access Databases in this Lesson
  • Saving SQL Pass-Through Query Results
  • Access SAS DBMS-Specific Reference Documentation
  • PROC SQL Versus PROC FEDSQL
  • PROC SQL Versus PROC FEDSQL Cheat Sheet (optional)
  • Learning More (optional)
Quiz
  • Activity 7.03
  • Accessing DBMS Data with SAS/ACCESS Review

Module 9: Case Study (Honors) and Certification Practice Exam

Admission details

The participants who wish to register for the ‘Structured Query Language (SQL) using SAS’ certification course should apply through the Coursera website.

Step 1: Find the course page using the following link,

https://www.coursera.org/learn/sas-sql

Step 2: Click on the ‘Enroll for Free’ option.

Step 3: Choose among the preferred time and mode for the course study.

Step 4: Pay the course fee.

Step 5: Start the course.


Filling the form

The candidate applying for the ‘Structured Query Language (SQL) using SAS’ online classes should enter their name, phone number, email address, and password to create the course account or can sign in using their Google, Facebook, or Apple ID.

Scholarship Details

  • Those candidates belonging to the ‘Structured Query Language (SQL) using SAS’ online course, who aren’t able to afford the course fee can apply for the financial support provided by Coursera.
  • The interested students must apply through the link ‘Financial Aid Available’ on the course page and should wait for the notification from Coursera regarding the acceptance of the application.

How it helps

The ‘Structured Query Language (SQL) using SAS’ certification benefits the students of this training by enabling them to excel in their career based on SQL programming language along with statistical analytics and data visualization. The students will receive an industrially significant certificate from SAS and the skills through free training.

Instructors

Mr Peter Styliadis

Mr Peter Styliadis
Senior Associate Technical Training Consultant
SAS Institute

FAQs

Which online platform offers the ‘Structured Query Language (SQL) using SAS’ certification course?

The course is provided by Coursera.

How long will it take to complete the ‘Structured Query Language (SQL) using SAS’ online course?

The course is designed to be completed in twenty-six hours.

What are the prerequisites for the ‘Structured Query Language (SQL) using SAS’ online certification course?

There are no prerequisites for this course.

Can I pay the ‘Structured Query Language (SQL) using SAS’ course fee in installments?

Yes, Coursera provides EMI options to pay this course fee.

Will I get a certificate for the ‘Structured Query Language (SQL) using SAS’ training?

Yes, you will get a certificate from SAS for this training.

Articles

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books