Oracle Linux 9: Intermediate to Advanced Training Course
Oracle Linux 9 is an enterprise-grade operating system designed for performance, security, and cloud integration.
This instructor-led, live training (online or onsite) is aimed at intermediate-level to advanced-level system administrators and IT professionals who wish to deepen their expertise in Oracle Linux 9 for system administration, performance tuning, security hardening, and automation.
By the end of this training, participants will be able to:
- Manage and optimize Oracle Linux 9 for enterprise environments.
- Implement advanced networking and security configurations.
- Automate system administration tasks using scripting.
- Monitor and troubleshoot performance issues effectively.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
Course Outline
Advanced System Administration
- Managing system processes and services
- Advanced user and group management
- Configuring system logging and auditing
Networking and Security
- Advanced network configuration and troubleshooting
- Firewall and SELinux policies
- Implementing secure SSH and VPN
Storage and File System Management
- Logical Volume Manager (LVM) and RAID
- Advanced disk partitioning and file system tuning
- Automating storage management
Performance Optimization and Monitoring
- System resource monitoring tools
- Tuning kernel parameters for performance
- Diagnosing and resolving bottlenecks
Automation and Scripting
- Automating tasks with Bash and Python scripting
- Using Ansible for configuration management
- Automating system updates and patches
High Availability and Virtualization
- Setting up high availability clusters
- Oracle Linux Virtualization Manager
- Deploying and managing containers with Podman
Troubleshooting and Best Practices
- Common system administration pitfalls
- Disaster recovery and backup strategies
- Best practices for enterprise deployments
Summary and Next Steps
Requirements
- Basic knowledge of Linux command line
- Familiarity with Oracle Linux 9 fundamentals
Audience
- System Administrators
- IT Professionals
- DevOps Engineers
- Cloud and Infrastructure Engineers
Open Training Courses require 5+ participants.
Oracle Linux 9: Intermediate to Advanced Training Course - Booking
Oracle Linux 9: Intermediate to Advanced Training Course - Enquiry
Testimonials (5)
I liked very much the format of the training, hands on, directly in sql developer.
Andreea - OPEN COURSE
Course - Oracle Database 19c PL and Advanced SQL
The exercises were explained very good.
Monica - DB Global Technology
Course - PL/SQL in Oracle 19c
overall a good training that responds to my needs. I received also information about Oracle VM VirtualBox allowing me to continue the practice on my own.
Liviu
Course - Oracle SQL LP - Fundamentals
I learned complex functions and how to apply them
Ana Alexandrescu - DB Global Technology
Course - Oracle SQL Advanced
It was quite hands-on, not too much theory.
David Lambaerts - Estee Lauder BV
Course - ORACLE PL/SQL Fundamentals
Upcoming Courses
Related Courses
Oracle SQL Language
14 HoursThe course answers questions
How to build a query?
What possibilities have SQL?
What is a relational database?
What is the structure and SQL commands
ORACLE PL/SQL Fundamentals
21 HoursThis 3 day course gives an introduction to ORACLE PL/SQL, an application development environment that enables the writing of stored procedures, functions and triggers using both SQL and PL/SQL commands.
The course takes the format of a workshop, with a mix of lecture, working examples and practical exercises. Although the content may be customised, at least 2 days are needed to cover the core elements.
Full course notes are provided along with sample database files, example SQL files and free software tools for use in accessing an ORACLE database.
Oracle Database 19c PL and Advanced SQL
28 HoursThis instructor-led, live training in Bulgaria (online or onsite) is aimed at intermediate-level database administrators who wish to have an in-depth understanding of Oracle Database 19c PL/SQL programming and advanced SQL techniques.
By the end of this training, participants will be able to:
- Understand the fundamentals and advanced features of PL/SQL.
- Develop advanced SQL queries to retrieve and manipulate data efficiently.
- Implement PL/SQL programming constructs to manage data and database operations.
- Optimize SQL queries for better performance.
- Use advanced PL/SQL features like collections, bulk processing, and error handling.
- Learn to debug and manage PL/SQL programs effectively.
Oracle: Programming with PL/SQL I
28 HoursThis instructor-led, live training in Bulgaria (online or onsite) is aimed at beginner-level developers and database administrators who wish to learn PL/SQL to automate database tasks, implement business logic, and develop robust database applications.
By the end of this training, participants will be able to:
- Develop efficient PL/SQL programs to automate database operations and integrate SQL commands effectively.
- Create reusable program units, including procedures, functions, packages, and triggers, for modular and scalable applications.
- Implement advanced data structures like associative arrays and manage query results using cursors.
- Handle errors robustly and secure code with encryption, obfuscation, and conditional compilation techniques.
- Apply PL/SQL in real-world scenarios, leveraging built-in packages for file handling, email automation, and other advanced functionalities.
Oracle: Programming with PL/SQL II
21 HoursThis instructor-led, live training in Bulgaria (online or onsite) is aimed at advanced-level developers and database administrators who wish to use PL/SQL to develop high-performing, secure, and scalable database solutions while leveraging advanced programming techniques and integrations.
By the end of this training, participants will be able to:
- Work with complex data types, collections, and bulk operations for efficient data management.
- Develop object types, table functions, and custom aggregates to enhance database functionality.
- Apply performance tuning techniques, use native compilation, and safeguard against SQL injection.
- Implement application contexts, VPD, and secure program units for robust database solutions.
Oracle SQL for Administrators
21 HoursThis instructor-led, live training in Bulgaria (online or onsite) is aimed at beginner-level database administrators and developers who wish to learn SQL to efficiently manage, query, and manipulate data in Oracle databases for administrative and operational tasks.
By the end of this training, participants will be able to:
- Understand Oracle database architecture, including schemas, users, and sessions.
- Write and optimize SQL queries for data retrieval, filtering, and manipulation.
- Use joins, subqueries, and set operators to work with multiple tables and complex queries.
- Perform data aggregation, grouping, and analysis using SQL functions.
- Manage schema objects like views, sequences, and indexes to enhance database operations.
Oracle SQL for Developers
35 HoursThis instructor-led, live training in Bulgaria (online or onsite) is aimed at intermediate-level developers and database administrators who wish to use Oracle SQL to design, manage, and optimize database applications and automate tasks efficiently.
By the end of this training, participants will be able to:
- Understand Oracle database architecture and manage users, schemas, and permissions.
- Write optimized SQL queries for data retrieval, manipulation, and analysis.
- Use advanced SQL techniques, including joins, subqueries, and hierarchical queries.
- Design and manage database objects like tables, indexes, views, and sequences.
Oracle SQL Advanced
14 HoursListeners
This course is designed for people who want to use the advanced features of SQL in Oracle
The course answers the questions
- How to build advanced queries?
- How to create advanced reports?
Oracle SQL for beginners
21 HoursListeners
This training is addressed for people starting to work with the SQL language in Oracle database
The course answer for questions:
- How to build a query?
- What possibilities have SQL?
- What is a relational database?
- What is the structure and SQL commands
Oracle SQL for Development and Database Management
35 HoursThis instructor-led, live training in Bulgaria (online or onsite) is aimed at intermediate-level database professionals who wish to enhance their skills in Oracle SQL development and administration.
By the end of this training, participants will be able to:
- Build and optimize complex SQL queries.
- Manage databases efficiently using Oracle SQL tools.
- Apply best practices in database development and maintenance.
- Administer user access and database security in an Oracle environment.
Oracle SQL LP - Fundamentals
14 HoursThe Oracle SQL Fundamentals training course is a comprehensive program designed to equip participants with essential skills and knowledge in Structured Query Language (SQL) using Oracle Database.
By the end of this training, participants will be able to:
- Gain proficiency in writing SQL queries to retrieve and manipulate data in Oracle databases.
- Acquire essential skills in joining tables and handling complex data relationships.
- Understand how to use functions effectively for data manipulation and calculation.
- Master the art of writing efficient sub-queries to perform advanced data filtering and processing
- Gain confidence to work with Oracle SQL in real-world scenarios, enhancing their career prospects in database management and development.
Oracle SQL Intermediate - Data Extraction
14 HoursThe objective of the course is to enable participants to gain a mastery of how to work with the SQL language in Oracle database for data extraction at intermediate level.
Oracle SQL LP - Intermediate
14 HoursThe Oracle SQL Intermediate Course is designed to bridge the gap between fundamental SQL concepts and advanced techniques, providing participants with a comprehensive understanding of intermediate-level SQL operations using Oracle Database. Through hands-on exercises and practical examples, participants will delve into various topics, including table joins, summary functions, hierarchical queries, set operators, analytic functions, execution plans, and indexes.
By the end of this training, participants will be able to:
- Gain proficiency in intermediate-level SQL operations necessary for querying and manipulating data in Oracle Database environments.
- Develop a deep understanding of table joins, summary functions, hierarchical queries, set operators, and analytic functions.
- Learn advanced techniques for optimizing SQL queries and improving database performance.
- Enhance problem-solving skills through hands-on exercises and real-world SQL scenarios.
- Gain confidence to tackle complex SQL challenges and advance their career in database management and development.
Oracle SQL Intermediate
14 HoursAudience
All who want to improve their basic skills in Oracle SQL and also systematize already gained knowledge.
Format of the course
25% lectures, 75% labs
PL/SQL in Oracle 19c
21 HoursThis instructor-led, live training in Bulgaria (online or onsite) is aimed at intermediate-level developers and administrators who wish to have a solid PL/SQL programming foundation to develop efficient and robust database applications using Oracle 19c.
By the end of this training, participants will be able to:
- Gain a comprehensive understanding of what PL/SQL is and its advantages over standard SQL.
- Learn how to declare and use variables and different data types within PL/SQL blocks.
- Apply control structures like IF-THEN-ELSE, CASE statements, and loops to create robust PL/SQL programs.
- Understand and implement explicit and implicit cursors for data retrieval.
- Handle exceptions effectively using predefined and user-defined exceptions.
- Develop and manage triggers to automate and enforce business rules.
- Create and use PL/SQL packages to encapsulate and modularize code for reuse and maintainability.