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