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 Oracle BI Publisher 12c training teaches you the fundamental concepts of Oracle BI Publisher, a reporting & document output management solution. Develop skills and design reports by using components such as Data Model, Report and Layout Editors. This course will help you to learn how to create layouts for reports, then publish the highly formatted reports to a wide range of destinations (printers, faxes, email, and document repositories via FTP or WebDAV). Publisher’s report formats can also be designed by using familiar Microsoft Office tools like Microsoft Word and Excel.
-
Keep your mission-critical applications and essential services up and running with comprehensive MySQL training. To grow your skillset and be more productive in your job, access a rich library of digital courses at your own convenience, then test your new skills through interactive, hands-on labs. Deepen your understanding of MySQL administration, development, security, and high availability in a risk-free environment through role- and topic-based courses. Learn what you need to know to deliver high-performance and scalable applications, then create new opportunities by getting MySQL certified.This OM8-PT: MySQL 8.0: Performance Tuning course teaches you how to use a wide range of configuration options, monitoring tools, and techniques used by MySQL database professionals to keep your applications fast, efficient, and secure.
Through a blend of hands-on labs and interactive lectures, you will learn how to do performance tuning; test and configure your server; examine performance metrics using a range of database system metrics, command line and graphical tools; design a circuit for optimal performance; identify and optimize slow queries and troubleshoot common performance issues.
-
Keep your mission-critical applications and essential services up and running with comprehensive MySQL training. To grow your skillset and be more productive in your job, access a rich library of digital courses at your own convenience, then test your new skills through interactive, hands-on labs. Deepen your understanding of MySQL administration, development, security, and high availability in a risk-free environment through role- and topic-based courses. Learn what you need to know to deliver high-performance and scalable applications, then create new opportunities by getting MySQL certified.
This OM-GSMDS: Getting Started with MySQL Database Service course teaches you how to create a cloud service instance, connect to the service and create a database, connect to the service instance and transfer a local server database to the MySQL Cloud Service instance. Backup your database. Connect to the instance from MySQL Workbench and from an application. This course describes the use of MySQL Cloud Service to host a MySQL database.
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.
-
Learn how to create secure, portable, high-performance applications using the world’s #1 programming language.
This comprehensive course is suitable for experienced programmers who want to learn the full Java programming language (Java SE), the language constructs, handle collections and concurrency, and utilize core language APIs and modularization. It is designed for people with existing knowledge of computing and programming concepts, and who need to learn all aspects of Java SE in the shortest possible time. Students practice the skills learned in each lesson through hands-on practices. The course is based on the current long-term support version, Java SE 11.
-
This Oracle Unified Directory 12c: Administration preparing gives you a diagram of the highlights and design of Oracle Unified Directory 12c. You’ll figure out how this arrangement takes into account adaptability to billions of passages, simplicity of establishment, flexible organizations, venture sensibility and successful observing.
-
Oracle Identity Manager 11g course explains complex OIM System Administration topics. Helps in enhancing knowledge of OIM System Administration by setting up a production like availability of OIM environment on high level and performing configuration, troubleshooting, diagnostics and performance tuning for OIM.
-
The Oracle Identity Governance 12c: Essentials Ed 1 training and certification course will give you a detailed overview of the essential concepts about implementing identity management solutions with Oracle Identity Governance. During the training, you will also learn about the Identity Governance infrastructure and the suite of Oracle Identity Management products. relationship of Oracle Identity Governance with other Oracle Identity Management products including Oracle Identity Analytics and Oracle Privileged Account Manager
-
Oracle Identity Governance 12c: Develop Identity Provisioning training course enables you to perform advanced administration, development, and customization tasks in Oracle Identity Manager 12c 12.2.1.3.0. During the class, you will learn the architecture of Oracle Identity Governance 12c and know the various development tools used.
-
In the Oracle Application Express: Administration Ed 2 course, students will learn the different ways in which Oracle Application Express can be installed and will perform a full development environment installation on a multitenant architecture of Oracle Database 12c.
They will identify the three options of configuring a web server for Oracle Application Express and will install and configure the Oracle REST Data Services.
-
The Oracle Database 12c R2: New Features for Administrators Part 1 Ed 1 training course will give you a detailed overview of following modules, the Using SQL New Features and Tools, the Understanding DB Architectures, and the Diagnosing Database Problems. During the training, you will be skilled with the knowledge about on-premises Multitenant databases and various other new features in different areas of database administration.
-
The course covers planning, installation, and deployment of Oracle Database Appliance, Release 18c. Students will learn how Oracle Database Appliance compares to other Oracle engineered systems and the advantages of using Oracle Database Appliance. After reviewing and planning for a new deployment, students will utilize the Web Console to deploy a bare metal appliance and the Oracle Appliance Configuration Manager tool to generate a deployment plan configuration for a virtualized appliance. Additional instructional videos and simulation software covers the concepts of racking and cabling a newly arrived Oracle Database Appliance system, running first boot scripts, downloading and installing the end-user bundle, and applying the latest patch bundles. The simulation labs are performed for both bare metal deployments and virtualized Oracle Database Appliance deployments.
-
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.
-
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.
-
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.
-
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
-
This OD-19c-SF: Oracle Database 19c: Security Fundamentals course teaches you Security aspect related to the latest release of Oracle Database (19c).
-
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
-
Oracle Database 19c is the latest release of Oracle’s flagship relational database management system.
This Oracle Database course teaches you how to use the advanced features of PL / SQL to design and tune PL / SQL to interface with the database and other applications.
In Oracle Database 19c: Advanced PL/SQL training you will learn advanced features of program design, packages, cursors, extended interface methods and collections. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.
-
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.
-
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.
-
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
-
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).
-
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.
