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

Course PW41

  • Duration:
    • 5 days

Dates:

Dates on request - if no dates are listed, please contact us to arrange an individual date by e-mail at it-campus@softwareone.com or by phone on +49 341 2568-486.

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!