Note : You must login with Google Account Id (SignIn) for which you have been given permission to view and download entire material.

This entire training is based on SAS Advanced Programming : PROC SQL (Total-13 Modules), which is focusing mainly on the syllabus of SAS A00-232 certification PROC SQL part in this training we are covering more than 80 hands on examples, which you can run your own with the data & code shared by http://HadoopExam.com You need to have setup of SAS University edition to run all the example programs. You can also see the below training module to check how to setup the SAS University Edition.

• About SQL
• What you can do in SQL
• Calculating values while select
• Selecting All columns
• Creating columns
• Referring Alias column
• Remove Duplicate records

• Where Clause
• Calculated Columns
• Operators in where clause

• Group By clause
• Having clause
• Data Remerging
• Order By clause & sorting

• Creating a table
• Describe table
• Using Specification table
• Using Existing Table
• Using Select statement

• INSERT Statement Using SET
• INSERT Statement Using Value Clause
• INSERT Statement Using Query Result Clause
• Describe Table Statement
• Dictionary Tables

• Horizontal Combination
• Inner Joins
• Inner Joins : Equi Joins
• Column Overlays
• Join Conditions
• Duplicate Rows & Joins
• Qualified table name
• Self join
• Complex inner join
• Natural Joins

• Outer Joins
• Left, Right & Full outer joins
• Match Merge vs SQL Joins
  • When all the values matches
  • When only few values matches
• Advantages of SQL Join compare to Match Merge

• Types of Set Operators
  • Except
  • Intersect
  • Union
  • Outer Union
• Options for set operators
  • All
  • CORR

• Order of evaluation
• Duplicity
• Column Overlays
• Except + ALL | Except + CORR | Except + ALL + CORR
• Intersect + ALL | Intersect + CORR | Intersect + ALL + CORR
• Union + ALL | Union + CORR | Union + ALL + CORR
• Outer Union + ALL | Outer Union + CORR

• Single value Subquery
• Multivalued subquery
• Types of Subquery
  • Non-correlated
  • correlated
• Multi-level correlated subquery

• Non-correlated queries & Conditional operators
• Subquery with Comparison operator
• Any + Comparison operator
• ALL + Comparison operator
• EXISTS and NOT EXISTS Operator

• Overview Of SQL Views
• Creating views
• Benefits of using Views & Their Data Sources

• Complex View Creation
• Checking View Definition
• Creating Views from Another View
• Updating SQL Views
• Dropping View