Oracle Database 19c: Administration Workshop
Master Oracle Database 19c administration with expert-led training covering multitenant architecture, security, performance tuning, and data management. Gain hands-on experience in database provisioning, storage optimization, and advanced troubleshooting techniques essential for modern database administrators.
- Available in:
- Malaysia
- Upcoming intakes:
- Jan 26, 2026
- Jan 26, 2026
Corporate Pricing
Pax:
Training Provider Pricing
Pax:
Features
Target Audience
Methodologies
Subsidies

What you'll learn
- Configure and manage Oracle Multitenant Container and Pluggable Databases effectively
- Administer Oracle Net Services and configure advanced connection architectures
- Configure memory management and understand background process architecture
- Optimize database performance using Automatic Workload Repository and tuning tools
- Execute data movement operations using Data Pump, SQL*Loader, and transport methods
- Monitor database instances and resolve performance issues using diagnostic tools
- Manage storage structures including tablespaces, segments, and compression features
- Implement comprehensive security through user management, privileges, and auditing
Why should you attend?
This comprehensive Oracle Database 19c administration workshop provides in-depth training on managing and maintaining Oracle Database environments with a strong focus on the multitenant architecture. Participants will master essential database administration tasks including installation, configuration, security implementation, and performance optimization. The course covers critical topics such as Oracle Multitenant Container Database architecture, Pluggable Database provisioning and management, and advanced storage administration techniques. The training emphasizes hands-on experience with Oracle Enterprise Manager, Database Configuration Assistant, SQL*Plus, and other essential database tools. Participants will learn to configure Oracle Net Services, manage database instances, implement security through user accounts and privileges, and utilize auditing capabilities for compliance. The curriculum includes extensive coverage of data movement techniques using Oracle Data Pump and SQL*Loader, along with strategies for transporting data across platforms. Advanced topics include memory and process management, Automatic Workload Repository analysis, performance monitoring using Automatic Database Diagnostic Monitor, and SQL tuning methodologies. Throughout the workshop, participants will engage in practical exercises that reinforce theoretical concepts, including creating and managing Pluggable Databases, configuring shared server architecture, implementing compression strategies, and optimizing database performance. The course prepares database administrators to handle real-world scenarios with confidence and expertise in Oracle Database 19c environments.
Course Syllabus
Day 1 - Database Architecture, Tools, and Database Creation
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 1
Day 2 - Networking, Connection Management, and PDB Provisioning
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 2
Day 3 - Advanced PDB Operations and Storage Management
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 3
Day 4 - Security, User Management, and Data Movement
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 4
Day 5 - Data Transport, Maintenance, Performance Monitoring, and Tuning
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 5
Ratings and Reviews
Instructor
Instructor
Instructor Reviews
Mohammad Mehdi Lotfinejad
Chief Data Officer & Data Science Trainer"Mehdi and I worked on several projects with company such as Petronas , Shell and CIMB Regional ETC. I must say Mehdi's training was highly appreciated by our clients as he was able to exhibit in full display his vast knowledge as a Data professional. I would highly recommend him to anyone looking for a top tier training expert."
"Not only knowledgeable but also having hands dirty on what he knows Friendly and building networks quickly."
"I had the pleasure of working with Mehdi together on some high-level initiatives such as the Petronas data scientist program and Shell's project to become a data-driven organization. During these projects, Mehdi received numerous accolades for his ability to share his knowledge and mentor up-and-coming data scientists. Based on our shared experiences, I have no hesitation in recommending Mehdi for any project or position he may be considered for."
FAQ
Frequently Asked Questions About This Course
- Public pricing: applies for individuals signing up from different companies.
- Corporate pricing: applies if a company wants to have an intake for its employees only.
- Training provider pricing: applies only for other training providers looking to hire our trainers and use our content. Our content has a licensing fee.
We will keep you updated on the status of the intake after you enroll.
Courses you may like
Why should you attend?
This comprehensive Oracle Database 19c administration workshop provides in-depth training on managing and maintaining Oracle Database environments with a strong focus on the multitenant architecture. Participants will master essential database administration tasks including installation, configuration, security implementation, and performance optimization. The course covers critical topics such as Oracle Multitenant Container Database architecture, Pluggable Database provisioning and management, and advanced storage administration techniques. The training emphasizes hands-on experience with Oracle Enterprise Manager, Database Configuration Assistant, SQL*Plus, and other essential database tools. Participants will learn to configure Oracle Net Services, manage database instances, implement security through user accounts and privileges, and utilize auditing capabilities for compliance. The curriculum includes extensive coverage of data movement techniques using Oracle Data Pump and SQL*Loader, along with strategies for transporting data across platforms. Advanced topics include memory and process management, Automatic Workload Repository analysis, performance monitoring using Automatic Database Diagnostic Monitor, and SQL tuning methodologies. Throughout the workshop, participants will engage in practical exercises that reinforce theoretical concepts, including creating and managing Pluggable Databases, configuring shared server architecture, implementing compression strategies, and optimizing database performance. The course prepares database administrators to handle real-world scenarios with confidence and expertise in Oracle Database 19c environments.
What you'll learn
- Configure and manage Oracle Multitenant Container and Pluggable Databases effectively
- Administer Oracle Net Services and configure advanced connection architectures
- Configure memory management and understand background process architecture
- Optimize database performance using Automatic Workload Repository and tuning tools
- Execute data movement operations using Data Pump, SQL*Loader, and transport methods
- Monitor database instances and resolve performance issues using diagnostic tools
- Manage storage structures including tablespaces, segments, and compression features
- Implement comprehensive security through user management, privileges, and auditing
Course Syllabus
Day 1 - Database Architecture, Tools, and Database Creation
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 1
Day 2 - Networking, Connection Management, and PDB Provisioning
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 2
Day 3 - Advanced PDB Operations and Storage Management
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 3
Day 4 - Security, User Management, and Data Movement
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 4
Day 5 - Data Transport, Maintenance, Performance Monitoring, and Tuning
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 5
Instructor Reviews
Mohammad Mehdi Lotfinejad
Chief Data Officer & Data Science Trainer"Mehdi and I worked on several projects with company such as Petronas , Shell and CIMB Regional ETC. I must say Mehdi's training was highly appreciated by our clients as he was able to exhibit in full display his vast knowledge as a Data professional. I would highly recommend him to anyone looking for a top tier training expert."
"Not only knowledgeable but also having hands dirty on what he knows Friendly and building networks quickly."
"I had the pleasure of working with Mehdi together on some high-level initiatives such as the Petronas data scientist program and Shell's project to become a data-driven organization. During these projects, Mehdi received numerous accolades for his ability to share his knowledge and mentor up-and-coming data scientists. Based on our shared experiences, I have no hesitation in recommending Mehdi for any project or position he may be considered for."
Corporate Pricing
Pax:
Training Provider Pricing
Pax:
Features
Target Audience
Methodologies
Subsidies

Ratings and Reviews
Instructors
Courses you may like
FAQ
Frequently Asked Questions About This Course
- Public pricing: applies for individuals signing up from different companies.
- Corporate pricing: applies if a company wants to have an intake for its employees only.
- Training provider pricing: applies only for other training providers looking to hire our trainers and use our content. Our content has a licensing fee.
We will keep you updated on the status of the intake after you enroll.
Our Offers
Academy for Trainers Academy for Trainers
Teach what you love. Abundent Academy gives you the tools you need to run your own trainings! We provide you with the platform, the students, the materials, and the support you need to succeed!
- Higher trainer payouts
- Ready-made course materials
- Student management system
- AI digital marketing assistant
Academy for Corporates Academy for Corporates
Get unlimited access to all of Abundent Academy's carefully curated courses for your team, all organized according to learning paths and roles! Perfect for companies looking to upskill their workforce and stay ahead in the tech industry.
- Carefully curated courses
- Role-based learning paths
- Team progress tracking
- Gap Identification and Analysis
Academy for Partners Academy for Partners
White-label IT training delivery for training providers. We become your behind-the-scenes delivery arm so you can say yes to more clients without hiring more trainers.
- Expand your training catalog
- 40+ expert trainers ready
- White-label delivery
- You keep client relationships