À propos de ce cours

46,493 consultations récentes
Certificat partageable
Obtenez un Certificat lorsque vous terminez
100 % en ligne
Commencez dès maintenant et apprenez aux horaires qui vous conviennent.
Cours 1 sur 3 dans le
Dates limites flexibles
Réinitialisez les dates limites selon votre disponibilité.
Approx. 23 heures pour terminer
Anglais
Certificat partageable
Obtenez un Certificat lorsque vous terminez
100 % en ligne
Commencez dès maintenant et apprenez aux horaires qui vous conviennent.
Cours 1 sur 3 dans le
Dates limites flexibles
Réinitialisez les dates limites selon votre disponibilité.
Approx. 23 heures pour terminer
Anglais

Offert par

Placeholder

SAS

Programme du cours : ce que vous apprendrez dans ce cours

Semaine
1

Semaine 1

1 heure pour terminer

Course Overview and Data Setup

1 heure pour terminer
1 vidéo (Total 1 min), 4 lectures
1 vidéo
4 lectures
Learner Prerequisites5 min
Using Forums and Getting Help5 min
Access SAS Software for this Course10 min
Set Up Data for This Course30 min
1 heure pour terminer

Essentials

1 heure pour terminer
8 vidéos (Total 13 min), 1 lecture, 2 quiz
8 vidéos
What Is SQL?3 min
What Is PROC SQL?1 min
PROC SQL Syntax1 min
Exploring Tables1 min
Demo: Exploring the Customer Table2 min
SQL Options36s
Comparing SQL and the DATA Step1 min
1 lecture
Learning More (Optional)10 min
2 exercices pour s'entraîner
Activity 1.0110 min
Essentials Review Quiz30 min
Semaine
2

Semaine 2

6 heures pour terminer

PROC SQL Fundamentals

6 heures pour terminer
29 vidéos (Total 56 min), 5 lectures, 18 quiz
29 vidéos
Filtering Rows Using the WHERE Clause4 min
Special WHERE Operators: Missing Values52s
Additional Special WHERE Operators1 min
Sorting the Output with the ORDER BY Clause33s
Ordering Columns by Position17s
Enhancing Reports4 min
Demo: Creating Simple Reports4 min
Creating a New Column1 min
Subsetting Calculated Values43s
Assigning Values Conditionally with the CASE Expression1 min
Demo: Assigning Values Conditionally2 min
Eliminating Duplicate Rows with the DISTINCT Keyword54s
Summarizing Data1 min
Demo: Using Summary Functions to Analyze a Table3 min
Summarizing Data Using the COUNT Function20s
Grouping Data2 min
Demo: Analyzing Groups of Data4 min
Summarizing Date and Time Data1 min
Counting Rows Using a Boolean Expression37s
Demo: Summarizing Data Using a Boolean Expression2 min
Creating Tables1 min
Creating Tables from a Query1 min
Creating Table Structures1 min
Inserting Rows into Tables2 min
Dropping Tables in PROC SQL10s
Scenario31s
DICTIONARY Tables1 min
Demo: Using DICTIONARY Tables5 min
5 lectures
Date, Time, and Datetime Values10 min
Commonly Used Summary Functions10 min
Additional Statements to Maintain Tables10 min
SQL Order of Execution Cheat Sheet (optional)1 min
Learning More (optional)1 min
18 exercices pour s'entraîner
Activity 2.0110 min
Activity 2.0210 min
Activity 2.0310 min
Activity 2.0410 min
Activity 2.0510 min
Level 1 Practice: Querying a Table20 min
Level 2 Practice: Working with Datetime Values20 min
Activity 2.0610 min
Activity 2.0710 min
Activity 2.0810 min
Level 1 Practice: Eliminating Duplicates20 min
Level 2 Practice: Grouping and Summarizing Data20 min
Activity 2.0910 min
Activity 2.1010 min
Activity 2.1110 min
Practice Level 1: Counting the Number of Tables in a Library20 min
Practice Level 2: Counting the Number of Tables in All Libraries20 min
PROC SQL Fundamentals Review Quiz30 min
Semaine
3

