Learn Oracle language with this online course

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.

Course highlight:

Learn from an Oracle Certified instructor with 6 yrs of DBA experience
Thorough, deliberate and detailed - the best way to master Oracle
The course prepares you for the OCA and OCP
Comprehensive Courseware : PPTs+ Docs + PDFs
Each class is 60 minutes

Language of the course:

English

Refunds:

If the candidate is not satisfied with the course, he or she can call for refund after first two sessions.

Course content:

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 sub queries and hierarchical queries
Solve problems by using multicolumn sub queries
Sub queries in the from clause of a SELECT statement, correlated sub queries, and scalar Sub queries
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 Oracle 9i 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