Oracle SQL and PL/SQL Fundamentals (5 days)

Audience: An ideal course for anyone who wants to learn the fundamentals of Oracle SQL and PL/SQL.
Pre-requisites: Following are the suggested pre-requisites for this course.

Course content:

Basic Oracle Database Concepts

Using the Oracle SQL Developer GUI Tool

SQL Fundamentals

Retrieving all or specific column values

Single row functions

Aggregating data

Retrieving Data from multiple tables

Using Sub Queries

Manipulating Data

Introduction to different types of database objects

Using DDL Statements to Create and Manage Tables

Introduction to PL/SQL

Declaring and using variables

Interacting with the Oracle Server

Writing Control Structures

Working with Composite Data Types

Using Explicit Cursors

Handling Exceptions

Creating Stored Procedures

Creating Stored Functions

Introduction to Creating Packages