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
Upon completion of this workshop, the participant will be able to:
