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
.svg)
.svg)
€ 1.890,-
plus VAT.
€ 2.249,10
incl. VAT.
Booking number
36179
Venue
Online
.svg)
1 appointment
€ 1.890,-
plus VAT.
€ 2.249,10
incl. VAT.
Booking number
36179
Venue
Online
1 appointment
plus VAT.
incl. VAT.
Booking number
Venue
0 Dates
Become a certified
Machine Learning Engineer
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 just for your employees - 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 administrators, administrators administrators, Oracle developers or architects, generally anyone who comes into contact with SQL.
.svg)
