Ce cours fait partie de SAS Advanced Programmer Certificat Professionnel
Instructeur : Peter Styliadis
15 659 déjà inscrits
Inclus avec 
(267 avis)
Ajouter à votre profil LinkedIn
60 devoirs
Ajoutez cette qualification à votre profil LinkedIn ou à votre CV
Partagez-le sur les réseaux sociaux et dans votre évaluation de performance
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 vidéo4 lectures
In this module, you learn about the Structured Query Language (SQL) and begin exploring data using the SQL procedure in SAS.
8 vidéos1 lecture2 devoirs
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 vidéos5 lectures18 devoirs
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 vidéos3 lectures14 devoirs
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 vidéos2 lectures12 devoirs
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 vidéos4 lectures6 devoirs
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 vidéos2 lectures5 devoirs
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 vidéos6 lectures2 devoirs
In this case study, you solve a real-world business problem by applying concepts that you learned in this course.
3 lectures1 devoir1 élément d'application
Affichage de 3 sur 267
267 avis
89,55 %
9,70 %
0,37 %
0 %
0,37 %
Accès illimité à plus de 7 000 cours de renommée internationale, à des projets pratiques et à des programmes de certificats reconnus sur le marché du travail, tous inclus dans votre abonnement
Obtenez un diplôme auprès d’universités de renommée mondiale - 100 % en ligne
Améliorez les compétences de vos employés pour exceller dans l’économie numérique
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. 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 only want to read and view the course content, you can audit the course for free.
If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.
