• +27 (0)21 418 4874


This is the outline for 2KO’s Oracle 12c OCP 1Z0-061: SQL Fundamentals Online Course. 2KO International delivers computer courses from beginner level to advanced, and is also a leading supplier of of online IT training courses, to ensure the best Oracle 12c certification training in South Africa.

With Oracle Database 12c: SQL Fundamentals, you experience the benefits of an Oracle Database that is re-engineered for Cloud computing. Multitenant architecture brings enterprises unprecedented hardware and software efficiencies, performance and manageability benefits, and fast and efficient Cloud provisioning. Oracle Database 12c: SQL Fundamentals certifications emphasize the full set of skills that DBAs need in today’s competitive marketplace.

Class Curriculum

Module 1: Introduction To Oracle 12c SQL
Introduction To Course
Intro To Oracle 12c SQL Fundamentals
Structure Of SQL
Basic Select Statements
Basic Select Statements Demo

Module 2: Retrieving Data
Modifying Reported Output
The Where Clause
The Order By Clause
Left And Right Outer Joins
The Where Clause Demo
Multi-Table Selection Demo

Module 3: SQL Functions
Single Row Functions
Aggregate Functions
Single-Row Functions Demo
Multi-Row Functions Demo
Group By
Grouping Demo
Conversion Functions
Conversion Functions Demo
Date-time Functions
Date-time Functions Demo

Module 4: Subqueries
Single Row Subqueries
Single Row Subqueries Demo
Multi Row Subqueries
Multi Row Subqueries Demo
Other Subquery Types
Other Subquery Types Demo

Module 5: Data Manipulation Language
Adding Data
Changing Data
Deleting Data
DML Demo

Module 6: Data Control Language
Security
Object Privileges
DCL Demo

Module 7: Data Definition Language
Creating Objects In The Database
Creating Objects In The Database Demo
Sequences
Sequenced Demo
Indexes
Views

Module 8: Combining Queries
Combining Queries

Module 9: Oracle 12C SQL Fundamentals
Oracle 12c SQL Fundamentals Review – Part 1
Oracle 12c SQL Fundamentals Review – Part 2
Oracle 12c SQL Fundamentals Review – Part 3
Conclusion