SQL for the SAS Programmer/Analyst
4.5 (19 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
249 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL for the SAS Programmer/Analyst to your Wishlist.

Add to Wishlist

SQL for the SAS Programmer/Analyst

This is the 2nd course in the series. If you have knowledge of SAS data step programming, learn Proc SQL now!
Best Seller
4.5 (19 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
249 students enrolled
Created by Ermin Dedic
Last updated 8/2017
English
Current price: $10 Original price: $195 Discount: 95% off
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 11 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • Apply SQL syntax (like SELECT, WHERE, HAVING, GROUP BY, ORDER BY)
  • Join tables (Inner join, left/right join, joining three tables, and full join)
  • Managing tables (from how to create one, to how to alter columns, add rows)
  • How to apply SQL to compare tables, find duplicate records, create conditions + more
View Curriculum
Requirements
  • Internet connection
  • A good knowledge of SAS data step
Description

*This course uses a commercial license from WPS. Anyone interested in full information, visit our disclaimer at the bottom. Thank you!*

Welcome! New course!

The goal of the course is to teach you SQL as it relates to the SAS programming language.  We will cover proc sql. This essentially means that you should have a good grasp of the SAS data step already! SQL is especially utilized for extracting/selecting data from database tables, and also manipulating that data.

If you're looking to gain a skill that is the PERFECT compliment to your knowledge with the SAS data step, this is the course. Employers often want employees to understand the SAS data step, and also how SQL is incorporated into the SAS Programming language.

Whether you are looking for a new job, looking to move up at your current company, or looking to get into a respected well-paying career after school..this course is for you!

The course has four main sections. The first section is Base Knowledge. You will learn about SQL syntax, including specifics on the Select and Where clause. You will also learn about Case Logic and Summary Functions. The second section is about Joining tables. I show you how to use the inner join, join three tables, left/right join, and full join. The third section is Working with Tables. I show you how to create a table, Alter columns (add, modify, delete) and how to Insert Rows in different ways. The final section is on Practical/Useful applications of SQL. For example, you'll learn how to Compare tables, find duplicate observations/get rid of them, how to sort the way you want to, and how to update a table under certain conditions.

Each section has video lessons, followed by a Quiz (that tests general knowledge), and then an Assignment (that requires you to apply what you've learned.)

Finally, you have nothing to lose. This course has a 30-day money back guarantee. Buy the course today and add an essential skill to your resume.

DISCLAIMER

We are not in any way affiliated or associated with SAS Institute. We do not provide, nor do we endorse, a download of SAS University edition for your learning purposes, nor do we personally use SAS software, or SAS logos. We do not link to SAS website, nor do we link to any SAS content, nor do we have screen shots of any of their assets, nor do we distribute it, nor do we suggest it's ours. 

We use a commercial license from WPS. The system I use, WPS, is in no way associated with SAS System. Furthermore, whenever you see the phrases "SAS", "SAS Language" and "language of SAS" used in the course content this refers to the computer programming language. While the phrases "program", "SAS program", "SAS language program" used in my course is used to refer to programs written in the SAS language. These may also be referred to as "scripts", "SAS scripts" or "SAS language scripts". 


Who is the target audience?
  • Students who have a base knowledge of SAS programming using the data step
  • Students who are interested in developing their SQL skills
Curriculum For This Course
28 Lectures
01:29:22
+
Introduction to the Course
3 Lectures 04:49

This is the dataset that you will use for the assignment portion of the course.

The dataset that you will need for the Assignments
01:16

Installation/Uploading instructions (please read carefully)
01:33
+
Base Knowledge of SQL
7 Lectures 28:37

I begin with an overview of SQL syntax, and how it tends to be organized. By understanding the big picture, we can then start deducing the specifics. I talk about SELECT statement,FROM,WHERE clause (HAVING clause),GROUP BY, ORDER BY.

SQL Snytax
08:37

The WHERE clause allows you to use operators to set conditions and only select what you want from a table. I go over comparison operators, logical operators, and special operators.

Preview 06:13

I get into the specifics about the SELECT statement. 

SELECT statement and Columns (Variables,Calculated Value,Formatted Value)
05:22

I discuss how you can use case logic/expression.

CASE Logic
03:22

You'll often have to summarize your table and get some statistics..I'll show you how.

Summary Functions
03:26

Base Knowledge Quiz

Base Knowledge Quiz
6 questions

Assignment 1
00:17

Solution Assignment 1
01:20
+
JOINING
6 Lectures 22:46
Inner Join
08:56

Joining Three Tables
02:29

Left/Right Join
04:11

Full Join (using coalesce function)
06:24

This is a quiz for the Joining section.

Joining Quiz
5 questions

Assignment 2
00:33

Solution Assignment 2
00:12
+
Working With Tables
5 Lectures 17:56

Altering Columns (add, modify, delete + adding values to column)
05:33

Inserting Rows with a Query and SET statement + Deleting Rows
07:08

Working with Tables Quiz

Working with Tables Quiz
3 questions

Assignment 3
00:32

Solution for Assignment 3
00:13
+
Practical Application of SQL in SAS programming
7 Lectures 15:22
Comparing Tables
02:33

Finding Duplicate Records
03:10

Only Displaying Unique records/rows
00:05

Customize The Way You Sort
03:46

Updating A Table Under Certain Conditions
05:04

Practical Application Quiz

Practical Application Quiz
2 questions

Assignment 4
00:37

Solution for Assignment 4
00:06
About the Instructor
Ermin Dedic
4.3 Average rating
329 Reviews
4,485 Students
9 Courses
Data Science, Graduate Student (Educational Psychology)

The success and fun I had with statistics based courses in University has resulted in my current teaching interests. My interest in data and statistics boils down to my passion for finding the objective truth, and applying these findings in life and business. Currently, I teach five courses. A Statistics course, a SAS course in English, a SAS course in Portuguese (with subtitles, but English instruction), a SAS SQL course, and a Pandas (Python 3 ) course.

O sucesso e diversão que eu tive durante meus cursos de estatística na Universidade resultaram em meu interesse em ensinar. Meu interesse em dados e estatística vêm de minha paixão por encontrar verdades objetivas, e aplicar estas descobertas na vida e no negócio. Atualmente, eu ensino quatro cursos. Um curso de Estatística, um curso de SAS em inglês, um curso de SAS em português (com legendas, mas instruções em inglês) e um curso de Pandas (Python 3).