Oracle Seminare

oracle-approved-education-center. PCIT ist seit 1999 offizieller Schulungspartner der Oracle University. Wir bieten Ihnen eine Vielzahl von Kursen aus dem Gesamtprogramm der Oracle Schulungen. Bei uns können Sie sämtliche Oracle Kurse sowohl in München als auch an allen anderen Schulungsorten buchen. Alle unsere Trainer sind Oracle zertifiziert und garantieren mit ihrer langjährigen Erfahrung den hohen Schulungsstandard. Falls Sie eine gesuchte Schulung nicht finden, kontaktieren Sie uns einfach und nennen Sie uns Ihren Schulungsbedarf. Wir werden bestimmt den passenden Kurs für Sie finden und anbieten können.
Vritual Class Online Kurse

"Corona Virus": Alle hier angebotenen Oracle-Kurse, auch die nicht als "LVC" gekennzeichneten, können auf Wunsch online absolviert werden! Bitte kontaktieren Sie uns hierzu!

Kontaktlos und ohne Reisekosten bestens geschult:
Unkompliziert und direkt vom Homeoffice in den virtuellen Schulungsraum per Remote (LVC).

Oracle Live Virtual Classes (LVC) können Sie von überall absolvieren, wo Sie Internetzugriff haben. Sie haben keine Anreise - das spart zusätzlich auch Zeit und Geld. Für die Onlinekurse der Oracle University wird das WebEx Training Center verwendet, um die Interaktion zwischen Dozenten und Kursteilnehmern/-innen zu vereinfachen.

 

 

In the Oracle Database 12c R2: Advanced PL/SQL course, students learn how to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and integrate with the other applications in the most efficient manner. They learn to write powerful PL/SQL programs using external C/Java routines, fine-grained access packages, cursors, extended interfaces and collections.

Learn To:

  • Apply PL/SQL designing best practices.
  • Create PL/SQL applications that use collections.
  • Work with JSON data in the database.
  • Implement a virtual private database with fine-grained access control.
  • Write code to interface with external C and Java applications.
  • Write code to interface with large objects and use SecureFile LOBs.
  • Write and tune PL/SQL code effectively to maximize performance.

Benefits To You

Students will benefit from using advanced features of program design, packages, cursors, extended interface methods, and collections and students learn how to write powerful PL/SQL programs.

Programming efficiency, use of external C and Java routines, PL/SQL server pages, and fine-grained access are covered. Students learn how to write PL/SQL routines that analyze the PL/SQL applications and caching techniques that can improve performance.

Students are introduced to the Virtual Private Database (VPD) to implement security policies and they learn techniques and tools to strengthen their applications against SQL injection attacks.

 

Startdatum 01.12.2021 - 09:00
Enddatum 03.12.2021 - 17:00
Anmeldungsende 27.11.2021
Netto Einzelpreis € 2.100,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. D80343- Oracle Database 12c: Advanced PL/SQL
Ort Berlin

Abgeschlossen

This Oracle Database 12c R2: Install and Upgrade Workshop gives you detailed information to help you install Oracle Database 12c Release 2 software. Expert Oracle instructors will teach you how to create a container database and provision pluggable databases.

