Skip to main content

Posts

Showing posts with the label Oracle Certifications

NIIT Oracle Certification Program: ORACLE DATABASE 10G: Administration Workshop II

ORACLE DATABASE 10G: ADMINISTRATION WORKSHOP II

INTRODUCTION:
Oracle Database 10g is Oracle’s revolutionary new grid offering for database administrators, which include breakthrough self-management, storage management, and clustering features. It is designed to relieve system administrators from repetitive, low-value administrative work and provide them with an opportunity to increase their value and expand their technical skills. Oracle database is generally implemented in large-scale organization managing voluminous amount of data and users.

Duration: 48 hours
Back to NIIT Certification Programs Index
PROGRAM CONTENTS:
Use RMAN to create and manage backup sets and image copiesRecover the database to a previous point in timeUse Oracle Secure Backup to backup and recover a databaseUse Oracle's Flashback technology to recover your databaseDetect block corruptions and take appropriate measures to correct themUse the various Database advisors and views to monitor and improve database …

NIIT Oracle Certification Program: ORACLE DATABASE 10G: Administration Workshop I

ORACLE DATABASE 10G: ADMINISTRATION WORKSHOP I

INTRODUCTION:
Oracle Database 10g is Oracle’s revolutionary new grid offering for database administrators, which include breakthrough self-management, storage management, and clustering features. It is designed to relieve system administrators from repetitive, low-value administrative work and provide them with an opportunity to increase their value and expand their technical skills. Oracle database is generally implemented in large-scale organization managing voluminous amount of data and users.

Duration: 48 hours
Back to NIIT Certification Programs Index

PROGRAM CONTENTS:
Install Oracle Database 10g and configure a databaseManage the Oracle instanceManage the Database storage structuresCreate and administer user accountsPerform backup and recovery of a databaseMonitor, troubleshoot, and maintain a databaseConfigure Oracle Net servicesMove data between databases and files
Back to NIIT Certification Programs Index

PRE REQUISITES:
The student…

NIIT Oracle Certification Program: ORACLE DATABASE 10G: PL/SQL Fundamantals

ORACLE DATABASE 10G: PL/SQL FUNDAMENTALS
INTRODUCTION:

Oracle Database 10g is Oracle’s revolutionary new grid offering for database administrators, which include breakthrough self-management, storage management, and clustering features. It is designed to relieve system administrators from repetitive, low-value administrative work and provide them with an opportunity to increase their value and expand their technical skills. Oracle database is generally implemented in large-scale organization managing voluminous amount of data and users.
Duration: 18 hours
Back to NIIT Certification Programs Index

PROGRAM CONTENTS:
Use PL/SQL programming constructs and conditional control statementsWrite PL/SQL code to interface with the databaseDesign PL/SQL program units that execute efficientlyHandle run-time errorsDescribe stored procedures and functions
Back to NIIT Certification Programs Index

PRE REQUISITES:
The student should have knowledge of SQL equivalent to:- Oracle Database 10g : Introduction t…

NIIT Oracle Certification Program: ORACLE 10G: Introduction to SQL

ORACLE 10G: INTRODUCTION TO SQL

INTRODUCTION:
Oracle Database 10g is Oracle’s revolutionary new grid offering for database administrators, which include breakthrough self-management, storage management, and clustering features. It is designed to relieve system administrators from repetitive, low-value administrative work and provide them with an opportunity to increase their value and expand their technical skills. Oracle database is generally implemented in large-scale organization managing voluminous amount of data and users.
Duration: 48 hours
Back to NIIT Certification Programs Index

PROGRAM CONTENTS:
Identify the major structural components of Oracle Database 10gRetrieve row and column data from tables with the SELECT statementCreate reports of sorted, restricted and aggregated dataRun data manipulation language (DML) statements to update data in Oracle Database 10gObtain metadata by querying the dictionary views
Back to NIIT Certification Programs Index

PRE REQUISITES: The students…

NIIT Oracle Certification Program: Introduction to ORACLE 9I- SQL

Oracle Certification ProgramsINTRODUCTION TO ORACLE 9I- SQL

INTRODUCTION:
Concepts of relational and object relational databases, SQL programming language, create and maintain database objects and to store, retrieve, and manipulate data. Participants also learn to retrieve data by using advanced techniques such as ROLLUP, CUBE, set operators, and hierarchical retrieval. Learn how to write SQL and SQL*Plus script files using the iSQL*Plus tool.

Duration: 40 hours
Back to NIIT Certification Programs Index

PROGRAM CONTENTS:
Describe relational and object relational database concepts Retrieve, insert, update, and delete dataUse the Single row and Group functions Retrieve data using additional advanced techniques like usingROLLUP, CUBE, set operators, correlated subqueries and hierarchical queriesSolve problems by using multicolumn subqueriessubqueries in the from clause of a SELECT statement, correlated subqueries, and scalar subqueriesUse the iSQL*Plus environmentWrite scripts to generat…