|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-for-the-sas-programmer/
课程评论：没有评论
课程名称：SAS SQL for the SAS Programmer/Analyst 课程概述：本课程专注于SAS SQL，是我更大规模的SAS编程完整课程的一部分。适合那些在SAS Base方面有一定基础但不常使用SAS SQL的学生。课程目标是教您SQL与SAS编程语言的关系，重点是SAS SQL。因此，您需要对SAS数据步骤有良好的理解！SQL主要用于从数据库表中提取/选择数据及操作这些数据。如果您希望获得一种与SAS数据步骤知识完美互补的技能，这门课程将是您理想的选择。雇主通常希望员工不仅理解SAS数据步骤，还要了解SQL如何融入SAS编程语言。不论您是希望找新工作、在当前公司晋升，还是希望毕业后进入一个受人尊敬且薪资优厚的职业，学习SAS SQL都将使您更接近目标。 课程分为四个主要部分： 1. 基础知识：学习SQL语法，特别是Select和Where子句，以及Case逻辑和汇总函数。 2. 表的连接：介绍如何使用内部连接、连接三张表、左/右连接和全连接。 3. 操作表：学习创建表、修改列（添加、修改、删除）和以不同方式插入行。 4. SQL的实际应用：例如，比较表、查找并去除重复观测、按需排序和在特定条件下更新表。 每个部分包含视频课程，随后是测验（测试一般知识）和作业（需要应用所学内容）。此外，课程提供30天退款保证。 最后，您没有什么可失去的。今天就购买课程，为您的简历增加一项重要的SAS编程技能。请注意，我们与SAS Institute并无任何关联或合作，也不提供或支持下载SAS大学版以供学习使用。我们使用的是WPS商业许可证，课程中提到的“SAS”、“SAS语言”仅指计算机编程语言，而“程序”则指用SAS语言编写的程序。
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.DISCLAIMERWe 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".
