Oracle SQL Querying for Beginners

Audience: This course is designed for anyone who wants to learn how to use the Oracle SQL language to retrieve data.
Pre-requisites: IT literate
Duration: 2 days

Course content

  • Introduction to Relational and Object Relational Database Management Systems
  • Using SQL Developer
  • Retrieve Data using the SQL SELECT Statement
  • Restrict and Sort Data
  • Single-Row Functions
  • Conversion Functions and Conditional Expressions
  • Display Data from Multiple Tables Using Joins 
  • Aggregation of Data using Group Functions
  • Use Sub-queries to Solve Queries
  • The SET Operators