Course Description

Introduction
Working with Oracle Cloud Exadata Express Cloud Service
Retrieve Data using the SQL SELECT Statement
Restricted and Sorted Data
Usage of Single-Row Functions to Customize Output
Conversion Functions and Conditional Expressions
Aggregated Data Using the Group Functions
Display Data From Multiple Tables
Usage of Subqueries to Solve Queries
SET Operators
Data Manipulation
DDL Statements to Create and Manage Tables
Other Schema Objects
Introduction to PL/SQL
PL/SQL Identifiers
Write Anonymous PL/SQL blocks
SQL statements in PL/SQL block
Control Structures
Composite Data Types
Explicit Cursors
Exception Handling
Stored Procedures and Function