PL/SQL Fundamentals

Modules

Hide all

Relational Database Concepts (6 topics)

• What is an Oracle Database
• Relational Database Structures
• Tables, Rows and Columns
• Indexes, Primary Keys and Foreign Keys
• Supported Datatypes
• The Data Dictionary

Using SQL*Plus (5 topics)

• What is SQL*Plus
• Getting Started
• Entering and Executing SQL Statements
• Editing SQL Statements
• Creating, Editing and Executing SQL Files

Using SQL Developer (5 topics)

• What is Oracle SQL Developer
• Starting SQL Developer
• Configure a Connection
• Navigation Tabs
• SQL Worksheet

Retrieving Data with the SELECT Statement (9 topics)

• The SELECT Statement
• The SELECT and FROM Clauses
• Conditions and the WHERE Clause
• Other Conditional Operators
• Logical Operators
• The ORDER BY Clause
• Column Aliases
• Arithmetic Expressions
• Precedence of Operators

Aggregate Functions (3 topics)

• Overview of Built In Aggregate Functions
• The GROUP BY Clause
• The HAVING Clause

Joining Tables (7 topics)

• Overview of Table Joins
• Inner Joins
• Table Aliases
• Outer Joins
• Self Joins
• ANSI Standard Joins
• Set Operators

Numeric, Character and Date Functions (6 topics)

• Function Types
• Using the Table dual to try out Functions
• Numeric Functions
• Character Functions
• String Concatenation
• Date Arithmetic and Date Functions

Conversion and Miscellaneous Functions (5 topics)

• Conversion Functions
• The NVL and NVL2 Functions
• The DECODE Function
• CASE Expressions
• The COALESCE and NULLIF Functions

SQL*Plus Parameters (3 topics)

• Command Line Substitution Parameters
• The Accept Command
• The Define and Undefine Commands

Using Subqueries (8 topics)

• Overview of Subqueries
• In-Line Views
• Top-N Queries
• Complex Subqueries
• Multi Column Subqueries
• Correlated Subqueries
• Subquery Rules
• Using the ANY, ALL and SOME Operators

Managing Data (9 topics)

• Inserting Rows
• Updating Rows
• Deleting Rows
• Verifying Updates
• Transaction Control
• Commit and Rollback
• Savepoints
• Commits and Constraints
• Amending Data in SQL Developer

Managing Tables (5 topics)

• Creating Tables
• Specifying Constraints
• Altering Tables, Columns and Constraints
• Dropping Tables, Columns and Constraints
• Copying Tables

Managing Indexes and Views (6 topics)

• Creating Indexes
• Dropping Indexes
• Listing Indexes
• Creating and Using Views
• Dropping Views
• Listing Views

Managing Sequences and Synonyms (4 topics)

• Create a Sequence
• View Sequence Details
• Create a Synonym
• List Synonyms