Oracle Database 12c: SQL and PL/SQL Fundamentals

Oracle Database 12c: SQL and PL/SQL Fundamentals Certification Training Course Overview

This Oracle Database: SQL and PL/SQL Fundamentals preparing conveys the basics of SQL and PL/SQL alongside the advantages of the programming dialects utilizing Oracle Database innovation. You'll investigate the ideas of social databases.

Audience :

  • Developer
  • Implementer
Test your current knowledge Qubits42

Oracle Database 12c: SQL and PL/SQL Fundamentals (40 Hours) Download Course Contents

Live Virtual Classroom
Group Training 1700
08 - 12 Aug 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 10 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)

04 - 08 Oct 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 1950
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Course Modules

Module 1: Introduction
  • Topic details are not available.
Module 3: Restricted and Sorted Data
  • Topic details are not available.
Module 7: Display Data From Multiple Tables
  • Topic details are not available.
Module 8: Usage of Subqueries to Solve Queries
  • Topic details are not available.
Module 9: SET Operators
  • Topic details are not available.
Module 10: Data Manipulation
  • Topic details are not available.
Module 12: Other Schema Objects
  • Topic details are not available.
Module 13: Introduction to PL/SQL
  • Topic details are not available.
Module 14: PL/SQL Identifiers
  • Topic details are not available.
Module 15: Write Executable Statements
  • Topic details are not available.
Module 16: Interaction with the Oracle Server
  • Topic details are not available.
Module 17: Control Structures
  • Topic details are not available.
Module 18: Usage of Composite Data Types
  • Topic details are not available.
Module 19: Explicit Cursors
  • Topic details are not available.
Module 20: Exception Handling
  • Topic details are not available.
Module 21: Stored Procedures and Functions
  • Topic details are not available.
Download Course Contents

Request More Information

Course Prerequisites
  • Basic Computer Knowledge.

You will learn how to :

  • Write inquiries against single and numerous tables, control information in tables and make database objects.
  • Use single column capacities to modify yield.
  • Invoke change capacities and contingent articulations.
  • Use bunch capacities to report accumulated information.
  • Create PL/SQL squares of utilization code that can be shared by different structures, reports and information the board applications.
  • Develop unknown PL/SQL squares, put away methods and capacities.
  • Declare identifiers and trap special cases.
  • Use DML proclamations to oversee information.
  • Use DDL proclamations to oversee database objects.
  • Declare PL/SQL Variables.
  • Conditionally control code stream (circles, control structures).