SAS SQL 1: Essentials - miac.com

January 30, 2018 | Author: Anonymous | Category: N/A
Share Embed


Short Description

SAS SQL 1: Essentials Course Contents Getting Started course logistics introducing the Structured Query Language introdu...

Description

SAS SQL 1: Essentials Course Contents Getting Started   

course logistics introducing the Structured Query Language introducing the business scenario

Basic Queries   

overview of the SQL procedure specifying columns specifying rows

Displaying Query Results  

presenting data summarizing data

Subqueries  

noncorrelated subqueries correlated subqueries (self-study)

SQL Joins  

introduction to SQL joins complex SQL joins

Set Operators     

introduction to set operators the EXCEPT operator the INTERSECT operator the UNION operator the OUTER UNION operator

Creating Tables and Views   

creating views with the SQL procedure creating tables with the SQL procedure (self-study) integrity constraints (self-study)

Additional SQL Procedure Features    

setting SQL procedure options dictionary tables and views interfacing PROC SQL with the macro language program testing and performance

Managing Tables  

introduction to indexes creating indexes (self-study)



maintaining tables

Accessing Relational Databases (Self-Study)  

LIBNAME access to DBMS data executing DBMS-specific SQL using the SQL Pass-Through Facility

Learning More  

SAS resources beyond this course

View more...

Comments

Copyright © 2017 KINPDF Inc.