Miracle Information System

Learn the most powerful Backend

How to access database

Understanding architecture of Oracle

	Introduction to Relational Database Management concept
	Introduction to Oracle 8i Architecture
	Introduction to Java,SQL Engine, Memory Architectures.
	Schema Objects
	Datasase Triggers, Stored Proceures
	Introduction to SQL
	Basic construct of a SQL Statement
	Creating tables
		Inserting data into the tables
		Retrieving information from the tables
		Displaying data from multiple tables
		Group Functions
		Sub-queries
		Specifying variables at runtime
		Altering Tables and Constraints
	Creating Views, Sequences and Indexes
	Controlling User Access
	Introduction to PL/SQL
		PL/SQL Architecture
		Advantages of PL/SQL
		Developing a simple PL/SQL Block
		Controlling flow in the PL/SQL Block
		PL/SQL Data Types
		Processing queries
		Cursors (Implicit & Explicit)
		Error Handling
		Pragma Init Exceptions