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
02/06/2014NWoerden1290 EUR
25/06/2014ELeuven1290 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