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
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
Related Products
Oracle Database SQL Workshop
This course is a combination of Oracle Database: SQL Workshop ..
£72.99 £89.99
Add to Cart
Oracle Database Design and Programming with SQL
This covers the Data Modelling and Database Devel..
£59.99 £79.99
Add to Cart
Oracle Database Design and Programming with SQL
This covers the Data Modelling and Database Devel..
£59.99 £79.99
Add to Cart
Oracle Database Design and Programming with SQL
This covers the Data Modelling and Database Devel..
£23.99 £29.99
Add to Cart
Oracle Database 12c Performance Management and Tuning
The Oracle Database 19c: Performance Manage..
£79.99 £99.99
Add to Cart
Oracle Database 12/19c Essentials Certified Implementation
The Oracle Database 12/19c Essentials ..
£169.99 £329.99
Add to Cart
Database Administration Unlimited Cloud Learning SubscriptionThe Database Administration Unlimited C..
£320.00 £355.00
Add to Cart
Oracle 23ai Data Warehousing Fundamentals
This course introduces students to the Oracle Database ..
£110.99 £129.99
Add to Cart
Oracle Database 23ai: SQL Workshop
This course is designed for Developers and Database Administra..
£84.99 £99.99
Add to Cart
Oracle Database 19c Data Warehousing Fundamentals
This course introduces students to the Oracle D..
£79.99 £99.99
Add to Cart
Oracle Database 19c Data Warehousing Fundamentals
This course introduces students to the Oracle D..
£79.99 £99.99
Add to Cart
Data Science Unlimited Cloud Learning SubscriptionThe Data Science Unlimited Cloud Learning Sub..
£310.00 £348.00
Add to Cart
AI & Machine Learning Unlimited Cloud Learning SubscriptionThe Machine Learning Unlimited C..
£310.00 £348.00
Add to Cart
Utilities Management Applications Unlimited Subscription
The Utilities Management Applicatio..
£559.00 £659.00
Add to Cart
Hospitality Management Unlimited Subscription
The Hospitality Management Unlimited Cloud Lea..
£239.00 £459.00
Add to Cart
Demand Management Unlimited Subscription
The Demand Management Unlimited Cloud Learning Subs..
£349.00 £399.00
Add to Cart
Product Management Unlimited Subscription
The Product Management Unlimited Cloud..
£249.00 £299.00
Add to Cart
Transport & Logistics Management Unlimited Subscription
The Transport & Logistics Ma..
£279.00 £339.00
Add to Cart
Oracle Database 23ai: New Features for Developers
This course focuses on the latest advancements ..
£124.00 £149.99
Add to Cart
Tags:
Database Management ,
Oracle Database ,
SQL ,
DBA