Oracle SQL Fundamentals Online Course

Oracle SQL Fundamentals Online Course in South Africa

 

This is the outline for 2KO's Oracle 12c OCP 1Z0-061: SQL Fundamentals Online Course. 2KO International Group provides IT & business training courses for learners of all levels, and is also a top-rated, certified supplier of online IT 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