Oracle SQL Fundamentals

     This hands-on course provides the basic knowledge and skills necessary to code SQL select statements. Students will receive a hands-on introduction to SQL basics. The course also includes some relational database management system (RDBMS) concepts and terminology.

Topics Covered

  • Database Management System Overview
  • What is a database?
  • Types of DBMSs
  • Relational Database Management System Overview
  • What is a RDBMS?
  • What is SQL? SQL*Plus? PL/SQL?
  • Difference between DDL, DML and DCL statements
  • SELECT statement and mandatory clauses
  • WHERE and ORDER BY clauses
  • Single row functions
  • Group functions
  • GROUP BY and HAVING clauses
  • Joining data from multiple tables
  • Subqueries
  • Data Manipulation Language (DML) statements (Time Permitting)


     Anyone retrieving data from an Oracle database using SQL


     An understanding of relational database design concepts.


     Students will understand relational database terminology, understand and code Oracle SQL select statements.

Furnished Materials:

  • PC Workstation for use during training
  • Student Manual

Recommended Follow-On Course


  • 3 Days


  • $1485

Training Dates:

Sign Up