Oracle Seminare

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.

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

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.

This is a second-level course for programmers learning the Java language. It rounds-out the topics that were taught in the previous course, Java SE: Programming I, and provides additional key skills for Java programmers, such as secure coding, modular programming, and database access.

This course uses today's main Java version for its practices (currently Java 11).

Learn To:

• Create Java technology applications with the latest JDK Technology
• Develop your object-oriented skills
• Identify good practices in the use of the language to create robust Java application
• Use Lambda expressions in Java applications
• Store and manipulate data using collections
• Manipulate files, directories and file systems
• Connect to databases using standard SQL queries through JDBC
• Create high-performance multi-threaded applications

Benefits to You

You can use this course to further develop your skills with the Java language and prepare for the Oracle Certified Professional, Java SE 8 Programmer Exam!

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.

The MySQL for Database Administrators course teaches DBAs and other database professionals how to maximize their organization's investment in MySQL and about the benefits of using the MySQL Cloud Service. Learn to configure the MySQL Server, set up replication and security, perform database backups, optimize query performance, and ensure high availability.

Through a variety of realistic, hands-on activities, expert MySQL instructors will teach you to install, configure, secure, and maintain your database server which you can deploy on-premise or as a MySQL Cloud Service instance.

Learn To:

• Install and configure MySQL Server and client programs.
• Recognize the key components of the MySQL architecture.
• Secure your server.
• Troubleshoot server slowdowns and other issues.
• Improve query performance.
• Configure and administer a variety of replication topologies.
• Understand the benefits of MySQL Cloud.

Benefits To You:

After taking this course, you will be equipped to use all the features of MySQL to get the best out of your Web, Cloud, and embedded applications, whether you work with the command line or graphical tools such as MySQL Workbench and MySQL Enterprise Monitor, whether you use on-premise or MySQL Cloud-based instances, and whether your challenge is complex replication requirements, or highly-tuned transactional systems.

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.

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 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.

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.