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
Contact Information
WINTRAC INC. - the one stop shopping center for IT training.
16523 S.W. McGwire Ct. Beaverton OR -97007
Phone: (503) 259-0312
Fax: 707-598-2268
Email: sales@wintrac.com