SAS SQL for the SAS Programmer/Analyst
SAS SQL for the SAS Programmer/Analyst, available at $59.99, has an average rating of 4.45, with 29 lectures, 4 quizzes, based on 184 reviews, and has 1306 subscribers.
You will learn about 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 This course is ideal for individuals who are Students who have a base knowledge of SAS programming using the data step or Students who are interested in developing their SQL skills It is particularly useful for Students who have a base knowledge of SAS programming using the data step or Students who are interested in developing their SQL skills.
Enroll now: SAS SQL for the SAS Programmer/Analyst
Summary
Title: SAS SQL for the SAS Programmer/Analyst
Price: $59.99
Average Rating: 4.45
Number of Lectures: 29
Number of Quizzes: 4
Number of Published Lectures: 29
Number of Published Quizzes: 4
Number of Curriculum Items: 33
Number of Published Curriculum Objects: 33
Original Price: $189.99
Quality Status: approved
Status: Live
What You Will 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
Who Should Attend
- Students who have a base knowledge of SAS programming using the data step
- Students who are interested in developing their SQL skills
Target Audiences
- Students who have a base knowledge of SAS programming using the data step
- Students who are interested in developing their SQL skills
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 theSAS 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 PERFECTcompliment 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”.
Course Curriculum
Chapter 1: Introduction to the Course
Lecture 1: Introduction
Lecture 2: The dataset that you will need for the Assignments/Excercises
Lecture 3: Installation/Uploading instructions (please read carefully)
Chapter 2: Base Knowledge of SQL
Lecture 1: SQL Snytax
Lecture 2: Where CLAUSE
Lecture 3: SELECT statement and Columns (Variables,Calculated Value,Formatted Value)
Lecture 4: CASE Logic
Lecture 5: Summary Functions
Lecture 6: Assignment 1
Lecture 7: Solution Assignment 1
Chapter 3: JOINING
Lecture 1: Inner Join
Lecture 2: Joining Three Tables
Lecture 3: Left/Right Join
Lecture 4: Full Join (using coalesce function)
Lecture 5: Assignment 2
Lecture 6: Solution Assignment 2
Chapter 4: Working With Tables
Lecture 1: Creating A Table
Lecture 2: Altering Columns (add, modify, delete + adding values to column)
Lecture 3: Inserting Rows with a Query and SET statement + Deleting Rows
Lecture 4: Assignment 3
Lecture 5: Solution for Assignment 3
Chapter 5: Practical Application of SQL in SAS programming
Lecture 1: Comparing Tables
Lecture 2: Finding Duplicate Records
Lecture 3: Only Displaying Unique records/rows
Lecture 4: Customize The Way You Sort
Lecture 5: Updating A Table Under Certain Conditions
Lecture 6: Assignment 4
Lecture 7: Solution for Assignment 4
Chapter 6: Bonus
Lecture 1: Bonus Lecture
Instructors
-
Ermin Dedic
All Things Data.
Rating Distribution
- 1 stars: 8 votes
- 2 stars: 3 votes
- 3 stars: 24 votes
- 4 stars: 74 votes
- 5 stars: 75 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Language Learning Courses to Learn in November 2024
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024