Oracle Database 12c: SQL and PL/SQL Fundamentals

Duration : 5 Days (40 Hours)

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

The Oracle Database 12c: SQL and PL/SQL Fundamentals training course covers the fundamentals of SQL and PL/SQL. Participants will learn how to create database objects and handle data in tables, along with writing queries for single and multiple tables. This course not only introduces the basics of SQL and PL/SQL but also emphasizes the benefits of using these languages with Oracle Database technology.

The training explores the concepts of relational databases and highlights the practical applications of these powerful programming languages in real-world scenarios. Enroll in the Oracle Database 12c: SQL and PL/SQL Fundamentals course by checking the available dates below and start building your skills today.

Intended Audience:

  • Software Developers
  • System Analysts
  • Implementers
  • PL/SQL Developers
  • Form Developers
  • Designers of User Interfaces
  • Application Developers
  • Coding of Reports
  • Expert Technical Advisors
  • Maker of Portals
  • Data Administrators
  • Professionals who are looking to gain a basic understanding of Oracle Database 12c with SQL and PL/SQL
  • Professionals who are looking to sit for the Oracle Database 12c: SQL and PL/SQL Fundamentals certification exam.

Learning Objectives of Oracle Database 12c: SQL and PL/SQL Fundamentals:

  • Execute DML commands to modify information in Oracle.
  • Design PL/SQL anonymous blocks that execute efficiently.
  • Please outline PL/capabilities SQL and syntax.
  • Take care of programming errors.
  • Specify the features of stored functions and procedures.
  • Make use of PL/conditional SQL’s execution features (loops, control structures, and explicit cursors).
  • Row processing with cursors.
  • Learn to recognise the key building blocks of the Oracle Database 11g.
  • In SQL, the SELECT command is used to get information from tables.
  • Generate restricted and sorted data reports.
  • Create and retrieve unique data with the use of SQL functions.
  • Use the ANSI SQL 99 JOIN syntax to display information from many tables.
  • Make summaries of collected information.
  • Execute DDL commands to construct and manipulate schema objects
  • Create database objects, perform table manipulations, and write queries against single or multiple tables.
  • The output can be tailored with the use of single row functions.
  • Utilize evaluation functions and if/then statements.
  • If you need to report on aggregated data, use group functions.
  • Make reusable PL/SQL code blobs for your forms, reports, and database management software.
  • Create anonymous PL/SQL procedures, functions, and blocks.
  • Make use of variable declarations and error handling.
  • Manage your data with DML statements.
  • Manage database objects via DDL statements.
  • Set PL/SQL Variable Declarations.
  • Using if/else statements to regulate programme flow (loops, control structures).
  • Specify the features of stored functions and procedures.
  • Learn how to get table information in rows and columns.

 Module 1: Introduction

 Module 2: Retrieve Data using the SQL SELECT Statemen

 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

Oracle Database 12c: SQL and PL/SQL Fundamentals Course Prerequisites:

  • Knowledge of data processing principles and procedures
  • Knowledge of computer programming principles

Discover the perfect fit for your learning journey

Choose Learning Modality

Live Online

  • Convenience
  • Cost-effective
  • Self-paced learning
  • Scalability


  • Interaction and collaboration
  • Networking opportunities
  • Real-time feedback
  • Personal attention


  • Familiar environment
  • Confidentiality
  • Team building
  • Immediate application

Training Exclusives

This course comes with following benefits:

  • Practice Labs.
  • Get Trained by Certified Trainers.
  • Access to the recordings of your class sessions for 90 days.
  • Digital courseware
  • Experience 24*7 learner support.

Got more questions? We’re all ears and ready to assist!

Request More Details

Please enable JavaScript in your browser to complete this form.

Subscribe to our Newsletter

Please enable JavaScript in your browser to complete this form.