Oracle Eğitimleri

Sadece teorik bilgi ile sınırlı olmayan, klasik eğitim formatının dışında, uzun yıllardır sahada edinilen tecrübelerin de katılımcılara aktarıldığı, isteğe göre 3-5 kişilik özel sınıflarda verdiğimiz Oracle Teknoloji Eğitimlerimiz ile hizmetinizdeyiz.

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