ORACLE TRAINING

Introduction to SQL constructs


Review of Basic SQL statements
Select, Project, Join
Describing Oracle tables
Restricting row returns

Using SQL*Plus


Creating basic reports
Using the set commands
Column wrapping
Creating breaks and summaries
Adding prompts to queries

Aggregation in SQL


Count(*)
Sum
Avg
Min and max
Using the group by clause

Joining Oracle tables


Equi-join
Outer join
Hiding joins by creating views
Using IN, NOT IN, EXISTS and NOTEXISTS
Subqueries
Exercise – write a subquery
Correlated subquery
Non-correlated subqueries

Aggregation in SQL


Count(*)
Sum
Avg
Min and max
Using the group by clause