Oracle 10g Online Training
Pin It

Oracle 10g Online Training

Oracle 10g Online Training, Globus Provides Oracle 10g Online Training with real time experienced consultants according to your convenient timings.

Oracle 10g Online Training : Learn Oracle 10g Training Online from Well Experienced Online Trainers.

Oracle 10g Online Training Course Curriculum

DBMS
  • Concepts of DBMS
  • Introduction
  • Importance and Need
  • Database Models and Normalization
  • Models
  • Hierarchial
  • Relational
  • Object
  • Normalization Techniques
Introduction to RDBMS
  • Concepts of RDBMS
  • Introdution
  • Comparision with DBMS
  • COOD Rules
  • Normalization Revisited
  • Concepts of ORDBMS & OODBMS
  • Introduction to ORDBMS
  • Introduction to OODBMS
  • Comparision and analysis
Structured Query Language(SQL)
  • Introduction to SQL
  • Predefined Data Types
  • Introduction to database objects
  • Table,View
Commands in SQL
  • Data Defination Language(DDL)
  • Data Manipulation Language(DML)
  • Data Control Language(DCL)
  • Transaction Control Language(TCL)
  • Database Security and Privileges(DCL)
Working with DDL,DML,TCL Commands
  • Operators
  • Conditional,Logical,Comparison,SET
  • Functions
  • Date,Number,Character,String,Group,Group by,Having clause
  • Transformation Functions
  • DECODE,TRANSLATE
  • NVL,NVL2(9i)
  • Aggregate Functions
Integrity Constraints
  • Different Types of Integrity Constraint
  • Use of Integrity Constraint in table

Oracle 10g Online Training Faqs:

Oracle Core DBA Responsibilities

  • (1) Creates and maintains all databases required for development, testing, education and production usage.
  • (2) Performs the capacity planning required to create and maintain the databases. The DBA works closely with system administration staff because computers often have applications or tools on them in addition to the Oracle Databases.
  • (3) Performs ongoing tuning of the database instances.
  • (4) Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
  • (5) Plans and implements backup and recovery of the Oracle database.
  • (6) Controls migrations of programs, database changes, reference data changes and menu changes through the development life cycle.
  • (7) Implements and enforces security for all of the Oracle Databases.
  • (8) Performs database re-organisations as required to assist performance and ensure maximum uptime of the database.
  • (9) Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance. The DBA will perform reviews on the design and code frequently to ensure the site standards are being adhered to.
  • (10) Evaluates releases of Oracle and its tools, and third party products to ensure that the site is running the products that are most appropriate. Planning is also performed by the DBA, along with the application developers and System administrators, to ensure that any new product usage or release upgrade takes place with minimal impact.
  • (11) Provides technical support to application development teams. This is usually in the form of a help desk. The DBA is usually the point of contact for Oracle Corporation.
  • (12) Enforces and maintains database constraints to ensure integrity of the database.
  • (13) Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
  • (14) Assists with impact analysis of any changes made to the database objects.
  • (15) Troubleshoots with problems regarding the databases, applications and development tools.
  • (16) Create new database users as required.
  • (17) Manage sharing of resources amongst applications.
  • (18) The DBA has ultimate responsibility for the physical database design.