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.

Online Jan 26-30, 2026 9:00 AM - 5:00 PM Mohammad Mehdi Lotfinejad
updated
intermediate
Oracle Database 19c: Administration Workshop
We price match

Public Pricing

MYR 8750

Corporate Pricing

Pax:

Training Fees: MYR 6500/day
Total Fees: MYR 32500 ++

Training Provider Pricing

Pax:

Training Fees: MYR 2800/day
Material Fees: MYR 600
Total Fees: MYR 14600 ++

Features

5 days
40 modules
2 intakes
Full life-time access
English
Technical: 25 pax

Target Audience

engineers
managers

Methodologies

lecture
slides
labs
q&A

Subsidies

HRDC Claimable logo

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
Module 1
Module 2
Short Break
15 mins
Module 3
Module 4
Recap and Q&A
15 mins
Lunch
1 hour
Module 5
Module 6
Short Break
15 mins
Module 7
Module 8
Recap and Q&A
15 mins
End of Day 1
Day 2 - Networking, Connection Management, and PDB Provisioning
Module 9
Module 10
Short Break
15 mins
Module 11
Module 12
Recap and Q&A
15 mins
Lunch
1 hour
Module 13
Module 14
Short Break
15 mins
Module 15
Module 16
Recap and Q&A
15 mins
End of Day 2
Day 3 - Advanced PDB Operations and Storage Management
Module 17
Module 18
Short Break
15 mins
Module 19
Module 20
Recap and Q&A
15 mins
Lunch
1 hour
Module 21
Module 22
Short Break
15 mins
Module 23
Module 24
Recap and Q&A
15 mins
End of Day 3
Day 4 - Security, User Management, and Data Movement
Module 25
Module 26
Short Break
15 mins
Module 27
Module 28
Recap and Q&A
15 mins
Lunch
1 hour
Module 29
Module 30
Short Break
15 mins
Module 31
Module 32
Recap and Q&A
15 mins
End of Day 4
Day 5 - Data Transport, Maintenance, Performance Monitoring, and Tuning
Module 33
Module 34
Short Break
15 mins
Module 35
Module 36
Recap and Q&A
15 mins
Lunch
1 hour
Module 37
Module 38
Short Break
15 mins
Module 39
Module 40
Recap and Q&A
15 mins
End of Day 5

Instructor

Loading...
Mohammad Mehdi Lotfinejad Chief Data Officer & Data Science Trainer
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
Mohammad Mehdi Lotfinejad is a distinguished Chief Data Officer and certified HRDF trainer with over 15 years of experience in computer science instruction and professional data science training. Currently serving as Chief Data and Knowledge Officer at Magna.ai, a Florida-based lawtech company, he leads the development of sophisticated graph databases, data warehouses, and API solutions that power AI-driven legal case analysis systems. His expertise spans the entire data ecosystem, from architecture design to workflow automation and team leadership. With a robust background encompassing more than a decade of hands-on experience in data engineering and data science, Mohammad has successfully implemented enterprise-scale data processing pipelines across multiple industries and geographies. His professional journey includes senior roles at Axiata Digital Advertising (ADA) in Malaysia, where he designed and deployed data pipelines using AWS Redshift, Snowflake, Apache Spark, and Apache Airflow, and at The Center of Applied Data Science, where he led teams delivering training solutions to major corporations including CIMB, PETRONAS, SHELL, and TNB. Mohammad's technical proficiency is comprehensive and current, encompassing cloud platforms (AWS, Google Cloud), data warehousing solutions (Redshift, Snowflake), big data technologies (Apache Spark, Hadoop, Hive), workflow orchestration (Apache Airflow), and multiple database systems (MySQL, PostgreSQL, MongoDB). He holds a Harvard Business School certification in Business Analytics and multiple AWS certifications, including specialized credentials in Big Data, Data Warehousing, and Practical Data Science with Amazon SageMaker. As an educator, Mohammad brings exceptional depth to his training delivery. His academic career includes faculty positions at Payame Noor University and Islamic Azad University, where he served in leadership roles including Chancellor and Department Head. He has authored three technical books and published numerous peer-reviewed papers in international journals. His teaching repertoire covers data engineering, data science, machine learning, software development, and computer architecture, delivered through engaging, hands-on methodologies that bridge theoretical concepts with practical industry applications. Mohammad's unique combination of executive leadership, technical expertise, and proven training capabilities makes him an invaluable resource for organizations seeking to develop their data science and engineering capabilities. His ability to translate complex technical concepts into actionable learning outcomes, coupled with his extensive real-world implementation experience, ensures that training participants gain immediately applicable skills that drive business value.
8 Students
96 Courses
18 Years

Instructor

