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
Available Options
Related Products
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 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 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 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 The Oracle Database 19c: Performance Manage..
£79.99 £99.99
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 Cloud Learning SubscriptionThe Database Administration Unlimited C..
£320.00 £355.00
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 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 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 This course introduces students to the Oracle D..
£79.99 £99.99
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 Cloud Learning SubscriptionThe Machine Learning Unlimited C..
£310.00 £348.00
Utilities Management Applications Unlimited
Utilities Management Applications Unlimited Subscription The Utilities Management Applicatio..
£559.00 £659.00
Hospitality Management Unlimited
Hospitality Management Unlimited Subscription The Hospitality Management Unlimited Cloud Lea..
£239.00 £459.00
Demand Management Unlimited
Demand Management Unlimited Subscription The Demand Management Unlimited Cloud Learning Subs..
£349.00 £399.00
Product Management Unlimited
Product Management Unlimited Subscription The Product Management Unlimited Cloud..
£249.00 £299.00
Transport & Logistics Management Unlimited
Transport & Logistics Management Unlimited Subscription The Transport & Logistics Ma..
£279.00 £339.00
Oracle Database 23ai: New Features for Developers
Oracle Database 23ai: New Features for Developers This course focuses on the latest advancements ..
£124.00 £149.99
Tags: Database Management, Oracle Database, SQL, DBA