Oracle Database: SQL and PL/SQL Fundamentals

In this Oracle Database: SQL and PL/SQL Fundamentals training course, you will learn the fundamentals of relational databases, SQL & PL/SQL programming language. You will also learn how to write queries against single and multiple tables, manipulate data in tables, and create database objects.

Important notice about this training

This training is run over 3 + 2 days on these dates:

Course objectives:

  • Write queries against single and multiple tables, manipulate data in tables and create database objects.
  • Use single row functions to customize output.
  • Invoke conversion functions and conditional expressions.
  • Use group functions to report aggregated data.
  • Create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.
  • Develop anonymous PL/SQL blocks, stored procedures and functions.
  • Declare identifiers and trap exceptions.
  • Use DML statements to manage data.
  • Use DDL statements to manage database objects.
  • Declare PL/SQL Variables.

Audience:

  • Administrator
  • Analyst
  • Developer

Prerequisites:

  • Familiarity with data processing concepts and techniques

Course content:

  • Introduction
  • Retrieve Data using the SQL SELECT Statement
  • Restricted and Sorted Data
  • Usage of Single-Row Functions to Customize Output
  • Conversion Functions and Conditional Expressions
    Module 7: Aggregated Data Using the Group Function
    Module 8: Display Data From Multiple Tables
    Module 9: Usage of Subqueries to Solve Queries
    Module 10: SET Operators
    Module 11: Data Manipulation
    Module 12: DDL Statements to Create and Manage Tables
    Module 13: Other Schema Objects
    Module 14: Introduction to PL/SQL
    Module 15: PL/SQL Identifiers

Module 16: Write Anonymous PL/SQL blocks
Module 17: SQL statements in PL/SQL block
Module 18: Control Structures
Module 19: Composite Data Types
Module 20: Explicit Cursors
Module 21: Exception Handling
Module 22: Stored Procedures and Functions

 

Other relevant courses

15. April
5 days
Virtual Classroom On Demand
3 days
Virtual Classroom On Demand
5 days
Classroom Virtual On Demand