Tag Archives: Backup and Recovery Concepts

TRAINING 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

  • Group Discussions
  • Group & Individual Exercises
  • Presentations
  • Games
  • Case Studies
  • Role Plays
  • Self-Assessment
  • Action Plan

FACILITIES

  • Certificate,
  • Quality Training Kit (Pencil case: Erase, Bolpoint, Pencil, Tipe X, Stabillo, Flash Disk 8 GB),
  • Bag.
  • Training Material (HandOut & SoftCopy)
  • Convenient training facilities in stars hotel (Public Training)
  • Lunch and Coffee Breaks (Public Training)
  • Souvenir

Permintaan Brosur penawaran Training ( Harga, Waktu dan Tempat) silahkan Menghubungi kami.

Catatan :

  • Pelatihan ini dapat di-customized sesuai kebutuhan perusahaan Anda bila diselenggarakan dalam bentuk In-House Training. Untuk permintaan In-House Trainingdengan jenis topik lainya, silahkan mengirimkan ke alamat email yang tercantum di web kami.
  • Request Training. Jika anda membutuhkan informasi pelatihan yang belum tercantum pada website ini, atau anda ingin memberikan usulan materi yang sesuai dengan tingkat kebutuhan perusahaan anda, silahkan mengirimkan ke alamat emailyang tercantum.
  • Bila tidak ada tanggal dan waktu atau yang tercantum sudah kadaluarsa didalam artikel mohon tanyakan kepada kami untuk jadwal terbarunya.
  • Peserta bisa mengajukan Tanggal Pelatihan / Training selain yang tertera pada silabus penawaran.

Training Database Administration Using Oracle Database 10g

Training Database Administration Using Oracle Database 10g

Jadwal Training 2016  (Bisa request tanggal selain yang tertera)

19-21 Januari 2016 / 09-11 Februari 2016 / 15-17 Maret 2016 / 05-07 April 2016 / 10-12 Mei 2016 / 07-09 Juni 2016 / 12-14 Juli 2016 / 09-11 Agustus 2016 / 06-08 September 2016 / 11-13 Oktober 2016 / 15-17 November 2016 / 13-15 Desember 2016

Jadwal Training 2017  (Bisa request tanggal selain yang tertera)

17-19 Januari 2017 / 07-09 Februari 2016 / 21-23 Maret 2017 / 11-13 April 2017 / 09-11 Mei 2017 / 06-08 Juni 2017 / 04-06 Juli 2017 / 01-03 Agustus 2017 / 05-07 September 2017 / 17-19 Oktober 2017 / 06-08 November 2017 / 05-07 Desember 2017

Lokasi Training Pilihan : di Yogyakarta, Jakarta, Bandung, Bogor, Surabaya, Malang, Bali, Lombok, Balikpapan, Makassar, Medan, Batam, Riau, Pontianak, Semarang, Solo, Manado, dan Kota-kota lainnya (dengan harga dan minimal kuota yang berbeda)

Training Database Administration Using Oracle Database 10g

Pelatihan ini diperuntukkan bagi kalangan pofesional IT, khususnya bagi yang concern terhadap penggunaan oracle sebagai basis datanya. Oracle database 10g, adalah pengembangan dari versi sebelumnya yang lebih memberikan layanan security dan internet platform disamping beberapa penyempurnaan dari versi sebelumnya. Dalam pelatihan ini, peserta akan dikenalkan dengan DBMS Oracle Database 10g dan administrasi serta beberapa langkah untuk migrasi dari versi sebelumnya.

MATERI

  • Course Syllabus
  • Introduction (Database Architecture)
  • Installing the Oracle Database Software
  • Creating an Oracle Database
  • Managing the Oracle Instance
  • Managing Database Storage Structures
  • Administering User Security
  • Managing Schema Objects
  • Managing Data and Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Security
  • Configuring the Oracle Network Environment
  • Proactive Maintenance Performance Management
  • Backup and Recovery Concepts
  • Performing Database Backups
  • Performing Database Recovery
  • Performing Flashback
  • Moving Data
  • Case Studies

METODE

