Home :: Oracle Training :: Training Classes

Oracle SQL & SQL*Plus Training Class

Tuition: $930.00

SQL continues to play an important role in businesses of all sizes, and SQL skills are always in high demand. The SQL and SQL Plus training class is designed to provide students with these highly marketable skills.

The SQL and SQL Plus training class provides its students with a thorough understanding of ANSI-standard SQL and SQL Plus, Oracle’s extension, used for formatting query results. This training course uses a concise series of lesions, with each lesson designed to provide students with the skills they will need to interact with Oracle databases in the real world.

The topics covered in the SQL and SQL Plus training class begin with an examination of the relational database approach to corporate data. Instruction then continues with an introduction to common SQL terminology, including the role of ad hoc queries and the use of SQL Plus commands can concepts. Students in the course will learn to use SQL’s most powerful and versatile command, the SELECT statement, during the many hands on exercises provided during the course.

Students will also learn a number of other commands in the data manipulation language (DML), data dictionary language (DDL) and data control language (DCL). This step by step means of instruction allow students without prior knowledge of SQL to take full advantage of this innovative and useful class.

Some of the goals of the SQL and SQL Plus course include:

• Understanding SQL and SQL Plus concepts
• Understanding and using SQL and SQL Plus commands
• Retrieving useful and meaningful data from relational databases
• Gaining real world practical experience through the use of hands on exercises and learning labs

Course Outline:

• Introduction
• Overview of RDBMS concepts
• Getting started
• SQL*Plus Commands
• Data Types
• The SELECT statements
• Table joins
• Summarizing data
• Subqueries
• Single-row functions
• Formatting output with SQL*Plus commands
• Substitution variables
• Data manipulation language (DML) commands
• Data definition language (DDL) commands
• Data control language (DCL) commands
• Advanced features