Morgen endet die Aktion: Entdecken Sie neue F盲higkeiten mit 30% Rabatt auf Kurse von Branchenexperten. Jetzt sparen.
Dieser Kurs ist Teil von SAS Advanced Programmer (berufsbezogenes Zertifikat)
Dozent: Peter Styliadis
17.302 bereits angemeldet
Bei 
enthalten
(285听叠别飞别谤迟耻苍驳别苍)
Zu Ihrem LinkedIn-Profil hinzuf眉gen
60 Aufgaben
In this module you get an overview of what you learn in this course and you set up the software and data you use for activities and practices in the course.
1 Video5 Lekt眉ren
In this module, you learn about the Structured Query Language (SQL) and begin exploring data using the SQL procedure in SAS.
8 Videos1 Lekt眉re2 Aufgaben
In this module, you learn the fundamentals of SQL by using the SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY clauses. You generate simple queries, group and summarize data, create and manage tables, and retrieve information about your SAS session using DICTIONARY tables.
29 Videos5 Lekt眉ren18 Aufgaben
In this module, you learn about joining data horizontally from multiple tables using the Cartesian product. You learn how to perform INNER, OUTER and complex joins.
22 Videos3 Lekt眉ren14 Aufgaben
In this module, you learn about using subqueries, or a query within a query. You begin by using a subquery in the WHERE or HAVING clause to dynamically subset your data, then you use a query in the FROM clause (In-Line view) to act as a virtual table. Finally, you use a subquery in the SELECT clause to perform dynamic calculations.
19 Videos2 Lekt眉ren12 Aufgaben
In this module, you learn to concatenate tables vertically using the INTERSECT, EXCEPT, UNION and OUTER UNION set operators. You learn the difference between the set operators, as well as how to use modifiers to adjust the default behavior.
12 Videos4 Lekt眉ren6 Aufgaben
In this module, you learn about creating and utilizing user-defined macro variables to dynamically write programs that are easily maintained. In addition, you learn to create data-driven macro variables using the SQL procedure, and how to apply the newly created macro variables to your program.
7 Videos2 Lekt眉ren5 Aufgaben
In this module, you learn about SAS/ACCESS technology to retrieve data from third party database management systems (DBMS). You learn about accessing data from a DBMS through the SQL Pass-Through Facility, which allows you to use the specific DBMS implementation of SQL, and the SAS/ACCESS LIBNAME statement, which translates SAS SQL to native DBMS SQL. Finally, you learn about the FEDSQL procedure to use vendor neutral SQL to push as much processing into the DBMS as possible.
15 Videos6 Lekt眉ren2 Aufgaben
In this case study, you solve a real-world business problem by applying concepts that you learned in this course.
3 Lekt眉ren1 Aufgabe1 App-Element
F眉gen Sie dieses Zeugnis Ihrem LinkedIn-Profil, Lebenslauf oder CV hinzu. Teilen Sie sie in Social Media und in Ihrer Leistungsbeurteilung.
University of Colorado Boulder
University of Michigan
285 Bewertungen
89,82听%
9,12听%
0,35听%
0,35听%
0,35听%
Zeigt 3 von 285 an
Gepr眉ft am 25. Sep. 2022
This course was great overview of SQL and it can be used in SAS.
Gepr眉ft am 15. Feb. 2022
Good instructions, videos, quizzes, and assignments. Instructors also provided additional resources. So much easier using SQL in SAS than standard SAS language.
Gepr眉ft am 21. Mai 2021
Wonderful and a fruitful experience. I recommend everyone to take this well structured class and then go through the book or a reading material to master the programming language
Unbegrenzter Zugang zu 10,000+ Weltklasse-Kursen, praktischen Projekten und berufsqualifizierenden Zertifikatsprogrammen - alles in Ihrem Abonnement enthalten
Erwerben Sie einen Abschluss von erstklassigen Universit盲ten 鈥� 100聽% online
Schulen Sie Ihre Mitarbeiter*innen, um sich in der digitalen Wirtschaft zu behaupten.
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don鈥檛 give refunds, but you can cancel your subscription at any time. See our full refund policy.
Finanzielle Unterst眉tzung verf眉gbar,
