Brainmatics
porno izle | porno video | sikiş | porno

Oracle Database 12c: Administration I

Training Oracle Database 12c: Administration I 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. Installing Oracle Database Software

1.1. Plan For an Oracle Database Software Installation
1.2. Install the Oracle Database Software

2. Creating an Oracle Database Using DBCA

2.1. Create a Database by Using the Database Configuration Assistant (DBCA)
2.2. Generate Database Creation Scripts by Using DBCA
2.3. Manage database Design Templates by Using DBCA
2.4. Configure Database Options by Using DBCA

3. Exploring the Oracle

3.1. List the Architectural Components
3.2. Explain the Memory Structures
3.3. Describe the Background Processes
3.4. Explain the Relationship Between Logical and Physical Storage Structures

4. Managing the Database Instance

4.1. Use Database Management Tools
4.2. Understand Initialization Parameter Files
4.3. Start Up and Shut Down an Oracle Database Instance
4.4. View the Alert Log and Access Dynamic Performance Views

5. Configuring the Oracle Network Environment

5.1. Configure Oracle Net Services
5.2. Use Tools for Configuring and Managing the Oracle Network
5.3. Configure Client-Side Network
5.4. Understand Database Resident Connection Pooling Configure Communication Between Databases

6. Managing Database Storage Structures

6.1. Describe the Storage of Table Row Data in Blocks
6.2. Create and Manage Tablespaces

7. Managing Space

7.1. Explain How Oracle Database Server Automatically Manages Space
7.2. Save Space by Using Compression
7.3. Proactively Monitor and Manage Tablespace Usage
7.4. Use the Segment Advisor
7.5. Reclaim Wasted Space from Tables and Indexes by Using the Segment Shrink Functionality
7.6. Manage Resumable Space Allocation

8. Administering User Security

8.1. Create and Manage Database User Accounts
8.2. Grant and Revoke Peivileges
8.3. Create and Manage Roles
8.4. Create and Manage Profiles

9. Managing Undo Data

9.1. Explain DML and Undo Data Generation
9.2. Monitor and Administer Undo Segments
9.3. Describe the Difference Between Undo Data and Redo Data Configure Undo Retention

10. Managing Data Concurrency

10.1. Describe the Locking Mechanism and How Oracle Manages Data Concurrency
10.2. Monitor and Reslove Locking Conflicts

11. Implementing Oracle Database Auditing

11.1. Explain DBA Responsibilities for Security and Auditing
11.2. Enable Standard Database Auditing and Unified Auditing

12. Performing Database Maintenance

12.1. Manage the Automatic Workload Repository (AWR)
12.2. Use the Automatic Database Diagnostic Monitor (ADDM)
12.3. Describe and Use the Advisory Framework
12.4. Set Alert Thresholds
12.5. Use Automated Tasks

13. Managing Performance

13.1. Use Enterprise Manager to Monitor Performance
13.2. Use Automatic Memory Management
13.3. Use the Memory Advisor to Size Memory Buffers

14. Managing Performance SQL Tuning

14.1. Manage Optimizer Statistics
14.2. Use the SQL Tuning Advisor
14.3. Use the SQL Access Advisor to Tune Workload

15. Managing Resources Using Database Resource Manager

15.1. Configure the Database Resource Manager
15.2. Access and Create Resource Plans
15.3. Monitor the Resource Manager

16. Automating Tasks by Using Oracle Scheduler

16.1. Use Oracle Scheduler to Simplify Management Tasks
16.2. Use Job Chains ro Perform a Series of Related Tasks
16.3. Use Scheduler Jobs on Remote Systems
16.4. Use Advanced Scheduler Features to Prioritize Jobs

17. Moving Data

17.1. Describe Ways to Move Data
17.2. Create and Use Directory Objects
17.3. Use SQL*Loader to Load Data from a Non-Oracle Database
17.4. Use External Tables to Move Data via Platform-Independent Files
17.5. Explain the General Architecture of Oracle Data Pump
17.6. Use Data Pump Export and Import to Move Data Between Oracle Databases

18. Backup and Recovery: Concepts and Configuration

18.1. Identify the Importance of Checkpoints, Redo Logfiles, and Archive Logfiles
18.2. Backup and Recovery: Configuration
18.3. Configure the Fast Recovery Area
18.4. Configure Archivelog Mode

19. Backup and Recovery Operations

19.1. CreaDVIOSR TO \ate Consistent Database Backups
19.2. Back Up Your Database Without Shutting It Down
19.3. Create Incremental Backups
19.4. Automate Database Backups
19.5. Manage Backups
19.6. Determine the Need for Perfoming Recovery
19.7. Use Recovery Manager (RMAN) and the Data Recovery Advisor to Perform Recovery of the Controlfile,Redo Logfile, and datafile

20. Installing Oracle Grid Infrastructure for Standalone Server

20.1. Configure Storage for Oracle Automatic Storage Management (ASM)
20.2. Install Oracle Grid Infrastucture for a Standalone Server

21. Using Oracle Restart

21.1. Use Oracle Restart to Manage Components

22. Upgrading Oracle Database Software and Migrating Data

22.1. Describe Upgrade Methods
22.2. Describe Data Migration Method
22.3. Describe the Upgrade Process
22.4. Migrating Data by Using Oracle Data Pump

23. Database Upgrade: Preparation, Upgrading, and Post-Upgrade Tasks

23.1. Describe Upgrade Requirements when Certain Features or Options Are Used in Oracle Database
23.2. Use the Pre-Upgrade Information Tool Before Perfoming an Upgrade
23.3. Prepare the New Oracle Home Prior to Perfoming an Upgrade
23.4. Upgrade the Database to Oracle Database 12c by Using the Database Upgrade Assistant (DBUA)
23.5. Perform a Manual Upgrade to Oracle Database 12c by Using Scripts and Tools
23.6. Migrate to Unified Auditing
23.7. Perform Post-Upgrade Tasks

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.