Oracle Database SQL – Introduction

3 day course

The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database. Topics covered include an overview of relational database principles and an introduction to the Oracle relational database server, using the iSQL*Plus web-based database interface and other traditional interfaces, techniques for writing queries, summarizing/grouping/sorting data, developing simple SQL*Plus reports, creating and maintaining database tables, using regular expressions, moving beyond basic table definitions, learning basic database security and object privileges, and developing complex SQL*Plus reports and using SQL*Plus scripts.

Overview of Course Topics:
(for a full detailed outline, visit our PDF link above)

• Relational Databases & SQL
• Using SQL*Plus
• Building a SELECT Statement
• Building a WHERE Clause
• Ordering the Result Table
• Pseudo Columns & Functions
• Joining Tables
• Using Set Operators
• Summary Functions
• Using Subqueries
• Creating & Selecting Groups
• SQL*Plus Commands
• Build Simple SQL*Plus Reports
• SQL Data Definition Language
• SQL Data Manipulation Language