pds-it
['Product detail page','no']
Databases / Oracle
The illustrations were created in cooperation between humans and artificial intelligence. They show a future in which technology is omnipresent, but people remain at the center.
AI-generated illustration

Oracle SQL - The basic training

Online
3 days
German
Download PDF
€ 1.890,-
plus VAT.
€ 2.249,10
incl. VAT.
Booking number
36179
Venue
Online
1 appointment
€ 1.890,-
plus VAT.
€ 2.249,10
incl. VAT.
Booking number
36179
Venue
Online
1 appointment
Become a certified
Machine Learning Engineer
This course is part of the certified Master Class "Machine Learning Engineer". If you book the entire Master Class, you save over 15 percent compared to booking this individual module.
To the Master Class
In-house training
In-house training for your Employees only - exclusive and effective.
Inquiries
In cooperation with
In this workshop you will learn the basics of Oracle SQL. The topics range from the syntax of simple statements to the various joins and subqueries to analytical functions, hierarchical queries and regular expressions in SQL.
Contents
  • SQL - History
  • ZERO
  • Syntax of the SELECT statement
    • SELECT FROM
    • SELECT DISTINCT FROM
    • WHERE and comparison operators
    • Arithmetic and string operators
    • AND, OR and NOT
    • ORDER BY
    • The DUAL table
    • ROWNUM
  • SQL functions
    • Numeric, string, converter, date and time
    • Comparison functions, LOBs and collections, hierarchical functions
    • Data mining, XML and JSON 
    • Encoding & Decoding
    • Environment - USER and SYS_CONTEXT
    • DECODE and CASE
  • GROUP BY, group functions and HAVING
  • Set operations - UNION, UNION ALL, INTERSECT and MINUS
  • DML (INSERT, UPDATE and DELETE)
  • Transactions - COMMIT, ROLLBACK, SAVEPOINT, SET TRANSACTION and read consistency
  • The Data Dictionary
  • Constraints - Primary, Unique and Foreign Key Constraints
  • ROWIDs and indices - index types, administration and reorganization 
  • Joins
    • old Oracle Join Syntax
    • INNER, CROSS, OUTER and NATURAL Joins
    • Self-Joins
  • Subqueries
    • Synchronous and asynchronous query
    • Inlay Views
    • EXISTS and NOT EXISTS, ANY and ALL
    • WITH
Your benefit
  • Basic knowledge of Oracle SQL 
  • Syntax of simple statements
  • Understanding joins and subqueries
  • Knowledge of analytical functions, hierarchical queries and regular expression in SQL
trainer
Peter Renner
Methods

This course consists of training training and is led by a trainer who supervises the participants live. Theory and practice are taught with live demonstrations and practical exercises. The video conferencing software Zoom is used.

Final examination
Recommended for

This workshop is aimed at prospective Oracle database administrator, administrator administrators, developers developers or architects, in general anyone who comes into contact with SQL.

Start dates and details

Form of learning

Learning form

27.8.2025
Online
Places free
Implementation secured
Online
Places free
Implementation secured

The training is carried out in cooperation with an authorized training partner.

The latter collects and processes data under its own responsibility. Please take note of the corresponding privacy policy

Do you have questions about training?
Call us on +49 761 595 33900 or write to us at service@haufe-akademie.de or use the contact form.