Description

A summary presentation of the technical characteristics of the Oracle offering and its recent developments intended for all those who wish to understand the principles and operating mechanisms of the DBMS.

Who is this training for ?

For whom ?

This course is aimed at all project managers and design engineers who have to lead projects or develop applications integrating Oracle.

Prerequisites

No special knowledge.

Training objectives

Understand the key elements of an Oracle database Discover the relational model Evaluate SQL and PL/SQL data manipulation languages Analyze the elements making up the architecture of an Oracle database

Training program

• Data Server Overview
  • - Relational model.
  • - Integrity constraints.
  • - Data types.
  • - Object-relational model.
  • - Data manipulation.
• Database access languages
  • - SQL language: ANSI.
  • - Structure of the SQL language.
  • - PL/SQL language.
  • - Procedural functionalities.
  • - Oracle and XML.
  • - Embedded SQL.
  • - ODBC.
  • - Oracle Objects for OLE.
  • - Java , JDBC and SQLJ Driver.
• Oracle Server Features
  • - Security features.
  • - User identification and privileges.
  • - Data dictionary.
  • - Query optimization.
  • - Event management and alerts.
  • - Transaction management.
  • - Globalization (NLS).
  • - Real Application Cluster.
  • - Symmetric Replication.
  • - Advanced Security.
  • - Standby Database and Oracle Data Guard.
  • - Virtual Private Database.
  • - Recovery Manager tool .
• Database architecture
  • - Composition of the database.
  • - Architecture of an instance.
  • - Structure of the database.
  • - Tablespaces.
  • - Data partitioning
• Net Services
  • - Connectivity and security.
  • - High activity support.
  • - Connection Manager and Multiplexing.
  • - Extended security services.
  • - Net Configuration Assistant.
  • - Native Hostname Adapter.
• Data versioning
  • - Oracle Flashback Query.
  • - Restitution of data deleted by mistake.
  • - Workspace Manager.
  • - Creation of Workspaces.
  • - Declaring versioned tables.
  • - Visualizing data differences.
• The Objects extension
  • - Object support.
  • - Using LOBs.
  • - The BFILE type.
  • - Collections: nested tables and VARRAY.
  • - Operators and methods on objects.
  • - Object Type Translator.
• Oracle 11g contributions
  • - Performance.
  • - Simplifying maintenance.
  • - Security.
  • - Tools and Oracle Grid Infrastructure.
  • - Oracle Restart.
  • - Database migration.