Learn To:

  • Configure the Oracle Linux 7 operating system for Oracle software installation.
  • Install Oracle Grid Infrastructure for a Standalone Server (12.1) using Oracle Universal Installer.
  • Install Oracle Grid Infrastructure for an Independent Server (12.2) using a golden image.
  • Configure ASMLIB and create ASM disk groups.
  • Install Oracle Database software (12.1) using Oracle Universal Installer.
  • Install Oracle Database software (12.2) using a silent installation.
  • Apply patch set updates to Oracle software.
  • Use Oracle Restart to manage components.
  • Upgrade an existing Oracle Database to Oracle Database 12c Release 2 (12.2.0.0.3.
  • Create a container database and provision pluggable databases.

Benefits To You

Students will benefit from working with multiple install scenarios in the lab sessions. This will allow the new course to be relevant for both 12c R1 and 12c R2 setups. After the install of the Grid Infrastructure software, the student will then gain experience patching Oracle Software.

 

Startdatum 02.12.2021 - 09:00
Enddatum 03.12.2021 - 17:00
Anmeldungsende 26.11.2021 - 09:00
Netto Einzelpreis € 1.422,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. Oracle Database 12c: Install and Upgrade Workshop
Ort Live Online

Abgeschlossen

This Oracle Database: SQL and PL/SQL Fundamentals training delivers the fundamentals of SQL and PL/SQL along with the benefits of the programming languages using Oracle Database technology. You'll explore the concepts of relational databases.

Learn To:

  • Write queries against single and multiple tables, manipulate data in tables and create database objects.
  • Use single row functions to customize output.
  • Invoke conversion functions and conditional expressions.
  • Use group functions to report aggregated data.
  • Create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.
  • Develop anonymous PL/SQL blocks, stored procedures and functions.
  • Declare identifiers and trap exceptions.
  • Use DML statements to manage data.
  • Use DDL statements to manage database objects.
  • Declare PL/SQL Variables.
  • Conditionally control code flow (loops, control structures).
  • Describe stored procedures and functions.
  • Retrieve row and column data from 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.

 

Startdatum 06.12.2021 - 08:00
Enddatum 10.12.2021
Anmeldungsende 03.12.2021
Netto Einzelpreis € 3.300,00
Speaker English
Kurs-Nr. D17218: Oracle Database: SQL and PL/SQL Fundamentals
Ort Live Online

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.

 

Startdatum 06.12.2021 - 09:00
Enddatum 10.12.2021 - 17:00
Anmeldungsende 03.12.2021 - 09:00
Netto Einzelpreis € 3.555,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. D72965:Oracle Solaris 11 Advanced System Administration
Ort Live Online

Die Teilnehmer lernen in diesem Kurs die Sprache SQL speziell zugeschnitten auf die Datenbank Oracle kennen. Es wird das Konzept von relationalen Datenbanken und die Datenbankarchitektur besprochen.  Die Teilnehmer lernen, wie Daten aus einer Datenbank abgefragt, verknüpft, gefiltert, aggregiert und in verschiedenen Ansichten aufbereitet und dargestellt werden können. Es wird der Export zu verschiedenen Programmen wie Microsoft Office, aber auch der Import von Daten besprochen. Die kostenfreien Tools SQL Developer und SQL Plus werden benutzt. Die Möglichkeiten zur Dateneingabe, Datenänderung und zum Löschen von Daten werden behandelt. Es werden auch Tabellen, Indexes, Views ... erstellt und vorhandene umstrukturiert. Auf wesentliche Aspekte zur Verbesserung der Performance wird eingegangen.

Zielgruppe:

  • Entwickler
  • Administratoren
  • Benutzerservice
  • Consultants
  • Datenbankdesigner
Startdatum 06.12.2021 - 09:00
Enddatum 10.12.2021 - 17:00
Anmeldungsende 03.12.2021 - 09:00
Netto Einzelpreis € 3.500,00
Speaker Deutsch
Number Hours 09:00 - 17:00
Kurs-Nr. OSQL20100: Oracle SQL Workshop
Ort Live Online

This Oracle Linux System Administration II training is ideal for experienced administrators who need to learn more advanced skills for working with Oracle Linux.

You'll learn how to automate the installation of the operating system, configure advanced networking services and work in greater depth with authentication solutions and various internet services. You will become proficient at working with advanced storage solutions and implementing multiple directory and file sharing services.

Startdatum 06.12.2021 - 09:00
Enddatum 10.12.2021 - 17:00
Anmeldungsende 03.12.2021 - 09:00
Netto Einzelpreis € 3.555,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. Oracle Linux System Administration
Ort Live Online

In this Oracle Database 12c R2: Backup and Recovery Workshop, students learn how to perform backup and recovery based on the related Oracle Database architecture components. Various backup, failure, restore, and recovery scenarios are provided so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. This course includes an interactive workshop, with scenarios that provide participants with opportunities to diagnose and recover from several failure situations.

Learn To:

  • Develop appropriate backup and recovery procedures to address your business needs.
  • Implement backup and recovery settings and perform backup operations to disk and tape.
  • Employ Oracle Database recovery procedures to recover from media and other failures.
  • Diagnose and repair data failures.
  • Use Flashback Technologies and data duplication to complement backup and recovery procedures.
  • Secure the availability of your database by appropriate backup and recovery strategies.

 

 

 

 

 

Startdatum 06.12.2021 - 09:00
Enddatum 10.12.2021 - 17:00
Anmeldungsende 03.12.2021
Netto Einzelpreis € 3.600,00
Speaker Deutsch
Number Hours 9:00 - 17:00
Kurs-Nr. Oracle Database: Backup & Recovery Workshop
Ort Live Online

This entry-level course is aimed at programmers who are new to Java and who need to learn its concepts, language constructs, and data types. Included in the agenda are topics on exception handling, lambda expressions, and modular programming.

The course is designed for programmers who will apply these language skills to develop programs using the latest major versions of the JDK, currently Java 11. Students practice the skills learned in each lesson through hands-on labs

Learn To:

    Use Java programming language constructs to create a Java technology application.
    Use decision and looping constructs and methods to dictate program flow.
    Understand basic object oriented concepts such as inheritance, encapsulation, and abstraction.
    Use and manipulate object references, and to write simple error handling code.
    Use the new SE 8 java.time and java.time.format packages to format and print the local date and time.
    Specify a data modification by passing a predicate lambda expression to the Collections class.

Startdatum 06.12.2021 - 09:00
Enddatum 10.12.2021 - 17:00
Anmeldungsende 03.12.2021 - 00:09
Netto Einzelpreis € 2.800,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. D91663: Java SE 8 Fundamentals
Ort Live Online

This Exadata Database Machine: Administration Workshop training introduces you to Oracle Exadata Database Machine, covering the features and capabilities of the Exadata Database Machine X6 product family. In this course, you will be introduced to Oracle Database Exadata Cloud Service.

Explore the various Exadata Database Machine features and configurations, with emphasis on the unique capabilities delivered by Exadata Storage Server. This course uses a virtualized environment for the hands-on component.

Learn To:

  • Describe Exadata Storage Server and how it's different from traditional database storage.
  • List the key capabilities and features of Exadata Database Machine and Exadata Storage Server.
  • Initially configure Exadata Database Machine and make appropriate up-front configuration decisions.
  • Implement Exadata Storage Server security.
  • Use query execution plans, statistics and wait events to examine Exadata Smart Scan.
  • Describe various options and best-practice recommendations for consolidation on Exadata Database Machine.
  • Describe various options for migrating to Database Machine and how to select the best approach.
  • Perform various maintenance tasks on Exadata Database Machine.
  • Configure Enterprise Manager Cloud Control 12c in conjunction with Exadata Database Machine.
  • Monitor Exadata Database Machine using the monitoring infrastructure inherently within Exadata Database Machine, along with the monitoring capabilities exposed through Enterprise Manager Cloud Control 12c.
  • Use other utilities for monitoring Exadata Database Machine which are supplied by Oracle.
  • Gain an understanding of the Oracle Database Exadata Cloud Service.

Benefits to You

Maximize the efficiency and effectiveness of your Exadata Database Machines. Develop an understanding of implementing the best practices taught in the course.

Hands-On Experience

Best-practice recommendations are highlighted throughout; and, where possible, the topics are reinforced through participation in structured hands-on lab exercises.

Startdatum 06.12.2021 - 09:00
Enddatum 10.12.2021 - 17:00
Anmeldungsende 03.12.2021
Netto Einzelpreis € 5.500,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. Exadata Database Machine: 12c Administration Workshop
Ort Live Online

The Oracle Linux 7: System Administration training helps you develop a range of skills, including installation, using the Unbreakable Enterprise Kernel, configuring Linux services, preparing the system for the Oracle Database, monitoring and troubleshooting.

Learn To:

  • Enable kernel features.
  • Set up users and groups.
  • Configure system logging, the boot process, the network and storage.
  • Install additional software packages.
  • Keep the kernel up to date by using Ksplice.
  • Understand how implementing Ksplice gives you zero down time kernel updates.
  • Configure services such as NTP, NFS, FTP, OpenSSH, firewalls and iptables.

Benefits to You

By taking this course, you'll walk away with the knowledge and skills to handle typical issues faced by administrators, while understanding the kernel development model and Linux distributions. Become more familiar with how Oracle Linux brings you the latest Linux innovations, delivering extreme performance, advanced scalability and reliability for enterprise applications and systems.

Startdatum 06.12.2021 - 09:00
Enddatum 10.12.2021 - 17:00
Anmeldungsende 03.12.2021 - 09:00
Netto Einzelpreis € 3.555,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. Oracle Linux 7 System Administration
Ort Live Online

Java Enterprise Edition (Java EE/JEE) is a powerful platform for building enterprise applications. This hands-on course is an accelerated course that covers the core technologies of JEE. It includes in-depth coverage of using JSF2 (JavaServer Faces 2), EJB3 (Enterprise JavaBeans 3), and JPA2 (Java Persistence API 2) to design and build your own multi-tier applications, as well as overview of other important technologies such as JAX-WS for building Java-based Web services.

The course begins with the Web tier - providing a brief overview of the Servlet API and technology, which is the foundation for JSF. It then moves on to comprehensive coverage of JSF2 - JEE’s component based UI framework - including coverage of Facelets and the JSF tag libraries. It moves on to cover EJB, the foundation of JEE’s business tier, including stateless and stateful session beans, and using its declarative transaction control. It then moves on to the business tier, covering JPA’s powerful Object-Relational mapping capabilities for accessing persistent data.

The course also provides overviews of other important technologies such as JAX-WS for building SOAP-based Web services, and JAX-RS for building RESTful services.

The course covers all the important concepts necessary to use the three core technologies of JSF, EJB, and JPA, as well as where the other technologies fit into the picture. It includes an extensive series of labs to exercise all major capabilities, and will leave you well prepared to use these technologies to build multi-tier enterprise systems.

Startdatum 06.12.2021 - 09:00
Enddatum 10.12.2021 - 17:00
Anmeldungsende 03.12.2021
Netto Einzelpreis € 2.800,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. JEEwJSF2EJB3aJPA2
Ort Live Online

Im Kurs "Oracle Database: SQL Tuning for Developers" lernen die Teilnehmer Oracle SQL-Tuning kennen und erfahren, wie sie die Tuningverfahren auf ihren SQL-Code anwenden. Die Teilnehmer lernen die verschiedenen Möglichkeiten kennen, mit denen sie effizient auf Daten zugreifen können.

Lernziele:

  • Mit Oracle-Tools ineffiziente SQL-Anweisungen identifizieren
  • Automatisches SQL-Tuning
  • SQL-Überwachung in Echtzeit
  • Effizientere SQL-Anweisungen erstellen
  • High-Load-SQL-Anweisungen überwachen und tracen
  • Optimizer-Statistiken für Datenbankobjekte verwalten
  • Prozessschritte und Operatoren des Optimizers verstehen
  • Ausführungspläne interpretieren
  • Anwendungs-Tracing durchführen

Vorteile für Teilnehmer:

Dieser Kurs setzt den Schwerpunkt auf die Anwendungsentwicklung. Die Teilnehmer profitieren von einem tieferen Verständnis hinsichtlich der Optimierung von Oracle SQL-Anweisungen und der Erstellung optimaler SQL-Anweisungen für die Oracle-Datenbank. Sie lernen, SQL-Code korrekt zu lesen, die richtigen Entscheidungen zu treffen und den Code zu optimieren. Hierzu werden verschiedene Verfahren erläutert.

 

 

 

 

Startdatum 08.12.2021 - 09:00
Enddatum 10.12.2021 - 17:00
Anmeldungsende 03.12.2021 - 09:00
Netto Einzelpreis € 2.100,00
Speaker Deutsch
Number Hours 09:00 - 17:00
Kurs-Nr. Oracle Database: SQL Tuning for Devalopers
Ort Live Online

Oracle Database 12c: Clusterware & ASM Admin Accelerated training covers 6 days worth of content in only 5 days. It starts with the Oracle Database 12c: Clusterware Admin Ed 1 course (4 days) and then covers the Oracle Database 12c: ASM Administration course (2 days). Learn about Oracle Clusterware and ASM architectures and how these products work together.

Learn To:

  • Perform Grid Infrastructure pre-installation tasks.
  • Install both Standard and Flex clusters.
  • Add and remove nodes from a cluster in addition to upgrading and patching existing Grid Homes.
  • Manage and administer both Standard Clusters and Policy-Managed Clusters.
  • Use Oracle Clusterware to make applications highly available.
  • Administer ASM files, directories, templates, and disk groups.
  • Manage and administer Oracle Cloud File System and its components.
  • Configure and manage advanced CloudFS features like ACFS Auditing and Encryption, ACFS Replication and High Availability NFS.

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 by learning about the Oracle Database 12c Grid Infrastructure, specifically about Oracle Cluster and Oracle ASM.

 

 

 

 

 

 

 

 


 

 

Startdatum 13.12.2021 - 09:00
Enddatum 17.12.2021 - 17:00
Anmeldungsende 10.12.2021 - 09:00
Netto Einzelpreis € 4.878,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. Oracle Database 12c: Clusterware & ASM Admin Accelerated
Ort Live Online

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.

Startdatum 13.12.2021 - 09:00
Enddatum 17.12.2021 - 17:00
Anmeldungsende 10.12.2021 - 09:00
Netto Einzelpreis € 3.555,00
Speaker Deutsch / English
Number Hours 9:00-17:00 Uhr
Kurs-Nr. D80153: Oracle WebLogic Server 12c: Administration II
Ort Live Online

The Oracle Solaris Cluster 4.x Administration Ed 4 course provides students with the essential information and skills needed to install and administer Oracle Solaris Cluster 4.3 hardware and software systems. Students are introduced to Oracle Solaris Cluster 4.3 hardware and software product features, hardware configuration, software installation along with configuration, data service configuration, and system operation. Students will get the opportunity to explore various use cases such as integrating Oracle database 12c as failover application, configuring Oracle Solaris cluster using unified archives.

Learn To:

  • Describe Oracle Solaris Cluster hardware and software.
  • Establish Cluster node console connectivity.
  • Prepare for the Oracle Solaris Cluster installation.
  • Configure the Oracle Solaris Cluster software.
  • Configure Oracle Solaris Cluster quorum devices and device fencing.
  • Use Cluster commands to administer global properties, quorum, disk paths, and interconnect components.
  • Configure volume management with ZFS and Solaris Volume Manager.
  • Manage the public network with IPMP and link aggregation.
  • Describe resources and resource groups, configure a failover data service resource group (Network File System [NFS]), and configure a scalable data service resource group (Apache), Advanced Resource Group Relationships.
  • Configure solaris10 branded zone, kernel zones, build zone clusters, migrate scalable application from global zone to zone cluster.
  • Explore Oracle Solaris Cluster use cases.

Benefits to You

This course provides an intensive hands-on experience for key system administration tasks aimed at giving students experience installing, configuring, and managing an Oracle Solaris Cluster 4.3 environment. Students will get the opportunity to explore various use cases integrating Oracle database 12c as failover application, configuring Oracle Solaris cluster using unified archives.

 

 

Startdatum 13.12.2021 - 09:00
Enddatum 17.12.2021 - 17:00
Anmeldungsende 10.12.2021 - 09:00
Netto Einzelpreis € 4.270,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. D74942: Oracle Solaris Cluster 4.x Administration
Ort Live Online

In dieser Schulung "Oracle Database 12c: Data Guard Administration" lernen Sie die Verwendung von Oracle Data Guard. Erfahrene Oracle University-Dozenten demonstrieren, wie Sie Ihre Oracle-Datenbank gegen geplante und ungeplante Ausfallzeiten schützen.

Lernumfang:

  • Hoch verfügbare Systeme erstellen
  • Geschäftliche Verarbeitungsanforderungen auf ein anderes System auslagern
  • Backupanforderungen auf ein anderes System auslagern

Vorteile für Teilnehmer

Nach Ablauf dieses Kurses verstehen Sie, wie Sie mit Data Guard-Standbydatenbanken verschiedene Produktionsfunktionen unterstützen können. Zu diesen Funktionen zählen die Ausführungen von Berichten, Abfragen und Tests mit der Standbyrolle.

Oracle Data Guard 12c

Außerdem lernen Sie in diesem Kurs die neuen Features und die Architektur von Oracle Data Guard 12c kennen. Sie erörtern Themen wie Oracle Active Data Guard, Far Sync, Rolling Upgrades und Snapshot-Standbydatenbanken. Außerdem lernen Sie in diesem Kurs, wie Sie Data Guard-Konfigurationen verwalten und Fehler beheben.

Startdatum 13.12.2021 - 09:00
Enddatum 16.12.2021 - 17:00
Anmeldungsende 10.12.2021 - 09:00
Netto Einzelpreis € 3.400,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. D79232-Oracle Database 12c: Data Guard Administration
Ort Live Online

This is a modern, fast-paced course suitable for developers with some previous experience in working with Java and Object-Oriented (OO) programming. The course can also be delivered to developers experienced in other OO languages (Python, C++, C#) but with limited Java exposure, as well as used as an advanced Java course for more experienced developers.

It includes an accelerated, yet thorough, hands-on review of Java foundational concepts, with attention given to OO design and implementation principles. This review also includes an overview of newer language features such as the Date/Time API (Java 8+), type inference with var, and switch expressions.

It then moves on to comprehensive coverage of more advanced topics in Java and OO development to provide participants with a strong grounding to use Java in a sophisticated and productive manner. This includes in-depth coverage of functional programming with lambdas and streams, as well as the Java Platform Module System (JPMS). Java modules presents a fundamental shift in how applications are organized, and interconnected to the libraries they use. Migration strategies are also covered, including a step-by-step case study.

This course covers far more than an introductory course, including important topics such as UML and Design Patterns, and using composition vs. inheritance, which are all key to creating well-structured OO systems. After these important areas, it moves on to the advanced Java topics described above. It teaches a number of useful techniques that enhance productivity and good system design - which may otherwise take Java developers years to absorb on their own.

Unit testing is stressed throughout the course, with most labs implemented as JUnit tests.

The course is very hands-on, including numerous code examples and programming labs that reinforce the concepts presented, so that you can immediately employ what you’ve learnt in your current project.

Be prepared to work hard and learn a great deal!

Startdatum 13.12.2021 - 09:00
Enddatum 17.12.2021 - 17:00
Anmeldungsende 10.12.2021
Netto Einzelpreis € 2.300,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. JIA11PLUS
Ort Live Online

The Oracle Database: Develop PL/SQL Program Units Ed 2 course helps students enhance their skills as PL/SQL developers by learning to develop stored procedures, functions, packages, and database triggers.

Startdatum 15.12.2021 - 09:00
Enddatum 17.12.2021 - 09:00
Anmeldungsende 13.12.2021 - 09:00
Netto Einzelpreis € 2.100,00
Speaker English
Number Hours 9:00-17:00 Uhr
Kurs-Nr. OD1001: Oracle Database: Develop PL/SQL Program Units
Ort Live Online

Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements from high-volume, 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.

Learn To:

  • Use Oracle Data Integrator to perform transformation of data among various platforms.
  • Design ODI mappings, procedures, and packages to perform ELT data transformations.
  • Administer ODI resources and set up security with ODI.
  • Perform data integration and transformation among various platforms.
  • Use the ODI graphical interface to define procedures, packages, and ELT jobs.
  • Set up and maintain a secure, multi-user ODI environment.
  • Implement changed data capture with ODI.
  • Use ODI Web services and perform integration of ODI with SOA.

Benefits to You

Taking this course will teach you how to improve performance and reduce integration costs across your organization's heterogeneous systems. You'll be able to centralize data across databases using your new skills to perform data integration, design ODI Mappings, and set up ODI security. In addition, Oracle Data Integrator can interact with the various tools of the Hadoop ecosystem (such as Hive, Hbase, HDFS, Oozie, etc), allowing administrators and data scientists to farm out map-reduce operations from established relational databases to Hadoop. They can also read back into the relational world the results of complex Big Data analysis for further processing.

Implement High-Performance Movement and Transformation

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.

ODI Repositories

Using the graphical interfaces, you'll develop the knowledge to create and manage ODI repositories, which store configuration information about the IT infrastructure, the metadata for all applications, projects, models and other ODI artifacts.

ODI Topology, Models, Mappings, and Other Objects

Furthermore, you'll develop the ability to create the ODI Topology, organize ODI models and design ODI Mappings, procedures, packages and other objects. This course is based on Oracle Data Integrator 12c (12.2.1).

Please Note

The latest release of Oracle Data Integrator supports storing ODI artifacts into source code management systems (such as Subversion.) This course teaches you how to integrate ODI with Subversion


  • Benutzer erstellen und verwalten
  • Datenbank überwachen und Leistung verwalten
  • Grundlegende Backup- und Recovery-Verfahren kennen lernen
  • Mit Oracle Support Workbench und My Oracle Support die Oracle Database-Software aktualisieren

 

Startdatum 20.12.2021 - 09:00
Enddatum 23.12.2021 - 17:00
Anmeldungsende 17.12.2021
Netto Einzelpreis € 3.975,00
Speaker Deutsch / English
Number Hours 09:00-17:00
Kurs-Nr. D82167: Oracle Data Integrator 12c: Integration and Administration
Ort Live Online

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.

 

Startdatum 20.12.2021 - 09:00
Enddatum 21.12.2021 - 17:00
Anmeldungsende 17.12.2021 - 09:00
Netto Einzelpreis € 1.400,00
Speaker Deutsch/English
Kurs-Nr. D77758: Oracle Database 12c R1: New Features for 12c R1 Administrators
Ort Live Online

Kurssuche

Von Datum
Bis Datum
Ort