The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner.
-
In the Oracle Database Security: Preventive Controls course, students learn how they can use Oracle Database Security products and technologies to meet the security, privacy and compliance requirements of their organization.
The current regulatory environment of the Sarbanes-Oxley Act, HIPAA, the UK Data Protection Act, and others, requires better security at the database level. Students learn how to secure the access to their databases and how to use the Oracle Database Security products and technologies that enhance data access and confidentiality. The course provides suggested Oracle solutions for common problems.
Learn To:
- Choose Oracle Database Security products and technologies to meet security requirements.
- Secure the database access by database or enterprise users with basic or strong authentication such as SSL, Kerberos and Radius.
- Protect against database bypass by using Transparent Database Encryption.
- Use Oracle Wallets and Oracle Key Vault to manage encryption keys.
- Discover sensitive columns such as Credit Card Numbers by using Application Data Modeling.
- Minimize sensitive data proliferation to test/dev environments by using Data Masking.
- Minimize storage costs in test/dev environments by using Data Subsetting.
- Reduce sensitive data exposure in applications by using Data Redaction.
- Understand and use Oracle Database Vault.
-
This Oracle Database 12c: Analytic SQL for Data Warehousing training teaches you how to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data and exclude branches from the tree structure. You’ll also learn to use regular expressions and sub-expressions to search for, match, and replace strings. In this course, you will be introduced to Oracle Business Intelligence Cloud Service.
Learn To:
- Use SQL with aggregation operators, SQL for Analysis and Reporting functions.
- Group and aggregate data using the ROLLUP and CUBE operators, the GROUPING function, Composite Columns and the concatenated Groupings.
- Analyze and report data using Ranking functions, the LAG/LEAD Functions and the PIVOT and UNPIVOT clauses.
- Perform advanced pattern matching.
- Use regular expressions to search for, match and replace strings.
- Gain an understanding of the Oracle Business Intelligence Cloud Service.
-
Throughout the lessons of the Oracle Database 12c R2: New Features for Administrators Part 2 course constituted by five modules; the Securing Data module, the Making Data Available module, the Partitioning Data module, the Managing Information Lifecycle module and the Monitoring DB Operations and Managing Performance module, students receive a good knowledge of the Oracle Database 12c Release 2 new and enhanced features in different areas of database administration like Unified Auditing, Transparent Data Encryption (TDE) and other areas of security, Recovery Manager, online operations, Oracle Data Pump, SQL*Loader, new partitioning methods, Automatic Data Optimization, In-Memory Column Store, Full Database In-Memory Caching, and Automatic Big Table Caching.
Learn To:
Gain an understanding of the new and enhanced features of Oracle Database 12c Release 2 (12.2.0.1) amongst different areas such as security, availability, partitioning, performance, and Information Lifecycle Management (ILM).
-
This Oracle Database 12c: Implement Partitioning training teaches you how to manage partitioning using Oracle Database 12c. Expert Oracle University instructors will demonstrate the benefits of partitioning for different types of workloads and learn the syntax for partitioning maintenance operations. In this course, you will be introduced to Oracle Database Cloud Service.
Learn To:
- Apply partitioning strategies to enhance application performance.
- Use partitioning techniques to reduce impact of table and index maintenance.
- Use partitioning to decrease the time to refresh materialized views.
- Partition lob segments, nested tables and object tables.
- Understand the Oracle Partitioning methods for tables, index and materialized views available in Oracle Database 12c Release 1.
- Gain an understanding of the Oracle Database Cloud Service.
-
This Oracle Database 12c: RAC Administration training will teach you about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion. In this course, you will be introduced to Oracle Database Exadata Cloud Service.
Learn To:
- Install Oracle RAC software.
- Create cluster databases.
- Administer both administrator and policy-managed Oracle RAC databases.
- Monitor and address performance issues.
- Learn about services in a RAC environment as well as highly available connection features including Application Continuity and Transaction Guard.
- Create and administer a RAC One Node Database.
- Create and manage multitennant RAC databases.
- Gain an understanding of the Oracle Database Exadata Cloud Service.
-
This OAE-W1: Oracle Application Express Workshop I training teaches you how to quickly and efficiently develop database-centric web applications using Oracle Application Express. Explore implementing security in your applications, managing application navigation, basic validation and debugging techniques used while developing an application in Oracle Application Express.
Learn To:
- Create database applications for both desktop and mobile interfaces.
- Add various components like new pages, reports regions, items and other components required to enhance an application.
- Create processes, validations, computations and dynamic actions within an application.
- Change the look and feel of your web applications using built-in themes and templates.
- Create and use shared components for an application.
- Understand managing and using session state variables.
- Implement security in an application.
- Manage application navigation using shared components.
- Improvise your application by creating calendars, charts and trees.
- Extend your application by adding advanced features like printing, BLOB object, data loading, site and more.
- Enable feedback mechanisms from the application and tracking the feedback from Oracle APEX.
-
In the Oracle Database 12c: Performance Management and Tuning course, learn about the performance analysis and tuning tasks expected of a DBA: proactive management through built-in performance analysis features and tools, diagnosis and tuning of the Oracle Database instance components, and diagnosis and tuning of SQL-related performance issues. In this course, you will be introduced to Oracle Database Cloud Service.
Learn To:
- Use the Oracle tuning methodology.
- Use Oracle-supplied tools for monitoring and diagnosing SQL and instance performance issues.
- Use database advisors to proactively correct performance problems.
- Identify and tune problem SQL statements.
- Monitor instance performance by using Enterprise Manager.
- Tune instance components.
- Gain an understanding of the Oracle Database Cloud Service.
-
This Oracle Database 12c: Clusterware Administration training will explore general cluster concepts and Oracle Clusterware architecture. Work with expert Oracle University instructors through interactive instruction and hands-on exercises to reinforce your learning. In this course, you will be introduced to Oracle Database Exadata Cloud Service.
Learn To:
- Perform Grid Infrastructure pre-installation tasks.
- Install both Standard and Flex clusters.
- Add and remove nodes from a cluster in addition to upgrading and patching existing Grid Homes.
- Manage and administer both Standard Clusters and Policy-Managed Clusters.
- Use Oracle Clusterware to make applications highly available.
- Gain an understanding of the Oracle Database Exadata Cloud Service.
-
This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language. Through hands-on instruction from expert Oracle instructors, you’ll learn to develop stored procedures, functions, packages and more.
Learn To:
- Conditionally control code flow (loops, control structures).
- Create stored procedures and functions.
- Use PL/SQL packages to group and contain related constructs.
- Create triggers to solve business challenges.
- Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.
- Create custom packages for applications.
- Write Dynamic SQL code for applications.
-
Keep your mission-critical applications and essential services up and running with comprehensive MySQL training.
To grow your skillset and be more productive in your job, access a rich library of digital courses at your own convenience, then test your new skills through interactive, hands-on labs. Deepen your understanding of MySQL administration, development, security, and high availability in a risk-free environment through role- and topic-based courses. Learn what you need to know to deliver high-performance and scalable applications, then create new opportunities by getting MySQL certified.
The OM-D: MySQL for Developers training course teaches developers you how to develop console and web applications using MySQL with your choice of the PHP, Java, or Python programming languages. Expert Oracle University instructors will guide you through realistic hands-on activities in which you will learn how to use Connectors to access MySQL databases, query the database effectively, present data in different formats, and how to use MySQL’s support for JSON and spatial data.
Learn to:
- Program with Connectors
- Write console and web applications
- Optimize query performance
- Write stored routines and triggers
- Store, access, and analyze geospatial data
- Use X DevAPI to access JSON data in document store
-
Supercharge your skills with PMP certification.
Project Management Professional (PMP) credential awarded by Project Management Institute (PMI), USA is the most important industry-recognized certification for project managers. Globally recognized and demanded, the PMP® demonstrates that you have the experience, education and competency to successfully lead and direct projects.
This PMP Examination Preparation course which provides 35 contact hours helps you understand the core principles of PMP® and provides the skills to pass the demanding and challenging PMP® examinations. Our training sessions are based on PMI-standardized course materials for 2021 PMP exams.
PMP 2021 has been re-designed to be value-oriented and organized into three domains, i.e. People, Process and Business Environment. PMP focuses on the key skillsets in the PMI Talent Triangle (Technical Project Management, Leadership and Strategic and Business Management).
Within the three domains of PMP, the Key Concepts, Trends and Emerging Practices, Tailoring Considerations and Consideration of Agile or Adaptive methods would be covered.
-
The PMI Agile Certified Practitioner (PMI-ACP) formally recognizes your knowledge of agile principles and your skill with agile techniques. It will make you shine even brighter to your employers, stakeholders and peers.
The PMI-ACP® is our fastest growing PMI certification, and it’s no wonder. Organizations that are highly agile and responsive to market dynamics complete more of their projects successfully than their slower-moving counterparts.
The PMI-ACP spans many approaches to agile such as Scrum, Kanban, Lean, extreme programming (XP) and test-driven development (TDD.) So it will increase your versatility, wherever your projects may take you.
-
Manage security of Red Hat Enterprise Linux systems deployed in bare-metal, virtual, and cloud environments.
The Red Hat Security: Linux in Physical, Virtual, and Cloud (RH415) course is designed for security administrators and system administrators who need to manage the secure operation of servers running Red Hat® Enterprise Linux®, whether deployed on physical hardware, as virtual machines, or as cloud instances.
This course is based on Red Hat Enterprise Linux 7.5, Red Hat Satellite 6.3, Red Hat Ansible® Engine 2.5, Red Hat Ansible Tower 3.2, and Red Hat Insights.
Maintaining security of computing systems is a process of managing risk through the implementation of processes and standards backed by technologies and tools. In this course, you will learn about resources that can be used to help you implement and comply with your security requirements.
Explore more about cybersecurity certifications with our cybersecurity training and certifications guide.
-
Learn how to automate administration on Windows Server to enable your DevOps workflow
Microsoft Windows Automation with Red Hat Ansible (DO417) is designed for Windows Server professionals without previous Ansible® experience. You will use Ansible to write automation playbooks for Microsoft Windows systems to perform common system administration tasks reproducibly at scale. You will also learn to use Red Hat® Ansible Tower to securely manage and run your Ansible playbooks from a central web-based user interface.
This course is based on Red Hat Ansible Engine 2.8, Red Hat Ansible Tower 3.5, and Windows Server 2016 and 2019.
-
An overview of Red Hat OpenStack Platform.
Red Hat OpenStack Technical Overview (CL010) is a series of on-demand, online videos to help you better understand the basics of cloud computing and Red Hat® OpenStack® Platform. Several online demonstrations and use cases are included.
-
Build advanced skills for performing Red Hat OpenStack Platform day 2 operations and management of hybrid cloud infrastructure.
Red Hat OpenStack Administration II: Day 2 Operations for Cloud Operators with exam (CL2110) is designed for cloud operators, service administrators, and automation engineers who operate and manage a full-featured hybrid and private cloud-computing environment using Red Hat OpenStack Platform. You will learn how to manage, monitor, troubleshoot, and scale a Red Hat OpenStack Platform infrastructure. This course focuses on using the OpenStack Client command-line user interface to configure metrics, policies, and architecture in order to support enterprise cloud applications and daily operations.
This course is based on Red Hat OpenStack version 16.1, and Red Hat Enterprise Linux version 8.2. The Red Hat Certified Specialist in Cloud Infrastructure exam (EX210) is included in this offering.
-
Learn the basics of Ansible automation and configuration management, and more
Ansible Essentials: Simplicity in Automation Technical Overview (DO007) is a series of on-demand, online videos that introduces you to Ansible automation and configuration management, provisioning, deploying, and managing compute infrastructure across cloud, virtual, and physical environments with Ansible.
-
Learn the basics of agile integration
Red Hat Agile Integration Technical Overview (DO040) provides a technical introduction to Red Hat’s comprehensive set of integration and messaging technologies.
-
Containers, Kubernetes and Red Hat OpenShift Technical Overview (DO080) is a series of on-demand, online videos that introduces you to Linux® containers and container orchestration technology using Docker, Kubernetes, and Red Hat® OpenShift Container Platform.
This course is based on Red Hat OpenShift Container Platform 4.1.
-
Identify the proper frameworks and tools to build your microservices architecture.
Developing Cloud-Native Applications with Microservices Architectures (DO092) is a series of on-demand, online videos that will teach you how to combine different frameworks and tools into a microservices architecture that fits your organizational needs.
-
A developer-focused introduction to OpenShift application building, deployment, scaling, and troubleshooting.
Red Hat® OpenShift® Container Platform is a containerized application platform that allows enterprises to accelerate and streamline application development, delivery, and deployment on-premise or in the cloud. As OpenShift and Kubernetes continue to become widely adopted, developers are increasingly required to understand how to develop, build, and deploy applications with a containerized application platform. While some developers are interested in managing the underlying infrastructure, most developers want to focus on developing applications and using OpenShift for its simple building, deployment, and scaling capabilities.
-
Configure, manage, and troubleshoot OpenShift clusters and containerized applications.
Red Hat OpenShift Administration II: Operating a Production Kubernetes Cluster with exam (DO281) teaches you how to configure, troubleshoot, and manage Red Hat® OpenShift® Container Platform. This hands-on, lab-based course shows you how to verify the successful installation of a cluster, manage it on a day-to-day basis, and troubleshoot the deployment of containerized applications.
This4course is based on Red Hat Enterprise Linux® 8.2 and OpenShift Container Platform 4.6. The Red Hat Certified Specialist in OpenShift Administration exam (EX280) is included.
-
Develop microservice-based applications in Java EE with Micro Profile and OpenShift Building on Red Hat Application Development I: Programming in Java EE (AD183), the introductory course for Java EE application development, Red Hat Application Development II: Implementing Microservice Architectures with exam (DO284) emphasizes learning architectural principles and implementing microservices in Java EE, primarily based on Micro Profile with WildFly Swarm and OpenShift. You will build on Java EE application development fundamentals and focus on how to develop, monitor, test, and deploy modern microservices applications. Many enterprises are looking for a way to take advantage of cloud-native architectures, but many do not know the best way to go about it. These enterprises have monolithic applications written in Java Enterprise Edition (JEE). The Red Hat Certified Enterprise Microservices Developer exam (EX283) is included in this bundle. This course is based on Red Hat® Enterprise Application Platform 7.4 and Wildfly Swarm 2018.3.3.
