In this workshop, we will teach you the basics of Oracle SQL. The workshop offers sufficient space for exercises in which the newly acquired knowledge can be implemented or existing knowledge can be deepened. The topics range from the syntax of simple statements to the various joins and subqueries to more specialized topics such as analytical functions, hierarchical queries and regular expressions in SQL.
1 SQL – History
2 NULL
3 Syntax of the SELECT statement
4 SQL functions
5 GROUP BY, group functions and HAVING
6 Set operations - UNION, UNION ALL, INTERSECT and MINUS
7 DML (INSERT, UPDATE and DELETE)
8 Transactions - COMMIT, ROLLBACK, SAVEPOINT, SET TRANSACTION and read consistency
9 The Data Dictionary
10 Constraints - Primary, Unique and Foreign Key Constraints
11 ROWIDs and Indexes - Index Types, Administration and Reorganization
12 Joins
13 Subqueries
Prospective Oracle database administrators, application administrators, Oracle developers or architects, generally anyone who comes into contact with SQL.
The course does not require a specific Oracle version. For newer features (from 12.2), the version from which they are available is indicated separately.
But we can arrange one for you. We will be happy to advise you individually on your course planning.
Contact us