This is just the SAS SQL portion of my larger SAS Programming Complete Course. Ideal for students who are fairly comfortable with SASBase but have not used SASSQLall that much.
The goal of the course is to teachyouSQL as it relates to the SASprogramming language. In other words, you will learn SASSQL.This means that you should have a good grasp of the SAS data step already! SQL is especially utilizedfor extracting/selecting datafrom database tables, and also manipulating that data.
If you're looking to gain a skill that is the PERFECT compliment to your knowledge with theSASdata step, this is the course. Employers often want employeesto understand the SAS data step, and also howSQL is incorporated into the SASProgramming 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..SASSQL 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 Workingwith 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. SASSQL.
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 SASsoftware, or SASlogos. We do not link to SAS website, nor do we linktoany SAScontent, nor do we have screen shots of any of their assets,nordo wedistribute 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 contentthis refers to the computer programming language. Whilethe phrases "program", "SAS program", "SAS language program" used in my courseisused to refer to programs written in the SAS language. These may also be referred to as "scripts", "SAS scripts" or "SAS language scripts".
