Workshop
digicode: ODSQLB
Oracle SQL - Basics
Course facts
Download as PDF- 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
Component of the following courses
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.
- Basic digital skills and confidence in using common IT applications
- Basic knowledge of relational databases
- A passion for analytical thinking, as well as good abstract thinking and visualization skills
This workshop is based on Oracle Database 23ai Free, and SQL*Plus is used as the front end. No prior installation is required.