EÄŸitim ve Workshoplar
Oracle EÄŸitimleri
Introduction to SQL (5 days)
-
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.
Program with PL/SQL (3 days)
-
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
Oracle Database Administration (5 days)
-
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.
Oracle RAC and GRID Administration (5 days)
-
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.
SQL Tuning (3 days)
-
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.
Dataguard Workshop (3 days)
-
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
Backup&Recovery Workshop (3 days)
-
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
Database Install, Patch and Upgrade Workshop (3 days)
-
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.