Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 1.5 hours on-demand video
  • 12 articles
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
Development Web Development SAS

SAS SQL for the SAS Programmer/Analyst

SAS SQL. SQL for SAS. If you have knowledge of SAS data step programming, learn Proc SQL now!
Rating: 4.1 out of 54.1 (150 ratings)
1,139 students
Created by Ermin Dedic
Last updated 7/2019
English
English [Auto]
30-Day Money-Back Guarantee

What you'll 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

Course content

6 sections • 29 lectures • 1h 29m total length

  • Preview02:00
  • The dataset that you will need for the Assignments/Excercises
    01:15
  • Installation/Uploading instructions (please read carefully)
    01:32

  • SQL Snytax
    08:37
  • Preview06:13
  • SELECT statement and Columns (Variables,Calculated Value,Formatted Value)
    05:22
  • CASE Logic
    03:22
  • Summary Functions
    03:26
  • Base Knowledge Quiz
    6 questions
  • Assignment 1
    00:14
  • Solution Assignment 1
    00:53

  • Inner Join
    08:56
  • Joining Three Tables
    02:29
  • Left/Right Join
    04:11
  • Full Join (using coalesce function)
    06:24
  • Joining Quiz
    5 questions
  • Assignment 2
    00:31
  • Solution Assignment 2
    00:12

  • Preview04:30
  • 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
    3 questions
  • Assignment 3
    00:31
  • Solution for Assignment 3
    00:13

  • 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
    2 questions
  • Assignment 4
    00:33
  • Solution for Assignment 4
    00:05

  • Bonus Lecture
    00:17

Requirements

  • Internet connection
  • A good knowledge of SAS data step

Description

This is just the SAS SQL portion of my larger SAS Programming Complete Course. Ideal for students who are fairly comfortable with SAS Base but have not used SAS SQL all that much.

The goal of the course is to teach you SQL as it relates to the SAS programming language.  In other words, you will learn SAS SQL. This 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..SAS SQL will get you that much closer.

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 another essential sas programming skill to your resume. SAS SQL.

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 this course is for:

  • Students who have a base knowledge of SAS programming using the data step
  • Students who are interested in developing their SQL skills

Instructor

Ermin Dedic
All Things Data.
Ermin Dedic
  • 4.2 Instructor Rating
  • 4,685 Reviews
  • 40,817 Students
  • 24 Courses

I have a passion for anything data, whether it is applying statistical methods to data more generally, or utilizing a data-driven approach in the Healthcare or Finance/Banking industries.

I studied Psychology for 6-years, including 2 years of Graduate school, where I was training to be a Child/School Psychologist. I was fortunate enough to have the opportunity to experience a blend of course work and clinical work but also recognize some of the problems facing the mental health system and graduate school system. While I am very interested in finding a solution for the latter, this is a long-term goal.

I did ultimately decide to voluntarily leave the Grad program, it was via academics that I fell in love with statistics and statistical software like SPSS/SAS.

Furthermore, it was my Graduate school experience that not only solidified my interest in teaching, it's where I received a lot of positive feedback on my ability to break down complex topics.

I enjoy receiving messages from students who have passed exams, obtained interviews, or gained employment, from taking one of my courses.

---------------------------------------------------------------------------------------
Para meus alunos de língua portuguesa ...

Sou apaixonado por estatística, ciência de dados, programação orientada a objetos e psicologia / saúde mental. Eu desenvolvi um conhecimento em Programação e Estatística SAS através da minha escolaridade e auto-estudo. Também sou autodidata em programação orientada a objetos.


Eu sou um ex-aluno de graduação em psicologia educacional. Dois anos depois, decidi me retirar voluntariamente. Aprendi que o ambiente acadêmico tradicional e o ambiente clínico não eram o caminho adequado para promover mudanças em larga escala.


Ensinar é uma paixão há muito tempo. Criei meu primeiro curso de vídeo online em 2016 (um curso de Estatística). Foi um projeto de pura paixão. Como resultado de obter ótimos comentários, continuei! Atualmente, ensino os cursos de SAS, estatísticas e psicologia, mas também estou sempre aprendendo. Gosto de receber mensagens de alunos que passaram nos exames, obtiveram entrevistas ou obtiveram emprego ao fazer um de meus cursos.

----------------------------------------------------------------------------------------------


  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.