In today's data-driven world, organizations rely heavily on databases to store, manage, and retrieve critical information. Oracle Database, a leading enterprise database management system (DBMS), plays a pivotal role in enabling businesses to make informed decisions, optimize operations, and gain a competitive edge. This comprehensive course, Database Installation and Administration using Oracle, is designed to equip you with the essential knowledge and skills to install, configure, and administer Oracle Database effectively. It will provide you with hands-on experience and practical insights. You will gain a thorough understanding of the Oracle Database architecture, including its key components and functionalities.

Duration           10 days.

Target Audience

• Database administrators
• Software Developers

Objectives

At the end of the course, the participants will be able to:

• Install and configure Oracle Database 12c.
• Create and manage databases.
• Configure and manage Oracle Network Environment (ONE)
• Monitor and manage memory.
• Manage storage.
• Manage space.
• Manage undo data.
• Manage data concurrency.
• Manage privileges.
• Audit database activity.
• Configure Recovery Manager (RMAN) to backup and recovery databases.
• Load and unload data.
• Manage resources.
• Proactively manage performance.
• Use the SQL Tuning and Access Advisors
• Automate tasks with the Scheduler.

Course Outline

Module 1: Introduction To Oracle Database

• Overview of Oracle Database
• Oracle Database Architecture
• Oracle Instance
• Oracle Network Environment (ONE)
• Installing Oracle Database

Module 2: Creating and Managing Databases

• Creating a Database
• Database Configuration Parameters
• Managing Database Users

Module 3: Oracle Database Objects

• Understanding tables, views, and indexes
• Data types and constraints
• Managing data with SQL commands
• Introduction to PL/SQL programming language

Module 4: Configuring and Managing Oracle Network Environment (ONE)

• Net Services Configuration
• Listener Configuration
• Database Configuration

Module 5: Monitoring and Managing Memory

• Memory Management Concepts
• SGA and PGA
• Monitoring Memory Usage

Module 6: Managing Storage

• Storage Management Concepts
• Tablespaces
• Datafiles

Module 7: Managing Space

• Space Management Concepts
• Segment Space Management
• Free Space Management

Module 8: Managing Undo Data

• Undo Data Management Concepts
• Undo Segments
• Undo Retention

Module 9: Managing Data Concurrency

• Data Concurrency Concepts
• Locks
• Transactions

Module 10: Managing Privileges

• Privilege System Concepts
• System Privileges
• User Privileges

Module 11: Auditing Database Activity

• Auditing Concepts
• Audit Trails
• Audit Policies

Module 12: Configuring Recovery Manager (RMAN)

• RMAN Concepts
• RMAN Backups
• RMAN Restoration

Module 13: Loading And Unloading Data

• Data Loading Techniques
• Data Unloading Techniques
• Data Transformation

Module 14: Managing Resources

• Resource Management Concepts
• Resource Governor
• Automatic Workload Repository (AWR)

Module 15: Proactively Managing Performance

• Performance Management Concepts
• Performance Tuning
• Capacity Planning

Module 16: Using The SQL Tuning and Access Advisors

• SQL Tuning Advisor
• SQL Access Advisor
• Stats pack

Module 17: Automating Tasks with the Scheduler

• Scheduler Concepts
• Scheduler Jobs
• Scheduler Calendars

Certification

• Upon successful completion of this training, participants will be issued with Macskills Training and Development Institute Certificate

Training Venue

• Training will be held at Macskills Training Centre. We also tailor make the training upon request at different locations across the world.

Airport Pick Up and Accommodation

• Airport pick up and accommodation is arranged upon request.

Terms Of Payment

• Payment should be made to Macskills Development Institute bank account before the start of the training and receipts sent.