P3688 – Oracle Database 12c: SQL and PL/SQL Fundamentals

• Duration: 10 weeks

Module 1: Introduction
Module 2: Retrieve Data using the SQL SELECT Statement
Module 3: Restricted and Sorted Data
Module 4: Usage of Single-Row Functions to Customize Output
Module 5: Conversion Functions and Conditional Expressions
Module 6:Aggregated Data Using the Group Functions
Module 7: Display Data From Multiple Tables
Module 8: Usage of Subqueries to Solve Queries
Module 9: SET Operators
Module 10: Data Manipulation
Module 11: DDL Statements to Create and Manage Tables
Module 12: Other Schema Objects
Module 13: Introduction to PL/SQL
Module 14: PL/SQL Identifiers
Module 15: Write Executable Statements
Module 16: Interaction with the Oracle Server
Module 17: Control Structures
Module 18: Usage of Composite Data Types
Module 19: Explicit Cursors
Module 20: Exception Handling
Module 21: Stored Procedures and Functions