Advanced workshop Oracle SQL («ODSQL1»)

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:

WORKSHOP
Oracle SQL - Basics («ODSQLB»)
3 days
CHF
2'950.–
Learn more

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