SAS Training : MS SYSTEMS - ADVANCED TRAINING SAS STRUCTURED QUERY LANGUAGE WORKSHOP

MS SYSTEMS - ADVANCED TRAINING SAS STRUCTURED QUERY LANGUAGE WORKSHOP

SAS Training Overview

This three day workshop uses the 'HANDS ON' approach to teach the participanys the essential concepts of Structured Query Language (SQL) using SAS.

SAS Training Audience

Application programmers.
Designers interested in gaining an understanding of SQL.
Systems programmers.

SAS Training Course duration

3 Days

SAS Training Objectives
Upon completion of this workshop, the participant will be able to:

Understand Relation Database Concepts.
Know how to connect to a relational database with SAS.
Run both simple and complex queries using SAS.

SAS Training Course outline

Relational database overview
Relational database operating environment
Relational Database Objects
Using SAS to access a Relational Database
SQL - Data Manipulation Language
Simple SQL Queries
Functions
JOINS & UNIONS
Subquery
SQL - Data Definition Language
Tables, Views, Synonyms
Relational Database Data dictionary