SQL
Oracle Certification Programs
Introduction 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
Program Contents:
- Describe relational and object relational database concepts
- Retrieve, insert, update, and delete data
- Use the Single row and Group functions
- Retrieve data using additional advanced techniques like using
- ROLLUP, CUBE, set operators, correlated subqueries and hierarchical queries
- Solve problems by using multicolumn subqueries
- subqueries in the from clause of a SELECT statement, correlated subqueries, and scalar subqueries
- Use the iSQL*Plus environment
- Write scripts to generate script files
- Generate reports using iSQL*Plus
- Create and maintain database objects
- Control transactions
- Control data/user access
- Use the Oracle9i Single row functions
- Use GROUPING SETS and the WITH clause
- Use the Oracle9i extensions to DML and DDL statements
- Apply techniques in real life simulation
Pre Requisites:
- Participants must be familiar with Data manipulation concepts and RDBMS concepts
Exit Profile:
- The candidate would learn how to use Data Server Technology
Global Certification Mapped:
- Program is mapped with OCP vendor certification
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
Program Contents:
- Identify the major structural components of Oracle Database 10g
- Retrieve row and column data from tables with the SELECT statement
- Create reports of sorted, restricted and aggregated data
- Run data manipulation language (DML) statements to update data in Oracle Database 10g
- Obtain metadata by querying the dictionary views
Pre Requisites:
- The students should have: Knowledge of SQL, equivalent to Oracle 10g: Introduction to SQL module
Exit Profile:
- Learner will be able to apply key concepts of relational databases and SQL Programming Language
Global Certification Mapped:
- Oracle Database SQL Certified Expert
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
Program Contents:
- Use PL/SQL programming constructs and conditional control statements
- Write PL/SQL code to interface with the database
- Design PL/SQL program units that execute efficiently
- Handle run-time errors
- Describe stored procedures and functions
Pre Requisites:
- The student should have knowledge of SQL equivalent to:- Oracle Database 10g : Introduction to SQL
Exit Profile:
- Learner will be able to design PL/SQL program units to interface with the database
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
Program Contents:
- Install Oracle Database 10g and configure a database
- Manage the Oracle instance
- Manage the Database storage structures
- Create and administer user accounts
- Perform backup and recovery of a database
- Monitor, troubleshoot, and maintain a database
- Configure Oracle Net services
- Move data between databases and files
Pre Requisites:
- The student should have knowledge of SQL equivalent to:- Oracle Database 10g : Introduction to SQL and Oracle Database 10gPL/SQL Fundamental Knowledge of Linux is desirable
Exit Profile:
- Learner will be able to administer and maintain the Oracle 10G database
Global Certification Mapped:
- Oracle Database 10g Administrator Certified Associate
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
Program Contents:
- Use RMAN to create and manage backup sets and image copies
- Recover the database to a previous point in time
- Use Oracle Secure Backup to backup and recover a database
- Use Oracle's Flashback technology to recover your database
- Detect block corruptions and take appropriate measures to correct them
- Use the various Database advisors and views to monitor and improve database performance
- Control database resource usage with the Resource Manager
- Simplify management tasks by using the Scheduler
- Review database log files for diagnostic purposes
- Customize language-dependent behavior for the database and individual sessions
- Administer a VLDB
- Implement a secure database
- Transport data across platforms
Pre Requisites:
The student should have knowledge of Oracle Database 10g: Administration Workshop I
- Knowledge of Linux is desirable
Exit Profile:
- Learner will be able to perform advanced database administration tasks on the Oracle 10G database
Global Certification Mapped:
- Oracle Database 10g Administrator Certified Professional