Introduction to Oracle using TOAD

Summary

Give your user community that competitive edge with this local Oracle Workshop. The course starts out with a complete overview of the Oracle architecture so students can get an understanding of how Oracle works. Attendees will learn how to access data from Oracle using the SQL language. The focus of this course is to give a working knowledge of SQL to non-IT people, or to people who are new to the relational database world. TOAD is a very popular Oracle SQL Query and Development tool. The attendees have the opportunity to construct various SQL statements to solve simple and complex business questions. This course includes how to update data, delete data, create tables, data relationships, and will touch briefly on using indexes to aid in the performance of the SQL. This course also covers creating various types of reports and web reports using the SQL*Plus interface.

Prerequisites

Before taking this course, a working knowledge of a PC is helpful but not required.

Duration

2 Days/Lecture & Lab

Audience

This course is designed to give a working knowledge of SQL to non-IT people, or to people who are new to the relational database world.

Topics

Oracle Architecture

• Introduction to SQL topics:

• Select, Insert, Update, Delete

• SQL Scripting Topics

• Formatting SQL

• Creating Tables/Indexes/Views

• Privileges

• Advanced Topics

• Joins, Functions, Group Functions, cross-reference output

• ANSI SQL Syntax

• Referential Integrity (Data Relationships)

• ODBC Drivers and MS Products

• TOAD Topics

• TOAD Options and Initial Setup features

• SQL Editor

• Schema Browser

• Master Detail Browser

• ER Diagrammer

• SQL Modeler

Related Scheduled Courses