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.

 

 

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 03.12.2020 - 09:00
Enddatum 04.12.2020 - 17:00
Anmeldungsende 01.12.2020 - 17: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 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 07.12.2020 - 09:00
Enddatum 11.12.2020 - 17:00
Anmeldungsende 04.12.2020 - 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

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 07.12.2020 - 09:00
Enddatum 10.12.2020 - 17:00
Anmeldungsende 04.12.2020 - 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 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.

 

 

 

 

Startdatum 07.12.2020 - 09:00
Enddatum 11.12.2020 - 17:00
Anmeldungsende 04.12.2020 - 00:51
Netto Einzelpreis € 3.500,00
Speaker Deutsch
Number Hours 09:00 - 17:00
Kurs-Nr. D80174: Oracle Database: PL/SQL Fundamentals
Ort Live Online
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.
 
Startdatum 14.12.2020 - 09:00
Enddatum 18.12.2020 - 17:00
Anmeldungsende 07.12.2020 - 09:00
Netto Einzelpreis € 3.300,00
Speaker English
Kurs-Nr. D61830 - Oracle Database 12c: Program with PL/SQL
Ort Live Online

Kursinhalte als PDF

 

Dieser Kurs eignet sich für Teilnehmer, die nicht nur in einer Oracle Cloud Umgebung mit einer Oracle Datenbank arbeiten wollen. Die Teilnehmer lernen in diesem Workshop, wie bei den anderen Kursen, die Administration einer Datenbank kennen. Es wird jedoch zusätzlich auch die Installation der Software  und die Erstellung von Datenbanken (unabhängig von einer Cloudumgebung) mit einem graphischem Tool, aber auch skriptgesteuert durchgeführt. Ebenso wird das Upgrade von Datenbankreleases behandelt. Die Teilnehmer lernen nicht nur den Enterprisemanager Express kennen. Auch die Installation und Benutzung von Enterprise Manager Cloud Control wird behandelt. Enterprise Manager Cloud Control  ist das professionelle Verwaltungs- und Überwachungs-Tool von Datenbanken, unabhängig davon, ob sich die Datenbank in einer Cloud befindet oder nicht. Der Zusatz im Namen, Cloud Control, ist sehr irreführend. Der Enterprise Manager Database Express ist von seiner Funktionalität gegenüber Enterprise Manager Cloud Control sehr eingeschränkt.

Zielgruppe:

  • Administratoren
  • Benutzerservice
  • Consultants
Startdatum 14.12.2020 - 09:00
Enddatum 18.12.2020 - 17:00
Anmeldungsende 11.12.2020 - 09:00
Netto Einzelpreis € 3.000,00
Speaker Deutsch
Number Hours 09:00 - 17:00
Kurs-Nr. ODAW20100: Oracle Datenbankadministration Workshop
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 14.12.2020 - 09:00
Enddatum 18.12.2020 - 17:00
Anmeldungsende 11.12.2020 - 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 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 14.12.2020 - 09:00
Enddatum 18.12.2020 - 17:00
Anmeldungsende 11.12.2020
Netto Einzelpreis € 3.500,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 14.12.2020 - 09:00
Enddatum 18.12.2020 - 17:00
Anmeldungsende 11.12.2020 - 00:09
Netto Einzelpreis € 2.390,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. D91663: Java SE 8 Fundamentals
Ort Live Online

This course provides an overview of the Oracle Database 18c new features and enhancements related to Multitenant architecture, security, RMAN, general database areas, performance, data warehousing and Sharding.

Learn To:

  • Use new features like Application PDB Fleet and PDB snapshots carousel of the Multitenant architecture.
  • Understand new features like PDB keystores and encryption of sensitive data in Database Replay files of the Security.
  • Benefit from new features like reuse of preplugin backups and duplication of active PDBs into an existing CDB of RMAN.
  • Use new features like private temporary tables and online modification of partitioning and subpartitioning strategy of General Database.
  • Configure and use new features like Automatic In-Memory Management in Performance.
  • Manipulate new features like inline external tables and polymorphic table functions of the Data Warehousing.
  • Understand enhancements like user-defined sharding method and support for PDBs as shards in Sharding.
