IT-Praxis: Oracle Database 23c SQL (Free - Developer Release)

Course PW41

  • Duration:
    • 5 days

Dates:

  • Implementation planned - places still available
  • Implementation - probability high - still places available
  • There are no more seats available. For many courses, it may still be possible to participate online, via virtual classroom.
  • Course times: As a rule, our seminars are held from 10:00 am to 5:00 pm on day 1 and from 9:00 am to 4:00 pm on the following days. Changes are possible. The concrete seminar times you will find in the binding order confirmation.
17.02.2025 - 21.02.2025 Virtual Classroom
  • 3180 EUR / Person
 German
07.04.2025 - 11.04.2025 Virtual Classroom
  • 3180 EUR / Person
 German
16.06.2025 - 20.06.2025 Virtual Classroom
  • 3180 EUR / Person
 German

Learn the basic concepts of relational databases, queries with selects, joins (in ANSI and Oracle syntax), commands for manipulating data.

This course teaches the basic concepts of relational databases and the SQL language. Participants will learn how to query and manipulate data within a database. The use of joins, subqueries, set operators and group functions is demonstrated. The course describes how to create and manage database objects such as tables, views, indices, sequences and synonyms. Participants also learn how to control user access to the database, create roles, assign authorisations and access metadata via dictionary views.
Oracle SQL Developer is used as a development tool in the course; SQL*Plus can be used as an option.
Get to know the new SQL features of Oracle 23c (Free - Developer Release).

  • Getting started with SQL
  • Querying data with SELECT
  • Data types
  • Customise query results with functions and conditional expressions
  • Grouping query results
  • Linking tables
  • Subqueries in SELECT statements
  • Set operators
  • Editing data and transactions
  • Data Dictionary
  • Creating and managing database objects
  • Manage authorisations
  • Data Warehouse Administrators
  • Developers
  • PL/SQL developers
  • Forms developers
  • system analysts
  • business analysts
  • Data processing
  • Familiarity with data processing concepts and techniques

This seminar is organised in cooperation with Robotron Datenbank-Software GmbH Dresden.

For classroom courses, the price quoted includes lunch in Robotron's in-house canteen.

For our online offers we use

  • Zoom for the presentation of the course content and
  • Citrix for the training environments

environments. In in-house courses, Zoom can be replaced by other software solutions.

Seminar times: 1st day 10.00 - 17.00, following days 09.00 - 17.00

Contact us

SoftwareONE

IT CAMPUS
Customer Training Solutions

Blochstraße 1
D-04329 Leipzig
*The services of SoftwareONE Deutschland GmbH directly serving school and educational purposes are predominantly VAT-exempt according to § 4 No. 21 a) bb) UStG. Contact us - we are happy to help!