Oracle Database 12c R2: SQL and PL/SQL Fundamentals Ed 2/1Z0-071

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

Oracle Database: SQL and PL/SQL Fundamentals Ed 2 training course is designed to learn the fundamentals of SQL and PL/SQL along with the benefits of the programming languages using Oracle Database technology.

Course Objective:

  • Run data manipulation statements (DML) to update data in the Oracle Database.
  • Design PL/SQL anonymous block that execute efficiently.
  • Describe the features and syntax of PL/SQL.
  • Handle runtime errors.
  • Describe stored procedures and functions.
  • Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors).
  • Use cursors to process rows.
  • Identify the major structural components of the Oracle Database 11g.
  • Retrieve row and column data from tables with the SELECT statement.
  • Create reports of sorted and restricted data.
  • Employ SQL functions to generate and retrieve customized data.
  • Display data from multiple tables using the ANSI SQL 99 JOIN syntax.
  • Create reports of aggregated data.
  • Run data definition language (DDL) statements to create and manage schema objects.
This course prepares you for Exam 1Z0-071. Test your current knowledge Qubits42

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

Live Virtual Classroom
Group Training 1750
02 - 06 Aug 09:00 AM - 05:00 PM CST
(8 Hours/Day)
06 - 10 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training (GTR) 2000
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

Customers who bought this course also bought

• Oracle BPM 12c: Essentials Ed 1
• Oracle Database 12c: Admin, Install and Upgrade Accelerated
• Oracle Database 12c: Advanced PL/SQL
• Oracle Database: Managing Multitenant Architecture Ed 1
• Oracle Database 12c R2: SQL Tuning for Developers Ed 2
• Oracle Database 19C:Administration Workshop
• Oracle Database: Backup and Recovery Workshop
• Oracle Database: Introduction to SQL
• Oracle HCM Cloud: US Payroll
• Oracle WebLogic Server 12c: Administration I Ed 3

Course Modules

Module 1: Introduction
  • Topic details are not available.
Module 2: Retrieve Data using the SQL SELECT Statement
  • Topic details are not available.
Module 3: Restricted and Sorted Data
  • Topic details are not available.
Module 4: Usage of Single-Row Functions to Customize Output
  • Topic details are not available.
Module 5: Usage of Single-Row Functions to Customize Output
  • Topic details are not available.
Module 6: Aggregated Data Using the Group Functions
  • 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 11: DDL Statements to Create and Manage Tables
  • 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: Exception Handling
  • Topic details are not available.
Download Course Contents

Request More Information

Course Prerequisites
  • Basic Computer Knowledge.
  • 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.
  • Conditionally control code flow (loops, control structures).
  • Describe stored procedures and functions.
  • Retrieve row and column data from tables.

FAQ's