Oracle SQL - Basics («ODSQLB»)

• Having a basic knowledge of Oracle SQL 
• Understanding the syntax of simple statements 
• Understanding joins and subqueries
• Understanding analytical functions, hierarchical queries and regular expressions in SQL

1 SQL - History

2 NULL

3 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

4 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

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 Das Data Dictionary

10 Constraints - Primary, Unique and Foreign Key Constraints

11 ROWIDs and indexes - index types, administration and reorganization  

12 Joins

• old Oracle Join Syntax
• INNER, CROSS, OUTER and NATURAL Joins
• Self-Joins

13 Subqueries

• synchronous and asynchronous query
• Inlay Views
• EXISTS and NOT EXISTS, ANY and ALL
• WITH

The participants receive theoretical knowledge, which is consolidated with many practical exercises.

This workshop is intended for prospective Oracle database administrators, application administrators, Oracle developers or architects, generally anyone who comes into contact with SQL.

Programming knowledge is not required, but helpful.