Workshop
Advanced workshop Oracle SQL («ODSQL1»)
In this workshop you will acquire a deepened knowledge of various Oracle database objects, which will be strengthened with many practical exercises. In addition, we will give you some Oracle highlights that stand out from the standard SQL.
Duration
3 days
Price
2'950.–
Course facts
- Understanding and applying Oracle SQL specialties
- Understanding and applying Oracle Flashback Query
- Understanding and applying Data Dictionary View
- Creating database objects
1 Introduction
- Refresh Standard SQL-3
2 Oracle SQL Basics
- Connect to an Oracle database
- SQLPLUS
- SQLDEVELOPER
- SQLCL
3 DDL/Database Objects
- User
- Privileges
- Roles
- Tablespace
- Field types
- Constraints
- Views
- Index/index access
4 Functions
- Format date
- Substring/Instring
- NVL/NVL2
- to_number
- case
5 DML
- Row Limiting
- Merge
- Read consistency
6 Data Dictionary Views
- CDB/DBA/ALL/USER_ Views
7 FLASHBACK
- Flashback Table
- Flashback Query
8 External tables
The participants receive theoretical knowledge, which is consolidated with many practical exercises.
This workshop is designed for (prospective) database administrators who want to get to know Oracle SQL in more depth and for developers who already know and use other databases.
You have SQL 3 standard knowledge to the extent of the following course:
Your benefit
- Highly professional course instructor who has been working as an Oracle database engineer for over 10 years
- Immediate added value in everyday work thanks to practical exercises
- Helpful practical tips thanks to specially developed Digicomp course material
- Optional desired topics can be included