Este curso forma parte de Certificado profesional de SAS Advanced Programmer

4.9
estrellas
214 calificaciones

Peter Styliadis

11.364 ya inscrito

Ofrecido Por

Certificado profesional de SAS Advanced ProgrammerSAS

Acerca de este Curso

40.505 vistas recientes

Course Description
In this course, you learn about Structured Query Language (SQL) and how it can be used in SAS programs to create reports and query your data.   

“By the end of this course, a learner will be able to…”
●	Query and subset data.
●	Summarize and present data.
●	Combine tables using joins and set operators.
●	Create and modify tables and views.
●	Create data-driven macro variables using a query.
●	Access DBMS data with SAS/ACCESS technology.

Fechas límite flexibles

Restablece las fechas límite en función de tus horarios.

Certificado para compartir

Obtén un certificado al finalizar

100 % en línea

Comienza de inmediato y aprende a tu propio ritmo.

Laboratorios de Coursera

Incluye proyectos de aprendizaje prácticos.

Obtén más información sobre los laboratorios de Coursera

Curso 1 de 3 en

Certificado profesional de SAS Advanced Programmer

Aprox. 26 horas para completar

Inglés (English)

¿Podría tu empresa beneficiarse de la capacitación de los empleados en las habilidades más demandadas?

Prueba Coursera para negocios

Fechas límite flexibles

Restablece las fechas límite en función de tus horarios.

Certificado para compartir

Obtén un certificado al finalizar

100 % en línea

Comienza de inmediato y aprende a tu propio ritmo.

Laboratorios de Coursera

Incluye proyectos de aprendizaje prácticos.

Obtén más información sobre los laboratorios de Coursera

Curso 1 de 3 en

Certificado profesional de SAS Advanced Programmer

Aprox. 26 horas para completar

Inglés (English)

¿Podría tu empresa beneficiarse de la capacitación de los empleados en las habilidades más demandadas?

Prueba Coursera para negocios

Instructor

Calificación del instructor

4,83/5 (85 calificaciones)

Peter Styliadis

Senior Technical Training Consultant

SAS Education

13.962 alumnos

5 cursos

Ofrecido por

SAS

Through innovative software and services, SAS empowers and inspires customers around the world to transform data into intelligence. SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS®, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change.

Mira cómo los empleados de las mejores empresas dominan las habilidades más demandadas

Obtén más información sobre Coursera para Empresas

Programa - Qué aprenderás en este curso

Semana1

Semana 1

1 hora para completar

Course Overview and Data Setup

1 hora para completar

1 video (Total 1 minutos), 4 lecturas

1 hora para completar

Essentials

1 hora para completar

8 videos (Total 13 minutos), 1 lectura, 2 cuestionarios

Semana2

Semana 2

7 horas para completar

PROC SQL Fundamentals

7 horas para completar

29 videos (Total 56 minutos), 5 lecturas, 18 cuestionarios

29 videos

Overview31sFiltering Rows Using the WHERE Clause4mSpecial WHERE Operators: Missing Values52sAdditional Special WHERE Operators1mSorting the Output with the ORDER BY Clause33sOrdering Columns by Position17sEnhancing Reports4mDemo: Creating Simple Reports4mCreating a New Column1mSubsetting Calculated Values43sAssigning Values Conditionally with the CASE Expression1mDemo: Assigning Values Conditionally2mEliminating Duplicate Rows with the DISTINCT Keyword54sSummarizing Data1mDemo: Using Summary Functions to Analyze a Table3mSummarizing Data Using the COUNT Function20sGrouping Data2mDemo: Analyzing Groups of Data4mSummarizing Date and Time Data1mCounting Rows Using a Boolean Expression37sDemo: Summarizing Data Using a Boolean Expression2mCreating Tables1mCreating Tables from a Query1mCreating Table Structures1mInserting Rows into Tables2mDropping Tables in PROC SQL10sScenario31sDICTIONARY Tables1mDemo: Using DICTIONARY Tables5m

5 lecturas

Date, Time, and Datetime Values10mCommonly Used Summary Functions10mAdditional Statements to Maintain Tables10mSQL Order of Execution Cheat Sheet (optional)1mLearning More (optional)1m

18 ejercicios de práctica

Activity 2.0110mActivity 2.0210mActivity 2.0310mActivity 2.0410mActivity 2.0510mLevel 1 Practice: Querying a Table20mLevel 2 Practice: Working with Datetime Values20mActivity 2.0610mActivity 2.0710mActivity 2.0810mLevel 1 Practice: Eliminating Duplicates20mLevel 2 Practice: Grouping and Summarizing Data20mActivity 2.0910mActivity 2.1010mActivity 2.1110mPractice Level 1: Counting the Number of Tables in a Library20mPractice Level 2: Counting the Number of Tables in All Libraries20mPROC SQL Fundamentals 1h 15m

