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

Live Online und ohne Reisekosten bestens geschult:
Unkompliziert und direkt vom Homeoffice in den Live Online 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.

 

 

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

Startdatum 04.12.2023 - 09:00
Enddatum 08.12.2023 - 17:00
Anmeldungsende 01.12.2024 - 13:20
Netto Einzelpreis € 3.555,00
Speaker English
Kurs-Nr. D49366GC30: Oracle Linux System Administration III LVC
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 08.04.2024 - 09:00
Enddatum 12.04.2024 - 17:00
Anmeldungsende 31.05.2024
Netto Einzelpreis € 3.600,00
Speaker Deutsch
Number Hours 9:00 - 17:00
Kurs-Nr. Oracle Database: Backup & Recovery Workshop
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 22.04.2024 - 09:00
Enddatum 26.04.2024 - 17:00
Anmeldungsende 05.04.2024
Netto Einzelpreis € 3.600,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. D105916: Oracle Database: Administration Workshop
Ort Live Online

Abgeschlossen

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 22.04.2024 - 09:00
Enddatum 26.04.2024 - 17:00
Anmeldungsende 19.04.2024
Netto Einzelpreis € 3.800,00
Speaker English
Kurs-Nr. D61830 - Oracle Database 12c: Program with PL/SQL
Ort Live Online

Abgeschlossen

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 22.04.2024 - 09:00
Enddatum 26.04.2024 - 17:00
Anmeldungsende 19.04.2024 - 09:00
Netto Einzelpreis € 3.555,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. Oracle Linux System Administration
Ort Live Online

Abgeschlossen

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.04.2024 - 09:00
Enddatum 26.04.2024 - 17:00
Anmeldungsende 04.04.2024 - 09:00
Netto Einzelpreis € 4.860,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. D80149: Oracle WebLogic Server 12c: Administration I
Ort Live Online

Abgeschlossen

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 06.05.2024 - 09:00
Enddatum 10.05.2024 - 17:00
Anmeldungsende 03.05.2024
Netto Einzelpreis € 3.600,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. Oracle Database 12c: Performance Management and Tuning
Ort Live Online

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

Startdatum 13.05.2024 - 09:00
Enddatum 17.05.2024 - 17:00
Anmeldungsende 10.05.2024 - 13:20
Netto Einzelpreis € 3.555,00
Speaker English
Kurs-Nr. D49366GC30: Oracle Linux System Administration III LVC
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.05.2024 - 09:00
Enddatum 17.05.2024 - 17:00
Anmeldungsende 10.05.2024
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

The Oracle Linux 8: 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 13.05.2024 - 09:00
Enddatum 17.05.2024 - 17:00
Anmeldungsende 10.05.2024 - 09:00
Netto Einzelpreis € 3.555,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. Oracle Linux 8 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 14.05.2024 - 09:00
Enddatum 17.05.2024 - 17:00
Anmeldungsende 10.05.2024 - 09:00
Netto Einzelpreis € 3.840,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. D79232-Oracle Database 12c: Data Guard Administration
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 20.05.2024 - 09:00
Enddatum 24.05.2024 - 17:00
Anmeldungsende 17.05.2024 - 09:00
Netto Einzelpreis € 4.860,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 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 22.05.2024 - 09:00
Enddatum 24.05.2024 - 17:00
Anmeldungsende 17.05.2024 - 09:00
Netto Einzelpreis € 2.880,00
Speaker English
Number Hours 9:00-17:00 Uhr
Kurs-Nr. OD1001: Oracle Database: Develop PL/SQL Program Units
Ort Live Online

Oracle Solaris 11 Advanced System Administration (Duration: 5 Days; Lab: None ) 

This course will be delivered without a lab

The Oracle Solaris 11 Advanced System Administration training expands your mastery of the enterprise-level Oracle Solaris 11 operating system. You're presented with complex and integrated administration concepts, supported by an intensive hands-on experience.

Objectives:

  • Installing Oracle Solaris 11 OS on Multiple Hosts
  • Managing the Image Packaging System (IPS) and Packages
  • Managing the Business Application Data
  • Configuring Network and Traffic Failover
  • Configuring Zones and the Virtual Network
  • Managing Services and Service Properties
  • Configuring Privileges and Role-Based Access Control
  • Securing System Resources using Solaris Auditing
  • Managing Processes and Priorities
  • Evaluating the System Resources
  • Monitoring and Troubleshooting Software Failures

 

Startdatum 27.05.2024 - 09:00
Enddatum 31.05.2024 - 17:00
Anmeldungsende 24.05.2024 - 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

This course will be delivered with a live lab

This course will teach you about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion.

Learn To:

  • Install and configure RAC
  • Manage RAC Database
  • Upgrade and patch RAC Database
  • Manage backup and recovery for RAC
  • Monitor and tune RAC Database
  • Manage high availability of services
  • Implement High Availability for connections and applications
  • Configure RAC One Node Database
  • Implement In-Memory Column Store in RAC
  • Configure Multitenant Architecture in RAC
  • Manage Quality of Service in RAC

Objectives:

Upon completion of this course, the student should be able to:

  • Grid Infrastructure: Overview
  • RAC Databases Overview and Architecture
  • Installing and Configuring Oracle RAC
  • Oracle RAC Administration
  • Upgrading and Patching Oracle RAC
  • Managing Backup and Recovery for RAC
  • Global Resource Management Concepts
  • RAC Database Monitoring and Tuning
  • RAC Database Monitoring and Tuning
  • High Availability for Connections and Applications
  • Oracle RAC One Node
  • Oracle Database In-Memory in RAC
  • Multitenant Architecture and RAC
  • Quality of Service Management

 

 


 

 

Startdatum 10.06.2024 - 09:00
Enddatum 14.06.2024 - 17:00
Anmeldungsende 07.06.2024 - 09:00
Netto Einzelpreis € 4.800,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. Oracle Database 12c: RAC 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 17.06.2024 - 09:00
Enddatum 21.06.2024 - 17:00
Anmeldungsende 14.06.2024 - 09:00
Netto Einzelpreis € 3.650,00
Speaker Deutsch
Number Hours 09:00 - 17:00
Kurs-Nr. OSQL20100: Oracle SQL Workshop
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 24.06.2024 - 09:00
Enddatum 28.06.2024 - 17:00
Anmeldungsende 07.06.2024 - 09:00
Netto Einzelpreis € 3.600,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. D105916: Oracle Database: Administration 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 24.06.2024 - 09:00
Enddatum 28.06.2024 - 17:00
Anmeldungsende 21.06.2024 - 09:00
Netto Einzelpreis € 3.555,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. Oracle Linux System Administration
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.07.2024 - 09:00
Enddatum 03.07.2024 - 17:00
Anmeldungsende 28.06.2024 - 09:00
Netto Einzelpreis € 2.880,00
Speaker Deutsch
Number Hours 09:00 - 17:00
Kurs-Nr. Oracle Database: SQL Tuning for Devalopers
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 08.07.2024 - 09:00
Enddatum 12.07.2024 - 17:00
Anmeldungsende 05.07.2024
Netto Einzelpreis € 5.500,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. Exadata Database Machine: 12c Administration Workshop
Ort Live Online

Kurssuche

Von Datum
Bis Datum
Ort