Home About Courses Schedule Services Webinars Contact Search

SAS Structured Query Language Workshop

SEE SCHEDULE

Duration: 3 days

Method: Instructor led, Hands-on workshops

Price: $1650.00

Course Code: SA1006


Audience

Application programmers, designers interested in gaining an understanding of SQL and Systems programmers.

Description

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

Objectives

Upon successful completion of this course, the student 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

Topics

  • I.Relational Database Overview
  • II.Relational Database Operating Environment
  • III.Relational Database Objects
  • IV.Using SAS to Access a Relational Database
  • V.SQL - Data Manipulation Language
  • VI.Simple SQL Queries
  • VII.Functions
  • VIII.JOINS & UNIONS
  • IX.Subquery
  • X.SQL - Data Definition Language
  • XI.Tables, Views, Synonyms
  • XII.Relational Database Data Dictionary