Semana3

Semana 3

4 horas para completar

SQL Joins

4 horas para completar

22 videos (Total 29 minutos), 3 lecturas, 14 cuestionarios

22 videos

Overview19sJoining Tables2mTypes of Joins1mJoining Two Tables with an Inner Join1mDemo: Performing an Inner Join with PROC SQL2mAlternative SQL Inner Join Syntax40sUsing Table Aliases39sMatching Rows with a Natural Join1mSelecting Data from More Than Two Tables39sDemo: Performing an Inner Join with Four Tables2mHandling Missing Values1mCreating Non-Equijoins47sSQL Outer Joins1mPerforming Left and Right Outer Joins1mJoining Two Tables with a Full Join42sDemo: Performing a Full Join with Proc SQL2mIdentifying Nonmatching Rows1mUsing Reflexive Joins1mDemo: Performing a Reflexive Join2mUsing Functions to Join Tables39sUsing Functions to Join When Column Types Are Different17sConverting Column Values with Functions1m

3 lecturas

Table Relationships10mSQL Join Summary Cheat Sheet (optional)1mLearning More (optional)1m

14 ejercicios de práctica

Activity 3.0110mActivity 3.0210mActivity 3.0310mActivity 3.0410mPractice Level 1: Performing an Inner Join20mPractice Level 2: Joining on Inequality20mActivity 3.0510mActivity 3.0610mPractice Level 1: Using Outer Joins to Find Nonmatches20mPractice Level 2: Using Outer Joins to Summarize Data20mActivity 3.0710mActivity 3.0810mActivity 3.0910mSQL Joins 50m

Semana4

Semana 4

4 horas para completar

Subqueries

4 horas para completar

19 videos (Total 33 minutos), 2 lecturas, 12 cuestionarios

19 videos

Overview17sWhat Is a Subquery?1mUsing a Subquery in the WHERE Clause2mDemo: Using a Subquery That Returns a Single Value2mUsing a Subquery in the HAVING Clause1mSubquery That Returns Multiple Values1mDemo: Using a Subquery That Returns Multiple Values2mUsing the ANY Keyword1mUsing Correlated Subqueries1mUsing Temporary Tables1mWhat Is an In-Line View?34sDemo: Using an In-Line View3mCreating a View2mMaking a View Portable2mUsing a Subquery in the SELECT Clause45sRemerging Summary Statistics in PROC SQL1mDemo: Remerging Summary Statistics2mControlling Remerging1mRemerging GROUP BY Summary Statistics1m

2 lecturas

Advantages/Disadvantage of Views10mLearning More (optional)1m

12 ejercicios de práctica

Activity 4.0110mActivity 4.0215mActivity 4.0310mPractice Level 1: Using a Subquery That Returns a Single Value20mPractice Level 2: Using a Subquery with Multiple Functions20mActivity 4.0410mPractice Level 1: Using an In-Line View20mPractice Level 2: Building a Complex Query Using In-Line Views20mActivity 4.0510mPractice Level 1: Remerging Summary Statistics20mPractice Level 2: Using a Subquery in the SELECT Clause with an In-Line Views20mSubqueries50m

Semana5

Semana 5

3 horas para completar

Set Operators

3 horas para completar

12 videos (Total 18 minutos), 4 lecturas, 6 cuestionarios

12 videos

Overview14sCombining Data Using Set Operators2mWhat Are Set Operators?2mUsing Set Operators1mUsing the INTERSECT Operator1mUsing the EXCEPT Operator1mUsing the UNION Operator34sDemo: Using the UNION Operator to Find All Unique Rows2mDefault Behavior of the UNION Operator36sCombining Set Operators40sUsing the OUTER UNION Operator48sDemo: Using the OUTER UNION Operator to Combine Tables3m

4 lecturas

Using a Set Operator Versus a Join10mUsing a Set Operator Versus a Subquery10mSQL Versus Traditional SAS Programming10mLearning More (optional)1m

6 ejercicios de práctica

Activity 5.0110mActivity 5.0210mPractice Level 1: Using the EXCEPT Set Operator20mPractice Level 2: Using the EXCEPT Set Operator with the DISTINCT Keyword20mPractice: Using the OUTER UNION Set Operator20mSet Operators50m

2 horas para completar

Using and Creating Macro Variables in SQL

2 horas para completar

7 videos (Total 15 minutos), 2 lecturas, 5 cuestionarios

7 videos

Overview16sCreating User-Defined Macro Variables2mCreating Data-Driven Macro Variables2mDemo: Using a PROC SQL Data-Driven Macro Variable2mCreating Multiple Macro Variables1mConcatenating Values into One Macro Variable1mDemo: Using PROC SQL to Concatenate Multiple Values into One Macro Variable4m

2 lecturas

Using Formats with Macro Variables10mLearning More (optional)1m

5 ejercicios de práctica

Activity 6.0110mActivity 6.0210mPractice Level 1: Creating a Macro Variable from an SQL Query20mPractice Level 2: Creating a Macro Variable with a List of Values from an SQL Query20mUsing and Creating Macro Variables in SQL50m

Semana6

Semana 6

2 horas para completar

Accessing DBMS Data with SAS/ACCESS

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.

2 horas para completar

15 videos (Total 24 minutos), 6 lecturas, 2 cuestionarios

15 videos

Overview23sDefining SAS/ACCESS Technology1mConnection Options41sOverview of the SQL Pass-Through Facility59sSteps for Using the SQL Pass-Through Facility3mDemo: Using an SQL Pass-Through Query3mSQL Pass-Through Facility Considerations57sOverview of the SAS/ACCESS LIBNAME Statement59sDemo: Using the SAS/ACCESS LIBNAME Statement3mSAS/ACCESS LIBNAME Considerations2mWhat Is PROC FEDSQL?56sComparing PROC SQL to PROC FEDSQL3mPROC FEDSQL Syntax47sExamining the Submitted SQL Code37sFedSQL and SAS Viya40s

6 lecturas

Note about the Demos that Access Databases in this Lesson10mSaving SQL Pass-Through Query Results10mAccess SAS DBMS-Specific Reference Documentation10mPROC SQL Versus PROC FEDSQL10mPROC SQL Versus PROC FEDSQL Cheat Sheet (optional)1mLearning More (optional)1m

2 ejercicios de práctica

Activity 7.0310mAccessing DBMS Data with SAS/ACCESS20m

2 horas para completar

Case Study (Honors) and Certification Practice Exam

2 horas para completar

3 lecturas

Reseñas

4.9

53 reseña

5 stars
89,76 %
4 stars
9,76 %
3 stars
0,46 %

Principales reseñas sobre STRUCTURED QUERY LANGUAGE (SQL) USING SAS

por SS7 de jun. de 2022

It was a great learning experience. practice questions and assignments were structured nicely to check the learning pattern.

por SO24 de sep. de 2022

This course was great overview of SQL and it can be used in SAS.

por AN20 de nov. de 2021

Very easy to understand, even for some one who never know what is an SQL in his entire Life.

por FD7 de ago. de 2021

This was very good. Easy to follow and the practices re-enforced my learning.

Ver todas las reseñas

Acerca de Certificado profesional de 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.

Preguntas Frecuentes

¿Cuándo podré acceder a las lecciones y tareas?
El acceso a las clases y las asignaciones depende del tipo de inscripción que tengas. Si tomas un curso en modo de oyente, verás la mayoría de los materiales del curso en forma gratuita. Para acceder a asignaciones calificadas y obtener un certificado, deberás comprar la experiencia de Certificado, ya sea durante o después de participar como oyente. Si no ves la opción de oyente:
es posible que el curso no ofrezca la opción de participar como oyente. En cambio, puedes intentar con una Prueba gratis o postularte para recibir ayuda económica.
Es posible que el curso ofrezca la opción 'Curso completo, sin certificado'. Esta opción te permite ver todos los materiales del curso, enviar las evaluaciones requeridas y obtener una calificación final. También significa que no podrás comprar una experiencia de Certificado.
¿Qué recibiré si me suscribo a este Certificado?
Cuando te inscribes en un curso, obtienes acceso a todos los cursos del Certificado y te darán un certificado cuando completes el trabajo. Se añadirá tu Certificado electrónico a la página Logros. Desde allí, puedes imprimir tu Certificado o añadirlo a tu perfil de LinkedIn. Si solo quieres leer y visualizar el contenido del curso, puedes auditar el curso sin costo.

¿Tienes más preguntas? Visita el Centro de Ayuda al Estudiante.

Desarrolla habilidades para tus empleados e impulsa los resultados de la empresa

Descubre Coursera para Empresas

Structured Query Language (SQL) using SAS

Acerca de este Curso