Semaine 3

4 heures pour terminer

SQL Joins

4 heures pour terminer
22 vidéos (Total 29 min), 3 lectures, 14 quiz
22 vidéos
Joining Tables2 min
Types of Joins1 min
Joining Two Tables with an Inner Join1 min
Demo: Performing an Inner Join with PROC SQL2 min
Alternative SQL Inner Join Syntax40s
Using Table Aliases39s
Matching Rows with a Natural Join1 min
Selecting Data from More Than Two Tables39s
Demo: Performing an Inner Join with Four Tables2 min
Handling Missing Values1 min
Creating Non-Equijoins47s
SQL Outer Joins1 min
Performing Left and Right Outer Joins1 min
Joining Two Tables with a Full Join42s
Demo: Performing a Full Join with Proc SQL2 min
Identifying Nonmatching Rows1 min
Using Reflexive Joins1 min
Demo: Performing a Reflexive Join2 min
Using Functions to Join Tables39s
Using Functions to Join When Column Types Are Different17s
Converting Column Values with Functions1 min
3 lectures
Table Relationships10 min
SQL Join Summary Cheat Sheet (optional)1 min
Learning More (optional)1 min
14 exercices pour s'entraîner
Activity 3.0110 min
Activity 3.0210 min
Activity 3.0310 min
Activity 3.0410 min
Practice Level 1: Performing an Inner Join20 min
Practice Level 2: Joining on Inequality20 min
Activity 3.0510 min
Activity 3.0610 min
Practice Level 1: Using Outer Joins to Find Nonmatches20 min
Practice Level 2: Using Outer Joins to Summarize Data20 min
Activity 3.0710 min
Activity 3.0810 min
Activity 3.0910 min
SQL Joins Review30 min
Semaine
4

Semaine 4

4 heures pour terminer

Subqueries

4 heures pour terminer
19 vidéos (Total 33 min), 2 lectures, 12 quiz
19 vidéos
What Is a Subquery?1 min
Using a Subquery in the WHERE Clause2 min
Demo: Using a Subquery That Returns a Single Value2 min
Using a Subquery in the HAVING Clause1 min
Subquery That Returns Multiple Values1 min
Demo: Using a Subquery That Returns Multiple Values2 min
Using the ANY Keyword1 min
Using Correlated Subqueries1 min
Using Temporary Tables1 min
What Is an In-Line View?34s
Demo: Using an In-Line View3 min
Creating a View2 min
Making a View Portable2 min
Using a Subquery in the SELECT Clause45s
Remerging Summary Statistics in PROC SQL1 min
Demo: Remerging Summary Statistics2 min
Controlling Remerging1 min
Remerging GROUP BY Summary Statistics1 min
2 lectures
Advantages/Disadvantage of Views10 min
Learning More (optional)1 min
12 exercices pour s'entraîner
Activity 4.0110 min
Activity 4.0215 min
Activity 4.0310 min
Practice Level 1: Using a Subquery That Returns a Single Value20 min
Practice Level 2: Using a Subquery with Multiple Functions20 min
Activity 4.0410 min
Practice Level 1: Using an In-Line View20 min
Practice Level 2: Building a Complex Query Using In-Line Views20 min
Activity 4.0510 min
Practice Level 1: Remerging Summary Statistics20 min
Practice Level 2: Using a Subquery in the SELECT Clause with an In-Line Views20 min
Subqueries Review30 min

Avis

Meilleurs avis pour STRUCTURED QUERY LANGUAGE (SQL) USING SAS

Voir tous les avis

À propos du Nombre de SAS Advanced Programmer Certificat Professionnel

SAS Advanced Programmer

Foire Aux Questions

D'autres questions ? Visitez le Centre d'Aide pour les Etudiants.