Kegiatan pelatihan dirancang agar peserta dapat memahami secara komprehensif materi yang disampaikan, sehingga dapat dimplementasikan secara aplikatif dalam dunia kerja. Adapun metode yang digunakan adalah:
1. Presentation
2. Discuss
3. Case Study
4. Evaluation

PESERTA

Pelatihan ini sangat relevan diikuti oleh : Database Administrators, Database, Designers, Project Manager, Sales Consultants, Support Engineer, Technical Consultant

Investasi dan Fasilitas Training

  • Harga : (dilampirkan dalam Brosur penawaran)
  • Fasilitas : Certificate, Training kits, USB 8 GB, Lunch, Coffe Break, Souvenir, City Tour
  • Untuk peserta luar kota disediakan transportasi antar-jemput dari Bandara/Stasiun ke Hotel (berlaku bagi perusahaan yang mengirimkan minimal 2 peserta)
  • Quota minimum Running 2 peserta ( jogja ), 3 Peserta ( Solo, Semarang) Quota minimum Running 3 peserta (Jakarta , Bandung dan Surabaya ) –  ( Untuk Manado, Bali , Batam, Pontianak, Balikpapan dan Lombok Quota minimal 4 peserta)

 

Permintaan Brosur penawaran Training ( Waktu dan Tempat) silahkan Menghubungi kami via :

Mobile : 0823 2326 5005 – 0857 2459 5005

Email : trainingcenterindo@gmail.com / info@jadwaltraining.co.id

Web: www.informasitraining-indonesia.com

Web www.jadwaltraining.co.id

DATABASE ADMINISTRATION USING ORACLE DATABASE 10g

DESKRIPSI

Pelatihan ini diperuntukkan bagi kalangan pofesional IT, khususnya bagi yang concern terhadap penggunaan oracle sebagai basis datanya. Oracle database 10g, adalah pengembangan dari versi sebelumnya yang lebih memberikan layanan security dan internet platform disamping beberapa penyempurnaan dari versi sebelumnya. Dalam pelatihan ini, peserta akan dikenalkan dengan DBMS Oracle Database 10g dan administrasi serta beberapa langkah untuk migrasi dari versi sebelumnya.

MATERI

• Course Syllabus
• Introduction (Database Architecture)
• Installing the Oracle Database Software
• Creating an Oracle Database
• Managing the Oracle Instance
• Managing Database Storage Structures
• Administering User Security
• Managing Schema Objects
• Managing Data and Concurrency
• Managing Undo Data
• Implementing Oracle Database Security
• Configuring the Oracle Network Environment
• Proactive Maintenance
• Performance Management
• Backup and Recovery Concepts
• Performing Database Backups
• Performing Database Recovery
• Performing Flashback
• Moving Data
• Case Studies

Investasi dan Fasilitas Training

  • Harga : (dilampirkan dalam Brosur penawaran)
  • Fasilitas : Certificate, Training kits, USB 8 GB, Lunch, Coffe Break, Souvenir, City Tour
  • Untuk peserta luar kota disediakan transportasi antar-jemput dari Bandara/Stasiun ke Hotel (berlaku bagi perusahaan yang mengirimkan minimal 2 peserta)
  • Quota minimum Running 2 peserta (jogja, Solo, Semarang) Quota minimum Running 3 peserta (Jakarta , Bandung dan Surabaya ) –  ( Untuk Manado, Bali , Batam, Pontianak, Balikpapan dan Lombok Quota minimal 4 peserta)

 

Permintaan Brosur penawaran Training ( Waktu dan Tempat) silahkan Menghubungi kami via :

Mobile : 0823 2326 5005 – 0857 2459 5005

Email : trainingcenterindo@gmail.com / info@jadwaltraining.co.id

Blog : https://informasitrainingdanseminar.wordpress.com

Web: www.informasitraining-indonesia.com

Web www.jadwaltraining.co.id

Jadwal training 2015 | Jadwal training 2016 | Jadwal training 2017 | Jadwal training 2018 | Jadwal training 2019 | Jadwal training 2020
Lokasi Training Pilihan : di Yogyakarta, Jakarta, Bandung, Bogor, Surabaya, Malang, Bali, Lombok, Balikpapan, Makassar, Medan, Batam, Riau, Pontianak, Semarang, Solo, Manado. (dengan harga dan minimal kuota yang berbeda)