Back To Oracle Training Courses

Introduction to Oracle: SQL and PL/SQL CBT Training (Ver. III) Training CBT Suite

Price: $516.00

CBT Course Overview:

The Self Study Store Computer Based Training Introduction to Oracle: SQL and PL/SQL (Ver. III) cover the concepts of relational databases and the SQL and PL/SQL programming languages. Students learn how to create and maintain database objects and to store, retrieve, and manipulate data. In addition, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. This curriculum will help candidates prepare for test 1Z0-001, which applies towards the following Oracle Certified Professional (OCP) Program certification tracks: Oracle7.3 Certified Database Administrator, Oracle8 Certified Database Administrator, and Oracle Certified Application Developer, Release 2.

Total Training Duration:

32 hours

CBT Course Modules:

• Oracle SQL: Basic SELECT Statements Training CBT
• Oracle SQL: Data Retrieval Techniques Training CBT
• Oracle SQL: DML and DDL Training CBT
• Oracle PL/SQL: Basics Training CBT

Training Course Topics:

• Learn relational database concepts and properties.
• Describe database design processes by explaining the system development life cycle and entity relationship modeling.
• Describe the concept of object relational database management systems.
• Write SQL SELECT queries.
• Customize SQL queries when selecting data from a table.
• Learn SQL*Plus environment, features, and commands.
• Restrict rows retrieved by a query.
• Learn comparison operators that can be used in defining row retrieval restrictions.
• Learn logical operators that can be used to define row retrieval restrictions.
• Retrieve rows from multiple tables by using an equijoin, a non-equijoin, an outer join, and a self join.
• Write SQL statements that contain common group functions.
• Restrict groups of rows retrieved by using the HAVING clause and to write SQL statements that contain common group functions.
• Group rows retrieved by using the GROUP BY clause.
• Write single-row, multiple row, multiple-column subqueries.
• Obtain values at run time by creating and maintaining substitution variables.
• Use SQL*Plus format commands to format report output.
• Run a formatted report using a SQL*Plus script file.