Loading...
Dr. Esther Suria Kala ICT & Cybersecurity Training Expert
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
Dr. Esther Suria Kala is a highly accomplished ICT consultant and corporate trainer with nearly 30 years of extensive experience in information technology, project management, and organizational development. As the founder of Angel Software Solutions, she has established herself as a versatile and dedicated professional who delivers cutting-edge training solutions across Malaysia and internationally. Her academic credentials are exceptional, including a PhD in Psychology with a focus on Human Behaviour and Human Resources, an MBA in Finance, and degrees in both Computer Science and Human Resources. Currently pursuing a second PhD in IT Information Security, Dr. Esther demonstrates an unwavering commitment to continuous learning and staying at the forefront of technological advancement. Her educational foundation is complemented by an impressive array of professional certifications, including Microsoft Certified Trainer (MCT), CISSP, ITIL, SAP Certified Associate, Certified Cyber Security Professional, Data Scientist, AI Engineering, and ECBA certifications. Dr. Esther's technical expertise spans an extensive range of domains, from traditional programming languages like Java, C++, and PHP to modern technologies including Python, AI coding, machine learning, RPA, and IR 4.0 microservices. She is proficient in database management systems including Microsoft SQL Server and Oracle, web development frameworks, and enterprise solutions like SAP Crystal Reports and SharePoint Server. Her knowledge extends to cybersecurity, ethical hacking, network administration, and data analytics, making her uniquely qualified to address both technical and strategic business challenges. As a trainer, Dr. Esther excels in bridging the gap between technical complexity and practical application. She delivers comprehensive training programs for both IT and non-IT professionals, covering everything from software development and cloud computing to soft skills such as digital marketing, business analysis, customer service, and project management. Her ability to communicate effectively in both English and Bahasa Malaysia enables her to connect with diverse audiences across different organizational levels. Her impressive client portfolio includes leading organizations such as Maybank, Telekom Malaysia, Malaysian Airlines, Tenaga Nasional Berhad, Bank Negara, Ministry of Education, Ministry of Finance, and numerous multinational corporations. This extensive experience across banking, telecommunications, government, aviation, and technology sectors demonstrates her adaptability and deep understanding of varied industry requirements. Recognized with the Outstanding Achievement Award in Information Technology from University Malaya in 2013, Dr. Esther continues to empower organizations through innovative training solutions that drive digital transformation and professional excellence.
228 Courses
English, Malay, Hindi, German, Tamil
30 Years

Instructor Reviews

ML

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

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
Module 1
Module 2
Short Break
15 mins
Module 3
Module 4
Recap and Q&A
15 mins
Lunch
1 hour
Module 5
Module 6
Short Break
15 mins
Module 7
Module 8
Recap and Q&A
15 mins
End of Day 1
Day 2 - Networking, Connection Management, and PDB Provisioning
Module 9
Module 10
Short Break
15 mins
Module 11
Module 12
Recap and Q&A
15 mins
Lunch
1 hour
Module 13
Module 14
Short Break
15 mins
Module 15
Module 16
Recap and Q&A
15 mins
End of Day 2
Day 3 - Advanced PDB Operations and Storage Management
Module 17
Module 18
Short Break
15 mins
Module 19
Module 20
Recap and Q&A
15 mins
Lunch
1 hour
Module 21
Module 22
Short Break
15 mins
Module 23
Module 24
Recap and Q&A
15 mins
End of Day 3
Day 4 - Security, User Management, and Data Movement
Module 25
Module 26
Short Break
15 mins
Module 27
Module 28
Recap and Q&A
15 mins
Lunch
1 hour
Module 29
Module 30
Short Break
15 mins
Module 31
Module 32
Recap and Q&A
15 mins
End of Day 4
Day 5 - Data Transport, Maintenance, Performance Monitoring, and Tuning
Module 33
Module 34
Short Break
15 mins
Module 35
Module 36
Recap and Q&A
15 mins
Lunch
1 hour
Module 37
Module 38
Short Break
15 mins
Module 39
Module 40
Recap and Q&A
15 mins
End of Day 5

Instructor Reviews

Mohammad Mehdi Lotfinejad

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

We price match

Public Pricing

MYR 8750

Corporate Pricing

Pax:

Training Fees: MYR 6500/day
Total Fees: MYR 32500 ++

Training Provider Pricing

Pax:

Training Fees: MYR 2800/day
Material Fees: MYR 600
Total Fees: MYR 14600 ++

Features

5 days
40 modules
2 intakes
Full life-time access
English
Technical: 25 pax

Target Audience

engineers
managers

Methodologies

lecture
slides
labs
q&A

Subsidies

HRDC Claimable logo

Instructors

