Database Installation and Administration using Oracle Course
Gain the skills you need to advance your career. This course offers hands-on learning, expert guidance, and real-world applications designed to help you grow.
Course Overview
| Course Title | Database Installation and Administration using Oracle Course |
| Organization | Tech For Development (T4D) |
| Venue | Tech For Development (T4D) Training Center along Tala Road, Runda, Nairobi |
| Duration | 10 days |
| Target Industries |
|
| Target Job Roles |
|
| Course Fees (Face-to-Face) | USD 2,200/KES 150,000 (Exclusive of VAT) |
| Course Fees (Virtual) | |
| Training Modes | Virtual and face-to-face training |
| Payment | Payment should be made to the Tech For Development (T4D) bank account on or before the start of the course |
| Accreditation | Tech For Development Certificate of Course Completion |
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.
Who Should Attend
- Database administrators
- Software Developers
Course Objective
By the end of this course, you 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 recover databases
- Load and unload data
- Manage resources
- Proactively manage performance
- Use the SQL Tuning and Access Advisors
- Automate tasks with the Scheduler
Course Modules
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
- Statspack
Module 17: Automating Tasks with the Scheduler
- Scheduler Concepts
- Scheduler Jobs
- Scheduler Calendars
Course Administration
Methodology
Instructor-led sessions use a blended learning approach combining presentations, guided practical exercises, web-based tutorials, and group work, delivered by seasoned industry experts. All facilitation and course materials are in English, so participants should be reasonably proficient in the language.
Accreditation
Upon successful completion of this training, participants will be issued a Tech For Development Certificate of Course Completion certified by the National Industrial Training Authority (NITA).
Training Venue
The training will be held at the Tech For Development Training Centre. The course fee covers the course tuition, training materials, two break refreshments, and lunch. All participants will additionally cater to their travel expenses, visa application, insurance, and other personal expenses.
Accommodation & Airport Transfer
Arranged upon request.For reservations contact the Training Officer:
Email: [email protected]
Phone: (+254) 790 824 179
Tailor-Made
This training can also be customized to suit the needs of your institution upon request. You can have it delivered in our T4D Training Centre or at a convenient location.
Payment
Payment should be transferred to the T4D account through a bank on or before the start of the course. Send proof of payment to [email protected].
Related Courses
Course Reviews
Based on 0 participant feedback
No reviews yet for this course. Be the first to share your experience!
Write a Course Review
Please share your honest feedback below.