MS SYSTEMS - ADVANCED TRAINING
SAS STRUCTURED QUERY LANGUAGE WORKSHOP
This course is provided by Wintrac. Wintrac provides one stop shopping for all your IT
training needs. Wintrac’s course catalog of over two thousand courses includes courses on SAs Training
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
Please contact your training representative for more details on having this course delivered onsite or online
