Brainmatics

Oracle Database 12c Administration (1Z0-062) Exam Preparation

Training Oracle Database 12c: Administration merupakan salah satu langkah untuk menjadi seorang Oracle Database Administration professional, didesain untuk memberikan sebuah fondasi dasar dalam adminisitrasi Database Oracle. Pada training ini Anda akan mempelajari bagaimana menginstal dan mengelola sebuah Database Oracle. Anda akan mendapatkan pemahaman konseptual arsitektur Database Oracle dan bagaimana komponen-komponen tersebut bekerja dan berinteraksi dengan yang lainnya.

Dengan training ini peserta diharapkan dapat membuat sebuah operasional database dan mengelolanya dengan tepat berbagai struktur secara efektif dan efisien termasuk pemantauan kinerja, kemanan database, pengelolaan user, dan teknik backup/recovery. Training ini pun ditunjang dengan praktik-praktik secara langsung.

OBJECTIVES

  1. Mampu membuat dan mengelola operasional database
  2. Mampu mengelola keamanan database, user, dan Teknik backup/recovery
  3. Memahami bagaimana komponen-komponen pada Oracle Database bekerja dan berinteraksi

AUDIENCE

  1. Application Developer
  2. Database Administrator
  3. PL/SQL Developer
  4. Data Analyst

PREREQUISITES

Tidak ada training khusus yang dipersyaratkan

CONTENT

1. Exploring the Oracle Database Architecture

1.1. List the architectural components of Oracle Database
1.2. Explain the memory structures
1.3. Describe the background processes

2. Oracle Database Instance

2.1. Understand initialization parameter files
2.2. Start up and shut down an Oracle database instance
2.3. View the alert log and access dynamic performance views

3. Administering User Security

3.1. Create and manage database user accounts
3.2. Grant and revoke privileges
3.3. Create and manage roles
3.4. Create and manage profiles

4. Create and manage tablespaces

4.1. Explain how Oracle database server automatically manages space
4.2. Save space by using compression
4.3. Use the Segment Advisor
4.4. Reclaim wasted space from tables and indexes by using the segment shrink functionality

5. Managing Data Concurrency

5.1. Describe the locking mechanism and how Oracle manages data concurrency
5.2. Monitor and resolve locking conflicts

6. Backup and Recovery Concepts

6.1. Identify the importance of checkpoints, redo log files, and archive log files

7. Performing Database Backups

7.1. Create consistent database backups
7.2. Back up your database without shutting it down
7.3. Create incremental backups
7.4. Automate database backups
7.5. Manage backups

8. Moving Data

8.1. Describe ways to move data
8.2. Use SQL*Loader to load data from a non-Oracle database
8.3. Use external tables to move data via platform-independent files
8.4 Explain the general architecture of Oracle Data Pump
8.5. Use Data Pump Export and Import to move data between Oracle databases

9. Managing Performance: SQL Tuning

9.1. Use the SQL Tuning advisor

10. Creating an Oracle Database Using DBCA

10.1. Generate database creation scripts by using DBCA
10.2. Manage database design templates by using DBCA

11. Introduction to DBAAS

11.1. Recognize the difference between a DBaaS Instance and a Database Instance
11.2. Navigate with My Services Dashboard
11.3. User authentication and roles
11.4. Generate a Secure Shell (SSH) Public/Private Key Pair

12. Oracle Database Management Tools

12.1. Use database management tools

13. Configuring the Oracle Network Environment

13.1. Configure Oracle Net Services
13.2. Use tools for configuring and managing the Oracle network
13.3. Configure client-side network
13.4 Configure communication between databases

14. Managing Database Storage Structures

14.1. Describe the storage of table row data in blocks
14.2. Create and manage tablespaces

15. Managing Undo Data

15.1. Explain DML and undo data generation
15.2. Monitor and administer undo data
15.3. Describe the difference between undo data and redo data
15.4. Configure undo retention

16. Implementing Oracle Database Auditing

16.1. Enable standard database auditing and unified auditing

17. Backup and Recovery Configuration

17.1. Configure the fast recovery area
17.2. Configure ARCHIVELOG mode

18. Performing Database Recovery

18.1. Determine the need for performing recovery
18.2. Use Recovery Manager (RMAN) and the Data Recovery Advisor to perform recovery of the control file, redo log file and data file

19. Performing Database Maintenance

19.1. Use server-generated alerts

20. Automating Tasks by Using Oracle Scheduler

20.1. Use Oracle Scheduler to simplify management tasks
20.2. Use job chains to perform a series of related tasks
20.3. Use Scheduler jobs on remote systems
20.4. Use advanced Scheduler features to prioritize jobs

21. Upgrading Oracle Database Software

21.1. Describe data migration methods
21.2. Describe the upgrade process

 

INSTRUCTOR

Ananias Ardiles Sembiring. Lahir di Pematang Siantar, 3 September 1983. Menyelesaikan pendidikan S1 di ITB pada tahun 2007, telah tersertifikasi OCP, dan OCA. Berpengalaman menjadi Database Administrator selama 7 tahun, dan berpengalaman mengajar Oracle selama 5 tahun.