Oracle Seminare

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.

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!

The Oracle Linux System Administration III course covers implementation of advanced Linux file systems, configuring virtualization services and resource management controls, use of Docker containers and Kubernetes container orchestration services, advanced security services, and advanced diagnostics services. The course also provides an extensive hands-on experience for advanced system administration tasks.

Learn to:

• Address today's large storage requirements including the Oracle Cluster File System, iSCSI and multipathing, and use of the Gluster File System.
• Manage resources to deliver consistent response times and performance.
• Allocate system resources to specific Linux processes.
• Use DTrace, which provides a comprehensive look into the software stack and enables you to identify performance bottlenecks.
• Use container technologies, including Oracle Container Runtime for Docker and Oracle Linux Container Services for use with Kubernetes.
• Use the Linux Auditing System and OpenSCAP to enhance system security.

Benefits To You:

After taking this course, you will be equipped to use the advanced features of Oracle Linux to get the most out of your systems and applications. You'll learn how to use Control Groups, Docker Containers, and KVM to increase your resource utilization by creating secure, isolated environments on a single host. Manage a cluster of containers across a cluster of systems by using the Kubernetes container orchestrator.

Erforderliche Vorkenntnisse:
   Oracle Linux System Administration II

Fast Track to Java and OO Development provides a comprehensive introduction to Java. It is suitable for programmers with good working programming experience (no Java experience needed). It can be taught to audiences with less experience by reducing coverage of the optional, more advanced, topics.

In addition to covering basic Java programming, the course provides a solid understanding of the core OO and Java concepts and practices needed to create well-designed Java programs. This includes creating well-designed Java classes, encapsulation, composition, and inheritance/interfaces.

The material and labs include coverage of useful new Java capabilities such as the new Java 9 module structure, type inference (Java 10-11), and API enhancements. It also introduces important APIs such as the Java Collections Framework, and JDBC/JPA. This course is suitable for environments using Java 9-11. It also covers details of the Java release cycle, and Long Term Support (LTS) releases.

In diesem Kurs "Oracle Database 12c: RAC Administration" erhalten Sie eine Einführung in die Architektur der Oracle RAC-Datenbank. Erfahrene Dozenten von Oracle University vermitteln Ihnen fundierte Kenntnisse zu globalen Ressourcen und Cache Fusion.

Lernumfang:

• Oracle RAC installieren
• Clusterdatenbanken erstellen
• Administrator- und Policy-verwaltete Oracle RAC-Datenbanken verwalten
• Performanceprobleme überwachen und beseitigen
• Der Kurs vermittelt Kenntnisse zu den Services in einer RAC-Umgebung sowie zu hochverfügbaren Verbindungsfunktionen wie Application Continuity und Transaction Guard.
• RAC One Node-Datenbanken erstellen und verwalten
• RAC-Datenbanken für Mehrmandanten erstellen und verwalten

Vorteile für Teilnehmer

Schnelle, zuverlässige, sichere und einfach zu verwaltende Performance sicherstellen Datenbank-Workloads optimieren, IT-Kosten senken und durch die Konsolidierung in Datenbankclouds eine höhere Servicequalität erzielen

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.

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!

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.

Die Schulung Oracle WebLogic Server 12c: Administration 1" erläutert Administratoren die Aufgaben bei der Installation und Konfiguration von Oracle WebLogic Server 12c und vermittelt Administratoren einen Überblick über die Architektur und Konzepte, die WebLogic Server zugrunde liegen.

Vorteile für Teilnehmer

Durch die Teilnahme an diesem Kurs, verbessern Sie die Performance und Skalierbarkeit der Anwendungen und Services Ihrer Organiation mit dem branchenweit führenden Anwendungsserver. Sie vereinfachen das Deployment und beschleunigen die Markteinführung erheblich

Lernumfang:

• Oracle WebLogic Server installieren
• Oracle WebLogic Server konfigurieren
• Oracle WebLogic Server verwalten
• Domainressourcen überwachen
• Anwendungen bereitstellen
• Domain erstellen
• Server 
starten
• Domainressourcen überwachen
• Node Manager einrichten und konfigurieren
• Anwendungen bereitstellen
• Ressourcen konfigurieren
• Cluster konfigurieren

In the Oracle Database 12c: Performance Management and Tuning course, learn about the performance analysis and tuning tasks expected of a DBA: proactive management through built-in performance analysis features and tools, diagnosis and tuning of the Oracle Database instance components, and diagnosis and tuning of SQL-related performance issues. In this course, you will be introduced to Oracle Database Cloud Service.

Learn To:

• Use the Oracle tuning methodology.
• Use Oracle-supplied tools for monitoring and diagnosing SQL and instance performance issues.
• Use database advisors to proactively correct performance problems.
• Identify and tune problem SQL statements.
• Monitor instance performance by using Enterprise Manager.
• Tune instance components.
• Gain an understanding of the Oracle Database Cloud Service.

Benefits To You:

The DBA will analyze the SQL performance with available tools. The DBA will be introduced to various methods of identifying the SQL statements that require tuning and the diagnostic tools used to find ways to improve performance. This will include the use of statistics, profiles to influence the optimizer, and using the SQL Advisors.

Maintain SQL Performance

A major task of DBAs is to maintain SQL performance across changes. This course introduces Database Replay and SQL Performance Analyzer which help the DBA test and minimize the impact of change.

Influence Instance Behavior

Instance tuning uses the same general method of observing a problem, diagnosing the problem, and implementing a solution. The instance tuning lessons cover the details of major tunable components and describe how you can influence the instance behavior. For each lesson, we will examine the relevant components of the architecture. The course only discusses the architecture to the level required to understand the symptoms and solutions. More detailed explanations are left to other courses, reference material, and the Oracle documentation.

Fast Track to Java and OO Development provides a comprehensive introduction to Java. It is suitable for programmers with good working programming experience (no Java experience needed). It can be taught to audiences with less experience by reducing coverage of the optional, more advanced, topics.

In addition to covering basic Java programming, the course provides a solid understanding of the core OO and Java concepts and practices needed to create well-designed Java programs. This includes creating well-designed Java classes, encapsulation, composition, and inheritance/interfaces.

The material and labs include coverage of useful new Java capabilities such as the new Java 9 module structure, type inference (Java 10-11), and API enhancements. It also introduces important APIs such as the Java Collections Framework, and JDBC/JPA. This course is suitable for environments using Java 9-11. It also covers details of the Java release cycle, and Long Term Support (LTS) releases.