This course covers the Data Modeling and Database Development process and the models that are used at each phase of the lifecycle. You’ll develop the skills to model and understand the database development lifecycle based on real life examples, while mapping the objects and engineer the logical model to a relational model.
-
This course will help you in migrating on-premises database apps to Oracle Cloud and develop the RESTful web services. You will create an Autonomous Transaction Processing database and use APEX Web to create the applications.
-
This course teaches you the features of the Oracle Big Data service. In this course you learn the key features of the service that provisions fully configured, secure, highly available and dedicated Hadoop and Spark clusters on demand.
-
Oracle Data Integrator is an extensive data integration platform that handles all information integration requirements from high-intensity, high-performance batch loads, to event-driven integration processes and SOA-enabled data services.
Oracle Data Integrator’s Extract, Load, Transform (E-LT) architecture leverages disparate RDBMS engines to process and transform the data – the approach that optimizes performance, scalability and lowers overall solution costs.
Expert Oracle University instructors will teach you how to use Oracle Data Integrator (ODI) 12c to implement high-performance movement and transformation of data among various platforms. This course covers using ODI graphical user interfaces that enable users to access different ODI components and resources that form ODI infrastructure.
-
The Oracle Data Integrator 12c: Advanced Integration and Development training and certification course will give you the a detailed overview of advanced techniques for using Oracle Data Integrator 12c (ODI). During the training, you will learn to implement high-performance movement and transformation of data among various platforms.
-
No involved lab condition for the Training On Demand course format This Oracle Database Cloud for Oracle DBAs training shows you how to regulate the Oracle Database Cloud Service. It’s optimal for existing DBAs who need to figure out how to manage Oracle Database in the cloud.
-
The Oracle Database 12c: RAC and Grid Infra Deployment Workshop Ed 1 training course will give you a detailed overview of configuring, administering and using important features of Oracle Database 12c RAC and Grid Infrastructure. Additionally, you will also be given a basic overview of the Oracle Database Exadata Cloud Service.
-
This XML Fundamentals training introduces you to the basics of XML. In this 2 day hands on course, you will learn the central XML technologies, including writing well formed and valid XML, creating Document Type Definitions (DTDs) and XML schema documents and using XPath and XQuery.
Learn To:
- Create well-formed and valid XML documents.
- Use XML Namespaces in an XML document to resolve name ambiguities in XML documents.
- Create Document Type Definition and XML schema documents to validate XML documents.
- Use XPath expressions and functions to find and select nodes in XML documents.
- Transform XML documents by using stylesheets and XPath expressions.
- Use Oracle JDeveloper to view, create, edit, and test XML and other XML-related documents.
- Use XQuery to query, generate, and transform XML content.
- Identify the features and benefits of Oracle XML DB
-
This UNIX and Linux Essentials course is designed for users and administrators who are new to the Oracle Linux and Oracle Solaris operating systems. It will help you develop the basic UNIX skills needed to interact comfortably and confidently with the operating system.
Learn To:
- Manage files and directories from the command line and learn to use the vim editing tool.
- Perform remote connections and file transfers.
- Customize the user environment and use advanced shell features in shell scripts.
- Archive and compress files and directories.
- Understand and manage process control.
- View and modify file and directory permissions.
Benefits to You
Learn to work effectively with UNIX and Oracle Linux environments and master the fundamental administrative tasks for these operating systems. These are the first steps to ensuring fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto Oracle Cloud or private clouds.
-
In the Oracle NoSQL Database for Developers Ed 1 course, you will learn how to use the Oracle NoSQL Database developer APIs for Java. You will also discover how to access the KVStore from a Java application to store and manipulate data in a KVStore.
Learn To:
- Understand the key concepts of the NoSQL technology and when to use the Oracle NoSQL Database versus an RDBMS.
- Learn to design the schema for a Java application using a table based approach as well as a key value pair approach.
- Learn to create the code for storing, manipulating and deleting data stored in a KVStore.
- Handle exceptions and implement security, consistency, and durability policies for the KVStore and an application.
You will identify the features and benefits of the Oracle NoSQL Database and will discover why and how Oracle NoSQL Database is used to store data, generally Big Data.
-
This Oracle NoSQL Database for Administrators training teaches you how to deploy a KVStore and troubleshoot installation and hardware failures. Expert Oracle University instructors will also teach you how to monitor and manage a KVStore.
Learn To:
- Plan installation of Oracle NoSQL Database.
- Install and configure Oracle NoSQL Database.
- Deploy Oracle NoSQL Database KVStore.
- Secure the configuration.
- Extend a KVStore by increasing the replication factor or capacity of the KVStore.
- Troubleshoot installation and hardware failures.
- Monitor and optimize Oracle NoSQL Database performance.
- Perform backup, recovery, and upgrades.
When you walk away from this course, you’ll be able to identify the features and benefits of the Oracle NoSQL Database. You’ll have a deeper understanding of how to optimize the KVStore’s performance.
-
This OD-MMA: Oracle Database: Managing Multitenant Architecture course covers all aspects of the multitenant architecture, providing detailed information on the components of an Oracle multitenant container database and its regular and application pluggable databases.
You learn why and how to create and manage a multitenant container database and its regular and application pluggable databases, with storage structures appropriate for the business applications. You practice cold and hot cloning, plugging unplugged pluggable databases in multitenant container databases using various methods.
In addition, you learn how to create common and local users and administer database security to meet your business requirements by using encryption, Database Vault and auditing and you will learn how to create a database deployment in the Cloud.
Versions Supported: 19c, 18c, 12c
-
This Oracle Database: Deploy, Patch and Upgrade Workshop gives you detailed information to help you install Oracle Database software. Expert Oracle instructors will teach you how to create a container database and provision pluggable databases. In this course, you will be introduced to Oracle Database Cloud Service.
Learn To:
- Install Oracle Grid Infrastructure for a Standalone Server.
- Use Oracle Restart to manage components.
- Upgrade an existing Oracle Database.
- Create a container database and provision pluggable databases.
- Gain an understanding of the Oracle Database Cloud Service.
Benefits to You
Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.
Gain Hands-On Experience
Get practical experience installing the Oracle Grid Infrastructure software and Oracle Database software by using Oracle Universal Installer. Expert Oracle instructors will teach you how to stop and start Oracle Restart using SRVCTL to manage components.
-
This Oracle Database 12c: Analytic SQL for Data Warehousing training teaches you how to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data and exclude branches from the tree structure. You’ll also learn to use regular expressions and sub-expressions to search for, match, and replace strings. In this course, you will be introduced to Oracle Business Intelligence Cloud Service.
Learn To:
- Use SQL with aggregation operators, SQL for Analysis and Reporting functions.
- Group and aggregate data using the ROLLUP and CUBE operators, the GROUPING function, Composite Columns and the concatenated Groupings.
- Analyze and report data using Ranking functions, the LAG/LEAD Functions and the PIVOT and UNPIVOT clauses.
- Perform advanced pattern matching.
- Use regular expressions to search for, match and replace strings.
- Gain an understanding of the Oracle Business Intelligence Cloud Service.
-
This course is targeted at Developers and Database Administrators and begins with the concepts of a relational database and the SQL programming language. It includes writing queries against single and multiple tables, manipulate data in tables, and create database objects.
You’ll also learn how to create sequences, synonyms, indexes, and views, manage schema objects, and manage data using subqueries. Additionally, the course covers controlling User Access and managing data in different time zones.
-
This course is targeted at Database Administrators and begins with explaining the architecture of an Oracle Database instance and the tools used to access it. The course includes creating and managing a database, configuring and managing Oracle Net Services along with creating and administering pluggable databases (PDBs). You learn how to create and manage database storage, users, backup, and implement database security.
Additionally, the course covers protection of database against failures, loading, and transporting data.
-
Oracle SOL Tuning for Developers Workshop course helps you learn how plans are tuned execution of Oracle SOL statements. You will learn how to write well-tuned SOL statements out of the box that are perfectly suited to Oracle DBMS.
-
The Oracle Database 19c: SQL Workshop course offers students an introduction to Oracle Database 19c database technology. In this class students learn the concepts of relational databases and the powerful SQL programming language.
This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.
-
Learn to write well-tuned SQL statements for the Oracle database.
This Oracle Database course teaches you how to write well-tuned SQL statements appropriate for the Oracle database. This Oracle SQL Tuning for Developers Workshop will help you explore Oracle SQL statement tuning.
MySQL Cloud Service provides numerous benefits over an on-premise database. It is easy to create a cloud instance, with flexible options for computing power, memory, and storage. GUI tools are available for backup and restore as well as patching and rolling back. After completing this course, you can take advantage of those benefits to use MySQL Cloud Service to its best advantage.
-
This OD-19c-SF: Oracle Database 19c: Security Fundamentals course teaches you Security aspect related to the latest release of Oracle Database (19c).
-
Get up to speed on Oracle RAC Administration.
This Oracle Database 19c: RAC Administration Workshop course will teach you about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion.
Learn To:
- Install and configure RAC
- Manage RAC Database
- Upgrade and patch RAC Database
- Manage backup and recovery for RAC
- Monitor and tune RAC Database
- Manage high availability of services
- Implement High Availability for connections and applications
- Configure RAC One Node Database
- Implement In-Memory Column Store in RAC
- Configure Multitenant Architecture in RAC
- Manage Quality of Service in RAC
-
Explore the most advanced features and methods for achieving maximum performance, availability, and reliability using core database technologies and features. Learn how to leverage enhancements in multitenant architecture, manage security, use RMAN, understand general Database Administration functionality, implement big data, and more.
This OD-19c-PW: Oracle Database 19c: PL/SQL Workshop course introduces students to PL/SQL, Procedural Language for SQL. Explore the differences between SQL and PL/SQL. Examine the characteristics of PL/SQL and how it is used to extend and automate SQL.
-
Tune your databases with targeted queries and tuning methodology so you can identify problems before they arise.
Learn how to use advisors inside of an oracle database, as well as various tools provided by Oracle, in order configure the right settings for optimal performance. Gain skills in this Oracle database course to:
- use targeted query tuning and methodology to identify tuning problems in an Oracle database to take corrective action
- how to identify and tune a common database
- troubleshoot performance issues
- use advisors inside the database in order to understand in advance what settings need to be made and how to use the various tools provided by Oracle to configure the database
-
Gain skills and knowledge needed to design and implement security policies to protect data from accidental, unauthorized, or inappropriate actions.
After completing this course, you will have the skills and knowledge necessary to design and implement security policies to protect data from accidental, unauthorized, or inappropriate actions. You will also be able to create and enforce practices of auditing and accountability for such actions. In addition, you will be able to develop applications that provide desired services securely in a variety of computational models, making use of database and directory services to maximize both efficiency and ease of use. This course is therefore essential for anyone who wants to work in the field of computer security.
-
The best database architecture for the hybrid cloud.
The multitenant architecture enables you to have many pluggable databases inside a single Oracle Database instance. Through a blend of hands-on labs and interactive lectures, you will explores the multitenant architecture and the different types of pluggable databases (PDBs) in multitenant container databases (CDBs).
-
This OD-19c-FDS: Oracle Database 19c: Fundamentals for Devs and SysAdmins course teaches you how to perform common, day-to-day administrative tasks that are required of an Oracle database administrator (DBA).
The Oracle database course covers the following topics:
- Install the Oracle Database Software and Create a Database
- Use Enterprise Manager Database Express
- Use SQL*Plus and SQL Developer
- Use the Listener Control Utility
- Use SQL Developer to Shut Down and Restart a Database
- View Initialization Parameters
- Manage the Database Storage Structures
- Administer Users and Security
- Create Application Tables and Load Database
- Perform Backup and Recovery
- Monitor Database Performance
-
The Oracle Database 19c: Data Warehousing Techniques course teaches you the various Data Warehousing concepts and techniques related to data extraction, transformation, and loading phases. You will learn about the different changed data capture methods for data refresh, and how to define summary management and implement materialized views. You will also learn about the role of warehouse metadata along with the various data warehouse implementation considerations.
-
This OD-19c-DWC: Oracle Database 19c: Data Warehousing Concepts course covers the following topics:
- Evolution of information management systems and data warehousing
- Need for machine learning, artificial intelligence, and big data in future data analytics
- Data warehouse concepts and terminology
- Multidimensional model concepts and create analytic views
- Explain the business, logical, dimensional, and physical data warehousing models
- Importance of extraction, transformation, and loading in data warehousing systems
-
The OD-19c-DMT: Oracle Database 19c: Data Mining Techniques course covers the basic concepts and primary terminologies associated with data mining. The course explains the steps associated with the data mining process, the use of Oracle Data Miner to perform data mining, and the options for deploying data mining predictive results.
-
This Oracle course introduces the main architectural concepts of Oracle Data Guard. The delegate will learn how to use Oracle Data Guard to protect an Oracle Database against planned and unplanned downtime.
Through a blend of hands-on labs and interactive lectures you will also learn how to create and manage physical, logical and snapshot standby databases and how to use standby databases for reporting, querying and testing purposes.
-
This is a newly curated course of one day duration that covers the Data Encryption aspect related to the latest of release of Oracle Database (19c).
The course covers the following topics:
- Managing Endpoints and Oracle Wallets
- Encryption
- Key Vault and Transparent Data Encryption
- Performing Oracle Key Vault Administrative Tasks
-
The threat to data has never been greater. Oracle Database helps reduce the risk of a data breach and simplifies regulatory compliance with security solutions for encryption and key management, granular access controls, flexible data masking, comprehensive activity monitoring, and sophisticated auditing capabilities.
The OD-19c-DC: Oracle Database 19c: Data Confidentiality course covers the following topics:
- Application Contexts
- Virtual Private Database
- Oracle Label Security
- Data Masking
- Data Redaction
- Real Application Security
-
A High Availability Cluster and the Foundation for Oracle RAC.
Oracle Clusterware is a portable cluster software that allows clustering of independent servers so that they cooperate as a single system. Oracle Clusterware was first released with Oracle Database 10g Release 1 as the required cluster technology for the Oracle multi-instance database, Oracle Real Application Clusters (RAC).
This OD-19c-CAW: Oracle Database 19c: Clusterware Administration Workshop course teaches you general cluster concepts and Oracle Clusterware architecture. In this course you will learn in-depth understanding of installing, configuring, patching and maintaining Oracle Clusterware 19c.
-
The student begins by gaining a deeper understanding of possibly the most important job of a DBA – backup and recovery. The concepts and architecture that support backup and recovery, along with implementation in various ways and situations are covered in detail. Students gain knowledge of the Recovery Manager (RMAN) command-line interface for various backup, failure, restore, and recovery scenarios, including data duplication.
-
Learn how to effectively manage and administer your Oracle Database.
This OD-19c-AW: Oracle Database 19c: Administration Workshop course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database.
In addition, you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.
-
Expand your database knowledge and gain an edge in a competitive IT marketplace.
Explore the most advanced features and methods for achieving maximum performance, availability, and reliability using core database technologies and features. Learn how to leverage enhancements in multitenant architecture, manage security, use RMAN, understand general Database Administration functionality, implement big data, and more.
This Oracle Database course teaches you about Oracle ASM architecture and its components. During the training, you will get a deep understanding of both standard ASM and Flex ASM applications.
