home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Soft skills » Introduction to HW & SW » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » Mac OS X » iPad and iPhone iOSDatabases, 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 » Data warehouse, business analytics and big dataApplication development » Methods and techniques » TOGAF » PRINCE2 » Agile development and Scrum » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITIL » SecuritybalkjePractical 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 filling in the RDBMS online self-test and/or the SQL online self-test.

Training method

Classroom instruction with practical exercises.

Course leader

Koen De Backer, Sandy Schillebeeckx, Kris Van Thillo.

Duration

3 days.

Schedule

datelanguageplacepriceremarks
27/05/2013NWoerden1290 EUR guaranteed
05/06/2013ELeuven1290 EUR
18/09/2013NWoerden1290 EUR
16/10/2013FLeuven1290 EUR
13/11/2013NWoerden1290 EUR
25/11/2013NLeuven1290 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 
  • Remarks:
    (guaranteed:) this session will certainly run
    (last places:) only limited number of places available
    (complete:) this session is fully booked; please contact us to get on the waiting list

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