Oracle SQL und Oracle PL/SQL

Introduction to relational database design

• Basics of relational database design
• The "Lingua Franca" of the database world: SQL
• Querying databases with the SELECT command
• Modifying data with the UPDATE, INSERT and DELETE commands

Advanced SQL

• Dealing with the "NULL" value
• Group functions and sorting
• Inner and outer joins
• Conversion
• Working with data and time intervals
• Hierarchy in the database
• Subqueries, inner views, virtual tables
• Transaction management, consistency and locking concept

DDL statements (create, alter, rename,...)

• Creating, modifying, emptying and deleting tables
• Dealing with views
• Data types, constraints, schema, synonyms, sequences, indexes

Structure of the database

• The Optimal Flexible Architecture (OFA)
• Alert and log files
• The Enterprise Manager, maintenance and upkeep of the database
• Tips for creating the database, importing and exporting

PL/SQL

• Basics of the PL/SQL language
• The PL/SQL block
• Loop constructs, cursors, exception handling
• Functions, procedures and packages
• Database triggers

Programmers and administrators with basic knowledge of relational databases and basic knowledge of a programming language

This seminar has the level "Programming / Basics".

If you are not sure if this course is the right level for you, you can check with the trainer in advance.

We offer you seminars with a high practical relevance. The content and exercises are geared to your daily tasks in your company and are completely free of advertising references to other software manufacturer's products.

All our training courses are vendor-independent. This enables us to offer critical reflections on the products themselves and comparisons with the manufacturer's competitors in the seminar. The course contents are our own and are derived from the practical experience of our trainers in projects.

Of course, the content of company seminars can be adapted to your individual needs. Please do not hesitate to contact us.

• Guaranteed delivery - guaranteed delivery for two or more participants
• Mobile classrooms - the ideal complement to corporate seminars
• Free support - for questions after the seminar
• Delivery on account - no prepayment required
• Interview with the trainer / quality assurance - get to know and assess the trainer in advance
• Clarification of seminar requirements - discuss your knowledge with the trainer
• Assistance with travel costs - we cover part of the cost of hotel accommodation
• Catering - all day cold / hot drinks and a full lunch in the restaurant
• Location of the training centers - always centrally located and very easy to reach
• Discounts - we have attractive prices, take advantage of our additional discounts
• Remotelabs - rent our remotelabs for your own seminars or as a complement to your company seminars