Oracle Installation & Administration Online Course

Oracle Installation & Administration Online Course in South Africa

 

This is the outline for 2KO's Oracle 12c OCP 1Z0-062: Installation and Administration online course. 2KO International supplies computer training all over Africa, starting from beginner level to advanced certification, and is also a top supplier of internationally recognised online computer 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

7.6 Views

 

Module 8: Combining Queries

8.1 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