Introduction to Oracle9i


Description:

In this course, you will examine the basic Oracle concepts and how they relate to database administrators and developers, identify and apply the techniques of logical database design to design a basic entity-relationship diagram, examine the purpose of denormalization, identify the advantages and disadvantages of iSQL*Plus, write SQL statements to retrieve and manipulate data, create and execute a simple PL/SQL program, list the purpose and syntax of packages, procedures, triggers, and functions, list the objects in an Oracle database, and examine the overall architecture of the Oracle Relational Database Management System (RDBMS).

 

Objectives:

  • After completing this course, you will be able to list the users of Oracle, trace the history of databases, list the phases in the development life cycle for Oracle systems, distinguish between data modeling techniques, create entities, add attributes and relationships, use SQL*Plus, examine the purpose of denormalization, identify the advantages and disadvantages of iSQL*Plus, query with the SELECT statement, work with set operators, subqueries, joins, ANSI SQL: 1999-compliant joins, and grouping functions, work with tables, insert and update data in tables using the MERGE statement, commit and rollback changes to data, control a transaction with savepoints, grant and manage privileges to users. You will also be able to identify variables and constants, describe anonymous blocks, conditional logic flow, and cursors, list the purpose and syntax of packages, procedures, triggers, and functions, list the contents of a datablock, manage datablocks, describe the architecture of Oracle9i, and the overall operation of a Relational Database Management System (RDBMS).

Hardware and Software Required:

  • Please note that the content in the course you have selected is supported and should function without major error in current, popular browsers. However, it has not been optimized for them. Therefore, you may encounter slight formatting or functionality issues during your learning experience.

 




User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: EL-IN-ORACLE9
  • Duration: 10 hours 24 minutes
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend