
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.
-
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
