home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » VMwareDatabases, transaction systems and middleware » DB2 for z/OS » DB2 UDB for Linux, UNIX and Windows » Oracle » SQL Server » MySQL » IMS » CICS » WebSphere MQ » WebSphere Application Server » Business intelligence and data warehouseApplication development » Methods and techniques » TOGAF » PRINCE2 » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITILbalkjePractical informationRegistration 
Oracle fundamentals course

Intended for

Analysts, programmers and database administrators who are going to use Oracle. Everybody who wants a thorough overview of the Oracle RDBMS.

Background

General knowledge of informatics and some familiarity with database systems (see course RDBMS concepts). Some familiarity with SQL (see course SQL fundamentals). You can test yourself to see if you have enough background by printing and filling in the self-tests(PDF file - 57 KB and PDF file - 56 KB).

Training method

Classroom instruction with practical exercises.

Course leader

Koen De Backer, Sandy Schillebeeckx, Kris Van Thillo.

Duration

3 days.

Schedule

datelanguageplacepriceremarks
15/02/2012 Leuven1260 EUR
22/02/2012NWoerden1260 EUR
04/04/2012FLeuven1260 EUR
09/05/2012NWoerden1260 EUR
06/06/2012NLeuven1260 EUR
Legend
  • You can enrol by clicking on the dates in the calendar.
  • N: Dutch; F: French; E: English; No code: language depends on the participants.
  • All prices are VAT excluded.
  • Countries:
    Belgium 
    Netherlands 
    Elsewhere 

Objectives

This course:

  • gives an overview of the Oracle RDBMS architecture;
  • examines the physical and logical Oracle objects, and their relationship;
  • describes the general and syntactical characteristics of the Oracle RDBMS: security, locking, utilities;
  • gives some basic rules concerning application performance.

Main topics

  • Oracle architecture:
  • Oracle instance and Oracle database • Oracle Client/server architecture
  • Data definition and Oracle Objects:
  • Oracle logical object structure • link with physical structure • DDL statements
  • Application development:
  • overview 3GL and 4GL
  • Catalog:
  • catalog • performance tables
  • Security concepts:
  • type privileges • roles
  • Basic utilities:
  • export/import • loader • scenarios
  • Locking:
  • lock types • vVersioning'
  • Performance and Tuning:
  • explain utility