Informações sobre o curso

45,035 visualizações recentes
Certificados compartilháveis
Tenha o certificado após a conclusão
100% on-line
Comece imediatamente e aprenda em seu próprio cronograma.
Prazos flexíveis
Redefinir os prazos de acordo com sua programação.
Aprox. 23 horas para completar
Inglês
Legendas: Inglês
Certificados compartilháveis
Tenha o certificado após a conclusão
100% on-line
Comece imediatamente e aprenda em seu próprio cronograma.
Prazos flexíveis
Redefinir os prazos de acordo com sua programação.
Aprox. 23 horas para completar
Inglês
Legendas: Inglês

oferecido por

Placeholder

SAS

Programa - O que você aprenderá com este curso

Semana
1

Semana 1

1 hora para concluir

Course Overview and Data Setup

1 hora para concluir
1 vídeo (Total 1 mín.), 4 leituras
1 vídeos
4 leituras
Learner Prerequisites5min
Using Forums and Getting Help5min
Access SAS Software for this Course10min
Set Up Data for This Course30min
1 hora para concluir

Essentials

1 hora para concluir
8 vídeos (Total 13 mín.), 1 leitura, 2 testes
8 videos
What Is SQL?3min
What Is PROC SQL?1min
PROC SQL Syntax1min
Exploring Tables1min
Demo: Exploring the Customer Table2min
SQL Options36s
Comparing SQL and the DATA Step1min
1 leituras
Learning More (Optional)10min
2 exercícios práticos
Activity 1.0110min
Essentials Review Quiz30min
Semana
2

Semana 2

6 horas para concluir

PROC SQL Fundamentals

6 horas para concluir
29 vídeos (Total 56 mín.), 5 leituras, 18 testes
29 videos
Filtering Rows Using the WHERE Clause4min
Special WHERE Operators: Missing Values52s
Additional Special WHERE Operators1min
Sorting the Output with the ORDER BY Clause33s
Ordering Columns by Position17s
Enhancing Reports4min
Demo: Creating Simple Reports4min
Creating a New Column1min
Subsetting Calculated Values43s
Assigning Values Conditionally with the CASE Expression1min
Demo: Assigning Values Conditionally2min
Eliminating Duplicate Rows with the DISTINCT Keyword54s
Summarizing Data1min
Demo: Using Summary Functions to Analyze a Table3min
Summarizing Data Using the COUNT Function20s
Grouping Data2min
Demo: Analyzing Groups of Data4min
Summarizing Date and Time Data1min
Counting Rows Using a Boolean Expression37s
Demo: Summarizing Data Using a Boolean Expression2min
Creating Tables1min
Creating Tables from a Query1min
Creating Table Structures1min
Inserting Rows into Tables2min
Dropping Tables in PROC SQL10s
Scenario31s
DICTIONARY Tables1min
Demo: Using DICTIONARY Tables5min
5 leituras
Date, Time, and Datetime Values10min
Commonly Used Summary Functions10min
Additional Statements to Maintain Tables10min
SQL Order of Execution Cheat Sheet (optional)1min
Learning More (optional)1min
18 exercícios práticos
Activity 2.0110min
Activity 2.0210min
Activity 2.0310min
Activity 2.0410min
Activity 2.0510min
Level 1 Practice: Querying a Table20min
Level 2 Practice: Working with Datetime Values20min
Activity 2.0610min
Activity 2.0710min
Activity 2.0810min
Level 1 Practice: Eliminating Duplicates20min
Level 2 Practice: Grouping and Summarizing Data20min
Activity 2.0910min
Activity 2.1010min
Activity 2.1110min
Practice Level 1: Counting the Number of Tables in a Library20min
Practice Level 2: Counting the Number of Tables in All Libraries20min
PROC SQL Fundamentals Review Quiz30min
Semana
3

Semana 3

4 horas para concluir

SQL Joins

4 horas para concluir
22 vídeos (Total 29 mín.), 3 leituras, 14 testes
22 videos
Joining Tables2min
Types of Joins1min
Joining Two Tables with an Inner Join1min
Demo: Performing an Inner Join with PROC SQL2min
Alternative SQL Inner Join Syntax40s
Using Table Aliases39s
Matching Rows with a Natural Join1min
Selecting Data from More Than Two Tables39s
Demo: Performing an Inner Join with Four Tables2min
Handling Missing Values1min
Creating Non-Equijoins47s
SQL Outer Joins1min
Performing Left and Right Outer Joins1min
Joining Two Tables with a Full Join42s
Demo: Performing a Full Join with Proc SQL2min
Identifying Nonmatching Rows1min
Using Reflexive Joins1min
Demo: Performing a Reflexive Join2min
Using Functions to Join Tables39s
Using Functions to Join When Column Types Are Different17s
Converting Column Values with Functions1min
3 leituras
Table Relationships10min
SQL Join Summary Cheat Sheet (optional)1min
Learning More (optional)1min
14 exercícios práticos
Activity 3.0110min
Activity 3.0210min
Activity 3.0310min
Activity 3.0410min
Practice Level 1: Performing an Inner Join20min
Practice Level 2: Joining on Inequality20min
Activity 3.0510min
Activity 3.0610min
Practice Level 1: Using Outer Joins to Find Nonmatches20min
Practice Level 2: Using Outer Joins to Summarize Data20min
Activity 3.0710min
Activity 3.0810min
Activity 3.0910min
SQL Joins Review30min
Semana
4

Semana 4

4 horas para concluir

Subqueries

4 horas para concluir
19 vídeos (Total 33 mín.), 2 leituras, 12 testes
19 videos
What Is a Subquery?1min
Using a Subquery in the WHERE Clause2min
Demo: Using a Subquery That Returns a Single Value2min
Using a Subquery in the HAVING Clause1min
Subquery That Returns Multiple Values1min
Demo: Using a Subquery That Returns Multiple Values2min
Using the ANY Keyword1min
Using Correlated Subqueries1min
Using Temporary Tables1min
What Is an In-Line View?34s
Demo: Using an In-Line View3min
Creating a View2min
Making a View Portable2min
Using a Subquery in the SELECT Clause45s
Remerging Summary Statistics in PROC SQL1min
Demo: Remerging Summary Statistics2min
Controlling Remerging1min
Remerging GROUP BY Summary Statistics1min
2 leituras
Advantages/Disadvantage of Views10min
Learning More (optional)1min
12 exercícios práticos
Activity 4.0110min
Activity 4.0215min
Activity 4.0310min
Practice Level 1: Using a Subquery That Returns a Single Value20min
Practice Level 2: Using a Subquery with Multiple Functions20min
Activity 4.0410min
Practice Level 1: Using an In-Line View20min
Practice Level 2: Building a Complex Query Using In-Line Views20min
Activity 4.0510min
Practice Level 1: Remerging Summary Statistics20min
Practice Level 2: Using a Subquery in the SELECT Clause with an In-Line Views20min
Subqueries Review30min

Avaliações

Principais avaliações do STRUCTURED QUERY LANGUAGE (SQL) USING SAS

Visualizar todas as avaliações

Sobre Certificado Profissional SAS Advanced Programmer

When you complete this professional certificate program, you will have experience in SAS programming using SAS 9 and will be able to process data using Structured Query Language in the SAS environment, use the SAS macro facility to design, write, and debug dynamic macro programs, and use advanced DATA step techniques and procedures to manipulate data. These skills prepare you for the SAS Advanced Programming Professional certification exam....
SAS Advanced Programmer

Perguntas Frequentes – FAQ

Mais dúvidas? Visite o Central de Ajuda ao Aprendiz.