Oracle 9i Home <> Courses <> Oracle 9i


Course Title:
Oracle 9i
Introduction:

A database management system, or DBMS, gives the user access to their data and helps them transform the data into information. Such database management systems include dBase, Paradox, IMS, and Oracle. These systems allow users to create, update, and extract information from their databases. Compared to a manual filing system, the biggest advantages to a computerized database system are speed, accuracy, and accessibility.

A database is a structured collection of data. Data refers to the characteristics of people, things, and events. Oracle stores each data item in its own field. For example, a person's first name, date of birth, and their postal code are each stored in separate fields. The name of a field usually reflects its contents. A postal code field might be named POSTAL-CODE or PSTL_CD. Each DBMS has its own rules for naming the data fields.

A field has little meaning unless it is seen within the context of other fields. The postal code T6G 2H1, for example, expresses nothing by itself. To what person or business does it belong? The postal code field is informative only after it is associated with other data. In Oracle, the fields relating to a particular person, thing, or event are bundled together to form a single, complete unit of data, called a record (it can also be referred to as a row or an occurrence). Each record is made up of a number of fields. No two fields in a record can have the same field name.

Eligibility: MCA, BCA, B.Sc.(IT), M.Sc.(IT), M.Sc.(CS), B.Sc.(CS), B.Tech, B.E.(Any Branch), O Level, A Level
Duration: 3 Months
Fees: INR
Curriculum:
  • Introduction
  • Oracle Architectural
  • Components
  • Oracle Server
  • Oracle Instance
  • Creating Database
  • Data Dictionary
  • Contents & Usage
  • Control File
  • Redo Log Files
  • Table Spaces
  • Data Files
  • Storage Structure
  • Relationships
  • Managing Undo Data
  • Managing Tables
  • Managing Indexes
  • Maintaining Data Integrity
  • Managing Password
  • Security & Resources
  • Managing Users
  • Managing Privileges
  • Managing Roles
  • Globalization Support
  • Basics of PL/SQL
  • PL/SQL Structures
  • Boolean Logic in PL/SQL
  • Cursors in PL/SQL
  • Iteration in PL/SQL
  • PL/SQL Tables
  • Triggers in PL/SQL
  • Stored Procedures
  • Fuctions & Packages
  • Bulking in PL/SQL

Enquiry Now

Send Enquiry

Call Now 9798260267
Widget by:Integrated Infotech