Oracle APEX or Oracle Application Express is an application development service in Oracle Database. It provides a fully-integrated, secure, and low-code platform for building and deploying applications.
This instructor-led, live training (online or onsite) is aimed at developers who wish to use Oracle APEX to develop, scale, and deploy applications faster with less code.
By the end of this training, participants will be able to:
Set up the necessary development environment to start developing database apps with Oracle APEX.
Understand and explore the Oracle APEX tools to build a fully-featured application.
Learn how to create applications and pages using Oracle APEX and the Page Designer UI.
Extend the functionality of complex enterprise apps easily with Oracle APEX.
Optimize and scale application performance and deployment.
Control and secure access to application data and components.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at developers who wish to use Oracle APEX to develop, scale, and deploy applications faster with less code.
By the end of this training, participants will be able to:
Set up the necessary development environment to start developing database apps with Oracle APEX.
Understand and explore the Oracle APEX tools to build a fully-featured application.
Learn how to create applications and pages using Oracle APEX and the Page Designer UI.
Extend the functionality of complex enterprise apps easily with Oracle APEX.
Optimize and scale application performance and deployment.
Control and secure access to application data and components.
The workshop is intended for beginners, starting to work with the Oracle database, future administrators and users of systems based on this database need able to use the SQL language for the extraction and modification of the information contained in the systems.
Exams and Certificates
The training plan coincides with the material required to pass the exam: 1Z0-051 Oracle Database 11g: SQL Fundamentals I, the first step to getting most certifications Oracle's Database
Purpose of training
The workshop aims to introduce participants to work with the Oracle database, making them familiar with the SQL language to the extent required for the efficient operation of the system and to take in the future obligations of database applications and Oracle databases.
The content of the training
The organization of the working environment
Introduction to relational databases
Extraction of the data using the SELECT statement
Modifying data using INSERT, UPDATE, DELETE
Overview of schema objects
Remarks
The workshops are based on 11g XE software
[category_overview] =>
[outline] =>
Introduction to Oracle
Database Architecture
Relational model database
Users diagrams sessions
Tools
Introduction to the SELECT statement
Screening and selection (WHERE clause)
sorting
Data types, operators, and service NULL
Built-in scalar functions
Actions to date
National and regional settings in SQL
Regular expressions
The analysis of aggregated data
Grouping functions
DISTINCT clause
Clauses GROUP BY and HAVING
Retrieving data from multiple tables
Inner and outer joins (INNER JOIN, OUTER JOIN)
ANSI SQL syntax, and other methods connectors (SELF JOIN, NATURAL JOIN)
Collective operators (UNION, UNION ALL, INTERSECT, MINUS)
Subqueries
Subqueries simple
Correlated subqueries
Operators EXISTS and NOT EXISTS
Other types of subqueries
Inquiries hierarchical and samples
Construction of the tree (CONNECT BY PRIOR clause and START WITH)
The SYS_CONNECT_BY_PATH
Data samples (SAMPLE clause)
Data manipulation (DML)
INSERT, UPDATE, DELETE
Operations on a large set of (INSERT FIRST INSERT ALL, MERGE)
Workshops are dedicated as a first step for developers and designers of applications based on Oracle databases. Participants do not need to have any prior knowledge of the Oracle database, or other relational database systems, even though such knowledge may be useful.
Exams and Certificates
The plan covers the training material required to pass the exam 1Z0-047 Oracle Database SQL Expert and obtain the title of Oracle Database SQL Certified Expert
Purpose of training
The workshop aims to familiarize participants with the Oracle database techniques to build database structures and data manipulation. Particular emphasis is placed on the participant to see across the board, which offers opportunities to design and build applications Relational Database Management System, Oracle Database, and to be able to independently work with her.
The content of the training
Introduction to database technology and the organization of the work environment
Acquisition and modification of data
Construction of the repository application
Safety and concurrency runtime
Notes
The workshops are based on the software version 11g XE
[category_overview] =>
[outline] =>
Introduction to the Oracle database
Database Architecture
Relational model database
Users diagrams sessions
Tools
Introduction to the SELECT statement
Screening and selection (WHERE clause)
Sorting
Data types, operators, and service NULL
Built-in scalar functions
Actions to date
National and regional settings in SQL
The analysis of aggregated data
Funkcje grupujące
Klauzula distinct
Klauzule GROUP BY and having
Retrieving data from multiple tables
Inner and outer joins (INNER JOIN, OUTER JOIN)
ANSI SQL syntax, and other methods connectors (SELF JOIN, NATURAL JOIN)
Collective operators (UNION, UNION ALL, INTERSECT, MINUS)
Subqueries
Subqueries simple
Correlated subqueries
Operators EXISTS and NOT EXISTS
Other types of subqueries
Inquiries hierarchical and samples
Construction of the tree (CONNECT BY PRIOR clause and START WITH)
The SYS_CONNECT_BY_PATH
Data samples (SAMPLE clause)
Data manipulation (DML)
"INSTRUCCIONES INSERT, UPDATE, DELETE
Operacja na dużych zbiorach (INSERT FIRST, ALL INSERT, MERGE)
Dictionary system
Concurrent users work
Transactions
Locks
FLASHBACK
Users and Permissions
Creating and modifying user patterns
Permissions and roles
Managing data storage - logical layer
Tables, temporary tables, index-organized tables
Limitations
Indexes
The views, sequences, synonyms, materialized views
Units stored PL / SQL
Modeling and restore the data model using Oracle SQL Modeler
Moving Data
A logical copy of the data - datapump import and export
Basic skills in any programming language, object-oriented structural or
The free use of the basics of SQL and knowledge of Oracle database environment (preferably Oracle 11g completion of training - Native SQL for Programmers - Workshops)
[overview] =>
For who
Workshops are dedicated to developers, end users and administrators, who until now have had no contact with the language PL / SQL, and the need to exploit its huge potential in working with a database, automate processes, and in building applications
Exams and Certificates
The plan covers the training material required to pass the exam 1Z0-144 Oracle Database 11g Program with PL / SQL and obtain the title of Oracle PL / SQL Developer Certified Associate
Purpose of training
The workshop aims to familiarize participants with the programming language PL / SQL, its capabilities and limitations. This workshop will include a full understanding of the mechanisms involved in the programming language PL / SQL needed to implement the logic of the free applications, automation of data processing and database management.
The content of the training
Introduction to PL / SQL architecture solutions based on this language, the organization of the working environment
Create scripts and stored program units that operate on data
Notes
The workshops are based on the software version 11g XE
[category_overview] =>
[outline] =>
Introduction to PL / SQL
Runtime Environment
Construction and types of PL / SQL blocks
Declaring and using variables
Control statements, decisions, loops
SQL statements in PL / SQL
DML commands
DDL and dynamic SQL
TCL commands and transactional
SELECT
Procedures and Functions
Create and delete
Parameterization
Passing parameters by value and reference, nocopy
Handling errors and exceptions
Create and use cursors
Records
static cursors
Parameterizing cursors
Cursor FOR UPDATE
Associative arrays
Packages
The structure of the package: the specification and body
Section Initialization and global variables, memory management, an instance of the package
The free use of the basics of SQL and knowledge of Oracle database environment (preferably Oracle 11g completion of training - Native SQL for Programmers - Workshops)
Fluency in the basics of PL / SQL (preferably Oracle 11g completion of training - Programming with PL / SQL I - Workshops)
[overview] =>
For who
This training is in addition to, and continuation of the 'Oracle 11g - Programming in PL / SQL and - workshops ", but can also be designed for practitioners, developers, PL / SQL who already have experience with the language, and who want to systematize their knowledge and learn advanced mechanisms and solutions developed in this language.
The content of the training
Objects, streams and complex data structures
Advanced solutions based on PL / SQL
Exams and Certificates
The plan covers the training material required to pass the exam 1Z0-146 Oracle Advanced PL / SQL and obtain the title of Oracle Advanced PL / SQL Developer Certified Professional
Purpose of training
The training is designed to familiarize participants with the advanced aspects of programming in an Oracle database. The emphasis is on flexibility and performance solutions based on PL / SQL.
Notes
The workshops are based on the software version 11g XE
[category_overview] =>
[outline] =>
Complex data types, collections
Subtypes
Cursor variables and dynamic cursors
Associative arrays, collections
Actions mass, bulk, forall
Exception handling bulk operations
Object orientation in an Oracle database
Types (classes)
methods of objects
permanent Collections
Functions Panel
streaming Features
Create your own aggregate functions
Calling functions in SQL, constraints, levels of purity, determinism
Organization of program units PL / SQL
Permissions in PL / SQL
Context name
Integration with other languages
Using JAVA
Linking procedures C language
Native compilation of the C language
Ready solutions
Create the application context
Mechanism of Virtual Private Database (VPD)
Support lobbying
Profiling code
Tracking code
Productivity PL / SQL code
Bind variables in SQL statements and the statistical distribution of
The free use of the basics of SQL and knowledge of Oracle database environment (preferably Oracle 11g completion of training - Native SQL for Programmers - Workshops)
Practical experience in working with Oracle
[overview] =>
For who
The workshop is intended for advanced programmers and Oracle users who seek knowledge and information on the efficient development of information systems in an Oracle database, and the tuning and testing of performance issues in existing applications. This course builds on knowledge often unavailable or incorrectly presented in the technical documentation, and collected during many years of practice leading them instructors. These workshops may be the end of the training path for developers, or a single step for people with extensive experience designing and programming in Oracle
Purpose of training
The workshop aims to provide mechanisms that occur in an Oracle database when performing SQL statements. Allows participants to avoid errors during software development, and explore, diagnose, and resolve performance problems in existing applications.
Particular emphasis is placed on the workshops, where we show the methodology and the practical aspects of the application and tuning SQL statements.
The content of the training
Mechanics perform SQL commands
Managing the process cost optimization
Methods of data storage and indexing
Monitoring database performance and processes based on dictionaries and track system applications
Analysis of cases of the most common problems that cause performance
Notes
The workshops are based on the software version 11g XE
[category_overview] =>
[outline] =>
Application Tuning Methodology
Architecture database and instance
Server processes
Memory structure (SGA, PGA)
Parsing and share cursors
The data files, log files, parameter files
Analysis of the command execution plan
Hypothetical plan (EXPLAIN PLAN, SQLPlus AutoTrac XPlane)
The actual execution plan (V $ SQL_PLAN, XPlane, AWR)
Monitoring the performance and find bottlenecks in the process
Monitoring the current status of the instance by system dictionary views
The monitoring of historical dictionaries
Tracking application (SQLTrace, TkProf, TreSess
The optimization process
Properties cost optimization and regulated
Determination to optimize
Control work cost-based optimizer by:
Session parameters and instance
Tips (hints)
Patterns of query plans
Statistics and Histograms
Impact statistics and histograms for performance
The methods of collecting statistics and histograms
Strategy of counting and estimating statistics
Management statistics: blocking, copying, editing, automation of collection, monitoring changes
Dynamic data sampling (temporary plates, complex predicates)
Multi-column statistics, based on expressions
Statistics System
The logical and physical structure of the database
Spaces tables.
segments
Extensions (EXTENTS)
Blocks
Data storage methods
The physical aspects of the table
temporary Tables
Tables index
external Tables
Partition Table (span, letter, hash, mixed)
Physical reorganization of tables
Materialized views and mechanism QUERY REWRITE
Methods of data indexing
Building B-TREE indexes
Properties index
Indexes: a unique, multi-column, function, inverse
Compression indices
Reconstruction and merging indexes
Virtual indexes
Indexes private and public
Bitmap Indexes and junction
Case study - full-scan data
The impact of a place at the table level and block performance readings
Loading Data conventional and direct path
The order of predicates
Case Study - access to data via the index
Methods of reading index (UNIQUE SCAN RANGE SCAN FULL SCAN FAST FULL SCAN MIN / MAX SCAN)
On-premise, Oracle database management systems can be costly and difficult to maintain for mid and large-scale organizations. Migrating Oracle databases to Azure SQL (also known as Microsoft Azure SQL Database, Microsoft Azure SQL or AzureSQL) or PostgreSQL (also known as Postgres or Postgre SQL) is a practical solution for growing businesses to address database management, maintenance, and scalability at an optimum cost.
This instructor-led, live training (online or onsite) is aimed at database administrators and cloud architects who wish to migrate Oracle databases to Azure SQL or PostgreSQL.
By the end of this training, participants will be able to:
Compare Azure SQL with PostgreSQL to choose the database that best meets business objectives and needs.
Prepare databases to move definitions, data, and procedures from Oracle to AzureSQL or PostgreSQL database system.
Perform post-migration steps to test, optimize, update, and maintain a migrated database.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at database administrators and cloud architects who wish to migrate Oracle databases to Azure SQL or PostgreSQL.
By the end of this training, participants will be able to:
Compare Azure SQL with PostgreSQL to choose the database that best meets business objectives and needs.
Prepare databases to move definitions, data, and procedures from Oracle to AzureSQL or PostgreSQL database system.
Perform post-migration steps to test, optimize, update, and maintain a migrated database.
[outline] =>
Introduction
Overview of Oracle Migration to Azure SQL or PostgreSQL
Designing a Proof of Concept Solution
Comparing Azure SQL Database With PostgreSQL Database
Configuring SQL Server Instances
Setting up Oracle Express Edition
Preparing the Database for Migration
Migrating SQL Server to Azure SQL
Deploying Post Upgrade Enhancements
Migrating Oracle Database to SQL Server 2017
Migrating the Application to Azure SQL
Migrating SQL Server to PostgreSQL
Preparing Oracle Database Migration to PostgreSQL
Migrating the Database and Application to PostgreSQL
The course is only suitable for those who have some knowledge of SQL.
Previous experience with an interactive computer system is desirable but not essential.
[overview] =>
This 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 18c is the next iteration of Oracle Database 12c Release 2, or "the first patch".
This instructor-led, live training (online or onsite) is aimed at engineers who wish to set up, deploy, migrate to and manage an Oracle 18c Database.
By the end of this training, participants will be able to:
Understand the major feature and architectural changes from previous Oracle versions.
Migrate to Oracle 18c from a previous version.
Deploy Oracle 18c in cloud or on premise.
Understand Oracle 18c's new yearly release cycle and plan maintenance around it.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at engineers who wish to set up, deploy, migrate to and manage an Oracle 18c Database.
By the end of this training, participants will be able to:
Understand the major feature and architectural changes from previous Oracle versions.
Migrate to Oracle 18c from a previous version.
Deploy Oracle 18c in cloud or on premise.
Understand Oracle 18c's new yearly release cycle and plan maintenance around it.
[outline] =>
Introduction
Oracle 18c and Oracle’s Autonomous Database Cloud
Overview of Oracle 18c Features and Architecture
On-premises and in cloud
Oracle 18c Incremental Enhancements over Oracle Database 12c Release 2.
Performance, High Availability, Multitenant Architecture, Security, Data Warehousing and Application Development
Oracle 18c Major Enhancements over Older Versions
Multitenant, Database In-Memory, Database Sharding, Connection Manager, etc.
Oracle 18c Deprecated Features from Older Versions
Non-CDB architecture, Oracle Streams, Oracle Multimedia, Oracle Administration Assistant for Windows, etc.
Upgrading from Previous Versions of Oracle
Multi-step Upgrade (10g => 12c => 18c)
Datadump "Upgrade" (Import/Export)
Understanding Oracle's Autonomous Database Cloud
Cost-based Optimization, Performance Tuning and Diagnostics, Data Automization, Cloud Operations
Automating Routine Administrative Tasks
Self-driving, Self-securing, Self-repairing
Deploying Oracle to a Public, Private and Hybrid Cloud
Oracle Database 21c is a converged database that supports a large range of workloads and data models. It’s a data management platform that provides high performance, security, availability, and scalability for cloud environments.
This instructor-led, live training (online or onsite) is aimed at database administrators who wish to learn and use the features of Oracle Database 21c in performing administrative tasks.
By the end of this training, participants will be able to:
Understand the core concepts of Oracle Database 21c administration.
Understand the Oracle 21c architecture.
Learn how to perform administration tasks on Oracle 21c.
Understand the Oracle 21c backup and recovery process.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at database administrators who wish to learn and use the features of Oracle Database 21c in performing administrative tasks.
By the end of this training, participants will be able to:
Understand the core concepts of Oracle Database 21c administration.
Understand the Oracle 21c architecture.
Learn how to perform administration tasks on Oracle 21c.
Understand the Oracle 21c backup and recovery process.
[outline] =>
Introduction
Introduction to Oracle Cloud
Overview of Oracle Database 21c
Oracle Database Architecture
Overview of the Oracle Database architecture
Configuring and connecting to the Oracle Database Instance
Understanding the Oracle Database memory structures
Process architecture and structures
Process startup sequence
Storage architecture
Database Instance
Overview of the Oracle Database management tools
Enterprise manager management framework
Setting Up the Oracle Network Environment
Overview of the Oracle Net Services and Oracle Net Listener
Oracle Network Connections
Configuring the Oracle Network tools
Listener Control Utility
Oracle Net configuration assistant
Oracle Net Manager
Enterprise Manager Cloud Control
Database Storage Structures
Overview of Database Block Content
Storage structure
Creating and managing Tablespaces
Navigating and viewing Tablespace information
Using Oracle managed files
User Security
Managing database user accounts
Predefined administrative accounts
Creating a user account
Authentication and password reset
Understanding the concept of privileges, roles, and profiles
Data Concurrency
Understanding the locking mechanism
Understanding data concurrency
DML locks
Enqueue mechanism
Lock conflicts
Undo Data
Overview of Undo data
Managing transactions and storing Undo information
No prior Oracle Business Intelligence experience required
Audience
Business analysts
Data analysts
Business intelligence professionals
[overview] =>
Oracle Business Intelligence (OBI) provides a comprehensive set of tools for analyzing, reporting, and visualizing data.
This instructor-led, live training (online or onsite) is aimed at beginner-level business analysts and data analysts who wish to leverage Oracle BI to extract valuable insights from their data.
By the end of this training, participants will be able to:
Navigate and utilize the Oracle BI interface effectively.
Create and customize reports and dashboards tailored to business needs.
Conduct ad-hoc analysis using various BI tools.
Utilize advanced features for comprehensive data exploration.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at beginner-level business analysts and data analysts who wish to leverage Oracle BI to extract valuable insights from their data.
By the end of this training, participants will be able to:
Navigate and utilize the Oracle BI interface effectively.
Create and customize reports and dashboards tailored to business needs.
Conduct ad-hoc analysis using various BI tools.
Utilize advanced features for comprehensive data exploration.
[outline] =>
Introduction
Overview of Oracle Business Intelligence
Key features and components
Understanding the BI life cycle
Navigating the Oracle BI Interface
Accessing and logging into Oracle BI
Exploring the BI dashboard
Overview of key tools: Oracle Answers, Oracle Dashboards, etc.
Creating Basic Reports with Oracle Answers
Building a simple report
Formatting and styling options
Implementing basic calculations
Exporting and sharing reports
Advanced Reporting Techniques
Working with advanced visualizations
Incorporating statistical analysis
Implementing conditional formatting
Mastering drill-down and drill-up techniques
Data Exploration and Analysis with Oracle Dashboards
Introduction to Oracle Dashboards
Conducting ad-hoc analysis
Integrating Dashboards with other Oracle BI tools
Advanced analysis features
Dashboard Design Best Practices
Overview of dashboard design principles
Creating and customizing dashboards
Implementing interactivity in dashboards
Best practices for effective dashboard design
Data Visualization Best Practices
Principles of effective data visualization
Creating compelling visualizations with Oracle BI tools
Oracle Database 19c is a multi-model database that provides full support for relational and non-relational data.
This instructor-led, live training (online or onsite) is aimed at system administrators who wish to learn how to administer, monitor, and support an Oracle database.
By the end of this training, participants will be able to:
Understand the major feature and architectural changes Oracle database.
Manage and monitor Oracle databases.
Optimize Oracle database performance.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at system administrators who wish to learn how to administer, monitor, and support an Oracle database.
By the end of this training, participants will be able to:
Understand the major feature and architectural changes Oracle database.
Manage and monitor Oracle databases.
Optimize Oracle database performance.
[outline] =>
Introduction
Overview of Oracle database server architecture
Overview of Oracle multitenant container database
Oracle database instance and database sharding
Accessing Oracle Database
Connecting to an Oracle database instance
Using Oracle database tools
SQL*Plus
Using Oracle SQL developer
Using Database Configuration Assistant (DBCA)
Understanding the Enterprise Manager cloud control 13c features
Overview of Oracle Enterprise Manager component
Single pane of glass for enterprise management
Managing Oracle Enterprise Manager database
Creating an Oracle Database
Creating an Oracle database using DBCA
Creating an Oracle database using an SQL command
Working with Database Instances
Starting the Oracle database instance
Shutting down an Oracle database instance
Comparing Shutdown modes
Opening and closing PDBs
Configuring PDBs
Managing Database Instances
Using initialization parameters
Working with the automatic diagnostic repository
Viewing the alert log
Using trace files
Administering the DDL log file
Working with dynamic performance views
Using a data dictionary
Overview of Oracle Net Services
Defining components of Oracle net services
Configuring and managing Oracle net services
Overview of Oracle net listener
Comparing dedicated and shared server architecture
Naming Methods
Establishing Oracle network connections
Understanding the naming methods
Easy connect
Local and directory naming
Managing workloads using database services
Creating database services
Working with the Listener
Using the default listener
Configuring dynamic service registration
Configuring static service registration
Configuring a Shared Server Architecture
Enabling a shared server
Controlling shared server operations
Using SGA and PGA
Shared server configuration considerations
Configuring Oracle Connect Manager
Understanding Oracle Connection Manager
Using filtering rules
Implementing intranet and internet access control
Using session multiplexing
Configuring Oracle Connection Manager
Configuring the cman.ora file
Configuring clients
Configuring the database server
Using the Oracle Connection Manager control utility
Oracle Database 19c is a multi-model database that provides full support for relational and non-relational data.
This instructor-led, live training (online or onsite) is aimed at system administrators who wish to have a comprehensive understanding of the security features of Oracle Database 19c.
By the end of this training, participants will be able to:
Understand the concepts of database security.
Implement authentication and authorization mechanisms to control access to the database.
Configure and manage user accounts, roles, and privileges effectively.
Implement robust security measures against various threats and vulnerabilities.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at system administrators who wish to have a comprehensive understanding of the security features of Oracle Database 19c.
By the end of this training, participants will be able to:
Understand the concepts of database security.
Implement authentication and authorization mechanisms to control access to the database.
Configure and manage user accounts, roles, and privileges effectively.
Implement robust security measures against various threats and vulnerabilities.
[outline] =>
Introduction
Overview of Oracle database 19c security
Understanding the importance of database security
Security Overview
Understanding network security
Defining a security policy
Authentication, Authorization, and User Management
Configuring authentication methods
Managing user accounts, roles, and profiles
Granting and revoking privileges
Implementing fine-grained access control
Managing database links and security implications
Data Encryption
Understanding encryption concepts and algorithms
Configuring encryptions
Implementing database auditing and monitoring
Responding to security incidents and breaches
Oracle Database 19c Advanced Security
Configuring realms, rules, and secure application roles
Oracle Fusion Human Capital Management (HCM) is a complete cloud solution that provides a modern set of tools to support complex human resource processes and workforce management.
This instructor-led, live training (online or onsite) is aimed at professionals who wish to learn the fundamental concepts of Oracle Fusion and implement Oracle Fusion HCM in their organization.
By the end of this training, participants will be able to:
Learn and understand the concepts of Oracle Fusion Human Capital Management (HCM).
Implement complete workforce structure management in any organization.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at professionals who wish to learn the fundamental concepts of Oracle Fusion and implement Oracle Fusion HCM in their organization.
By the end of this training, participants will be able to:
Learn and understand the concepts of Oracle Fusion Human Capital Management (HCM).
Implement complete workforce structure management in any organization.
[outline] =>
Introduction
Overview of Oracle Fusion HCM
Understanding the UI
Getting Started with Oracle Fusion HCM
Implementing Oracle Fusion
Preparing Fusion applications
User and role management
Synchronizing users and roles in LDAP
Functional setup manager
Workforce Management and Work Structure
Human resources
Workforce lifecycle manager
Managing profiles, performance, and goals
Managing compensation
Employment models
Managing work structures
Payroll Management
Payroll overview
HCM security overview
Configuring payroll
Creating and defining payroll element entries
Calculating payroll
Defining payment methods
Payroll costing
Defining payroll flow patterns
Goals Management
Concepts and actions of goal management
Setting up goal management
Understanding lookups, flex fields, and profile options
Creating and managing goal plans
Managing worker and organization goals
Administering and assigning goals
Approving goals
Understanding questionnaire concepts
Managing questions
Using question library
Creating questionnaires
Using questionnaire templates
Defining worker performance
Using performance management
Managing performance documents and worker evaluations
Monitoring tasks for worker performance
Absence Management
Setting up absence management
Overview of absence types
Understanding absence patterns and features
Absence types, plans, and reasons
Scheduling absences
Managing absence records and entitlements
Understanding absence recording
Absence approvals
Monitoring absence process
Time and Labor Management
Time card layout components
Managing HCM groups
Creating time card components
Understanding time card calculation rules
Managing worker time entry profile
Managing time processing profile
Loading timecards
Summary and Next Steps
[language] => en
[duration] => 28
[status] => published
[changed] => 1700037885
[source_title] => Oracle Fusion Human Capital Management (HCM)
[source_language] => en
[cert_code] =>
[weight] => -12
[excluded_sites] =>
[use_mt] => stdClass Object
(
[field_overview] =>
[field_course_outline] =>
[field_prerequisits] =>
[field_overview_in_category] =>
)
[cc] => oraclefusionhcm
)
[oraclelinux8] => stdClass Object
(
[course_code] => oraclelinux8
[hr_nid] => 435831
[title] => Oracle Linux 8: System Administration I
[requirements] =>
Knowledge of Linux system
Audience
System administrator
Technical consultant
Database administrator
[overview] =>
Oracle Linux is a high-performance and secure operating environment that delivers an easy-to-manage environment for virtualization, management, automation, and cloud-native computing tools.
This instructor-led, live training (online or onsite) is aimed at system administrators who wish to learn how to use and manage an Oracle Linux 8 system.
By the end of this training, participants will be able to:
Configure passwordless authentication.
Administer user and group accounts.
Configure network interface.
Monitor and troubleshoot Oracle Linux.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at system administrators who wish to learn how to use and manage an Oracle Linux 8 system.
By the end of this training, participants will be able to:
Configure passwordless authentication.
Administer user and group accounts.
Configure network interface.
Monitor and troubleshoot Oracle Linux.
[outline] =>
Introduction
Overview of Oracle Linux
Exploring the gateway machine
Exploring the host VM
Getting Started with Oracle Linux
Installing Oracle Linux 8
Connecting to a remote server by using SSH
Configuring OpenSSH
Using the GRUB Bootloader
Overview of the GRUB Bootloader
Configuring the GRUB 2 Bootloader
Exploring the GRUB 2 Bootloader
Booting different kernels
Introduction to Systemd
Overview of systemd
Understanding the service unit file
Using grub menu and command line
Using systemd units
Using systemd service units
Managing Time
Managing system tasks
Configuring date and time
Configuring Chrony
Automating tasks
Configuring Device and Kenel
Understanding the sysfs file system
Updating using DNF
Using loadable kernel modules
Using /proc file and sysfs file system
Using the sysctl utility
Configuring udev rules
Managing Packages
Installing, updating, or removing packages using dnf
Oracle APEX or Oracle Application Express is an application development service in Oracle Database. It provides a fully-integrated, secure, and low-code platform for building and deploying applications.
This instructor-led, live training (online or onsite) is aimed at developers who wish to use Oracle APEX to develop, scale, and deploy applications faster with less code.
By the end of this training, participants will be able to:
Set up the necessary development environment to start developing database apps with Oracle APEX.
Understand and explore the Oracle APEX tools to build a fully-featured application.
Learn how to create applications and pages using Oracle APEX and the Page Designer UI.
Extend the functionality of complex enterprise apps easily with Oracle APEX.
Optimize and scale application performance and deployment.
Control and secure access to application data and components.
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.
Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
The workshop is intended for beginners, starting to work with the Oracle database, future administrators and users of systems based on this database need able to use the SQL language for the extraction and modification of the information contained in the systems.
Exams and Certificates
The training plan coincides with the material required to pass the exam: 1Z0-051 Oracle Database 11g: SQL Fundamentals I, the first step to getting most certifications Oracle's Database
Purpose of training
The workshop aims to introduce participants to work with the Oracle database, making them familiar with the SQL language to the extent required for the efficient operation of the system and to take in the future obligations of database applications and Oracle databases.
Workshops are dedicated as a first step for developers and designers of applications based on Oracle databases. Participants do not need to have any prior knowledge of the Oracle database, or other relational database systems, even though such knowledge may be useful.
Exams and Certificates
The plan covers the training material required to pass the exam 1Z0-047 Oracle Database SQL Expert and obtain the title of Oracle Database SQL Certified Expert
Purpose of training
The workshop aims to familiarize participants with the Oracle database techniques to build database structures and data manipulation. Particular emphasis is placed on the participant to see across the board, which offers opportunities to design and build applications Relational Database Management System, Oracle Database, and to be able to independently work with her.
The content of the training
Introduction to database technology and the organization of the work environment
Acquisition and modification of data
Construction of the repository application
Safety and concurrency runtime
Notes
The workshops are based on the software version 11g XE
Workshops are dedicated to developers, end users and administrators, who until now have had no contact with the language PL / SQL, and the need to exploit its huge potential in working with a database, automate processes, and in building applications
Exams and Certificates
The plan covers the training material required to pass the exam 1Z0-144 Oracle Database 11g Program with PL / SQL and obtain the title of Oracle PL / SQL Developer Certified Associate
Purpose of training
The workshop aims to familiarize participants with the programming language PL / SQL, its capabilities and limitations. This workshop will include a full understanding of the mechanisms involved in the programming language PL / SQL needed to implement the logic of the free applications, automation of data processing and database management.
The content of the training
Introduction to PL / SQL architecture solutions based on this language, the organization of the working environment
Create scripts and stored program units that operate on data
Notes
The workshops are based on the software version 11g XE
This training is in addition to, and continuation of the 'Oracle 11g - Programming in PL / SQL and - workshops ", but can also be designed for practitioners, developers, PL / SQL who already have experience with the language, and who want to systematize their knowledge and learn advanced mechanisms and solutions developed in this language.
The content of the training
Objects, streams and complex data structures
Advanced solutions based on PL / SQL
Exams and Certificates
The plan covers the training material required to pass the exam 1Z0-146 Oracle Advanced PL / SQL and obtain the title of Oracle Advanced PL / SQL Developer Certified Professional
Purpose of training
The training is designed to familiarize participants with the advanced aspects of programming in an Oracle database. The emphasis is on flexibility and performance solutions based on PL / SQL.
Notes
The workshops are based on the software version 11g XE
The workshop is intended for advanced programmers and Oracle users who seek knowledge and information on the efficient development of information systems in an Oracle database, and the tuning and testing of performance issues in existing applications. This course builds on knowledge often unavailable or incorrectly presented in the technical documentation, and collected during many years of practice leading them instructors. These workshops may be the end of the training path for developers, or a single step for people with extensive experience designing and programming in Oracle
Purpose of training
The workshop aims to provide mechanisms that occur in an Oracle database when performing SQL statements. Allows participants to avoid errors during software development, and explore, diagnose, and resolve performance problems in existing applications.
Particular emphasis is placed on the workshops, where we show the methodology and the practical aspects of the application and tuning SQL statements.
The content of the training
Mechanics perform SQL commands
Managing the process cost optimization
Methods of data storage and indexing
Monitoring database performance and processes based on dictionaries and track system applications
Analysis of cases of the most common problems that cause performance
Notes
The workshops are based on the software version 11g XE
This instructor-led, live training in Ecuador (online or onsite) is aimed at database administrators and cloud architects who wish to migrate Oracle databases to Azure SQL or PostgreSQL.
By the end of this training, participants will be able to:
Compare Azure SQL with PostgreSQL to choose the database that best meets business objectives and needs.
Prepare databases to move definitions, data, and procedures from Oracle to AzureSQL or PostgreSQL database system.
Perform post-migration steps to test, optimize, update, and maintain a migrated database.
This 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.
This instructor-led, live training in Ecuador (online or onsite) is aimed at engineers who wish to set up, deploy, migrate to and manage an Oracle 18c Database.
By the end of this training, participants will be able to:
Understand the major feature and architectural changes from previous Oracle versions.
Migrate to Oracle 18c from a previous version.
Deploy Oracle 18c in cloud or on premise.
Understand Oracle 18c's new yearly release cycle and plan maintenance around it.
This instructor-led, live training in Ecuador (online or onsite) is aimed at database administrators who wish to learn and use the features of Oracle Database 21c in performing administrative tasks.
By the end of this training, participants will be able to:
Understand the core concepts of Oracle Database 21c administration.
Understand the Oracle 21c architecture.
Learn how to perform administration tasks on Oracle 21c.
Understand the Oracle 21c backup and recovery process.
This instructor-led, live training in Ecuador (online or onsite) is aimed at beginner-level business analysts and data analysts who wish to leverage Oracle BI to extract valuable insights from their data.
By the end of this training, participants will be able to:
Navigate and utilize the Oracle BI interface effectively.
Create and customize reports and dashboards tailored to business needs.
Conduct ad-hoc analysis using various BI tools.
Utilize advanced features for comprehensive data exploration.
This instructor-led, live training in Ecuador (online or onsite) is aimed at system administrators who wish to learn how to administer, monitor, and support an Oracle database.
By the end of this training, participants will be able to:
Understand the major feature and architectural changes Oracle database.
This instructor-led, live training in Ecuador (online or onsite) is aimed at system administrators who wish to have a comprehensive understanding of the security features of Oracle Database 19c.
By the end of this training, participants will be able to:
Understand the concepts of database security.
Implement authentication and authorization mechanisms to control access to the database.
Configure and manage user accounts, roles, and privileges effectively.
Implement robust security measures against various threats and vulnerabilities.
This instructor-led, live training in Ecuador (online or onsite) is aimed at professionals who wish to learn the fundamental concepts of Oracle Fusion and implement Oracle Fusion HCM in their organization.
By the end of this training, participants will be able to:
Learn and understand the concepts of Oracle Fusion Human Capital Management (HCM).
Implement complete workforce structure management in any organization.
This instructor-led, live training in Ecuador (online or onsite) is aimed at system administrators who wish to learn how to use and manage an Oracle Linux 8 system.
By the end of this training, participants will be able to:
Oracle APEX or Oracle Application Express is an application development service in Oracle Database. It provides a fully-integrated, secure, and low-code platform for building and deploying applications.
This instructor-led, live training (online or onsite) is aimed at developers who wish to use Oracle APEX to develop, scale, and deploy applications faster with less code.
By the end of this training, participants will be able to:
Set up the necessary development environment to start developing database apps with Oracle APEX.
Understand and explore the Oracle APEX tools to build a fully-featured application.
Learn how to create applications and pages using Oracle APEX and the Page Designer UI.
Extend the functionality of complex enterprise apps easily with Oracle APEX.
Optimize and scale application performance and deployment.
Control and secure access to application data and components.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at developers who wish to use Oracle APEX to develop, scale, and deploy applications faster with less code.
By the end of this training, participants will be able to:
Set up the necessary development environment to start developing database apps with Oracle APEX.
Understand and explore the Oracle APEX tools to build a fully-featured application.
Learn how to create applications and pages using Oracle APEX and the Page Designer UI.
Extend the functionality of complex enterprise apps easily with Oracle APEX.
Optimize and scale application performance and deployment.
Control and secure access to application data and components.
The workshop is intended for beginners, starting to work with the Oracle database, future administrators and users of systems based on this database need able to use the SQL language for the extraction and modification of the information contained in the systems.
Exams and Certificates
The training plan coincides with the material required to pass the exam: 1Z0-051 Oracle Database 11g: SQL Fundamentals I, the first step to getting most certifications Oracle's Database
Purpose of training
The workshop aims to introduce participants to work with the Oracle database, making them familiar with the SQL language to the extent required for the efficient operation of the system and to take in the future obligations of database applications and Oracle databases.
The content of the training
The organization of the working environment
Introduction to relational databases
Extraction of the data using the SELECT statement
Modifying data using INSERT, UPDATE, DELETE
Overview of schema objects
Remarks
The workshops are based on 11g XE software
[category_overview] =>
[outline] =>
Introduction to Oracle
Database Architecture
Relational model database
Users diagrams sessions
Tools
Introduction to the SELECT statement
Screening and selection (WHERE clause)
sorting
Data types, operators, and service NULL
Built-in scalar functions
Actions to date
National and regional settings in SQL
Regular expressions
The analysis of aggregated data
Grouping functions
DISTINCT clause
Clauses GROUP BY and HAVING
Retrieving data from multiple tables
Inner and outer joins (INNER JOIN, OUTER JOIN)
ANSI SQL syntax, and other methods connectors (SELF JOIN, NATURAL JOIN)
Collective operators (UNION, UNION ALL, INTERSECT, MINUS)
Subqueries
Subqueries simple
Correlated subqueries
Operators EXISTS and NOT EXISTS
Other types of subqueries
Inquiries hierarchical and samples
Construction of the tree (CONNECT BY PRIOR clause and START WITH)
The SYS_CONNECT_BY_PATH
Data samples (SAMPLE clause)
Data manipulation (DML)
INSERT, UPDATE, DELETE
Operations on a large set of (INSERT FIRST INSERT ALL, MERGE)
Workshops are dedicated as a first step for developers and designers of applications based on Oracle databases. Participants do not need to have any prior knowledge of the Oracle database, or other relational database systems, even though such knowledge may be useful.
Exams and Certificates
The plan covers the training material required to pass the exam 1Z0-047 Oracle Database SQL Expert and obtain the title of Oracle Database SQL Certified Expert
Purpose of training
The workshop aims to familiarize participants with the Oracle database techniques to build database structures and data manipulation. Particular emphasis is placed on the participant to see across the board, which offers opportunities to design and build applications Relational Database Management System, Oracle Database, and to be able to independently work with her.
The content of the training
Introduction to database technology and the organization of the work environment
Acquisition and modification of data
Construction of the repository application
Safety and concurrency runtime
Notes
The workshops are based on the software version 11g XE
[category_overview] =>
[outline] =>
Introduction to the Oracle database
Database Architecture
Relational model database
Users diagrams sessions
Tools
Introduction to the SELECT statement
Screening and selection (WHERE clause)
Sorting
Data types, operators, and service NULL
Built-in scalar functions
Actions to date
National and regional settings in SQL
The analysis of aggregated data
Funkcje grupujące
Klauzula distinct
Klauzule GROUP BY and having
Retrieving data from multiple tables
Inner and outer joins (INNER JOIN, OUTER JOIN)
ANSI SQL syntax, and other methods connectors (SELF JOIN, NATURAL JOIN)
Collective operators (UNION, UNION ALL, INTERSECT, MINUS)
Subqueries
Subqueries simple
Correlated subqueries
Operators EXISTS and NOT EXISTS
Other types of subqueries
Inquiries hierarchical and samples
Construction of the tree (CONNECT BY PRIOR clause and START WITH)
The SYS_CONNECT_BY_PATH
Data samples (SAMPLE clause)
Data manipulation (DML)
"INSTRUCCIONES INSERT, UPDATE, DELETE
Operacja na dużych zbiorach (INSERT FIRST, ALL INSERT, MERGE)
Dictionary system
Concurrent users work
Transactions
Locks
FLASHBACK
Users and Permissions
Creating and modifying user patterns
Permissions and roles
Managing data storage - logical layer
Tables, temporary tables, index-organized tables
Limitations
Indexes
The views, sequences, synonyms, materialized views
Units stored PL / SQL
Modeling and restore the data model using Oracle SQL Modeler
Moving Data
A logical copy of the data - datapump import and export
Basic skills in any programming language, object-oriented structural or
The free use of the basics of SQL and knowledge of Oracle database environment (preferably Oracle 11g completion of training - Native SQL for Programmers - Workshops)
[overview] =>
For who
Workshops are dedicated to developers, end users and administrators, who until now have had no contact with the language PL / SQL, and the need to exploit its huge potential in working with a database, automate processes, and in building applications
Exams and Certificates
The plan covers the training material required to pass the exam 1Z0-144 Oracle Database 11g Program with PL / SQL and obtain the title of Oracle PL / SQL Developer Certified Associate
Purpose of training
The workshop aims to familiarize participants with the programming language PL / SQL, its capabilities and limitations. This workshop will include a full understanding of the mechanisms involved in the programming language PL / SQL needed to implement the logic of the free applications, automation of data processing and database management.
The content of the training
Introduction to PL / SQL architecture solutions based on this language, the organization of the working environment
Create scripts and stored program units that operate on data
Notes
The workshops are based on the software version 11g XE
[category_overview] =>
[outline] =>
Introduction to PL / SQL
Runtime Environment
Construction and types of PL / SQL blocks
Declaring and using variables
Control statements, decisions, loops
SQL statements in PL / SQL
DML commands
DDL and dynamic SQL
TCL commands and transactional
SELECT
Procedures and Functions
Create and delete
Parameterization
Passing parameters by value and reference, nocopy
Handling errors and exceptions
Create and use cursors
Records
static cursors
Parameterizing cursors
Cursor FOR UPDATE
Associative arrays
Packages
The structure of the package: the specification and body
Section Initialization and global variables, memory management, an instance of the package
The free use of the basics of SQL and knowledge of Oracle database environment (preferably Oracle 11g completion of training - Native SQL for Programmers - Workshops)
Fluency in the basics of PL / SQL (preferably Oracle 11g completion of training - Programming with PL / SQL I - Workshops)
[overview] =>
For who
This training is in addition to, and continuation of the 'Oracle 11g - Programming in PL / SQL and - workshops ", but can also be designed for practitioners, developers, PL / SQL who already have experience with the language, and who want to systematize their knowledge and learn advanced mechanisms and solutions developed in this language.
The content of the training
Objects, streams and complex data structures
Advanced solutions based on PL / SQL
Exams and Certificates
The plan covers the training material required to pass the exam 1Z0-146 Oracle Advanced PL / SQL and obtain the title of Oracle Advanced PL / SQL Developer Certified Professional
Purpose of training
The training is designed to familiarize participants with the advanced aspects of programming in an Oracle database. The emphasis is on flexibility and performance solutions based on PL / SQL.
Notes
The workshops are based on the software version 11g XE
[category_overview] =>
[outline] =>
Complex data types, collections
Subtypes
Cursor variables and dynamic cursors
Associative arrays, collections
Actions mass, bulk, forall
Exception handling bulk operations
Object orientation in an Oracle database
Types (classes)
methods of objects
permanent Collections
Functions Panel
streaming Features
Create your own aggregate functions
Calling functions in SQL, constraints, levels of purity, determinism
Organization of program units PL / SQL
Permissions in PL / SQL
Context name
Integration with other languages
Using JAVA
Linking procedures C language
Native compilation of the C language
Ready solutions
Create the application context
Mechanism of Virtual Private Database (VPD)
Support lobbying
Profiling code
Tracking code
Productivity PL / SQL code
Bind variables in SQL statements and the statistical distribution of
The free use of the basics of SQL and knowledge of Oracle database environment (preferably Oracle 11g completion of training - Native SQL for Programmers - Workshops)
Practical experience in working with Oracle
[overview] =>
For who
The workshop is intended for advanced programmers and Oracle users who seek knowledge and information on the efficient development of information systems in an Oracle database, and the tuning and testing of performance issues in existing applications. This course builds on knowledge often unavailable or incorrectly presented in the technical documentation, and collected during many years of practice leading them instructors. These workshops may be the end of the training path for developers, or a single step for people with extensive experience designing and programming in Oracle
Purpose of training
The workshop aims to provide mechanisms that occur in an Oracle database when performing SQL statements. Allows participants to avoid errors during software development, and explore, diagnose, and resolve performance problems in existing applications.
Particular emphasis is placed on the workshops, where we show the methodology and the practical aspects of the application and tuning SQL statements.
The content of the training
Mechanics perform SQL commands
Managing the process cost optimization
Methods of data storage and indexing
Monitoring database performance and processes based on dictionaries and track system applications
Analysis of cases of the most common problems that cause performance
Notes
The workshops are based on the software version 11g XE
[category_overview] =>
[outline] =>
Application Tuning Methodology
Architecture database and instance
Server processes
Memory structure (SGA, PGA)
Parsing and share cursors
The data files, log files, parameter files
Analysis of the command execution plan
Hypothetical plan (EXPLAIN PLAN, SQLPlus AutoTrac XPlane)
The actual execution plan (V $ SQL_PLAN, XPlane, AWR)
Monitoring the performance and find bottlenecks in the process
Monitoring the current status of the instance by system dictionary views
The monitoring of historical dictionaries
Tracking application (SQLTrace, TkProf, TreSess
The optimization process
Properties cost optimization and regulated
Determination to optimize
Control work cost-based optimizer by:
Session parameters and instance
Tips (hints)
Patterns of query plans
Statistics and Histograms
Impact statistics and histograms for performance
The methods of collecting statistics and histograms
Strategy of counting and estimating statistics
Management statistics: blocking, copying, editing, automation of collection, monitoring changes
Dynamic data sampling (temporary plates, complex predicates)
Multi-column statistics, based on expressions
Statistics System
The logical and physical structure of the database
Spaces tables.
segments
Extensions (EXTENTS)
Blocks
Data storage methods
The physical aspects of the table
temporary Tables
Tables index
external Tables
Partition Table (span, letter, hash, mixed)
Physical reorganization of tables
Materialized views and mechanism QUERY REWRITE
Methods of data indexing
Building B-TREE indexes
Properties index
Indexes: a unique, multi-column, function, inverse
Compression indices
Reconstruction and merging indexes
Virtual indexes
Indexes private and public
Bitmap Indexes and junction
Case study - full-scan data
The impact of a place at the table level and block performance readings
Loading Data conventional and direct path
The order of predicates
Case Study - access to data via the index
Methods of reading index (UNIQUE SCAN RANGE SCAN FULL SCAN FAST FULL SCAN MIN / MAX SCAN)
On-premise, Oracle database management systems can be costly and difficult to maintain for mid and large-scale organizations. Migrating Oracle databases to Azure SQL (also known as Microsoft Azure SQL Database, Microsoft Azure SQL or AzureSQL) or PostgreSQL (also known as Postgres or Postgre SQL) is a practical solution for growing businesses to address database management, maintenance, and scalability at an optimum cost.
This instructor-led, live training (online or onsite) is aimed at database administrators and cloud architects who wish to migrate Oracle databases to Azure SQL or PostgreSQL.
By the end of this training, participants will be able to:
Compare Azure SQL with PostgreSQL to choose the database that best meets business objectives and needs.
Prepare databases to move definitions, data, and procedures from Oracle to AzureSQL or PostgreSQL database system.
Perform post-migration steps to test, optimize, update, and maintain a migrated database.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at database administrators and cloud architects who wish to migrate Oracle databases to Azure SQL or PostgreSQL.
By the end of this training, participants will be able to:
Compare Azure SQL with PostgreSQL to choose the database that best meets business objectives and needs.
Prepare databases to move definitions, data, and procedures from Oracle to AzureSQL or PostgreSQL database system.
Perform post-migration steps to test, optimize, update, and maintain a migrated database.
[outline] =>
Introduction
Overview of Oracle Migration to Azure SQL or PostgreSQL
Designing a Proof of Concept Solution
Comparing Azure SQL Database With PostgreSQL Database
Configuring SQL Server Instances
Setting up Oracle Express Edition
Preparing the Database for Migration
Migrating SQL Server to Azure SQL
Deploying Post Upgrade Enhancements
Migrating Oracle Database to SQL Server 2017
Migrating the Application to Azure SQL
Migrating SQL Server to PostgreSQL
Preparing Oracle Database Migration to PostgreSQL
Migrating the Database and Application to PostgreSQL
The course is only suitable for those who have some knowledge of SQL.
Previous experience with an interactive computer system is desirable but not essential.
[overview] =>
This 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 18c is the next iteration of Oracle Database 12c Release 2, or "the first patch".
This instructor-led, live training (online or onsite) is aimed at engineers who wish to set up, deploy, migrate to and manage an Oracle 18c Database.
By the end of this training, participants will be able to:
Understand the major feature and architectural changes from previous Oracle versions.
Migrate to Oracle 18c from a previous version.
Deploy Oracle 18c in cloud or on premise.
Understand Oracle 18c's new yearly release cycle and plan maintenance around it.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at engineers who wish to set up, deploy, migrate to and manage an Oracle 18c Database.
By the end of this training, participants will be able to:
Understand the major feature and architectural changes from previous Oracle versions.
Migrate to Oracle 18c from a previous version.
Deploy Oracle 18c in cloud or on premise.
Understand Oracle 18c's new yearly release cycle and plan maintenance around it.
[outline] =>
Introduction
Oracle 18c and Oracle’s Autonomous Database Cloud
Overview of Oracle 18c Features and Architecture
On-premises and in cloud
Oracle 18c Incremental Enhancements over Oracle Database 12c Release 2.
Performance, High Availability, Multitenant Architecture, Security, Data Warehousing and Application Development
Oracle 18c Major Enhancements over Older Versions
Multitenant, Database In-Memory, Database Sharding, Connection Manager, etc.
Oracle 18c Deprecated Features from Older Versions
Non-CDB architecture, Oracle Streams, Oracle Multimedia, Oracle Administration Assistant for Windows, etc.
Upgrading from Previous Versions of Oracle
Multi-step Upgrade (10g => 12c => 18c)
Datadump "Upgrade" (Import/Export)
Understanding Oracle's Autonomous Database Cloud
Cost-based Optimization, Performance Tuning and Diagnostics, Data Automization, Cloud Operations
Automating Routine Administrative Tasks
Self-driving, Self-securing, Self-repairing
Deploying Oracle to a Public, Private and Hybrid Cloud
Oracle Database 21c is a converged database that supports a large range of workloads and data models. It’s a data management platform that provides high performance, security, availability, and scalability for cloud environments.
This instructor-led, live training (online or onsite) is aimed at database administrators who wish to learn and use the features of Oracle Database 21c in performing administrative tasks.
By the end of this training, participants will be able to:
Understand the core concepts of Oracle Database 21c administration.
Understand the Oracle 21c architecture.
Learn how to perform administration tasks on Oracle 21c.
Understand the Oracle 21c backup and recovery process.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at database administrators who wish to learn and use the features of Oracle Database 21c in performing administrative tasks.
By the end of this training, participants will be able to:
Understand the core concepts of Oracle Database 21c administration.
Understand the Oracle 21c architecture.
Learn how to perform administration tasks on Oracle 21c.
Understand the Oracle 21c backup and recovery process.
[outline] =>
Introduction
Introduction to Oracle Cloud
Overview of Oracle Database 21c
Oracle Database Architecture
Overview of the Oracle Database architecture
Configuring and connecting to the Oracle Database Instance
Understanding the Oracle Database memory structures
Process architecture and structures
Process startup sequence
Storage architecture
Database Instance
Overview of the Oracle Database management tools
Enterprise manager management framework
Setting Up the Oracle Network Environment
Overview of the Oracle Net Services and Oracle Net Listener
Oracle Network Connections
Configuring the Oracle Network tools
Listener Control Utility
Oracle Net configuration assistant
Oracle Net Manager
Enterprise Manager Cloud Control
Database Storage Structures
Overview of Database Block Content
Storage structure
Creating and managing Tablespaces
Navigating and viewing Tablespace information
Using Oracle managed files
User Security
Managing database user accounts
Predefined administrative accounts
Creating a user account
Authentication and password reset
Understanding the concept of privileges, roles, and profiles
Data Concurrency
Understanding the locking mechanism
Understanding data concurrency
DML locks
Enqueue mechanism
Lock conflicts
Undo Data
Overview of Undo data
Managing transactions and storing Undo information
No prior Oracle Business Intelligence experience required
Audience
Business analysts
Data analysts
Business intelligence professionals
[overview] =>
Oracle Business Intelligence (OBI) provides a comprehensive set of tools for analyzing, reporting, and visualizing data.
This instructor-led, live training (online or onsite) is aimed at beginner-level business analysts and data analysts who wish to leverage Oracle BI to extract valuable insights from their data.
By the end of this training, participants will be able to:
Navigate and utilize the Oracle BI interface effectively.
Create and customize reports and dashboards tailored to business needs.
Conduct ad-hoc analysis using various BI tools.
Utilize advanced features for comprehensive data exploration.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at beginner-level business analysts and data analysts who wish to leverage Oracle BI to extract valuable insights from their data.
By the end of this training, participants will be able to:
Navigate and utilize the Oracle BI interface effectively.
Create and customize reports and dashboards tailored to business needs.
Conduct ad-hoc analysis using various BI tools.
Utilize advanced features for comprehensive data exploration.
[outline] =>
Introduction
Overview of Oracle Business Intelligence
Key features and components
Understanding the BI life cycle
Navigating the Oracle BI Interface
Accessing and logging into Oracle BI
Exploring the BI dashboard
Overview of key tools: Oracle Answers, Oracle Dashboards, etc.
Creating Basic Reports with Oracle Answers
Building a simple report
Formatting and styling options
Implementing basic calculations
Exporting and sharing reports
Advanced Reporting Techniques
Working with advanced visualizations
Incorporating statistical analysis
Implementing conditional formatting
Mastering drill-down and drill-up techniques
Data Exploration and Analysis with Oracle Dashboards
Introduction to Oracle Dashboards
Conducting ad-hoc analysis
Integrating Dashboards with other Oracle BI tools
Advanced analysis features
Dashboard Design Best Practices
Overview of dashboard design principles
Creating and customizing dashboards
Implementing interactivity in dashboards
Best practices for effective dashboard design
Data Visualization Best Practices
Principles of effective data visualization
Creating compelling visualizations with Oracle BI tools
Oracle Database 19c is a multi-model database that provides full support for relational and non-relational data.
This instructor-led, live training (online or onsite) is aimed at system administrators who wish to learn how to administer, monitor, and support an Oracle database.
By the end of this training, participants will be able to:
Understand the major feature and architectural changes Oracle database.
Manage and monitor Oracle databases.
Optimize Oracle database performance.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at system administrators who wish to learn how to administer, monitor, and support an Oracle database.
By the end of this training, participants will be able to:
Understand the major feature and architectural changes Oracle database.
Manage and monitor Oracle databases.
Optimize Oracle database performance.
[outline] =>
Introduction
Overview of Oracle database server architecture
Overview of Oracle multitenant container database
Oracle database instance and database sharding
Accessing Oracle Database
Connecting to an Oracle database instance
Using Oracle database tools
SQL*Plus
Using Oracle SQL developer
Using Database Configuration Assistant (DBCA)
Understanding the Enterprise Manager cloud control 13c features
Overview of Oracle Enterprise Manager component
Single pane of glass for enterprise management
Managing Oracle Enterprise Manager database
Creating an Oracle Database
Creating an Oracle database using DBCA
Creating an Oracle database using an SQL command
Working with Database Instances
Starting the Oracle database instance
Shutting down an Oracle database instance
Comparing Shutdown modes
Opening and closing PDBs
Configuring PDBs
Managing Database Instances
Using initialization parameters
Working with the automatic diagnostic repository
Viewing the alert log
Using trace files
Administering the DDL log file
Working with dynamic performance views
Using a data dictionary
Overview of Oracle Net Services
Defining components of Oracle net services
Configuring and managing Oracle net services
Overview of Oracle net listener
Comparing dedicated and shared server architecture
Naming Methods
Establishing Oracle network connections
Understanding the naming methods
Easy connect
Local and directory naming
Managing workloads using database services
Creating database services
Working with the Listener
Using the default listener
Configuring dynamic service registration
Configuring static service registration
Configuring a Shared Server Architecture
Enabling a shared server
Controlling shared server operations
Using SGA and PGA
Shared server configuration considerations
Configuring Oracle Connect Manager
Understanding Oracle Connection Manager
Using filtering rules
Implementing intranet and internet access control
Using session multiplexing
Configuring Oracle Connection Manager
Configuring the cman.ora file
Configuring clients
Configuring the database server
Using the Oracle Connection Manager control utility
Oracle Database 19c is a multi-model database that provides full support for relational and non-relational data.
This instructor-led, live training (online or onsite) is aimed at system administrators who wish to have a comprehensive understanding of the security features of Oracle Database 19c.
By the end of this training, participants will be able to:
Understand the concepts of database security.
Implement authentication and authorization mechanisms to control access to the database.
Configure and manage user accounts, roles, and privileges effectively.
Implement robust security measures against various threats and vulnerabilities.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at system administrators who wish to have a comprehensive understanding of the security features of Oracle Database 19c.
By the end of this training, participants will be able to:
Understand the concepts of database security.
Implement authentication and authorization mechanisms to control access to the database.
Configure and manage user accounts, roles, and privileges effectively.
Implement robust security measures against various threats and vulnerabilities.
[outline] =>
Introduction
Overview of Oracle database 19c security
Understanding the importance of database security
Security Overview
Understanding network security
Defining a security policy
Authentication, Authorization, and User Management
Configuring authentication methods
Managing user accounts, roles, and profiles
Granting and revoking privileges
Implementing fine-grained access control
Managing database links and security implications
Data Encryption
Understanding encryption concepts and algorithms
Configuring encryptions
Implementing database auditing and monitoring
Responding to security incidents and breaches
Oracle Database 19c Advanced Security
Configuring realms, rules, and secure application roles
Oracle Fusion Human Capital Management (HCM) is a complete cloud solution that provides a modern set of tools to support complex human resource processes and workforce management.
This instructor-led, live training (online or onsite) is aimed at professionals who wish to learn the fundamental concepts of Oracle Fusion and implement Oracle Fusion HCM in their organization.
By the end of this training, participants will be able to:
Learn and understand the concepts of Oracle Fusion Human Capital Management (HCM).
Implement complete workforce structure management in any organization.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at professionals who wish to learn the fundamental concepts of Oracle Fusion and implement Oracle Fusion HCM in their organization.
By the end of this training, participants will be able to:
Learn and understand the concepts of Oracle Fusion Human Capital Management (HCM).
Implement complete workforce structure management in any organization.
[outline] =>
Introduction
Overview of Oracle Fusion HCM
Understanding the UI
Getting Started with Oracle Fusion HCM
Implementing Oracle Fusion
Preparing Fusion applications
User and role management
Synchronizing users and roles in LDAP
Functional setup manager
Workforce Management and Work Structure
Human resources
Workforce lifecycle manager
Managing profiles, performance, and goals
Managing compensation
Employment models
Managing work structures
Payroll Management
Payroll overview
HCM security overview
Configuring payroll
Creating and defining payroll element entries
Calculating payroll
Defining payment methods
Payroll costing
Defining payroll flow patterns
Goals Management
Concepts and actions of goal management
Setting up goal management
Understanding lookups, flex fields, and profile options
Creating and managing goal plans
Managing worker and organization goals
Administering and assigning goals
Approving goals
Understanding questionnaire concepts
Managing questions
Using question library
Creating questionnaires
Using questionnaire templates
Defining worker performance
Using performance management
Managing performance documents and worker evaluations
Monitoring tasks for worker performance
Absence Management
Setting up absence management
Overview of absence types
Understanding absence patterns and features
Absence types, plans, and reasons
Scheduling absences
Managing absence records and entitlements
Understanding absence recording
Absence approvals
Monitoring absence process
Time and Labor Management
Time card layout components
Managing HCM groups
Creating time card components
Understanding time card calculation rules
Managing worker time entry profile
Managing time processing profile
Loading timecards
Summary and Next Steps
[language] => en
[duration] => 28
[status] => published
[changed] => 1700037885
[source_title] => Oracle Fusion Human Capital Management (HCM)
[source_language] => en
[cert_code] =>
[weight] => -12
[excluded_sites] =>
[use_mt] => stdClass Object
(
[field_overview] =>
[field_course_outline] =>
[field_prerequisits] =>
[field_overview_in_category] =>
)
[cc] => oraclefusionhcm
)
[oraclelinux8] => stdClass Object
(
[course_code] => oraclelinux8
[hr_nid] => 435831
[title] => Oracle Linux 8: System Administration I
[requirements] =>
Knowledge of Linux system
Audience
System administrator
Technical consultant
Database administrator
[overview] =>
Oracle Linux is a high-performance and secure operating environment that delivers an easy-to-manage environment for virtualization, management, automation, and cloud-native computing tools.
This instructor-led, live training (online or onsite) is aimed at system administrators who wish to learn how to use and manage an Oracle Linux 8 system.
By the end of this training, participants will be able to:
Configure passwordless authentication.
Administer user and group accounts.
Configure network interface.
Monitor and troubleshoot Oracle Linux.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at system administrators who wish to learn how to use and manage an Oracle Linux 8 system.
By the end of this training, participants will be able to:
Configure passwordless authentication.
Administer user and group accounts.
Configure network interface.
Monitor and troubleshoot Oracle Linux.
[outline] =>
Introduction
Overview of Oracle Linux
Exploring the gateway machine
Exploring the host VM
Getting Started with Oracle Linux
Installing Oracle Linux 8
Connecting to a remote server by using SSH
Configuring OpenSSH
Using the GRUB Bootloader
Overview of the GRUB Bootloader
Configuring the GRUB 2 Bootloader
Exploring the GRUB 2 Bootloader
Booting different kernels
Introduction to Systemd
Overview of systemd
Understanding the service unit file
Using grub menu and command line
Using systemd units
Using systemd service units
Managing Time
Managing system tasks
Configuring date and time
Configuring Chrony
Automating tasks
Configuring Device and Kenel
Understanding the sysfs file system
Updating using DNF
Using loadable kernel modules
Using /proc file and sysfs file system
Using the sysctl utility
Configuring udev rules
Managing Packages
Installing, updating, or removing packages using dnf
Oracle APEX or Oracle Application Express is an application development service in Oracle Database. It provides a fully-integrated, secure, and low-code platform for building and deploying applications.
This instructor-led, live training (online or onsite) is aimed at developers who wish to use Oracle APEX to develop, scale, and deploy applications faster with less code.
By the end of this training, participants will be able to:
Set up the necessary development environment to start developing database apps with Oracle APEX.
Understand and explore the Oracle APEX tools to build a fully-featured application.
Learn how to create applications and pages using Oracle APEX and the Page Designer UI.
Extend the functionality of complex enterprise apps easily with Oracle APEX.
Optimize and scale application performance and deployment.
Control and secure access to application data and components.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at developers who wish to use Oracle APEX to develop, scale, and deploy applications faster with less code.
By the end of this training, participants will be able to:
Set up the necessary development environment to start developing database apps with Oracle APEX.
Understand and explore the Oracle APEX tools to build a fully-featured application.
Learn how to create applications and pages using Oracle APEX and the Page Designer UI.
Extend the functionality of complex enterprise apps easily with Oracle APEX.
Optimize and scale application performance and deployment.
Control and secure access to application data and components.
The workshop is intended for beginners, starting to work with the Oracle database, future administrators and users of systems based on this database need able to use the SQL language for the extraction and modification of the information contained in the systems.
Exams and Certificates
The training plan coincides with the material required to pass the exam: 1Z0-051 Oracle Database 11g: SQL Fundamentals I, the first step to getting most certifications Oracle's Database
Purpose of training
The workshop aims to introduce participants to work with the Oracle database, making them familiar with the SQL language to the extent required for the efficient operation of the system and to take in the future obligations of database applications and Oracle databases.
The content of the training
The organization of the working environment
Introduction to relational databases
Extraction of the data using the SELECT statement
Modifying data using INSERT, UPDATE, DELETE
Overview of schema objects
Remarks
The workshops are based on 11g XE software
[category_overview] =>
[outline] =>
Introduction to Oracle
Database Architecture
Relational model database
Users diagrams sessions
Tools
Introduction to the SELECT statement
Screening and selection (WHERE clause)
sorting
Data types, operators, and service NULL
Built-in scalar functions
Actions to date
National and regional settings in SQL
Regular expressions
The analysis of aggregated data
Grouping functions
DISTINCT clause
Clauses GROUP BY and HAVING
Retrieving data from multiple tables
Inner and outer joins (INNER JOIN, OUTER JOIN)
ANSI SQL syntax, and other methods connectors (SELF JOIN, NATURAL JOIN)
Collective operators (UNION, UNION ALL, INTERSECT, MINUS)
Subqueries
Subqueries simple
Correlated subqueries
Operators EXISTS and NOT EXISTS
Other types of subqueries
Inquiries hierarchical and samples
Construction of the tree (CONNECT BY PRIOR clause and START WITH)
The SYS_CONNECT_BY_PATH
Data samples (SAMPLE clause)
Data manipulation (DML)
INSERT, UPDATE, DELETE
Operations on a large set of (INSERT FIRST INSERT ALL, MERGE)
Workshops are dedicated as a first step for developers and designers of applications based on Oracle databases. Participants do not need to have any prior knowledge of the Oracle database, or other relational database systems, even though such knowledge may be useful.
Exams and Certificates
The plan covers the training material required to pass the exam 1Z0-047 Oracle Database SQL Expert and obtain the title of Oracle Database SQL Certified Expert
Purpose of training
The workshop aims to familiarize participants with the Oracle database techniques to build database structures and data manipulation. Particular emphasis is placed on the participant to see across the board, which offers opportunities to design and build applications Relational Database Management System, Oracle Database, and to be able to independently work with her.
The content of the training
Introduction to database technology and the organization of the work environment
Acquisition and modification of data
Construction of the repository application
Safety and concurrency runtime
Notes
The workshops are based on the software version 11g XE
[category_overview] =>
[outline] =>
Introduction to the Oracle database
Database Architecture
Relational model database
Users diagrams sessions
Tools
Introduction to the SELECT statement
Screening and selection (WHERE clause)
Sorting
Data types, operators, and service NULL
Built-in scalar functions
Actions to date
National and regional settings in SQL
The analysis of aggregated data
Funkcje grupujące
Klauzula distinct
Klauzule GROUP BY and having
Retrieving data from multiple tables
Inner and outer joins (INNER JOIN, OUTER JOIN)
ANSI SQL syntax, and other methods connectors (SELF JOIN, NATURAL JOIN)
Collective operators (UNION, UNION ALL, INTERSECT, MINUS)
Subqueries
Subqueries simple
Correlated subqueries
Operators EXISTS and NOT EXISTS
Other types of subqueries
Inquiries hierarchical and samples
Construction of the tree (CONNECT BY PRIOR clause and START WITH)
The SYS_CONNECT_BY_PATH
Data samples (SAMPLE clause)
Data manipulation (DML)
"INSTRUCCIONES INSERT, UPDATE, DELETE
Operacja na dużych zbiorach (INSERT FIRST, ALL INSERT, MERGE)
Dictionary system
Concurrent users work
Transactions
Locks
FLASHBACK
Users and Permissions
Creating and modifying user patterns
Permissions and roles
Managing data storage - logical layer
Tables, temporary tables, index-organized tables
Limitations
Indexes
The views, sequences, synonyms, materialized views
Units stored PL / SQL
Modeling and restore the data model using Oracle SQL Modeler
Moving Data
A logical copy of the data - datapump import and export
Basic skills in any programming language, object-oriented structural or
The free use of the basics of SQL and knowledge of Oracle database environment (preferably Oracle 11g completion of training - Native SQL for Programmers - Workshops)
[overview] =>
For who
Workshops are dedicated to developers, end users and administrators, who until now have had no contact with the language PL / SQL, and the need to exploit its huge potential in working with a database, automate processes, and in building applications
Exams and Certificates
The plan covers the training material required to pass the exam 1Z0-144 Oracle Database 11g Program with PL / SQL and obtain the title of Oracle PL / SQL Developer Certified Associate
Purpose of training
The workshop aims to familiarize participants with the programming language PL / SQL, its capabilities and limitations. This workshop will include a full understanding of the mechanisms involved in the programming language PL / SQL needed to implement the logic of the free applications, automation of data processing and database management.
The content of the training
Introduction to PL / SQL architecture solutions based on this language, the organization of the working environment
Create scripts and stored program units that operate on data
Notes
The workshops are based on the software version 11g XE
[category_overview] =>
[outline] =>
Introduction to PL / SQL
Runtime Environment
Construction and types of PL / SQL blocks
Declaring and using variables
Control statements, decisions, loops
SQL statements in PL / SQL
DML commands
DDL and dynamic SQL
TCL commands and transactional
SELECT
Procedures and Functions
Create and delete
Parameterization
Passing parameters by value and reference, nocopy
Handling errors and exceptions
Create and use cursors
Records
static cursors
Parameterizing cursors
Cursor FOR UPDATE
Associative arrays
Packages
The structure of the package: the specification and body
Section Initialization and global variables, memory management, an instance of the package
The free use of the basics of SQL and knowledge of Oracle database environment (preferably Oracle 11g completion of training - Native SQL for Programmers - Workshops)
Fluency in the basics of PL / SQL (preferably Oracle 11g completion of training - Programming with PL / SQL I - Workshops)
[overview] =>
For who
This training is in addition to, and continuation of the 'Oracle 11g - Programming in PL / SQL and - workshops ", but can also be designed for practitioners, developers, PL / SQL who already have experience with the language, and who want to systematize their knowledge and learn advanced mechanisms and solutions developed in this language.
The content of the training
Objects, streams and complex data structures
Advanced solutions based on PL / SQL
Exams and Certificates
The plan covers the training material required to pass the exam 1Z0-146 Oracle Advanced PL / SQL and obtain the title of Oracle Advanced PL / SQL Developer Certified Professional
Purpose of training
The training is designed to familiarize participants with the advanced aspects of programming in an Oracle database. The emphasis is on flexibility and performance solutions based on PL / SQL.
Notes
The workshops are based on the software version 11g XE
[category_overview] =>
[outline] =>
Complex data types, collections
Subtypes
Cursor variables and dynamic cursors
Associative arrays, collections
Actions mass, bulk, forall
Exception handling bulk operations
Object orientation in an Oracle database
Types (classes)
methods of objects
permanent Collections
Functions Panel
streaming Features
Create your own aggregate functions
Calling functions in SQL, constraints, levels of purity, determinism
Organization of program units PL / SQL
Permissions in PL / SQL
Context name
Integration with other languages
Using JAVA
Linking procedures C language
Native compilation of the C language
Ready solutions
Create the application context
Mechanism of Virtual Private Database (VPD)
Support lobbying
Profiling code
Tracking code
Productivity PL / SQL code
Bind variables in SQL statements and the statistical distribution of
The free use of the basics of SQL and knowledge of Oracle database environment (preferably Oracle 11g completion of training - Native SQL for Programmers - Workshops)
Practical experience in working with Oracle
[overview] =>
For who
The workshop is intended for advanced programmers and Oracle users who seek knowledge and information on the efficient development of information systems in an Oracle database, and the tuning and testing of performance issues in existing applications. This course builds on knowledge often unavailable or incorrectly presented in the technical documentation, and collected during many years of practice leading them instructors. These workshops may be the end of the training path for developers, or a single step for people with extensive experience designing and programming in Oracle
Purpose of training
The workshop aims to provide mechanisms that occur in an Oracle database when performing SQL statements. Allows participants to avoid errors during software development, and explore, diagnose, and resolve performance problems in existing applications.
Particular emphasis is placed on the workshops, where we show the methodology and the practical aspects of the application and tuning SQL statements.
The content of the training
Mechanics perform SQL commands
Managing the process cost optimization
Methods of data storage and indexing
Monitoring database performance and processes based on dictionaries and track system applications
Analysis of cases of the most common problems that cause performance
Notes
The workshops are based on the software version 11g XE
[category_overview] =>
[outline] =>
Application Tuning Methodology
Architecture database and instance
Server processes
Memory structure (SGA, PGA)
Parsing and share cursors
The data files, log files, parameter files
Analysis of the command execution plan
Hypothetical plan (EXPLAIN PLAN, SQLPlus AutoTrac XPlane)
The actual execution plan (V $ SQL_PLAN, XPlane, AWR)
Monitoring the performance and find bottlenecks in the process
Monitoring the current status of the instance by system dictionary views
The monitoring of historical dictionaries
Tracking application (SQLTrace, TkProf, TreSess
The optimization process
Properties cost optimization and regulated
Determination to optimize
Control work cost-based optimizer by:
Session parameters and instance
Tips (hints)
Patterns of query plans
Statistics and Histograms
Impact statistics and histograms for performance
The methods of collecting statistics and histograms
Strategy of counting and estimating statistics
Management statistics: blocking, copying, editing, automation of collection, monitoring changes
Dynamic data sampling (temporary plates, complex predicates)
Multi-column statistics, based on expressions
Statistics System
The logical and physical structure of the database
Spaces tables.
segments
Extensions (EXTENTS)
Blocks
Data storage methods
The physical aspects of the table
temporary Tables
Tables index
external Tables
Partition Table (span, letter, hash, mixed)
Physical reorganization of tables
Materialized views and mechanism QUERY REWRITE
Methods of data indexing
Building B-TREE indexes
Properties index
Indexes: a unique, multi-column, function, inverse
Compression indices
Reconstruction and merging indexes
Virtual indexes
Indexes private and public
Bitmap Indexes and junction
Case study - full-scan data
The impact of a place at the table level and block performance readings
Loading Data conventional and direct path
The order of predicates
Case Study - access to data via the index
Methods of reading index (UNIQUE SCAN RANGE SCAN FULL SCAN FAST FULL SCAN MIN / MAX SCAN)
On-premise, Oracle database management systems can be costly and difficult to maintain for mid and large-scale organizations. Migrating Oracle databases to Azure SQL (also known as Microsoft Azure SQL Database, Microsoft Azure SQL or AzureSQL) or PostgreSQL (also known as Postgres or Postgre SQL) is a practical solution for growing businesses to address database management, maintenance, and scalability at an optimum cost.
This instructor-led, live training (online or onsite) is aimed at database administrators and cloud architects who wish to migrate Oracle databases to Azure SQL or PostgreSQL.
By the end of this training, participants will be able to:
Compare Azure SQL with PostgreSQL to choose the database that best meets business objectives and needs.
Prepare databases to move definitions, data, and procedures from Oracle to AzureSQL or PostgreSQL database system.
Perform post-migration steps to test, optimize, update, and maintain a migrated database.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at database administrators and cloud architects who wish to migrate Oracle databases to Azure SQL or PostgreSQL.
By the end of this training, participants will be able to:
Compare Azure SQL with PostgreSQL to choose the database that best meets business objectives and needs.
Prepare databases to move definitions, data, and procedures from Oracle to AzureSQL or PostgreSQL database system.
Perform post-migration steps to test, optimize, update, and maintain a migrated database.
[outline] =>
Introduction
Overview of Oracle Migration to Azure SQL or PostgreSQL
Designing a Proof of Concept Solution
Comparing Azure SQL Database With PostgreSQL Database
Configuring SQL Server Instances
Setting up Oracle Express Edition
Preparing the Database for Migration
Migrating SQL Server to Azure SQL
Deploying Post Upgrade Enhancements
Migrating Oracle Database to SQL Server 2017
Migrating the Application to Azure SQL
Migrating SQL Server to PostgreSQL
Preparing Oracle Database Migration to PostgreSQL
Migrating the Database and Application to PostgreSQL
The course is only suitable for those who have some knowledge of SQL.
Previous experience with an interactive computer system is desirable but not essential.
[overview] =>
This 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 18c is the next iteration of Oracle Database 12c Release 2, or "the first patch".
This instructor-led, live training (online or onsite) is aimed at engineers who wish to set up, deploy, migrate to and manage an Oracle 18c Database.
By the end of this training, participants will be able to:
Understand the major feature and architectural changes from previous Oracle versions.
Migrate to Oracle 18c from a previous version.
Deploy Oracle 18c in cloud or on premise.
Understand Oracle 18c's new yearly release cycle and plan maintenance around it.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at engineers who wish to set up, deploy, migrate to and manage an Oracle 18c Database.
By the end of this training, participants will be able to:
Understand the major feature and architectural changes from previous Oracle versions.
Migrate to Oracle 18c from a previous version.
Deploy Oracle 18c in cloud or on premise.
Understand Oracle 18c's new yearly release cycle and plan maintenance around it.
[outline] =>
Introduction
Oracle 18c and Oracle’s Autonomous Database Cloud
Overview of Oracle 18c Features and Architecture
On-premises and in cloud
Oracle 18c Incremental Enhancements over Oracle Database 12c Release 2.
Performance, High Availability, Multitenant Architecture, Security, Data Warehousing and Application Development
Oracle 18c Major Enhancements over Older Versions
Multitenant, Database In-Memory, Database Sharding, Connection Manager, etc.
Oracle 18c Deprecated Features from Older Versions
Non-CDB architecture, Oracle Streams, Oracle Multimedia, Oracle Administration Assistant for Windows, etc.
Upgrading from Previous Versions of Oracle
Multi-step Upgrade (10g => 12c => 18c)
Datadump "Upgrade" (Import/Export)
Understanding Oracle's Autonomous Database Cloud
Cost-based Optimization, Performance Tuning and Diagnostics, Data Automization, Cloud Operations
Automating Routine Administrative Tasks
Self-driving, Self-securing, Self-repairing
Deploying Oracle to a Public, Private and Hybrid Cloud
Oracle Database 21c is a converged database that supports a large range of workloads and data models. It’s a data management platform that provides high performance, security, availability, and scalability for cloud environments.
This instructor-led, live training (online or onsite) is aimed at database administrators who wish to learn and use the features of Oracle Database 21c in performing administrative tasks.
By the end of this training, participants will be able to:
Understand the core concepts of Oracle Database 21c administration.
Understand the Oracle 21c architecture.
Learn how to perform administration tasks on Oracle 21c.
Understand the Oracle 21c backup and recovery process.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at database administrators who wish to learn and use the features of Oracle Database 21c in performing administrative tasks.
By the end of this training, participants will be able to:
Understand the core concepts of Oracle Database 21c administration.
Understand the Oracle 21c architecture.
Learn how to perform administration tasks on Oracle 21c.
Understand the Oracle 21c backup and recovery process.
[outline] =>
Introduction
Introduction to Oracle Cloud
Overview of Oracle Database 21c
Oracle Database Architecture
Overview of the Oracle Database architecture
Configuring and connecting to the Oracle Database Instance
Understanding the Oracle Database memory structures
Process architecture and structures
Process startup sequence
Storage architecture
Database Instance
Overview of the Oracle Database management tools
Enterprise manager management framework
Setting Up the Oracle Network Environment
Overview of the Oracle Net Services and Oracle Net Listener
Oracle Network Connections
Configuring the Oracle Network tools
Listener Control Utility
Oracle Net configuration assistant
Oracle Net Manager
Enterprise Manager Cloud Control
Database Storage Structures
Overview of Database Block Content
Storage structure
Creating and managing Tablespaces
Navigating and viewing Tablespace information
Using Oracle managed files
User Security
Managing database user accounts
Predefined administrative accounts
Creating a user account
Authentication and password reset
Understanding the concept of privileges, roles, and profiles
Data Concurrency
Understanding the locking mechanism
Understanding data concurrency
DML locks
Enqueue mechanism
Lock conflicts
Undo Data
Overview of Undo data
Managing transactions and storing Undo information
No prior Oracle Business Intelligence experience required
Audience
Business analysts
Data analysts
Business intelligence professionals
[overview] =>
Oracle Business Intelligence (OBI) provides a comprehensive set of tools for analyzing, reporting, and visualizing data.
This instructor-led, live training (online or onsite) is aimed at beginner-level business analysts and data analysts who wish to leverage Oracle BI to extract valuable insights from their data.
By the end of this training, participants will be able to:
Navigate and utilize the Oracle BI interface effectively.
Create and customize reports and dashboards tailored to business needs.
Conduct ad-hoc analysis using various BI tools.
Utilize advanced features for comprehensive data exploration.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at beginner-level business analysts and data analysts who wish to leverage Oracle BI to extract valuable insights from their data.
By the end of this training, participants will be able to:
Navigate and utilize the Oracle BI interface effectively.
Create and customize reports and dashboards tailored to business needs.
Conduct ad-hoc analysis using various BI tools.
Utilize advanced features for comprehensive data exploration.
[outline] =>
Introduction
Overview of Oracle Business Intelligence
Key features and components
Understanding the BI life cycle
Navigating the Oracle BI Interface
Accessing and logging into Oracle BI
Exploring the BI dashboard
Overview of key tools: Oracle Answers, Oracle Dashboards, etc.
Creating Basic Reports with Oracle Answers
Building a simple report
Formatting and styling options
Implementing basic calculations
Exporting and sharing reports
Advanced Reporting Techniques
Working with advanced visualizations
Incorporating statistical analysis
Implementing conditional formatting
Mastering drill-down and drill-up techniques
Data Exploration and Analysis with Oracle Dashboards
Introduction to Oracle Dashboards
Conducting ad-hoc analysis
Integrating Dashboards with other Oracle BI tools
Advanced analysis features
Dashboard Design Best Practices
Overview of dashboard design principles
Creating and customizing dashboards
Implementing interactivity in dashboards
Best practices for effective dashboard design
Data Visualization Best Practices
Principles of effective data visualization
Creating compelling visualizations with Oracle BI tools
Oracle Database 19c is a multi-model database that provides full support for relational and non-relational data.
This instructor-led, live training (online or onsite) is aimed at system administrators who wish to learn how to administer, monitor, and support an Oracle database.
By the end of this training, participants will be able to:
Understand the major feature and architectural changes Oracle database.
Manage and monitor Oracle databases.
Optimize Oracle database performance.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at system administrators who wish to learn how to administer, monitor, and support an Oracle database.
By the end of this training, participants will be able to:
Understand the major feature and architectural changes Oracle database.
Manage and monitor Oracle databases.
Optimize Oracle database performance.
[outline] =>
Introduction
Overview of Oracle database server architecture
Overview of Oracle multitenant container database
Oracle database instance and database sharding
Accessing Oracle Database
Connecting to an Oracle database instance
Using Oracle database tools
SQL*Plus
Using Oracle SQL developer
Using Database Configuration Assistant (DBCA)
Understanding the Enterprise Manager cloud control 13c features
Overview of Oracle Enterprise Manager component
Single pane of glass for enterprise management
Managing Oracle Enterprise Manager database
Creating an Oracle Database
Creating an Oracle database using DBCA
Creating an Oracle database using an SQL command
Working with Database Instances
Starting the Oracle database instance
Shutting down an Oracle database instance
Comparing Shutdown modes
Opening and closing PDBs
Configuring PDBs
Managing Database Instances
Using initialization parameters
Working with the automatic diagnostic repository
Viewing the alert log
Using trace files
Administering the DDL log file
Working with dynamic performance views
Using a data dictionary
Overview of Oracle Net Services
Defining components of Oracle net services
Configuring and managing Oracle net services
Overview of Oracle net listener
Comparing dedicated and shared server architecture
Naming Methods
Establishing Oracle network connections
Understanding the naming methods
Easy connect
Local and directory naming
Managing workloads using database services
Creating database services
Working with the Listener
Using the default listener
Configuring dynamic service registration
Configuring static service registration
Configuring a Shared Server Architecture
Enabling a shared server
Controlling shared server operations
Using SGA and PGA
Shared server configuration considerations
Configuring Oracle Connect Manager
Understanding Oracle Connection Manager
Using filtering rules
Implementing intranet and internet access control
Using session multiplexing
Configuring Oracle Connection Manager
Configuring the cman.ora file
Configuring clients
Configuring the database server
Using the Oracle Connection Manager control utility
Oracle Database 19c is a multi-model database that provides full support for relational and non-relational data.
This instructor-led, live training (online or onsite) is aimed at system administrators who wish to have a comprehensive understanding of the security features of Oracle Database 19c.
By the end of this training, participants will be able to:
Understand the concepts of database security.
Implement authentication and authorization mechanisms to control access to the database.
Configure and manage user accounts, roles, and privileges effectively.
Implement robust security measures against various threats and vulnerabilities.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at system administrators who wish to have a comprehensive understanding of the security features of Oracle Database 19c.
By the end of this training, participants will be able to:
Understand the concepts of database security.
Implement authentication and authorization mechanisms to control access to the database.
Configure and manage user accounts, roles, and privileges effectively.
Implement robust security measures against various threats and vulnerabilities.
[outline] =>
Introduction
Overview of Oracle database 19c security
Understanding the importance of database security
Security Overview
Understanding network security
Defining a security policy
Authentication, Authorization, and User Management
Configuring authentication methods
Managing user accounts, roles, and profiles
Granting and revoking privileges
Implementing fine-grained access control
Managing database links and security implications
Data Encryption
Understanding encryption concepts and algorithms
Configuring encryptions
Implementing database auditing and monitoring
Responding to security incidents and breaches
Oracle Database 19c Advanced Security
Configuring realms, rules, and secure application roles
Oracle Fusion Human Capital Management (HCM) is a complete cloud solution that provides a modern set of tools to support complex human resource processes and workforce management.
This instructor-led, live training (online or onsite) is aimed at professionals who wish to learn the fundamental concepts of Oracle Fusion and implement Oracle Fusion HCM in their organization.
By the end of this training, participants will be able to:
Learn and understand the concepts of Oracle Fusion Human Capital Management (HCM).
Implement complete workforce structure management in any organization.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at professionals who wish to learn the fundamental concepts of Oracle Fusion and implement Oracle Fusion HCM in their organization.
By the end of this training, participants will be able to:
Learn and understand the concepts of Oracle Fusion Human Capital Management (HCM).
Implement complete workforce structure management in any organization.
[outline] =>
Introduction
Overview of Oracle Fusion HCM
Understanding the UI
Getting Started with Oracle Fusion HCM
Implementing Oracle Fusion
Preparing Fusion applications
User and role management
Synchronizing users and roles in LDAP
Functional setup manager
Workforce Management and Work Structure
Human resources
Workforce lifecycle manager
Managing profiles, performance, and goals
Managing compensation
Employment models
Managing work structures
Payroll Management
Payroll overview
HCM security overview
Configuring payroll
Creating and defining payroll element entries
Calculating payroll
Defining payment methods
Payroll costing
Defining payroll flow patterns
Goals Management
Concepts and actions of goal management
Setting up goal management
Understanding lookups, flex fields, and profile options
Creating and managing goal plans
Managing worker and organization goals
Administering and assigning goals
Approving goals
Understanding questionnaire concepts
Managing questions
Using question library
Creating questionnaires
Using questionnaire templates
Defining worker performance
Using performance management
Managing performance documents and worker evaluations
Monitoring tasks for worker performance
Absence Management
Setting up absence management
Overview of absence types
Understanding absence patterns and features
Absence types, plans, and reasons
Scheduling absences
Managing absence records and entitlements
Understanding absence recording
Absence approvals
Monitoring absence process
Time and Labor Management
Time card layout components
Managing HCM groups
Creating time card components
Understanding time card calculation rules
Managing worker time entry profile
Managing time processing profile
Loading timecards
Summary and Next Steps
[language] => en
[duration] => 28
[status] => published
[changed] => 1700037885
[source_title] => Oracle Fusion Human Capital Management (HCM)
[source_language] => en
[cert_code] =>
[weight] => -12
[excluded_sites] =>
[use_mt] => stdClass Object
(
[field_overview] =>
[field_course_outline] =>
[field_prerequisits] =>
[field_overview_in_category] =>
)
[cc] => oraclefusionhcm
)
[oraclelinux8] => stdClass Object
(
[course_code] => oraclelinux8
[hr_nid] => 435831
[title] => Oracle Linux 8: System Administration I
[requirements] =>
Knowledge of Linux system
Audience
System administrator
Technical consultant
Database administrator
[overview] =>
Oracle Linux is a high-performance and secure operating environment that delivers an easy-to-manage environment for virtualization, management, automation, and cloud-native computing tools.
This instructor-led, live training (online or onsite) is aimed at system administrators who wish to learn how to use and manage an Oracle Linux 8 system.
By the end of this training, participants will be able to:
Configure passwordless authentication.
Administer user and group accounts.
Configure network interface.
Monitor and troubleshoot Oracle Linux.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at system administrators who wish to learn how to use and manage an Oracle Linux 8 system.
By the end of this training, participants will be able to:
Configure passwordless authentication.
Administer user and group accounts.
Configure network interface.
Monitor and troubleshoot Oracle Linux.
[outline] =>
Introduction
Overview of Oracle Linux
Exploring the gateway machine
Exploring the host VM
Getting Started with Oracle Linux
Installing Oracle Linux 8
Connecting to a remote server by using SSH
Configuring OpenSSH
Using the GRUB Bootloader
Overview of the GRUB Bootloader
Configuring the GRUB 2 Bootloader
Exploring the GRUB 2 Bootloader
Booting different kernels
Introduction to Systemd
Overview of systemd
Understanding the service unit file
Using grub menu and command line
Using systemd units
Using systemd service units
Managing Time
Managing system tasks
Configuring date and time
Configuring Chrony
Automating tasks
Configuring Device and Kenel
Understanding the sysfs file system
Updating using DNF
Using loadable kernel modules
Using /proc file and sysfs file system
Using the sysctl utility
Configuring udev rules
Managing Packages
Installing, updating, or removing packages using dnf
Oracle APEX or Oracle Application Express is an application development service in Oracle Database. It provides a fully-integrated, secure, and low-code platform for building and deploying applications.
This instructor-led, live training (online or onsite) is aimed at developers who wish to use Oracle APEX to develop, scale, and deploy applications faster with less code.
By the end of this training, participants will be able to:
Set up the necessary development environment to start developing database apps with Oracle APEX.
Understand and explore the Oracle APEX tools to build a fully-featured application.
Learn how to create applications and pages using Oracle APEX and the Page Designer UI.
Extend the functionality of complex enterprise apps easily with Oracle APEX.
Optimize and scale application performance and deployment.
Control and secure access to application data and components.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at developers who wish to use Oracle APEX to develop, scale, and deploy applications faster with less code.
By the end of this training, participants will be able to:
Set up the necessary development environment to start developing database apps with Oracle APEX.
Understand and explore the Oracle APEX tools to build a fully-featured application.
Learn how to create applications and pages using Oracle APEX and the Page Designer UI.
Extend the functionality of complex enterprise apps easily with Oracle APEX.
Optimize and scale application performance and deployment.
Control and secure access to application data and components.
The workshop is intended for beginners, starting to work with the Oracle database, future administrators and users of systems based on this database need able to use the SQL language for the extraction and modification of the information contained in the systems.
Exams and Certificates
The training plan coincides with the material required to pass the exam: 1Z0-051 Oracle Database 11g: SQL Fundamentals I, the first step to getting most certifications Oracle's Database
Purpose of training
The workshop aims to introduce participants to work with the Oracle database, making them familiar with the SQL language to the extent required for the efficient operation of the system and to take in the future obligations of database applications and Oracle databases.
The content of the training
The organization of the working environment
Introduction to relational databases
Extraction of the data using the SELECT statement
Modifying data using INSERT, UPDATE, DELETE
Overview of schema objects
Remarks
The workshops are based on 11g XE software
[category_overview] =>
[outline] =>
Introduction to Oracle
Database Architecture
Relational model database
Users diagrams sessions
Tools
Introduction to the SELECT statement
Screening and selection (WHERE clause)
sorting
Data types, operators, and service NULL
Built-in scalar functions
Actions to date
National and regional settings in SQL
Regular expressions
The analysis of aggregated data
Grouping functions
DISTINCT clause
Clauses GROUP BY and HAVING
Retrieving data from multiple tables
Inner and outer joins (INNER JOIN, OUTER JOIN)
ANSI SQL syntax, and other methods connectors (SELF JOIN, NATURAL JOIN)
Collective operators (UNION, UNION ALL, INTERSECT, MINUS)
Subqueries
Subqueries simple
Correlated subqueries
Operators EXISTS and NOT EXISTS
Other types of subqueries
Inquiries hierarchical and samples
Construction of the tree (CONNECT BY PRIOR clause and START WITH)
The SYS_CONNECT_BY_PATH
Data samples (SAMPLE clause)
Data manipulation (DML)
INSERT, UPDATE, DELETE
Operations on a large set of (INSERT FIRST INSERT ALL, MERGE)
Workshops are dedicated as a first step for developers and designers of applications based on Oracle databases. Participants do not need to have any prior knowledge of the Oracle database, or other relational database systems, even though such knowledge may be useful.
Exams and Certificates
The plan covers the training material required to pass the exam 1Z0-047 Oracle Database SQL Expert and obtain the title of Oracle Database SQL Certified Expert
Purpose of training
The workshop aims to familiarize participants with the Oracle database techniques to build database structures and data manipulation. Particular emphasis is placed on the participant to see across the board, which offers opportunities to design and build applications Relational Database Management System, Oracle Database, and to be able to independently work with her.
The content of the training
Introduction to database technology and the organization of the work environment
Acquisition and modification of data
Construction of the repository application
Safety and concurrency runtime
Notes
The workshops are based on the software version 11g XE
[category_overview] =>
[outline] =>
Introduction to the Oracle database
Database Architecture
Relational model database
Users diagrams sessions
Tools
Introduction to the SELECT statement
Screening and selection (WHERE clause)
Sorting
Data types, operators, and service NULL
Built-in scalar functions
Actions to date
National and regional settings in SQL
The analysis of aggregated data
Funkcje grupujące
Klauzula distinct
Klauzule GROUP BY and having
Retrieving data from multiple tables
Inner and outer joins (INNER JOIN, OUTER JOIN)
ANSI SQL syntax, and other methods connectors (SELF JOIN, NATURAL JOIN)
Collective operators (UNION, UNION ALL, INTERSECT, MINUS)
Subqueries
Subqueries simple
Correlated subqueries
Operators EXISTS and NOT EXISTS
Other types of subqueries
Inquiries hierarchical and samples
Construction of the tree (CONNECT BY PRIOR clause and START WITH)
The SYS_CONNECT_BY_PATH
Data samples (SAMPLE clause)
Data manipulation (DML)
"INSTRUCCIONES INSERT, UPDATE, DELETE
Operacja na dużych zbiorach (INSERT FIRST, ALL INSERT, MERGE)
Dictionary system
Concurrent users work
Transactions
Locks
FLASHBACK
Users and Permissions
Creating and modifying user patterns
Permissions and roles
Managing data storage - logical layer
Tables, temporary tables, index-organized tables
Limitations
Indexes
The views, sequences, synonyms, materialized views
Units stored PL / SQL
Modeling and restore the data model using Oracle SQL Modeler
Moving Data
A logical copy of the data - datapump import and export
Basic skills in any programming language, object-oriented structural or
The free use of the basics of SQL and knowledge of Oracle database environment (preferably Oracle 11g completion of training - Native SQL for Programmers - Workshops)
[overview] =>
For who
Workshops are dedicated to developers, end users and administrators, who until now have had no contact with the language PL / SQL, and the need to exploit its huge potential in working with a database, automate processes, and in building applications
Exams and Certificates
The plan covers the training material required to pass the exam 1Z0-144 Oracle Database 11g Program with PL / SQL and obtain the title of Oracle PL / SQL Developer Certified Associate
Purpose of training
The workshop aims to familiarize participants with the programming language PL / SQL, its capabilities and limitations. This workshop will include a full understanding of the mechanisms involved in the programming language PL / SQL needed to implement the logic of the free applications, automation of data processing and database management.
The content of the training
Introduction to PL / SQL architecture solutions based on this language, the organization of the working environment
Create scripts and stored program units that operate on data
Notes
The workshops are based on the software version 11g XE
[category_overview] =>
[outline] =>
Introduction to PL / SQL
Runtime Environment
Construction and types of PL / SQL blocks
Declaring and using variables
Control statements, decisions, loops
SQL statements in PL / SQL
DML commands
DDL and dynamic SQL
TCL commands and transactional
SELECT
Procedures and Functions
Create and delete
Parameterization
Passing parameters by value and reference, nocopy
Handling errors and exceptions
Create and use cursors
Records
static cursors
Parameterizing cursors
Cursor FOR UPDATE
Associative arrays
Packages
The structure of the package: the specification and body
Section Initialization and global variables, memory management, an instance of the package
The free use of the basics of SQL and knowledge of Oracle database environment (preferably Oracle 11g completion of training - Native SQL for Programmers - Workshops)
Fluency in the basics of PL / SQL (preferably Oracle 11g completion of training - Programming with PL / SQL I - Workshops)
[overview] =>
For who
This training is in addition to, and continuation of the 'Oracle 11g - Programming in PL / SQL and - workshops ", but can also be designed for practitioners, developers, PL / SQL who already have experience with the language, and who want to systematize their knowledge and learn advanced mechanisms and solutions developed in this language.
The content of the training
Objects, streams and complex data structures
Advanced solutions based on PL / SQL
Exams and Certificates
The plan covers the training material required to pass the exam 1Z0-146 Oracle Advanced PL / SQL and obtain the title of Oracle Advanced PL / SQL Developer Certified Professional
Purpose of training
The training is designed to familiarize participants with the advanced aspects of programming in an Oracle database. The emphasis is on flexibility and performance solutions based on PL / SQL.
Notes
The workshops are based on the software version 11g XE
[category_overview] =>
[outline] =>
Complex data types, collections
Subtypes
Cursor variables and dynamic cursors
Associative arrays, collections
Actions mass, bulk, forall
Exception handling bulk operations
Object orientation in an Oracle database
Types (classes)
methods of objects
permanent Collections
Functions Panel
streaming Features
Create your own aggregate functions
Calling functions in SQL, constraints, levels of purity, determinism
Organization of program units PL / SQL
Permissions in PL / SQL
Context name
Integration with other languages
Using JAVA
Linking procedures C language
Native compilation of the C language
Ready solutions
Create the application context
Mechanism of Virtual Private Database (VPD)
Support lobbying
Profiling code
Tracking code
Productivity PL / SQL code
Bind variables in SQL statements and the statistical distribution of
The free use of the basics of SQL and knowledge of Oracle database environment (preferably Oracle 11g completion of training - Native SQL for Programmers - Workshops)
Practical experience in working with Oracle
[overview] =>
For who
The workshop is intended for advanced programmers and Oracle users who seek knowledge and information on the efficient development of information systems in an Oracle database, and the tuning and testing of performance issues in existing applications. This course builds on knowledge often unavailable or incorrectly presented in the technical documentation, and collected during many years of practice leading them instructors. These workshops may be the end of the training path for developers, or a single step for people with extensive experience designing and programming in Oracle
Purpose of training
The workshop aims to provide mechanisms that occur in an Oracle database when performing SQL statements. Allows participants to avoid errors during software development, and explore, diagnose, and resolve performance problems in existing applications.
Particular emphasis is placed on the workshops, where we show the methodology and the practical aspects of the application and tuning SQL statements.
The content of the training
Mechanics perform SQL commands
Managing the process cost optimization
Methods of data storage and indexing
Monitoring database performance and processes based on dictionaries and track system applications
Analysis of cases of the most common problems that cause performance
Notes
The workshops are based on the software version 11g XE
[category_overview] =>
[outline] =>
Application Tuning Methodology
Architecture database and instance
Server processes
Memory structure (SGA, PGA)
Parsing and share cursors
The data files, log files, parameter files
Analysis of the command execution plan
Hypothetical plan (EXPLAIN PLAN, SQLPlus AutoTrac XPlane)
The actual execution plan (V $ SQL_PLAN, XPlane, AWR)
Monitoring the performance and find bottlenecks in the process
Monitoring the current status of the instance by system dictionary views
The monitoring of historical dictionaries
Tracking application (SQLTrace, TkProf, TreSess
The optimization process
Properties cost optimization and regulated
Determination to optimize
Control work cost-based optimizer by:
Session parameters and instance
Tips (hints)
Patterns of query plans
Statistics and Histograms
Impact statistics and histograms for performance
The methods of collecting statistics and histograms
Strategy of counting and estimating statistics
Management statistics: blocking, copying, editing, automation of collection, monitoring changes
Dynamic data sampling (temporary plates, complex predicates)
Multi-column statistics, based on expressions
Statistics System
The logical and physical structure of the database
Spaces tables.
segments
Extensions (EXTENTS)
Blocks
Data storage methods
The physical aspects of the table
temporary Tables
Tables index
external Tables
Partition Table (span, letter, hash, mixed)
Physical reorganization of tables
Materialized views and mechanism QUERY REWRITE
Methods of data indexing
Building B-TREE indexes
Properties index
Indexes: a unique, multi-column, function, inverse
Compression indices
Reconstruction and merging indexes
Virtual indexes
Indexes private and public
Bitmap Indexes and junction
Case study - full-scan data
The impact of a place at the table level and block performance readings
Loading Data conventional and direct path
The order of predicates
Case Study - access to data via the index
Methods of reading index (UNIQUE SCAN RANGE SCAN FULL SCAN FAST FULL SCAN MIN / MAX SCAN)
On-premise, Oracle database management systems can be costly and difficult to maintain for mid and large-scale organizations. Migrating Oracle databases to Azure SQL (also known as Microsoft Azure SQL Database, Microsoft Azure SQL or AzureSQL) or PostgreSQL (also known as Postgres or Postgre SQL) is a practical solution for growing businesses to address database management, maintenance, and scalability at an optimum cost.
This instructor-led, live training (online or onsite) is aimed at database administrators and cloud architects who wish to migrate Oracle databases to Azure SQL or PostgreSQL.
By the end of this training, participants will be able to:
Compare Azure SQL with PostgreSQL to choose the database that best meets business objectives and needs.
Prepare databases to move definitions, data, and procedures from Oracle to AzureSQL or PostgreSQL database system.
Perform post-migration steps to test, optimize, update, and maintain a migrated database.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at database administrators and cloud architects who wish to migrate Oracle databases to Azure SQL or PostgreSQL.
By the end of this training, participants will be able to:
Compare Azure SQL with PostgreSQL to choose the database that best meets business objectives and needs.
Prepare databases to move definitions, data, and procedures from Oracle to AzureSQL or PostgreSQL database system.
Perform post-migration steps to test, optimize, update, and maintain a migrated database.
[outline] =>
Introduction
Overview of Oracle Migration to Azure SQL or PostgreSQL
Designing a Proof of Concept Solution
Comparing Azure SQL Database With PostgreSQL Database
Configuring SQL Server Instances
Setting up Oracle Express Edition
Preparing the Database for Migration
Migrating SQL Server to Azure SQL
Deploying Post Upgrade Enhancements
Migrating Oracle Database to SQL Server 2017
Migrating the Application to Azure SQL
Migrating SQL Server to PostgreSQL
Preparing Oracle Database Migration to PostgreSQL
Migrating the Database and Application to PostgreSQL
The course is only suitable for those who have some knowledge of SQL.
Previous experience with an interactive computer system is desirable but not essential.
[overview] =>
This 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 18c is the next iteration of Oracle Database 12c Release 2, or "the first patch".
This instructor-led, live training (online or onsite) is aimed at engineers who wish to set up, deploy, migrate to and manage an Oracle 18c Database.
By the end of this training, participants will be able to:
Understand the major feature and architectural changes from previous Oracle versions.
Migrate to Oracle 18c from a previous version.
Deploy Oracle 18c in cloud or on premise.
Understand Oracle 18c's new yearly release cycle and plan maintenance around it.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at engineers who wish to set up, deploy, migrate to and manage an Oracle 18c Database.
By the end of this training, participants will be able to:
Understand the major feature and architectural changes from previous Oracle versions.
Migrate to Oracle 18c from a previous version.
Deploy Oracle 18c in cloud or on premise.
Understand Oracle 18c's new yearly release cycle and plan maintenance around it.
[outline] =>
Introduction
Oracle 18c and Oracle’s Autonomous Database Cloud
Overview of Oracle 18c Features and Architecture
On-premises and in cloud
Oracle 18c Incremental Enhancements over Oracle Database 12c Release 2.
Performance, High Availability, Multitenant Architecture, Security, Data Warehousing and Application Development
Oracle 18c Major Enhancements over Older Versions
Multitenant, Database In-Memory, Database Sharding, Connection Manager, etc.
Oracle 18c Deprecated Features from Older Versions
Non-CDB architecture, Oracle Streams, Oracle Multimedia, Oracle Administration Assistant for Windows, etc.
Upgrading from Previous Versions of Oracle
Multi-step Upgrade (10g => 12c => 18c)
Datadump "Upgrade" (Import/Export)
Understanding Oracle's Autonomous Database Cloud
Cost-based Optimization, Performance Tuning and Diagnostics, Data Automization, Cloud Operations
Automating Routine Administrative Tasks
Self-driving, Self-securing, Self-repairing
Deploying Oracle to a Public, Private and Hybrid Cloud
Oracle Database 21c is a converged database that supports a large range of workloads and data models. It’s a data management platform that provides high performance, security, availability, and scalability for cloud environments.
This instructor-led, live training (online or onsite) is aimed at database administrators who wish to learn and use the features of Oracle Database 21c in performing administrative tasks.
By the end of this training, participants will be able to:
Understand the core concepts of Oracle Database 21c administration.
Understand the Oracle 21c architecture.
Learn how to perform administration tasks on Oracle 21c.
Understand the Oracle 21c backup and recovery process.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at database administrators who wish to learn and use the features of Oracle Database 21c in performing administrative tasks.
By the end of this training, participants will be able to:
Understand the core concepts of Oracle Database 21c administration.
Understand the Oracle 21c architecture.
Learn how to perform administration tasks on Oracle 21c.
Understand the Oracle 21c backup and recovery process.
[outline] =>
Introduction
Introduction to Oracle Cloud
Overview of Oracle Database 21c
Oracle Database Architecture
Overview of the Oracle Database architecture
Configuring and connecting to the Oracle Database Instance
Understanding the Oracle Database memory structures
Process architecture and structures
Process startup sequence
Storage architecture
Database Instance
Overview of the Oracle Database management tools
Enterprise manager management framework
Setting Up the Oracle Network Environment
Overview of the Oracle Net Services and Oracle Net Listener
Oracle Network Connections
Configuring the Oracle Network tools
Listener Control Utility
Oracle Net configuration assistant
Oracle Net Manager
Enterprise Manager Cloud Control
Database Storage Structures
Overview of Database Block Content
Storage structure
Creating and managing Tablespaces
Navigating and viewing Tablespace information
Using Oracle managed files
User Security
Managing database user accounts
Predefined administrative accounts
Creating a user account
Authentication and password reset
Understanding the concept of privileges, roles, and profiles
Data Concurrency
Understanding the locking mechanism
Understanding data concurrency
DML locks
Enqueue mechanism
Lock conflicts
Undo Data
Overview of Undo data
Managing transactions and storing Undo information
No prior Oracle Business Intelligence experience required
Audience
Business analysts
Data analysts
Business intelligence professionals
[overview] =>
Oracle Business Intelligence (OBI) provides a comprehensive set of tools for analyzing, reporting, and visualizing data.
This instructor-led, live training (online or onsite) is aimed at beginner-level business analysts and data analysts who wish to leverage Oracle BI to extract valuable insights from their data.
By the end of this training, participants will be able to:
Navigate and utilize the Oracle BI interface effectively.
Create and customize reports and dashboards tailored to business needs.
Conduct ad-hoc analysis using various BI tools.
Utilize advanced features for comprehensive data exploration.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at beginner-level business analysts and data analysts who wish to leverage Oracle BI to extract valuable insights from their data.
By the end of this training, participants will be able to:
Navigate and utilize the Oracle BI interface effectively.
Create and customize reports and dashboards tailored to business needs.
Conduct ad-hoc analysis using various BI tools.
Utilize advanced features for comprehensive data exploration.
[outline] =>
Introduction
Overview of Oracle Business Intelligence
Key features and components
Understanding the BI life cycle
Navigating the Oracle BI Interface
Accessing and logging into Oracle BI
Exploring the BI dashboard
Overview of key tools: Oracle Answers, Oracle Dashboards, etc.
Creating Basic Reports with Oracle Answers
Building a simple report
Formatting and styling options
Implementing basic calculations
Exporting and sharing reports
Advanced Reporting Techniques
Working with advanced visualizations
Incorporating statistical analysis
Implementing conditional formatting
Mastering drill-down and drill-up techniques
Data Exploration and Analysis with Oracle Dashboards
Introduction to Oracle Dashboards
Conducting ad-hoc analysis
Integrating Dashboards with other Oracle BI tools
Advanced analysis features
Dashboard Design Best Practices
Overview of dashboard design principles
Creating and customizing dashboards
Implementing interactivity in dashboards
Best practices for effective dashboard design
Data Visualization Best Practices
Principles of effective data visualization
Creating compelling visualizations with Oracle BI tools
Oracle Database 19c is a multi-model database that provides full support for relational and non-relational data.
This instructor-led, live training (online or onsite) is aimed at system administrators who wish to learn how to administer, monitor, and support an Oracle database.
By the end of this training, participants will be able to:
Understand the major feature and architectural changes Oracle database.
Manage and monitor Oracle databases.
Optimize Oracle database performance.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at system administrators who wish to learn how to administer, monitor, and support an Oracle database.
By the end of this training, participants will be able to:
Understand the major feature and architectural changes Oracle database.
Manage and monitor Oracle databases.
Optimize Oracle database performance.
[outline] =>
Introduction
Overview of Oracle database server architecture
Overview of Oracle multitenant container database
Oracle database instance and database sharding
Accessing Oracle Database
Connecting to an Oracle database instance
Using Oracle database tools
SQL*Plus
Using Oracle SQL developer
Using Database Configuration Assistant (DBCA)
Understanding the Enterprise Manager cloud control 13c features
Overview of Oracle Enterprise Manager component
Single pane of glass for enterprise management
Managing Oracle Enterprise Manager database
Creating an Oracle Database
Creating an Oracle database using DBCA
Creating an Oracle database using an SQL command
Working with Database Instances
Starting the Oracle database instance
Shutting down an Oracle database instance
Comparing Shutdown modes
Opening and closing PDBs
Configuring PDBs
Managing Database Instances
Using initialization parameters
Working with the automatic diagnostic repository
Viewing the alert log
Using trace files
Administering the DDL log file
Working with dynamic performance views
Using a data dictionary
Overview of Oracle Net Services
Defining components of Oracle net services
Configuring and managing Oracle net services
Overview of Oracle net listener
Comparing dedicated and shared server architecture
Naming Methods
Establishing Oracle network connections
Understanding the naming methods
Easy connect
Local and directory naming
Managing workloads using database services
Creating database services
Working with the Listener
Using the default listener
Configuring dynamic service registration
Configuring static service registration
Configuring a Shared Server Architecture
Enabling a shared server
Controlling shared server operations
Using SGA and PGA
Shared server configuration considerations
Configuring Oracle Connect Manager
Understanding Oracle Connection Manager
Using filtering rules
Implementing intranet and internet access control
Using session multiplexing
Configuring Oracle Connection Manager
Configuring the cman.ora file
Configuring clients
Configuring the database server
Using the Oracle Connection Manager control utility
Oracle Database 19c is a multi-model database that provides full support for relational and non-relational data.
This instructor-led, live training (online or onsite) is aimed at system administrators who wish to have a comprehensive understanding of the security features of Oracle Database 19c.
By the end of this training, participants will be able to:
Understand the concepts of database security.
Implement authentication and authorization mechanisms to control access to the database.
Configure and manage user accounts, roles, and privileges effectively.
Implement robust security measures against various threats and vulnerabilities.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at system administrators who wish to have a comprehensive understanding of the security features of Oracle Database 19c.
By the end of this training, participants will be able to:
Understand the concepts of database security.
Implement authentication and authorization mechanisms to control access to the database.
Configure and manage user accounts, roles, and privileges effectively.
Implement robust security measures against various threats and vulnerabilities.
[outline] =>
Introduction
Overview of Oracle database 19c security
Understanding the importance of database security
Security Overview
Understanding network security
Defining a security policy
Authentication, Authorization, and User Management
Configuring authentication methods
Managing user accounts, roles, and profiles
Granting and revoking privileges
Implementing fine-grained access control
Managing database links and security implications
Data Encryption
Understanding encryption concepts and algorithms
Configuring encryptions
Implementing database auditing and monitoring
Responding to security incidents and breaches
Oracle Database 19c Advanced Security
Configuring realms, rules, and secure application roles
Oracle Fusion Human Capital Management (HCM) is a complete cloud solution that provides a modern set of tools to support complex human resource processes and workforce management.
This instructor-led, live training (online or onsite) is aimed at professionals who wish to learn the fundamental concepts of Oracle Fusion and implement Oracle Fusion HCM in their organization.
By the end of this training, participants will be able to:
Learn and understand the concepts of Oracle Fusion Human Capital Management (HCM).
Implement complete workforce structure management in any organization.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at professionals who wish to learn the fundamental concepts of Oracle Fusion and implement Oracle Fusion HCM in their organization.
By the end of this training, participants will be able to:
Learn and understand the concepts of Oracle Fusion Human Capital Management (HCM).
Implement complete workforce structure management in any organization.
[outline] =>
Introduction
Overview of Oracle Fusion HCM
Understanding the UI
Getting Started with Oracle Fusion HCM
Implementing Oracle Fusion
Preparing Fusion applications
User and role management
Synchronizing users and roles in LDAP
Functional setup manager
Workforce Management and Work Structure
Human resources
Workforce lifecycle manager
Managing profiles, performance, and goals
Managing compensation
Employment models
Managing work structures
Payroll Management
Payroll overview
HCM security overview
Configuring payroll
Creating and defining payroll element entries
Calculating payroll
Defining payment methods
Payroll costing
Defining payroll flow patterns
Goals Management
Concepts and actions of goal management
Setting up goal management
Understanding lookups, flex fields, and profile options
Creating and managing goal plans
Managing worker and organization goals
Administering and assigning goals
Approving goals
Understanding questionnaire concepts
Managing questions
Using question library
Creating questionnaires
Using questionnaire templates
Defining worker performance
Using performance management
Managing performance documents and worker evaluations
Monitoring tasks for worker performance
Absence Management
Setting up absence management
Overview of absence types
Understanding absence patterns and features
Absence types, plans, and reasons
Scheduling absences
Managing absence records and entitlements
Understanding absence recording
Absence approvals
Monitoring absence process
Time and Labor Management
Time card layout components
Managing HCM groups
Creating time card components
Understanding time card calculation rules
Managing worker time entry profile
Managing time processing profile
Loading timecards
Summary and Next Steps
[language] => en
[duration] => 28
[status] => published
[changed] => 1700037885
[source_title] => Oracle Fusion Human Capital Management (HCM)
[source_language] => en
[cert_code] =>
[weight] => -12
[excluded_sites] =>
[use_mt] => stdClass Object
(
[field_overview] =>
[field_course_outline] =>
[field_prerequisits] =>
[field_overview_in_category] =>
)
[cc] => oraclefusionhcm
)
[oraclelinux8] => stdClass Object
(
[course_code] => oraclelinux8
[hr_nid] => 435831
[title] => Oracle Linux 8: System Administration I
[requirements] =>
Knowledge of Linux system
Audience
System administrator
Technical consultant
Database administrator
[overview] =>
Oracle Linux is a high-performance and secure operating environment that delivers an easy-to-manage environment for virtualization, management, automation, and cloud-native computing tools.
This instructor-led, live training (online or onsite) is aimed at system administrators who wish to learn how to use and manage an Oracle Linux 8 system.
By the end of this training, participants will be able to:
Configure passwordless authentication.
Administer user and group accounts.
Configure network interface.
Monitor and troubleshoot Oracle Linux.
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.
[category_overview] =>
This instructor-led, live training in <loc> (online or onsite) is aimed at system administrators who wish to learn how to use and manage an Oracle Linux 8 system.
By the end of this training, participants will be able to:
Configure passwordless authentication.
Administer user and group accounts.
Configure network interface.
Monitor and troubleshoot Oracle Linux.
[outline] =>
Introduction
Overview of Oracle Linux
Exploring the gateway machine
Exploring the host VM
Getting Started with Oracle Linux
Installing Oracle Linux 8
Connecting to a remote server by using SSH
Configuring OpenSSH
Using the GRUB Bootloader
Overview of the GRUB Bootloader
Configuring the GRUB 2 Bootloader
Exploring the GRUB 2 Bootloader
Booting different kernels
Introduction to Systemd
Overview of systemd
Understanding the service unit file
Using grub menu and command line
Using systemd units
Using systemd service units
Managing Time
Managing system tasks
Configuring date and time
Configuring Chrony
Automating tasks
Configuring Device and Kenel
Understanding the sysfs file system
Updating using DNF
Using loadable kernel modules
Using /proc file and sysfs file system
Using the sysctl utility
Configuring udev rules
Managing Packages
Installing, updating, or removing packages using dnf