Oracle 12C Online Training

 >>  Oracle 12C Online Training

Oracle 12C Online Training


 (4.9) | 1500 Ratings


Introduction


Oracle 12C Online Training Details
Track Regular Track Weekend Track Fast Track
Course Duration 30 Hrs 8 Weekends 5 Days
Hours 1hr/day 2 Hours a day 6 Hours a day
Training Mode Online Classroom Online Classroom Online Classroom
Delivery Instructor Led-Live Instructor Led-Live Instructor Led-Live


Course Curriculum

Oracle 12C Online Training Modules

 Oracle Course Overview

  • Oracle Training Course Prerequisites
  • Oracle Training Course Objectives
  • Oracle Training Course Duration

Oracle Training Topics

  • Introduction to DBMS
  • Introduction to RDBMS
  • Sub Language Commands
  • Introduction to SQL Database Object
  • Built-in Functions
  • Grouping the Result of a Query
  • Working with Integrity Constraints
  • REF constraint
  • Querying Multiple Tables (Joins)
  • Working with Sub Queries
  • Working with DML, DRL, DCL, TCL Commands
  • Maintaining Database Objects
  • VIEWS in Oracle
  • Working with Sequences
  • Working with Synonyms
  • Working with Index and Clusters
  • Creating Cluster Tables, Implementing Locks, working with roles
  • Pseudo Columns in Oracle
  • Data Partitions and Parallel Process
  • Locks
  • SQL * Loader
  • PL-SQL (Procedure Language – SQL)
  • Advanced PL/SQL
  • Functions in PL/SQL
  • Packages in PL/SQL
  • EXCEPTIONS in PL/SQL
  • Database Triggers in PL/SQL
  • File Input/Output
  • Implementing Object Technology
  • Using LOBS
  • Using Collections
  • Oracle Database Architecture
  • Advanced Features
  • DBA CONCEPTS
  • The Advantages of PL/SQL
  • PL/SQL Architechture, PL/SQL Data Types
  • Advanced PL/SQL
  • Advanced Version Features

Exam & Certification

0

Course Review

(4.9)
5 stars
4 stars
3 stars
2 stars
1 stars

Course Curriculum

Oracle 12C Online Training Modules

 Oracle Course Overview

  • Oracle Training Course Prerequisites
  • Oracle Training Course Objectives
  • Oracle Training Course Duration

Oracle Training Topics

  • Introduction to DBMS
  • Introduction to RDBMS
  • Sub Language Commands
  • Introduction to SQL Database Object
  • Built-in Functions
  • Grouping the Result of a Query
  • Working with Integrity Constraints
  • REF constraint
  • Querying Multiple Tables (Joins)
  • Working with Sub Queries
  • Working with DML, DRL, DCL, TCL Commands
  • Maintaining Database Objects
  • VIEWS in Oracle
  • Working with Sequences
  • Working with Synonyms
  • Working with Index and Clusters
  • Creating Cluster Tables, Implementing Locks, working with roles
  • Pseudo Columns in Oracle
  • Data Partitions and Parallel Process
  • Locks
  • SQL * Loader
  • PL-SQL (Procedure Language – SQL)
  • Advanced PL/SQL
  • Functions in PL/SQL
  • Packages in PL/SQL
  • EXCEPTIONS in PL/SQL
  • Database Triggers in PL/SQL
  • File Input/Output
  • Implementing Object Technology
  • Using LOBS
  • Using Collections
  • Oracle Database Architecture
  • Advanced Features
  • DBA CONCEPTS
  • The Advantages of PL/SQL
  • PL/SQL Architechture, PL/SQL Data Types
  • Advanced PL/SQL
  • Advanced Version Features

    Click here for Help and Support

    Click here for Help and Support: info@sacrostectservices.com     For Inquiry Call Us:   +91 996-629-7972(IND)

  +91 996-629-7972(IND)
X

Quick Enquiry

X

Business Enquiry