Oracle

Oracle Training

Contents

  • 1 Oracle Course Overview
  • 1.1 Oracle Training Course Prerequisites
  • 1.2 Oracle Training Course Objectives
  • 1.3 Oracle Training Course Duration
  • 2 Oracle Training Content
  • 2.1 Introduction to DBMS
  • 2.2 Introduction to RDBMS
  • 2.3 Sub Language Commands
  • 2.4 Introduction to SQL Database Object
  • 2.5 Built-in Functions
  • 2.6 Grouping the Result of a Query
  • 2.7 Working with Integrity Constraints
  • 2.8 REF constraint
  • 2.9 Querying Multiple Tables (Joins)
  • 2.10 Working with Sub Queries
  • 2.11 Working with DCL, TCL Commands
  • 2.12 Maintaining Database Objects
  • 2.13 VIEWS in Oracle
  • 2.14 Working with Sequences
  • 2.15 Working with Synonyms
  • 2.16 Working with Index and Clusters
  • 2.17 Creating Cluster Tables, Implementing Locks, working with roles
  • 2.18 Pseudo Columns in Oracle
  • 2.19 Data Partitions and Parallel Process
  • 2.20 Locks
  • 2.21 SQL * Loader
  • 2.22 PL-SQL (Procedure Language – SQL)
  • 2.23 Advanced PL/SQL
  • 2.23.1 Functions in PL/SQL
  • 2.23.1.1 Packages in PL/SQL
  • 2.24 EXCEPTIONS in PL/SQL
  • 2.25 Database Triggers in PL/SQL
  • 2.26 File Input/Output
  • 2.27 Implementing Object Technology
  • 2.28 Using LOBS
  • 2.29 Using Collections
  • 2.30 Oracle Database Architecture
  • 2.31 Advanced Features
  • 2.32 DBA CONCEPTS
Contact Me