TRAINING ADVANCED DATABASE 2 FOR ADMINISTRATOR AND DEVELOPERS
TRAINING PEMAHAMAN ADVANCED DATABASE 2 FOR ADMINISTRATOR AND DEVELOPERS
TRAINING PENTINGNYA ADVANCED DATABASE 2 FOR ADMINISTRATOR AND DEVELOPERS
OBJECTIVES
* Describe Oracle Database Architecture
* Install and configure Oracle Database 11g
* Configure Oracle Net services
* Manage the database storage structures
* Create and administer user accounts
* Perform basic backup and recovery of a database
* Manage users and schemas
* Manage data and concurrency
* Monitor and administer undo data
* Backup and recover a database
* Monitor performance
* Use the database diagnostic monitor
COURSE OUTLINE
1. Exploring the Oracle Database Architecture :Â Oracle Database
Architecture Overview, Interacting with an Oracle
Database, Process Architecture, Database Storage
Architecture, Logical and Physical Database
Structures, Tablespaces and Data Files, SYSTEM and SYSAUX
Tablespaces, Segments, Extents, and Blocks
2. Preparing the Database Environment :Â Tasks of an Oracle Database
Administrator, Tools Used to Administer an Oracle
Database, Installation: System Requirements, Optimal Flexible
Architecture (OFA), Setting Environment Variables, Oracle
Universal Installer (OUI), Database Configuration
Options, Advanced Installation Options
3. Creating an Oracle Database : Planning the Database, Configuring
the Listener, Using the DBCA to Create a Database, Password
Management, Creating a Database Design Template, Using the DBCA
to Delete a Database, Using DBCA For Additional Tasks
4. Managing the Oracle Instance : Management Framework, Oracle
Enterprise Manager, Initialization Parameter, Database Startup
and Shutdown, Shutdown Modes, Viewing the Alert History, Using
Trace Files, Data Dictionary: Overview
5. Configuring the Oracle Network Environment :Â Oracle Net Services
& Listener, Establishing Net Connections, Tools for Configuring
and Managing the Oracle Network, Net Services Administration
Pages, Naming Methods, Directory Naming, SGA and PGA, When Not
to Use a Shared Server
6. Managing Database Storage Structures : Storage Structures, How
Table Data Is Stored, Anatomy of a Database Block, Space
Management in Tablespaces, Tablespaces in the Preconfigured
Database, Actions with Tablespaces, Oracle Managed Files
(OMF), ASM: Concepts
7. Administering User Security :Database User Accounts, Predefined
Accounts: SYS and SYSTEM, Administrator Authentication, Benefits
of Roles, Predefined Roles, Implementing Password Security
Features, Assigning Quota to Users
8. Managing Schema Objects : What Is a Schema?, Accessing Schema
Objects, Specifying Data Types in Tables, Creating and Modifying
Tables, Understanding Data Integrity, Indexes &
Views, Sequences, Temporary Tables
9. Managing Data and Concurrency :Â Manipulating Data Through
SQL, PL/SQL, Administering PL/SQL Objects, Functions,
Procedures, Packages & Triggers, Data Concurrency, Enqueue
Mechanism, Resolving Lock Conflicts Using SQL, Deadlocks
10. Managing Undo Data : Data Manipulation, Transactions and Undo
Data, Undo Data Versus Redo Data, Configuring Undo
Retention, Guaranteeing Undo Retention, Using the Undo
Advisor, Viewing System Activity
11. Implementing Oracle Database Security :Â Industry Security
Requirements, Principle of Least Privilege, Monitoring for
Compliance, Value-Based Auditing, Fine-Grained Auditing, DBA
Auditing, Security Updates, Applying Security Patches
12. Database Maintenance : Introducing Terminology, Optimizer
Statistics, Automatic Workload Repository (AWR), Automatic
Database Diagnostic Monitor (ADDM), Advisory
Framework, Automated Maintenance Tasks, Server-Generated
Alerts, Reacting to Alerts
13. Performance Management : Performance Monitoring, Managing Memory
Components, Enabling Automatic Memory Management
(AMM), Automatic Shared Memory Advisor, Using Memory
Advisors, Dynamic Performance Statistics, Troubleshooting and
Tuning Views, Invalid and Unusable Objects
14. Backup and Recovery Concepts : Part of Your Job, Statement
Failure, User Error, Understanding Instance Recovery, Phases of
Instance Recovery, Using the MTTR Advisor, Media
Failure, Archive Log Files
15. Performing Database Backups : Backup Solutions: Overview, Oracle
Secure Backup, User-Managed Backup, Terminology, Recovery
Manager (RMAN), Configuring Backup Settings, Backing Up the
Control File to a Trace File, Monitoring the Flash Recovery Area
16. Performing Database Recovery : Opening a Database, Data Recovery
Advisor, Loss of a Control File, Loss of a Redo Log File, Data
Recovery Advisor, Data Failures, Listing Data Failures, Data
Recovery Advisor Views
17. Moving Data : Moving Data: General Architecture, Directory
Object: Overview, SQL*Loader: Overview, Data Pump:
Overview, Performance Initialization Parameters, Using
Enterprise Manager to Monitor Data Pump Jobs, Data Dictionary
18. 3 Enhancing Database Capabilities :Â Using EM Support
Workbench, Create a Service Request, Package and upload
diagnostic data to Oracle Support, Track the SR and Implement
Repairs, Incident Packaging Configuration, Working with Oracle
Support, MetaLink Integration ,Managing Patches
TRAINING METHOD
Pre test
Presentation
Discussion
Case Study
Post test
Evaluation
JADWAL TRAINING TAHUN 2023
17 – 18 Januari 2023
14 – 15 Februari 2023
20 – 21 Maret 2023
4 – 5 April 2023
16 – 17 Mei 2023
20 – 21 Juni 2023
17 – 18 Juli 2023
15 – 16 Agustus 2023
25 – 26 September 2023
17 – 18 Oktober 2023
21 – 22 November 2023
27 – 28 Desember 2023
Metode Training
- Tatap Muka/offline
- Online via zoom
Kota Penyelenggaraan jika offline :
- Bandung
- Jogjakarta
- Surabaya
- Jakarta
fasilitas yang didapatkan
- Training Kit Eksklusif
- Tas
- Name Tag
- Modul
- Flash disk
- Ballpoint
- Block Note
- Souvenir
- Harga yang Reliable
- Trainer Kompeten di bidangnya
- Pelayanan Maksimal untuk peserta
- Penjemputan dari dan ke bandara
Investasi :
Public training : Rp. 4.500.000 (minimum 3 pax)
In House Training : on Call