Startdatum 21.12.2020 - 09:00
Enddatum 23.12.2020 - 17:00
Anmeldungsende 18.12.2020 - 09:00
Netto Einzelpreis € 2.133,00
Speaker Deutsch/English
Kurs-Nr. D77758: Oracle Database 12c R1: New Features for 12c R1 Administrators
Ort München

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.

 

 

 

 

Startdatum 25.01.2021 - 09:00
Enddatum 29.01.2021 - 17:00
Anmeldungsende 22.01.2021
Netto Einzelpreis € 3.500,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. Oracle Database 12c: Performance Management and Tuning
Ort Live Online
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.
 
Startdatum 01.02.2021 - 09:00
Enddatum 05.02.2021 - 17:00
Anmeldungsende 29.01.2021
Netto Einzelpreis € 3.300,00
Speaker English
Kurs-Nr. D61830 - Oracle Database 12c: Program with PL/SQL
Ort Live Online

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.

 

 

 

 

Startdatum 08.02.2021 - 09:00
Enddatum 12.02.2021 - 17:00
Anmeldungsende 05.02.2021
Netto Einzelpreis € 3.500,00
Speaker Deutsch
Number Hours 09:00 - 17:00
Kurs-Nr. D80174: Oracle Database: PL/SQL Fundamentals
Ort Live Online

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 22.02.2021 - 09:00
Enddatum 26.02.2021 - 17:00
Anmeldungsende 19.02.2021 - 09:00
Netto Einzelpreis € 3.300,00
Speaker English
Kurs-Nr. D17218: Oracle Database: SQL and PL/SQL Fundamentals
Ort Live Online

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 22.02.2021 - 09:00
Enddatum 24.02.2021 - 17:00
Anmeldungsende 19.02.2021
Netto Einzelpreis € 2.100,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. D80343- Oracle Database 12c: Advanced PL/SQL
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 22.02.2021 - 09:00
Enddatum 26.02.2021 - 17:00
Anmeldungsende 19.02.2021 - 09:00
Netto Einzelpreis € 3.300,00
Speaker Deutsch
Number Hours 09:00 - 17:00
Kurs-Nr. OSQL20100: Oracle SQL Workshop
Ort Live Online

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

 

 

 

 

Startdatum 22.02.2021 - 09:00
Enddatum 26.02.2021 - 17:00
Anmeldungsende 19.02.2021 - 09:00
Netto Einzelpreis € 3.555,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. D80149: Oracle WebLogic Server 12c: Administration I
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 01.03.2021 - 09:00
Enddatum 03.03.2021 - 17:00
Anmeldungsende 26.02.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

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 08.03.2021 - 09:00
Enddatum 12.03.2021 - 17:00
Anmeldungsende 05.03.2021 - 00:10
Netto Einzelpreis € 2.390,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. D91663: Java SE 8 Fundamentals
Ort Live Online

This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition, you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course.
To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.

What You Will Learn

The Oracle Database 18c: Administration Workshop course provides you with a firm foundation in administration of an Oracle database. In this course, you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner

Learn To:

  • Manage an Oracle Database instance.
  • Configure the Oracle Network environment.
  • Create and manage storage structures.
  • Manage and move data.
  • Create and manage users.
  • Monitor the database and manage performance.
  • Create and manage Database Cloud Service database deployments.

Benefits To You

You will benefit from this course as you learn detailed information on the architecture of an Oracle Database instance and database, enabling you to manage your database resources effectively. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition, you learn how to create users and administer database security to meet your business requirements. This course provides basic information on backup and recovery techniques. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.

Startdatum 15.03.2021 - 09:00
Enddatum 19.03.2021 - 17:00
Anmeldungsende 12.03.2021 - 09:00
Netto Einzelpreis € 3.500,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. D105916: Oracle Database: Administration Workshop
Ort Live Online

Kurssuche

Von Datum
Bis Datum
Ort