Introduction to Oracle SQL

Audience: This course is designed for anyone who wants to learn the concepts of relational databases and the SQL programming language. It provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database tables.
Pre-requisites: IT literate
Duration: 3 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
  • Managing Tables using DML statements
  •  Introduction to Data Definition Language