In this workshop, we will teach you advanced techniques and concepts 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 Data Types in Detail
2 GROUP BY – Extensions ROLLUP, CUBE and GROUPING
3 Analytical Functions
4 Top-N and the SQL ROW LIMIT Clause
5 Data Definition Language (DDL): Tables, Sequences, Views
6 Hierarchical Queries – START WITH and CONNECT BY, LEVEL and PRIOR
7 Advanced DML
8 Regular Expressions
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