Breaking News:
RSS
Tools
Dec 16
Training IT - Oracle DBA 11g Admin 1 PDF Print E-mail

Sudah terbukti secara teknis,bahwa sistem database yang paling handal adalah Oracle. Peserta pelatihan wajib mempelajari sistem database ini untuk menjadi programmer yang handal.


Daftar Materi Pelatihan:

      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 Topics

    Minggu I : 

    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  

    Minggu II :

    1.   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

    2.   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

    3.   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  

    4.   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

    Minggu III :

    1. 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

    2. 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

    3. 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

    4. 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

    Minggu IV :

    1. 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

    2. 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  

    3. 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

    Minggu V :

    1. 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

    2. 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

    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

    Trainer :  Sumadi Eko Putra, S.Kom


    Praktisi Berpengalaman dan Dosen ilmu Komputer. Aktifitas utama Sebagai NOC Performance Data Support di PT. Bakrie Telekom.

    Durasi Training : 30 Jam (5x pertemuan @6 jam)

    Waktu Training : 1.  Sabtu / Minggu (09.00 – 16.00)

    2.  Rabu dan Sabtu (13.00 - 16.00)


    Fasilitas Training :


    1.Modul
    2.Sertifikat
    3.Makan Siang dan Coffee break( Untuk Kelas Sabtu dan Minggu )
    4.Snack ( Untuk Kelas Malam )
    5.Akses Internet

    Biaya Training :  Rp. 3.400.000,-

    Biaya Pendaftaran : Rp. 100.000,-


    TEMPAT PENDAFTARAN & TRAINING:


    TANMIA INFORMATIKA
    Jl. Raya Pasar Minggu No. 15D Kel. Pejaten Timur
    KM 19     Jakarta Selatan

    (Depan Kantor PMD – DEPDAGRI Jak-Sel)
    Telp. +62-21-70734001, Fax. +62-21-7900022

    Email : Infoattanmia-informatika.com This e-mail address is being protected from spambots. You need JavaScript enabled to view it