• Oracle Database 12c SQL & PL/SQL Fundamentals

Oracle Database 12c SQL & PL/SQL Fundamentals

This course will assist in preparation for the Oracle Database SQL 1Z0-071 and PL/SQL 1Z0-044 certification exams. The Oracle Database SQL and PL/SQL course provides step-by-step instructions on how to write efficient code and development techniques to address your business challenges.

On successful Completion of the Fundamentals of Modelling course you will be able to:


  • Run data definition language (DDL) statements
  • Identify the major structural components of the Oracle Database
  • 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
  • Use the SET operators to create subsets of data
  • Run data manipulation statements (DML) to update data
  • Employ SQL & PL/SQL functions to generate and retrieve customized data
  • Create PL/SQL Triggers
  • Create PL/SQL Stored Procedures and Functions

Write a review

Please login or register to review

Oracle Database 12c SQL & PL/SQL Fundamentals

  • Brand: Weblearning Publishing
  • Product Code: Oracle Database 12c SQL & PL/SQL Fundamentals
  • Reward Points: 100
  • Availability: In Stock
  • £79.99
  • £61.99

  • Price in reward points: 1200

  • 2 or more £59.99
  • 4 or more £54.99

Available Options


Related Products

Oracle Database SQL Workshop

Oracle Database SQL Workshop

Oracle Database SQL Workshop  This course is a combination of Oracle Database: SQL Workshop ..

£72.99 £89.99

Oracle Database Design and Programming with SQL CBT

Oracle Database Design and Programming with SQL CBT

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£59.99 £79.99

Oracle Database Design and Programming with SQL eLearning

Oracle Database Design and Programming with SQL eLearning

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£59.99 £79.99

Oracle Database Design and Programming with SQL Training Guide

Oracle Database Design and Programming with SQL Training Guide

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£23.99 £29.99

Oracle Database 12c Performance Management and Tuning

Oracle Database 12c Performance Management and Tuning

Oracle Database 12c Performance Management and Tuning The Oracle Database 19c: Performance Manage..

£79.99 £99.99

Oracle Database 12/19c Essentials Certified Implementation

Oracle Database 12/19c Essentials Certified Implementation

Oracle Database 12/19c Essentials Certified Implementation The Oracle Database 12/19c Essentials ..

£169.99 £329.99

Database Administration Unlimited

Database Administration Unlimited

Database Administration Unlimited Cloud Learning SubscriptionThe Database Administration Unlimited C..

£320.00 £355.00

Oracle Database 23ai Data Warehousing Fundamentals

Oracle Database 23ai Data Warehousing Fundamentals

Oracle 23ai Data Warehousing Fundamentals This course introduces students to the Oracle Database ..

£110.99 £129.99

Oracle Database 23ai SQL Workshop

Oracle Database 23ai SQL Workshop

Oracle Database 23ai: SQL Workshop This course is designed for Developers and Database Administra..

£84.99 £99.99

Oracle Database 19c Data Warehousing Fundamentals CBT

Oracle Database 19c Data Warehousing Fundamentals CBT

Oracle Database 19c Data Warehousing Fundamentals This course introduces students to the Oracle D..

£79.99 £99.99

Oracle Database 19c Data Warehousing Fundamentals eLearning

Oracle Database 19c Data Warehousing Fundamentals eLearning

Oracle Database 19c Data Warehousing Fundamentals This course introduces students to the Oracle D..

£79.99 £99.99

Data Science Unlimited

Data Science Unlimited

Data Science Unlimited Cloud Learning SubscriptionThe Data Science Unlimited Cloud Learning Sub..

£310.00 £348.00

AI & Machine Learning Unlimited

AI & Machine Learning Unlimited

AI & Machine Learning Unlimited Cloud Learning SubscriptionThe Machine Learning Unlimited C..

£310.00 £348.00

Big Data Unlimited

Big Data Unlimited

Big Data Unlimited Cloud Learning SubscriptionThe Big Data  Unlimited Cloud Learning Subsc..

£365.00 £399.00

Big Data & Data Science VM Training Appliance

Big Data & Data Science VM Training Appliance

Big Data & Data Science VM Training ApplianceThis Big Data & Data Science VM Training Applia..

£249.00 £279.00

Utilities Management Applications Unlimited

Utilities Management Applications Unlimited

Utilities Management Applications Unlimited Subscription The Utilities Management Applicatio..

£559.00 £659.00

Hospitality Management Unlimited

Hospitality Management Unlimited

Hospitality Management Unlimited Subscription The Hospitality Management Unlimited Cloud Lea..

£239.00 £459.00

Demand Management Unlimited

Demand Management Unlimited

Demand Management Unlimited Subscription The Demand Management Unlimited Cloud Learning Subs..

£349.00 £399.00

Product Management Unlimited

Product Management Unlimited

Product Management Unlimited  Subscription The Product Management Unlimited  Cloud..

£249.00 £299.00

Transport & Logistics Management Unlimited

Transport & Logistics Management Unlimited

Transport & Logistics Management Unlimited Subscription The Transport & Logistics Ma..

£279.00 £339.00

Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171

Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171

Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171 This course introduces stude..

£124.00 £149.99

Tags: Database Management, Oracle Database, SQL, DBA