Oracle Seminare

The course provides the Oracle Database 19c new features and enhancements related to database overall, security, availability, performance, data warehousing, and diagnosability. In the lessons, you learn the new and enhanced features of Oracle Database 19c amongst different areas such as database overall, security, availability, performance, big data and warehousing, and diagnosability.

• Topics of the database overall module cover new features such as DBCA, OUI, and Data Pump enhancements.
• Topics of the security module cover enhancements such as key management of encrypted Oracle-managed tablespaces in TDE, and Database Vault operations control.
• Topics of the availability module cover enhancements in RMAN such as recovery catalog connection when the user is connected to the target database as PDB.
• Topics of the performance module cover enhancements such as PDB-level ADDM analysis, Memoptimized Rowstore - Fast Ingest deferred writes and enabling SQL developers to use Real-Time SQL Monitor.
• Topics of the data warehousing module cover enhancements such as hybrid partitioned tables and automated indexing.
• Topics of the diagnosability module cover new features such as an end-to-end automated service for fault prediction, detection, and fixation to avoid or minimize the human intervention, and new service request data collections determining the data to collect for crucial errors.
• Topics of the sharding module cover enhancements such as the support for multiple PDB-shards in the same CDB and of multiple table family for system-managed sharding.

 

This Oracle Database 12c: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.

Learn To:

• Understand the basic concepts of relational databases ensure refined code by developers.
• Create reports of sorted and restricted data.
• Run data manipulation statements (DML).
• Control database access to specific objects.
• Manage schema objects.
• Manage objects with data dictionary views.
• Retrieve row and column data from tables.
• Control privileges at the object and system level.
• Create indexes and constraints; alter existing schema objects.
• Create and query external tables.

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.

Learn Advanced Features of SQL

This course will help you understand the advanced features of SQL. Learning these features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Some of the date-time functions available in the Oracle Database are also covered. This course also discusses how to use the regular expression support in SQL through expert instruction.

Use Development Tools

The main development tool used in this training is Oracle SQL Developer. SQL*Plus is available as an optional development tool. This is appropriate for a 10g, 11g and 12c audience.

Course Bundle

Note: This course is a combination of Oracle Database 12c: SQL Workshop I and Oracle Database12c: SQL Workshop II courses.

This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL and then explores thebenefits of this powerful programming language. Through hands-on instruction from expert Oracle instructors, you'lllearn to develop stored procedures, functions, packages and more.

 

This Oracle Database 12c: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.

Learn To:

• Understand the basic concepts of relational databases ensure refined code by developers.
• Create reports of sorted and restricted data.
• Run data manipulation statements (DML).
• Control database access to specific objects.
• Manage schema objects.
• Manage objects with data dictionary views.
• Retrieve row and column data from tables.
• Control privileges at the object and system level.
• Create indexes and constraints; alter existing schema objects.
• Create and query external tables.

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.

Learn Advanced Features of SQL

This course will help you understand the advanced features of SQL. Learning these features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Some of the date-time functions available in the Oracle Database are also covered. This course also discusses how to use the regular expression support in SQL through expert instruction.

Use Development Tools

The main development tool used in this training is Oracle SQL Developer. SQL*Plus is available as an optional development tool. This is appropriate for a 10g, 11g and 12c audience.

Course Bundle

Note: This course is a combination of Oracle Database 12c: SQL Workshop I and Oracle Database12c: SQL Workshop II courses.

The course provides the Oracle Database 19c new features and enhancements related to database overall, security, availability, performance, data warehousing, and diagnosability. In the lessons, you learn the new and enhanced features of Oracle Database 19c amongst different areas such as database overall, security, availability, performance, big data and warehousing, and diagnosability.

• Topics of the database overall module cover new features such as DBCA, OUI, and Data Pump enhancements.
• Topics of the security module cover enhancements such as key management of encrypted Oracle-managed tablespaces in TDE, and Database Vault operations control.
• Topics of the availability module cover enhancements in RMAN such as recovery catalog connection when the user is connected to the target database as PDB.
• Topics of the performance module cover enhancements such as PDB-level ADDM analysis, Memoptimized Rowstore - Fast Ingest deferred writes and enabling SQL developers to use Real-Time SQL Monitor.
• Topics of the data warehousing module cover enhancements such as hybrid partitioned tables and automated indexing.
• Topics of the diagnosability module cover new features such as an end-to-end automated service for fault prediction, detection, and fixation to avoid or minimize the human intervention, and new service request data collections determining the data to collect for crucial errors.
• Topics of the sharding module cover enhancements such as the support for multiple PDB-shards in the same CDB and of multiple table family for system-managed sharding.

 

This Oracle Solaris 11 Advanced System Administration training provides an intensive hands-on experience on Oracle Solaris 11.3 operating system. You'll learn complex and integrated administration concepts through a combination of lessons and hands-on exercises that will reinforce your learning. Also, this course will introduce you to Oracle Solaris 11 on the Cloud.

