Students & Members/Admin Login Area -->

Cancel
Oracle Course
Course Duration: 4 Months

IT Training

KnowledgeTech, an established IT Training, Service Provider & Web Development Firm in Powai believes in empowerment of education through Complete IT based Solutions. We represent a brand that acknowledges and delivers education & all IT based requirements & services with excellence.

Course Curriculum
  • Oracle 9i/10g

    - RDBMS

    - Back-End Programming

    - Client Server Architecture

    - CODD’s Rule

    - Defining Relational Model

    - DATABASE OBJECTS: Creating Tables,Views, Sequence

    - Synonyms,Indexing,Alert Sequence, Insert Tables

    - Constraints. Unique Key, Primary key

    - Operator Types:Numeric, Logical, Relational

    - Query Expression Operator, Union Intersect,Minus

    - Functions: Arithmetic, Group, Data

    - SQL & SQL Plus Select Statements

    - SQL Data Types of Oracle

    - Data Defination, Operators

    - Function, Multi-Table

    - Queries Sub- Queries

    - Normal- Correlated

    - DDL & DML Commands

    - Pseudo coloumn ROWID, Script Files, Locking

    - Commands, Joins , Inner Joins, ARRAY

    - Package Type, Cursor, Exception

    - PL SQL Plus

    - PL SQL , Tables Arrays

    - Data Types - Scalar Composite

    - PL SQL Block Structure

    - Constraints, Procedure Pkg,Declaration Prog,Constructs

    - Cursors, SubBlocks, View & Security, LOB’s Data Types

    - Nested Tables

    - DATABASE ADMINISTRATION

    - Advanced Oracle, Concepts & Utilities

    - Physical & Logical, Table Spaces, Segments, Extent

    - Allocation / Deallocation, Truncated Table Command

    - COMMIT

    - DATABASE TRIGGERS