INTRODUCTION TO DATA MANAGEMENT

FILE SYSTEM CONCEPTS

DATABASE MODELS

  • Hierarchal Model
  • Network Model
  • Relational Model

INTRODUCTION TO RDBMS

RDBMS concepts and features Advantages of RDBMS over FMS and DBMS E.F Codd’s Rules, ACID properties Database design and Normalization process

INTRODUCTION TO COMPUTING MODELS

COMPUTING MODEL CONCEPTS AND ARCHITECTURE

  • Centralized computing
  • Model De-Centralized computing
  • Model Distributed computing Model

FILE SERVER, CLIENT-SERVER TECHNOLOGY

INTRODUCTION TO ORACLE

SQL

INTRODUCTION TO SQL

  • Sublanguage Commands
  • Data Retrieval Language (DRL)
  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Transaction Control Language (TCL)
  • Database security and privileges

WORKING WITH DRL

  • Select statement Distinct Selection ‘Where’ Clause ‘Order by’ Clauses

WORKING WITH DDL AND DML

  • DDL commands
  • Database objects and object types Working with Tables
  • Data Types
  • Table partitions Create, Alter, Add, Modify, Drop Insert, Update, Delete
  • Commit, Rollback
  • History of Oracle
  • Oracle products and features Oracle versions and releases About SQL & SQL*PLUS SQL*NET

ORACLE BUILT-IN FUNCTIONS

  • Arithmetic Functions Character Functions Date Functions Queries with Single Row Functions ‘Group By’ & ‘Having’ Clause
  • Using ROLLUP and CUBE Misc Functions
  • Working with Regular Expressions

CONSTRAINTS

  • Data Integrity Concepts Different types of Constraints Table Level and Column Level Composite Constraints
  • Check Constraint and Restrictions Referential Integrity
  • On Delete Cascade

SUB QUERIES

  • Normal Sub Queries.
  • Co-related Sub Queries.
  • Updating Using Co-Related.
  • Deleting Co-Related
  • Using Exists and Not Exists
  • Inline Queries
  • Miscellaneous Sub Queries.

JOINS

  • Joining Tables
  • Simple Joins
  • Outer Joins
  • Self Joins
  • Joins with Inline Queries
  • ANSI Join Syntaxes

SELECT STATEMENT WITH MISC OPTIONS

  • Set Operators
  • MERGE Statement
  • Pseudo Columns
  • Top N Analysis

VIEWS, SYNONYMS & INDEXES

  • Simple & Complex Views
  • Modifying the View Query
  • Limitation on Manipulations
  • With Check Options
  • Force View
  • Synonyms
  • Indexes
  • Sequences

DATA CONTROLLING & LOCKS

  • Object Privileges
  • With Grant option
  • Locks overview
  • Isolation Levels
  • Dead Lock Concept

ISQL   *    PLUS

NORMALIZATION BASICS PL-SQL

INTRODUCTION TO PL/SQL   

  • Back-end and Frond-end
  • Role of PL/SQL in Applications Programming Fundamentals
  • Restriction of SQL in PL/SQL PL/SQL Engine
  • Working with PL/SQL Blocks Conditional Structure

DATABASE TRIGGERS

  • Introduction to Triggers
  • Statement Level Triggers
  • Row Level Triggers
  • When Clause Co-relations
  • Trigger Predicates

EXCEPTION HANDLING

  • System Defined Exceptions
  • User Defined Exceptions Exception Propagation       
  • Defining Own Error Messages
  • Program Exception Int
  • SQLCODE,SQLERRM
  • Insted of Triggers Compound  Triggers
  • Mutation of Triggers

ADVANCE DATA TYPES

Internal & External LOBs Manipulations of LOBs Working with DBMS_LOB Package

CURSORS                                                             

TYPES & COLLECTIONS

  • Introduction to Cursors Types of Cursors
  • For Cursor Cursor Attributes
  • Working with Implicit and Explicit Cursors
  • Dynamic Cursors

STORED SUBPROGRAMS

  • Introduction of Stored subprograms Working with Stored Procedures Overloading of Subprogram Limitations of Functions Understanding of Packages Type Spec & Body
  • Package Instantiation Calling Packages & Procedures & Functions
  • Types & Objects Objects
  • in Database PL/SQL Type
  • Inheritance Type
  • Evaluation
  • Nested Tables and VArrays
  • Collections in Database

NATIVE DYNAMIC SQL

  • Execute Immediate SQL Working with Bulk Dynamic SQL

ADVANCED PL/ SQL

  • File Input / Output
  • PL/SQL files I/O
  • Using Built-in Packages
  • UTL_FILE
  • DBMS_OUPUT.PUT_LINE

IMPLEMENTING OBJECT TECHNOLOGY

  • What is Object Technology? OOPS Features in Objects Creating of Objects
  • Creating User Defined Data Types Creating Object Types
  • Inserting row in a table using objects Retrieving data from object based tables Calling a Method
  • Indexing, Abstract Data type attributes

USING LOBS

  • Large Objects (LOBS)
  • Creating tables with LOBs Working with LOB values Insert, Update, Delete in LOBs Populating LOBs using DBMS_LOB Using B-File

USING COLLECTIONS

  • Advantages of collections Nested Tables, VARRYING arrays Creating tables using Nested Tables Insert, Update, Delete Nested tables Table Records
  • Nested tables in PL/SQL

JAVA OBJECTS AND SQLJ

  • Creating Java Objects Loading Java classed in to Database Diff. between Java with SQL and SQLJ Using DML, DDL in SQLJ

ADVANCED FEATURES

  • Returning into clause, Bulk Collect Bulk Bind
  • Analytical functions, Multiple Inserts Merge Statement, Temporary Tables Autonomous Transactions
  • Dynamic SQL
  • Flash Back Command Purge, Recycle Bin Virtual columns Read only Tables Cross Tab Views using Pivot and Un-pivot Operators

ORACLE ARCHITECTURE & DBA CONCEPTS

  • Introduction to Oracle Architecture Physical & Logical structures Oracle Memory structures (SGA, PGA) Oracle Background Process
  • Backup & Recovery Concepts Oracle Utilities

ORACLE DBA ROLE AND RESPONSIBILITIES ON PRODUCTION & DEVELOPMENT ENVIRONMENT.

CONTACT ME
CONTACT ME
close-link
Hi how can I help you
Scroll to Top