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)

Audience:

     Anyone retrieving data from an Oracle database using SQL

Prerequisites:

     An understanding of relational database design concepts.

Benefits:

     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

Length:

  • 3 Days

Price:

  • $1485

Training Dates:

Sign Up