Oracle Trainings

​

We are at your service with our Oracle Technology Trainings, not only limited to theoretical knowledge, but also the classical education format, where many years of experience in the field are also transferred to the participants,

Introduction to SQL

Introduction to SQL

  • Understand the basic concepts of RDBMS.

  • Create reports of sorted and restricted data.

  • Run data manipulation statements (DML).

  • Control database access to specific objects.

  • Manage schema objects.

  • Manage objects with data dictionary views.

  • Retrieve row and column data from tables.

  • Control privileges

  • Create indexes and constraints; 

  • Alter existing schema objects.

  • Create and query external tables.

Duration: 

5 Days

kisspng-oracle-sql-developer-oracle-data

Program with PL/SQL

Program with PL/SQL

  • Conditionally control code flow (loops, control structures).

  • Create stored procedures and functions.

  • Use PL/SQL packages

  • Create and usetriggers 

  • Use Oracle supplied PL/SQL packages to generate screen output and file output.

  • Create custom packages for applications.

  • Write Dynamic SQL code for applications.

Duration: 

5 Days

plsql.png

Database Administration

Database Administration

  • ​Learn Oracle Database Architecture.

  • Create and manage an Oracle Database Instance.

  • Create and manage Storage Structures.

  • Configure the Oracle Network Environment.

  • Create and manage users.

  • Monitor the database and manage performance.

  • Learn basic information on backup and recovery techniques.

Duration: 

5 Days

hiclipart.com (1).png

RAC Adminitration

RAC Administration

  • ​Install Oracle RAC software.

  • Create cluster databases.

  • Administer both administrator and policy-managed Oracle RAC databases.

  • Monitor and address performance issues.

  • Learn about services in a RAC environment

  • Create and administer a RAC One Node Database.

  • Create and manage multitennant RAC databases.

Duration: 

5 Days

kindpng_2183621.png

SQL Tuning Workshop

SQL Tuning

  • ​Use Oracle tools to identify inefficient SQL statements.

  • Use Automatic SQL Tuning.

  • Use Real Time SQL monitoring.

  • Write more efficient SQL statements.

  • Monitor and trace high load SQL statements.

  • Manage optimizer statistics on database objects.

  • Understand the optimizer process steps.

  • Interpret execution plans.

Duration: 

3 Days

pngguru.com.png

Dataguard Workshop

Dataguard Workshop

  • ​Understand Data Guard architecture

  • Create, manage, and monitor Physical and Logical Standby databases

  • Perform Switchover and Failover

  • Implement Oracle Active Data Guard

  • Create and manage Snapshot Standby database

  • Implement client failover in a Data Guard Configuration

  • Use RMAN in a Data Guard environment

  • Use advanced options in Oracle Data Guard

Duration: 

3 Days

150504-backup-restore.png

Backup&Recovery Workshop

Backup&Recovery Workshop

  • ​Develop backup and recovery procedures to address your business needs.

  • Implement backup and recovery settings and perform backup operations.

  • UseDatabase recovery procedures to recover from media and other failures.

  • Diagnose and repair data failures.

  • Use Flashback Technologies and data duplication.

  • Secure the availability of your database by appropriate backup and recovery strategies.

Duration: 

3 Days

pnggurud.com.png

Admin/Install/Upgrade

Workshop

Admin, Install, Patch and Upgrade Workshop

  • Upgrade an existing Oracle Database to Oracle Database 12c.

  • Create and manage an Oracle Database Instance.

  • Create and manage Storage Structures.

  • Patch an Oracle database with PSU/RU

  • Create and manage users.

  • Monitor the database and manage performance.

Duration: 

3 Days

database.png