Loading...
Mohammad Mehdi Lotfinejad Chief Data Officer & Data Science Trainer
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
Mohammad Mehdi Lotfinejad is a distinguished Chief Data Officer and certified HRDF trainer with over 15 years of experience in computer science instruction and professional data science training. Currently serving as Chief Data and Knowledge Officer at Magna.ai, a Florida-based lawtech company, he leads the development of sophisticated graph databases, data warehouses, and API solutions that power AI-driven legal case analysis systems. His expertise spans the entire data ecosystem, from architecture design to workflow automation and team leadership. With a robust background encompassing more than a decade of hands-on experience in data engineering and data science, Mohammad has successfully implemented enterprise-scale data processing pipelines across multiple industries and geographies. His professional journey includes senior roles at Axiata Digital Advertising (ADA) in Malaysia, where he designed and deployed data pipelines using AWS Redshift, Snowflake, Apache Spark, and Apache Airflow, and at The Center of Applied Data Science, where he led teams delivering training solutions to major corporations including CIMB, PETRONAS, SHELL, and TNB. Mohammad's technical proficiency is comprehensive and current, encompassing cloud platforms (AWS, Google Cloud), data warehousing solutions (Redshift, Snowflake), big data technologies (Apache Spark, Hadoop, Hive), workflow orchestration (Apache Airflow), and multiple database systems (MySQL, PostgreSQL, MongoDB). He holds a Harvard Business School certification in Business Analytics and multiple AWS certifications, including specialized credentials in Big Data, Data Warehousing, and Practical Data Science with Amazon SageMaker. As an educator, Mohammad brings exceptional depth to his training delivery. His academic career includes faculty positions at Payame Noor University and Islamic Azad University, where he served in leadership roles including Chancellor and Department Head. He has authored three technical books and published numerous peer-reviewed papers in international journals. His teaching repertoire covers data engineering, data science, machine learning, software development, and computer architecture, delivered through engaging, hands-on methodologies that bridge theoretical concepts with practical industry applications. Mohammad's unique combination of executive leadership, technical expertise, and proven training capabilities makes him an invaluable resource for organizations seeking to develop their data science and engineering capabilities. His ability to translate complex technical concepts into actionable learning outcomes, coupled with his extensive real-world implementation experience, ensures that training participants gain immediately applicable skills that drive business value.
8 Students
96 Courses
18 Years
Loading...
Dr. Esther Suria Kala ICT & Cybersecurity Training Expert
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
Dr. Esther Suria Kala is a highly accomplished ICT consultant and corporate trainer with nearly 30 years of extensive experience in information technology, project management, and organizational development. As the founder of Angel Software Solutions, she has established herself as a versatile and dedicated professional who delivers cutting-edge training solutions across Malaysia and internationally. Her academic credentials are exceptional, including a PhD in Psychology with a focus on Human Behaviour and Human Resources, an MBA in Finance, and degrees in both Computer Science and Human Resources. Currently pursuing a second PhD in IT Information Security, Dr. Esther demonstrates an unwavering commitment to continuous learning and staying at the forefront of technological advancement. Her educational foundation is complemented by an impressive array of professional certifications, including Microsoft Certified Trainer (MCT), CISSP, ITIL, SAP Certified Associate, Certified Cyber Security Professional, Data Scientist, AI Engineering, and ECBA certifications. Dr. Esther's technical expertise spans an extensive range of domains, from traditional programming languages like Java, C++, and PHP to modern technologies including Python, AI coding, machine learning, RPA, and IR 4.0 microservices. She is proficient in database management systems including Microsoft SQL Server and Oracle, web development frameworks, and enterprise solutions like SAP Crystal Reports and SharePoint Server. Her knowledge extends to cybersecurity, ethical hacking, network administration, and data analytics, making her uniquely qualified to address both technical and strategic business challenges. As a trainer, Dr. Esther excels in bridging the gap between technical complexity and practical application. She delivers comprehensive training programs for both IT and non-IT professionals, covering everything from software development and cloud computing to soft skills such as digital marketing, business analysis, customer service, and project management. Her ability to communicate effectively in both English and Bahasa Malaysia enables her to connect with diverse audiences across different organizational levels. Her impressive client portfolio includes leading organizations such as Maybank, Telekom Malaysia, Malaysian Airlines, Tenaga Nasional Berhad, Bank Negara, Ministry of Education, Ministry of Finance, and numerous multinational corporations. This extensive experience across banking, telecommunications, government, aviation, and technology sectors demonstrates her adaptability and deep understanding of varied industry requirements. Recognized with the Outstanding Achievement Award in Information Technology from University Malaya in 2013, Dr. Esther continues to empower organizations through innovative training solutions that drive digital transformation and professional excellence.
228 Courses
English, Malay, Hindi, German, Tamil
30 Years

FAQ

Frequently Asked Questions About This Course

Close menu