Home > Programming Language > Oracle Training kolkata

Oracle Training kolkata

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

Tags: , , , , , ,

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • Twitter
  • RSS
Copyright @ www.computertrainingkolkata.com. All rights reserved.