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

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

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

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

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

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

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

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