Winter Savings - Save on IT Training Using Promo Code FROSTBYTE

closeClose

SAS(R) SQL 1: Essentials for FedEx Institute

  • Tuition USD $1,450 GSA  $1,178.84
  • Reviews star_rate star_rate star_rate star_rate star_half 2019 Ratings
  • Course Code FESQ1
  • Duration 2 days
  • Available Formats Classroom

This course teaches you how to process SAS data using Structured Query Language (SQL).

Skills Gained

  • query and subset data
  • summarize and present data
  • combine tables, including complex joins and merges
  • create and modify table views and indexes
  • replace multiple DATA and PROC steps with one SQL query.

Who Can Benefit

  • SAS programmers and business analysts

Prerequisites

  • Before attending this class, you should be able to
  • submit SAS programs on your operating system
  • create and access SAS data sets
  • use arithmetic, comparison, and logical operators
  • invoke SAS procedures.

Course Details

Introduction

  • introducing the Structured Query Language
  • course logistics

Basic Queries

  • overview of the SQL procedure
  • specifying columns
  • specifying rows

Displaying Query Results

  • presenting data
  • summarizing data

SQL Joins

  • introduction to SQL joins
  • inner joins
  • outer joins
  • complex SQL joins

Subqueries

  • noncorrelated subqueries
  • in-line views

Set Operators

  • introduction to set operators
  • the UNION operator
  • the OUTER UNION operator
  • the EXCEPT operator
  • the INTERSECT operator

Creating Tables and Views

  • creating tables with the SQL procedure
  • creating views with the SQL procedure

Advanced PROC SQL Features

  • dictionary tables and views
  • using SQL procedure options
  • interfacing PROC SQL with the macro language

Learning More

  • SAS resources
  • beyond this course

Self-Study Topics

  • correlated subqueries
  • introduction to indexes
  • creating indexes
  • maintaining tables with the SQL procedure
  • integrity constraints

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

Great first experience with ExitCertified. I look forward to many more trainings.

The overall learning experience with ExitCertified provided course is excellent.

Attended in the New York timezone from Switzerland, with an instructor based out of Sydney Australia - worked really well!

It was great content, some additional exam prep focus would have been nice. I believe everyone in the class has the goal of passing some AWS cert exams.

Excellent facilities, excellent staff.. and the coffee is good too! Thanks for helping to advance my career and the career of my colleagues!

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward