• +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
1.1 Introduction To Course
1.2 Intro To Oracle 12c SQL Fundamentals
1.3 Structure Of SQL
1.4 Basic Select Statements
1.5 Basic Select Statements Demo

Module 2: Retrieving Data
2.1 Modifying Reported Output
2.2 The Where Clause
2.3 The Order By Clause
2.4 Left And Right Outer Joins
2.5 The Where Clause Demo
2.6 Multi-Table Selection Demo

Module 3: SQL Functions
3.1 Single Row Functions
3.2 Aggregate Functions
3.3 Single-Row Functions Demo
3.4 Multi-Row Functions Demo
3.5 Group By
3.6 Grouping Demo
3.7 Conversion Functions
3.8 Conversion Functions Demo
3.9 Date-time Functions
3.10 Date-time Functions Demo

Module 4: Subqueries
4.1 Single Row Subqueries
4.2 Single Row Subqueries Demo
4.3 Multi Row Subqueries
4.4 Multi Row Subqueries Demo
4.5 Other Subquery Types
4.6 Other Subquery Types Demo

Module 5: Data Manipulation Language
5.1 Adding Data
5.2 Changing Data
5.3 Deleting Data
5.4 DML Demo

Module 6: Data Control Language
6.1 Security
6.2 Object Privileges
6.3 DCL Demo

Module 7: Data Definition Language
7.1 Creating Objects In The Database
7.2 Creating Objects In The Database Demo
7.3 Sequences
7.4 Sequenced Demo
7.5 Indexes

Module 8: Combining Queries
Combining Queries

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