ORACLE COURSE OUTLINE
Introduction
• What is Database ?
• Understanding an RDBMS
• Understanding Tables, Records, and Fields
• SQL Language
Working with Oracle
• Creating Databases
• Types of Databases
• Specifying Field Data Types
• Altering Table and Field Names
• Altering Field Properties
• Altering Table Types
• Backing Up Databases and Tables
• Restoring Databases and Tables from Backup
• Dropping Databases and Tables
• SQL Queries and subqueries
• Using Built-In Functions
• Joining Tables
• Using Using Table and Column Aliases
PL/SQL Tables
• Basics of PL/SQL
• PL/SQL architecture
• PL/SQL Basics, Variables, Constants, data types & error handling
• Dynamic SQL in PL/SQL
• PL/SQL wrapper utility
• Control structures
• Declaring Variables and Constants
• Executing a PL/SQL Block
• Error checking – exception handling
• Defining exceptions
• Cursors in PL/SQL
• Triggers in PL/SQL
• Stored procedures, functions and packages
• Bulk queries
• Bulk DML (forall statement)
• Using cursor attributes
• Analyzing impact of bulk operations
Course Fee : Rs.4000