This is an advanced course which dives into the details of configuring and administering an Oracle Solaris 11 system.

Note: Students without Oracle Solaris 11 system administration experience should take the Oracle Solaris 11 System Administration course first to ensure an effective knowledge of Oracle Solaris 11 system administration before attempting to take this advanced course. Those with Oracle Solaris 10 experience should take the Transition to Oracle Solaris 11 course as it builds on your Oracle Solaris 10 knowledge and provides training more tailored to your background.

Learn To:

• Manage Services and Service Properties Using SMF.
• Manage Software Packages by Using IPS.
• Back Up and Restore Data Using ZFS.
• Configure Network and Network High Availability.
• Administer Network Services.
• Administer the Zones.
• Secure the Oracle Solaris 11 OS.
• Manage Processes and Priorities.
• Install Oracle Solaris 11 OS on Multiple Hosts.
• Implement System Messaging and Diagnostic Facilities.
• Introduce Oracle Solaris 11 on the Cloud.

Benefits to You

Develop skills with and a better understanding of the Oracle Solaris 11.3 system administration and new enhancements done to the OS, which allow you to run your most demanding enterprise applications in private, hybrid, or public clouds.

Develop Oracle Solaris 11.3 OS Expertise

This course builds on the system administration skills taught in the Oracle Solaris 11.3 System Administration course. You'll work with expert Oracle University instructors to develop a deep understanding of Oracle Solaris 11.3 OS that you can leverage in your day-to-day job.

This course is a continuation of Oracle WebLogic Server 12c: Administration I. It teaches you how to perform important administrative tasks, employing best practices that enable you to make the most of your WebLogic applications.

Learn how to:

• Upgrade WebLogic products without disrupting client applications
• Create and use domain templates
• Deploy shared libraries and applications using advanced deployment techniques
• Configure advanced JDBC features
• Create and run WLST scripts
• Interact and manage WLS using REST
• Configure and use Coherence*Web and managed Coherence servers
• Create and work with simple domain partitions

Benefits to You

Increase the reliability, availability, scalability, and performance (RASP) of your organization’s applications and services with the #1 application server. Take advantage of WebLogic Server features to maximize the effectiveness of your enterprise.

Oracle WebLogic Server Domain Management Tasks

This course trains administrators in WebLogic Server administrative tasks related to managing the day to day operations of running applications, including performing rolling upgrades, creating and using domain templates, configuring automatic crash recovery, and creating and running WebLogic Scripting Tool (WLST) scripts.

Oracle WebLogic Server Deployment Tasks

This course trains administrators in WebLogic Server administrative tasks related to real-world management of application deployments, including using deployment modes, creating and using deployment plans, deploying shared libraries, and deploying versioned applications and libraries.

Oracle WebLogic Server Subsystem Administration Tasks

This course trains administrators in WebLogic Server administrative tasks. These tasks are related to WebLogic infrastructure features, including creating and using work managers, managing data sources, using multi data sources, configuring WebLogic security artifacts, configuring SSL for WebLogic Server, configuring automatic JTA service migration, configuring and using the WebLogic Diagnostic Framework (WLDF), configuring Coherence*Web for HTTP session persistence and configuring managed Coherence servers.

This course is a continuation of Oracle WebLogic Server 12c: Administration I. It teaches you how to perform important administrative tasks, employing best practices that enable you to make the most of your WebLogic applications.

Learn how to:

• Upgrade WebLogic products without disrupting client applications
• Create and use domain templates
• Deploy shared libraries and applications using advanced deployment techniques
• Configure advanced JDBC features
• Create and run WLST scripts
• Interact and manage WLS using REST
• Configure and use Coherence*Web and managed Coherence servers
• Create and work with simple domain partitions

Benefits to You

Increase the reliability, availability, scalability, and performance (RASP) of your organization’s applications and services with the #1 application server. Take advantage of WebLogic Server features to maximize the effectiveness of your enterprise.

Oracle WebLogic Server Domain Management Tasks

This course trains administrators in WebLogic Server administrative tasks related to managing the day to day operations of running applications, including performing rolling upgrades, creating and using domain templates, configuring automatic crash recovery, and creating and running WebLogic Scripting Tool (WLST) scripts.

Oracle WebLogic Server Deployment Tasks

This course trains administrators in WebLogic Server administrative tasks related to real-world management of application deployments, including using deployment modes, creating and using deployment plans, deploying shared libraries, and deploying versioned applications and libraries.

Oracle WebLogic Server Subsystem Administration Tasks

This course trains administrators in WebLogic Server administrative tasks. These tasks are related to WebLogic infrastructure features, including creating and using work managers, managing data sources, using multi data sources, configuring WebLogic security artifacts, configuring SSL for WebLogic Server, configuring automatic JTA service migration, configuring and using the WebLogic Diagnostic Framework (WLDF), configuring Coherence*Web for HTTP session persistence and configuring managed Coherence servers.