PART 1:  SQL Processing With saas

Chapter 1: Performing Queries Using PROC SQL

  • PROC SQL Basics
  • Writing a PROC SQL Step
  • Selecting Columns
  • Specifying the Table
  • Specifying Subsetting Criteria
  • Ordering Rows
  • Querying Multiple Tables
  • Summarizing Groups of Data
  • Creating Output Tables

Chapter 2: Performing Advanced Queries Using PROC SQL

  • Viewing SELECT Statement Syntax
  • Displaying All Columns
  • Limiting the Number of Rows Displayed
  • Eliminating Duplicate Rows from Output
  • Subsetting Rows by Using Conditional Operators
  • Subsetting Rows by Using Calculated Values
  • Enhancing Query Output
  • Summarizing and Grouping Data
  • Subsetting Data by Using Subqueries
  • Subsetting Data by Using Noncorrelated Subqueries
  • Subsetting Data by Using Correlated Subqueries

Chapter 3: Combining Tables Horizontally Using PROC SQL

  • Understanding Joins
  • Generating a Cartesian Product
  • Using Inner Joins
  • Using Outer Joins
  • Creating an Inner Join with Outer Join-Style Syntax
  • Comparing SQL Joins and DATA Step Match-Merges
  • Using In-Line Views
  • Joining Multiple Tables and Views

Chapter 4: Combining Tables Vertically Using PROC SQL

  • Understanding Set Operations
  • Using the EXCEPT Set Operator
  • Using the INTERSECT Set Operator
  • Using the UNION Set Operator
  • Using the OUTER UNION Set Operator
  • Comparing Outer Unions and Other saas Techniques

Chapter 5: Creating and Managing Tables Using PROC SQL

  • Understanding Methods of Creating Tables
  • Creating an Empty Table by Defining Columns
  • Displaying the Structure of a Table
  • Creating an Empty Table That Is Like Another Table
  • Creating a Table from a Query Result
  • Inserting Rows of Data into a Table
  • Creating a Table That Has Integrity Constraints
  • Handling Errors in Row Insertions
  • Displaying Integrity Constraints for a Table
  • Updating Values in Existing Table Rows
  • Deleting Rows in a Table
  • Altering Columns in a Table
  • Dropping Tables

Chapter 6: Creating and Managing Indexes Using PROC SQL

  • Understanding Indexes
  • Deciding Whether to Create an Index
  • Creating an Index
  • Displaying Index Specifications
  • Managing Index Usage
  • Dropping Indexes

Chapter 7: Creating and Managing Views Using PROC SQL

  • Creating and Using PROC SQL Views
  • Displaying the Definition for a PROC SQL View
  • Managing PROC SQL Views
  • Updating PROC SQL Views
  • Dropping PROC SQL Views

Chapter 8: Managing Processing Using PROC SQL

  • Specifying SQL Options
  • Controlling Execution
  • Controlling Output
  • Testing and Evaluating Performance
  • Resetting Options
  • Using Dictionary Tables

PART 2 saas Macro Language

Chapter 9: Introducing Macro Variables

  • Basic Concepts
  • Using Automatic Macro Variables
  • Using User-Defined Macro Variables
  • Processing Macro Variables
  • Displaying Macro Variable Values in the saas Log
  • Using Macro Functions to Mask Special Characters
  • Using Macro Functions to Manipulate Character Strings
  • Using saas Functions with Macro Variables
  • Combining Macro Variable References with Text

Chapter 10: Processing Macro Variables at Execution Time

  • Creating a Macro Variable During DATA Step Execution
  • Creating Multiple Macro Variables During DATA Step Execution
  • Referencing Macro Variables Indirectly
  • Obtaining Macro Variable Values During DATA Step Execution
  • Creating Macro Variables During PROC SQL Step Execution
  • Working with PROC SQL Views
  • Using Macro Variables in SCL Programs

Chapter 11: Creating and Using Macro Programs

  • Basic Concepts
  • Developing and Debugging Macros
  • Using Macro Parameters
  • Understanding Symbol Tables
  • Processing Statements Conditionally
  • Processing Statements Iteratively
  • Using Arithmetic and Logical Expressions

Chapter 12: Storing Macro Programs

  • Understanding Session-Compiled Macros
  • Storing Macro Definitions in External Files
  • Storing Macro Definitions in Catalog SOURCE Entries
  • Using the Autocall Facility
  • Using Stored Compiled Macros

Trainers Profile: Trainer is working as a Senior Consultant from saas India, based in Magarpatta City with 7+ years of Consulting and Training Experience.

Course Duration: 2 Month (Around 50+ Hours) of Class Room Training, Classes will be conducted during morning, evening, or weekends. Duration of the class would be 1 � 4 Hours (depends on Weekdays or Weekend Batch)

Course Fee: 25,000 INR

Trainers Contact Details: +91-9325793756 (

Mode of Training: This would be class room Training with Practical hands on system. So whats we teach as per theory we show every steps and Process on the system. We recommend our student to concentrate much on Practice and get more Hands on.

saas Software Access: saas Training Academy will Provide saas Software (Valid Learning License) and that will be installed in your personal laptop for the Practice.

Books and Study Material: saas Training Academy will provide all Study Material and Books for this course in Soft Copy format.

Self-Practice Required: If you are looking to get into Informatica Development role so please dedicated 150-250 Hrs. of Self-study and Practice in order to get command on the system and then only you can easily clear Interviews.

Background Need to get into this course: This course suits to the people who are coming from Technical Background (BE, MCA, BCA, MCS etc.). If you have any Prior knowledge of any Programming Skills (C, C++, Java etc.), this will help you to understand the course better.