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.

 

Kursthemen

Java Schulung Seminar

Lernen Sie die Programmiersprache Java von kompetenten und erfahrenen Trainern. PCIT ist seit 1999 offizieller Schulungspartner der Oracle University (Sun Microsystems). Seit 2014 gibt es das neue Java SE 8, das neben verbesserter Stabilität und Sicherheit eine große Bandbreite von neuen Features bietet. Aber auch beim bewährten Java EE 7, dem Industriestandard für Datenverarbeitung mit Java, stehen wir gerne zu Verfügung.

Dank neuen Funktionen, die den HTML5-Support verbessern, die Entwicklerproduktivität steigern sowie die Erfüllung von Unternehmensanforderungen verbessern, müssen Entwickler weniger Standardcode schreiben, haben einen besseren Support für die neuesten Webanwendungen und -Frameworks und können auf verbesserte Skalierbarkeit und umfangreichere, einfachere Funktionen zugreifen. Wir beraten Sie gerne bei der Umstellung und bieten zertifizierte Fortbildungsmöglichkeiten für Sie und Ihre Mitarbeiter.

Falls Sie Ihren Wunschtermin hier nicht finden, nehmen Sie bitte Kontakt mit uns auf. Wir beraten Sie sehr gerne.

 

PCIT ist seit 1999 "Approved Education Center (OAEC) vom Oracle (Sun Microsystems)". Bei uns können Sie sämtliche Oracle Kurse sowohl in München als auch an allen anderen Schulungsorten buchen. Alle unsere Oracle zertifizierten Trainer haben langjährige Erfahrung in ihrem Gebiet und garantieren den hohen Schulungsstandard.

Das bewährte Enterprise Betriebssystem "Solaris" für Ihre SPARC und x86 Server: Hier erhalten Sie alle Kurse für Einsteiger, Umsteiger und Profis.

MySQL ist die weltweit beliebteste Open Source-Datenbank und ermöglicht die kosteneffiziente Bereitstellung zuverlässiger, hochleistungsfähiger und skalierbarer Web-basierter und eingebetteter Datenbankanwendungen. Neben der Benutzerfreundlichkeit, der hohen Leistungsfähigkeit und Zuverlässigkeit von MySQL profitieren Sie außerdem von den innovativen Funktionen, Management-Tools und dem technischen Support, der Ihnen bei der Entwicklung, Bereitstellung und Verwaltung Ihrer MySQL-Anwendungen zur Verfügung steht.
MariaDB ist ein freies, relationales Open-Source-Datenbank­verwaltungs­system, das durch eine Abspaltung (Fork) aus MySQL entstanden ist. Das Projekt wurde von MySQLs früherem Hauptentwickler Ulf Michael Widenius initiiert, der auch die Storage-Engine Aria entwickelte, auf welcher MariaDB aufbaut (Aria ist diejenige Software-Schicht, welche die Basisfunktionalität der Datenbank enthält, d. h. das Erstellen, Lesen, Ändern, Löschen von Daten).

Stellen Sie die Verfügbarkeit Ihrer Applikationen sicher - Hochverfügbarkeit mit Solaris Cluster.

Seminaranfrage mit Wunschtermin und Teilnehmerzahl bitte hier stellen:

 

Oracle Linux Schulung Seminar

Die vollständig freie auf RedHat basierende Linux Distribution von Oracle ist die bevorzugte Betriebssystem-Plattform für alle x86-basierten Oracle Systeme. Oracle integriert in diese Linux Version den jeweils aktuellen Mainstream Linux Kernel und verzichtet damit auf die bei Redhat verwendeten Backports von Kernel-Erweiterungen. Oracle Linux ist in erster Linie zur Installation auf Servern und Workstations gedacht. Zusammen mit der auf XEN basierenden Virtualisierung Oracle VM und den für viele weitere Oracle Produkte verfügbaren fertigen VMs ist es bestens für den Einsatz im Rechenzentrum geeignet. Außerdem ist Oracle Linux die interne Entwicklungsplattform für viele Produkte und damit ist ein optimales Zusammenspiel von Oracle Linux und darauf aufsetzenden Oracle Produkten geeignet.

Seminaranfrage mit Wunschtermin und Teilnehmerzahl bitte hier stellen:

 

Oracle Database

Seminaranfrage mit Wunschtermin:

 

Oracle WebLogice

Oracle WebLogic Server ist der führende Application Server für herkömmliche und Cloud-Umgebungen. Mit Oracle WebLogic können Sie Anwendungen der nächsten Generation auf einer unternehmenswichtigen Cloud-Plattform bereitstellen, Vorgänge mit systemeigenem Cloud-Management vereinfachen und die Markteinführung mit einer modernen Entwicklungsplattform und integrierten Tools beschleunigen.

Warum Oracle?

Oracle WebLogic Server bietet Flexibilität zwischen Clouds am eigenen Standort und Drittanbieter-Clouds und wurde für Oracle Exalogic Elastic Cloud optimiert. Als Herzstück der Oracle Cloud Application Foundation bietet Oracle WebLogic Server hervorragende Cloud-Performance, Skalierbarkeit und Elastizität, einzigartige Integration in Oracle Database, einschließlich Multi-Tenant-Datenbanksupport, und trägt mit mobiler Anwendungsentwicklung und kompetentem Support zur Produktivität von Entwicklern bei. Oracle ist Marktführer der Branche.

 

Oracle VM

Seminaranfrage mit Wunschtermin und Teilnehmerzahl bitte hier stellen:

 

Exadata Oracle

Die Oracle Exadata Database Machine ist die perfekt abgestimmte Hardware für allerhöchste Performance Ansprüche für den Betrieb von Oracle Datenbanken.

Sie besteht aus horizontal skalierenden x68 Servern und einem einzigartigen intelligenten Storage Server mit InfiniBand und modernster Flash-Technologie.

 

Throughout the lessons of the Oracle Database 12c R2: New Features for Administrators Part 2 course constituted by five modules; the Securing Data module, the Making Data Available module, the Partitioning Data module, the Managing Information Lifecycle module and the Monitoring DB Operations and Managing Performance module, students receive a good knowledge of the Oracle Database 12c Release 2 new and enhanced features in different areas of database administration like Unified Auditing, Transparent Data Encryption (TDE) and other areas of security, Recovery Manager, online operations, Oracle Data Pump, SQL*Loader, new partitioning methods, Automatic Data Optimization, In-Memory Column Store, Full Database In-Memory Caching, and Automatic Big Table Caching.

Learn To:

  • Gain an understanding of the new and enhanced features of Oracle Database 12c Release 2 (12.2.0.1) amongst different areas such as security, availability, partitioning, performance, and Information Lifecycle Management (ILM).

Benefits To You

Benefit from getting a thorough understanding of the following lessons:

  • The lessons of the Securing Data module cover enhancements in auditing like role based conditional auditing, in privilege administration like new system administrative privilege for RAC, in Privilege Analysis and Data Redaction, in Transparent Sensitive Data Protection with new types of policies for FGA and TDE, and finally also in Transparent Data Encryption (TDE).
  • The lessons of the Making Data Available module cover enhanced features in RMAN like table recovery, transport data across platforms, enhancements related to online operations, and finally ongoing enhancements with Oracle Data Pump, SQL*Loader and external tables.
  • The lesson of the Partitioning Data module covers enhancements and new partitioning methods.
  • The lessons of the Managing Information Lifecycle module introduce Heat Map and Automatic Data Optimization with heat map statistics tracking and ADO policies. The lessons also cover Temporal functionalities such as temporal history and temporal validity. In-Database Archiving provides a new feature, the Row-archival.
  • The lessons of the Monitoring DB Operations and Managing Performance module explain the new features to improve the performance of the databases with SQL Performance Analyzer, DB Replay and SQL Plan Management, and to improve query execution with the Optimizer Statistics Advisor, JOIN processing. You will also learn about In-Memory Database option.

 

 

 

 

 


 

 

Startdatum 27.01.2020 - 07:00
Enddatum 31.01.2020 - 15:00
Anmeldungsende 20.01.2020
Netto Einzelpreis € 3.315,00
Speaker English
Kurs-Nr. Oracle Database 12c R2: New Features for Administrators Part 2
Ort LVC

Abgeschlossen

The MySQL for Beginners course helps you learn about the world's most popular open source database. Expert Oracle University instructors will teach you how to use the MySQL Server and tools, while helping you develop deeper knowledge of using relational databases.

Learn To:

  • Explain the relational database model.
  • Describe the features and benefits of MySQL.
  • Install and configure the MySQL server and clients.
  • Design efficient databases.
  • Use Structured Query Language (SQL) to build your database and query data.
  • Employ appropriate MySQL tools.

Benefits to You
This course will teach you everything you need to know to start using the incredibly popular MySQL database in your Web, Cloud and embedded applications. In learning about MySQL, you will develop an understanding of relational databases and how to design a robust and efficient database. You will harness that power by learning SQL and use it to build databases, populate them with data and query that data through extensive hands-on practices.

Manage Your MySQL Database
This course also introduces you to more advanced tools and techniques to help you manage your MySQL database and data. At the end of the course, you will be confident in your abilities to use the MySQL database and put your new skills to work.

Startdatum 27.01.2020 - 09:00
Enddatum 30.01.2020 - 17:00
Anmeldungsende 20.01.2020
Netto Einzelpreis € 2.844,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. D61918: MySQL for Beginners
Ort München

Abgeschlossen

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 27.01.2020 - 09:00
Enddatum 30.01.2020 - 17:00
Anmeldungsende 20.01.2020
Netto Einzelpreis € 3.416,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. D79232-Oracle Database 12c: Data Guard Administration
Ort München

Abgeschlossen

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 27.01.2020 - 09:00
Enddatum 30.01.2020 - 17:00
Anmeldungsende 20.01.2020
Netto Einzelpreis € 3.416,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. D79232-Oracle Database 12c: Data Guard Administration
Ort Frankfurt

Abgeschlossen

This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language. Through hands-on instruction from expert Oracle instructors, you'll learn to develop stored procedures, functions, packages and more.

Learn To:

  • Conditionally control code flow (loops, control structures).
  • Create stored procedures and functions.
  • Use PL/SQL packages to group and contain related constructs.
  • Create triggers to solve business challenges.
  • Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.
  • Create custom packages for applications.
  • Write Dynamic SQL code for applications.

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.

Use Oracle SQL Developer

You will use Oracle SQL Developer to develop these program units. SQL*Plus is introduced in this course as optional tools.

Course Bundle

Note: This course is a combination of Oracle Database: PL/SQL Fundamentals and Oracle Database: Develop PL/SQL Program Units courses.

 

Startdatum 27.01.2020 - 09:00
Enddatum 29.01.2020 - 17:00
Anmeldungsende 20.01.2020
Netto Einzelpreis € 3.555,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. D61830 - Oracle Database 12c: Program with PL/SQL
Ort München

Abgeschlossen

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 03.02.2020 - 09:00
Enddatum 07.02.2020 - 17:00
Anmeldungsende 27.01.2020
Listenpreis € 3.555,00
Reduzierter Preis € 3.448,35 (Until 23.01.2020 00:00)
Speaker Deutsch
Number Hours 9:00 - 17:00
Kurs-Nr. Oracle Database 12c R2: Backup & Recovery Workshop
Ort München

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 03.02.2020 - 09:00
Enddatum 07.02.2020 - 17:00
Anmeldungsende 27.01.2020
Listenpreis € 3.555,00
Reduzierter Preis € 3.448,35 (Until 27.01.2020 00:00)
Speaker Deutsch
Number Hours 09:00 - 17:00
Kurs-Nr. D80174: Oracle Database: PL/SQL Fundamentals
Ort Dresden

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 03.02.2020 - 09:00
Enddatum 07.02.2020 - 17:00
Anmeldungsende 27.01.2020
Listenpreis € 3.555,00
Reduzierter Preis € 3.448,35 (Until 23.01.2020 00:00)
Speaker Deutsch
Number Hours 9:00 - 17:00
Kurs-Nr. Oracle Database 12c R2: Backup & Recovery Workshop
Ort Frankfurt

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 03.02.2020 - 09:00
Enddatum 07.02.2020 - 17:00
Anmeldungsende 27.01.2020
Netto Einzelpreis € 3.555,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. Oracle Database 12c: Performance Management and Tuning
Ort München

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 03.02.2020 - 09:00
Enddatum 07.02.2020 - 17:00
Anmeldungsende 27.01.2020
Listenpreis € 3.555,00
Reduzierter Preis € 3.448,35 (Until 23.01.2020 00:00)
Speaker Deutsch
Number Hours 9:00 - 17:00
Kurs-Nr. Oracle Database 12c R2: Backup & Recovery Workshop
Ort München

Throughout the lessons of the Oracle Database 12c R2: New Features for Administrators Part 2 course constituted by five modules; the Securing Data module, the Making Data Available module, the Partitioning Data module, the Managing Information Lifecycle module and the Monitoring DB Operations and Managing Performance module, students receive a good knowledge of the Oracle Database 12c Release 2 new and enhanced features in different areas of database administration like Unified Auditing, Transparent Data Encryption (TDE) and other areas of security, Recovery Manager, online operations, Oracle Data Pump, SQL*Loader, new partitioning methods, Automatic Data Optimization, In-Memory Column Store, Full Database In-Memory Caching, and Automatic Big Table Caching.

Learn To:

  • Gain an understanding of the new and enhanced features of Oracle Database 12c Release 2 (12.2.0.1) amongst different areas such as security, availability, partitioning, performance, and Information Lifecycle Management (ILM).

Benefits To You

Benefit from getting a thorough understanding of the following lessons:

  • The lessons of the Securing Data module cover enhancements in auditing like role based conditional auditing, in privilege administration like new system administrative privilege for RAC, in Privilege Analysis and Data Redaction, in Transparent Sensitive Data Protection with new types of policies for FGA and TDE, and finally also in Transparent Data Encryption (TDE).
  • The lessons of the Making Data Available module cover enhanced features in RMAN like table recovery, transport data across platforms, enhancements related to online operations, and finally ongoing enhancements with Oracle Data Pump, SQL*Loader and external tables.
  • The lesson of the Partitioning Data module covers enhancements and new partitioning methods.
  • The lessons of the Managing Information Lifecycle module introduce Heat Map and Automatic Data Optimization with heat map statistics tracking and ADO policies. The lessons also cover Temporal functionalities such as temporal history and temporal validity. In-Database Archiving provides a new feature, the Row-archival.
  • The lessons of the Monitoring DB Operations and Managing Performance module explain the new features to improve the performance of the databases with SQL Performance Analyzer, DB Replay and SQL Plan Management, and to improve query execution with the Optimizer Statistics Advisor, JOIN processing. You will also learn about In-Memory Database option.

 

 

 

 

 


 

 

Startdatum 10.02.2020 - 08:00
Enddatum 14.02.2020 - 16:00
Anmeldungsende 03.02.2020
Netto Einzelpreis € 3.315,00
Speaker English
Kurs-Nr. Oracle Database 12c R2: New Features for Administrators Part 2
Ort LVC

The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide 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. This course covers both Database as a Cloud Service and the on-premises Oracle Database.

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

Startdatum 10.02.2020 - 09:00
Enddatum 14.02.2020 - 17:00
Anmeldungsende 03.02.2020
Netto Einzelpreis € 3.555,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. D78846: Oracle Database 12c R2 Administration Workshop
Ort München

This Oracle Linux 7: Advanced Administration training is ideal for experienced administrators who need to learn more about Oracle Linux 7. You'll learn how to configure networking services and authentication services, implement virtualization technologies to more effectively manage system resources, perform advanced storage administration tasks, implement shared storage technologies, and develop advanced troubleshooting skills. In this course, you will be introduced to the Oracle IaaS Cloud Solution.

Learn To:

  • Configure DNS, DHCP, HTTP, Samba, and other network services.
  • Configure LDAP, PAM, and other authentication services.
  • Automate installation using Kickstart.
  • Recover from boot errors.
  • Use advanced package management features.
  • Configure network bonding, VLANs, and VPNs.
  • Implement Linux Containers, Docker, KVM and other virtualization services.
  • Allocate system resources to specific Linux processes.
  • Use DTrace to identify performance bottlenecks.
  • Configure iSCSI, device multipathing, and OCFS2.
  • Gain an understanding of the Oracle IaaS Cloud Solution.

Benefits to You

After taking this course, you will be equipped to use the advanced features of Oracle Linux 7 to get the most out of your systems and applications. You'll learn how to automate Oracle Linux installations and implement networking and authentication services to facilitate the management of a large number of systems. You'll also learn how to use Control Groups, Linux Containers, Docker, and KVM to increase your resource utilization by creating secure, isolated environments on a single host. Become familiar with advanced storage features, including encrypted file systems, disk quotas, iSCSI, device multipathing, and the OCFS2 file system to better use your storage resources.

Gain Hands-On Experience

Extensive hands-on practices will guide you through each concept. You will configure network services and authentication services, configure network storage, shared file system types, and device multipathing. You will also configure different virtualization technologies to better utilize system resources such as CPU, memory, network and I/O bandwidth, and to allocate these system resources to critical processes.

 

Startdatum 10.02.2020 - 09:00
Enddatum 14.02.2020 - 17:00
Anmeldungsende 03.02.2020
Netto Einzelpreis € 3.555,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. Oracle Linux 7: Advanced Administration
Ort München

This Oracle Linux 7: Advanced Administration training is ideal for experienced administrators who need to learn more about Oracle Linux 7. You'll learn how to configure networking services and authentication services, implement virtualization technologies to more effectively manage system resources, perform advanced storage administration tasks, implement shared storage technologies, and develop advanced troubleshooting skills. In this course, you will be introduced to the Oracle IaaS Cloud Solution.

Learn To:

  • Configure DNS, DHCP, HTTP, Samba, and other network services.
  • Configure LDAP, PAM, and other authentication services.
  • Automate installation using Kickstart.
  • Recover from boot errors.
  • Use advanced package management features.
  • Configure network bonding, VLANs, and VPNs.
  • Implement Linux Containers, Docker, KVM and other virtualization services.
  • Allocate system resources to specific Linux processes.
  • Use DTrace to identify performance bottlenecks.
  • Configure iSCSI, device multipathing, and OCFS2.
  • Gain an understanding of the Oracle IaaS Cloud Solution.

Benefits to You

After taking this course, you will be equipped to use the advanced features of Oracle Linux 7 to get the most out of your systems and applications. You'll learn how to automate Oracle Linux installations and implement networking and authentication services to facilitate the management of a large number of systems. You'll also learn how to use Control Groups, Linux Containers, Docker, and KVM to increase your resource utilization by creating secure, isolated environments on a single host. Become familiar with advanced storage features, including encrypted file systems, disk quotas, iSCSI, device multipathing, and the OCFS2 file system to better use your storage resources.

Gain Hands-On Experience

Extensive hands-on practices will guide you through each concept. You will configure network services and authentication services, configure network storage, shared file system types, and device multipathing. You will also configure different virtualization technologies to better utilize system resources such as CPU, memory, network and I/O bandwidth, and to allocate these system resources to critical processes.

 

Startdatum 10.02.2020 - 09:00
Enddatum 14.02.2020 - 17:00
Anmeldungsende 03.02.2020
Netto Einzelpreis € 3.555,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. Oracle Linux 7: Advanced Administration
Ort Frankfurt

Throughout the lessons of the Oracle Database 12c R2: New Features for Administrators Part 1 course, students receive comprehensive training on Oracle Database 12c Release 2 new and enhanced features in different areas of database administration, mainly in on-premises Multitenant databases. The lessons are grouped into three modules: Using SQL New Features and ToolsUnderstanding DB Architectures, and Diagnosing Database Problems,

Learn To:

  • Use the new SQLcl utility and gain information on SQL*Plus and SQL enhancements.
  • Understand the new and enhanced features of Oracle Database 12c Release 2 (12.2.0.1) amongst different areas such as the new Multitenant architecture and the Sharded database architecture.
  • Diagnose database issues, handling Automatic Diagnostic Repository (ADR) file management and using the Trace File Analyzer (TFA) tool.

Benefits To You

You will benefit from learning the following lessons:

  • Using the SQL New Features and Tools module covers the usage of the new SQLcl utility and the new features in SQL*Plus and SQL.
  • Most of the Understanding DB Architectures module lessons cover the new Multitenant architecture. The concept of regular and application containers of a Multitenant container database includes new administrative tasks such as creating, managing, securing, backing up, recovering and upgrading regular and application containers, as well as migrating an 11g database to a 12c multitenant container database. The lessons also cover enhanced features of Resource Manager to help you manage the resources within a Multitenant container database. You will discover other enhancements supported in a Multitenant container database like heat map and Automatic Data Optimization (ADO) support, Database Vault and encryption. The second part of the module gives an overview of database sharding. It describes the challenges and benefits of a sharded database, the sharded database architecture and how to configure a sharded database.
  • The lesson of the Diagnosing Database Problems module covers enhancements in ADR space management and explain what can be completed with the Trace File Analyzer (TFA) tool in terms of database diagnosis. 


 

 

Startdatum 17.02.2020 - 09:00
Enddatum 21.02.2020 - 17:00
Anmeldungsende 10.02.2020
Netto Einzelpreis € 3.555,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. Oracle Database 12c R2: New Features for Administrators
Ort München

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 17.02.2020 - 09:00
Enddatum 21.02.2020 - 17:00
Anmeldungsende 10.02.2020
Netto Einzelpreis € 3.555,00
Ort München

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 17.02.2020 - 09:00
Enddatum 21.02.2020 - 17:00
Anmeldungsende 10.02.2020
Netto Einzelpreis € 3.555,00
Speaker Deutsch
Number Hours 09:00 - 17:00
Kurs-Nr. D80174: Oracle Database: PL/SQL Fundamentals
Ort München

The Oracle Database 12c R2: New Features for 12c R1 Administrators course is designed for existing 12c Release 1 DBAs. In addition to covering the New Features of R2, this course also introduces students to the Oracle Database Cloud Service.

Learn To:

  • Create and manage application containers and applications in multitenant container databases.
  • Manage resources in a multitenant container database and pluggable databases with Resource Manager performance profiles and new memory directives.
  • Perform pluggable database flashback.
  • Upgrade the multitenant container databases and pluggable databases.
  • Manage security by using enhancements in unified auditing, system privileges, Privilege Analysis, Data Redaction, Transparent Sensitive Data Protection and Transparent Data Encryption.
  • Manage data availability by using Recovery Manager, Oracle Data Pump features and SQL*Loader enhancements, and by performing enhanced online operations.
  • Increase the SQL performance by using the In-Memory Column-Store enhancements at deployment and SQL performance.
  • Tune the SQL performance by using the Optimizer Statistics Advisor and SQL join processing.
  • Monitor your databases by using DB operations enhancements.
  • Benefit from enhancements in partitioning methods.
  • Benefit from ADR automatic space file management.
  • Use the Trace File Analyzer collector to diagnose issues.
  • Use the new SQL*Plus history commands and SQL enhancements such as long identifiers.
  • Use the new SQLcl utility to benefit from commands and features missing from SQL*Plus itself.
  • Describe the Oracle Public Cloud services related to databases management.

Benefits To You

In the lessons, you learn the new and enhanced features of Oracle Database 12c Release 2 (12.2.0.1) amongst different areas such as Multitenant, security, availability, performance, diagnosability, manageability, partitioning and SQL.

You also learn how to easily deploy databases with Oracle Database Cloud Services, check automated backups and monitor your Cloud deployment with new Cloud tools.

 

 

 

Startdatum 17.02.2020 - 09:00
Enddatum 21.02.2020 - 17:00
Anmeldungsende 10.02.2020
Netto Einzelpreis € 3.555,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. D77758: Oracle Database 12c R1: New Features for 12c R1 Administrators
Ort München

Throughout the lessons of the Oracle Database 12c R2: New Features for Administrators Part 2 course constituted by five modules; the Securing Data module, the Making Data Available module, the Partitioning Data module, the Managing Information Lifecycle module and the Monitoring DB Operations and Managing Performance module, students receive a good knowledge of the Oracle Database 12c Release 2 new and enhanced features in different areas of database administration like Unified Auditing, Transparent Data Encryption (TDE) and other areas of security, Recovery Manager, online operations, Oracle Data Pump, SQL*Loader, new partitioning methods, Automatic Data Optimization, In-Memory Column Store, Full Database In-Memory Caching, and Automatic Big Table Caching.

Learn To:

  • Gain an understanding of the new and enhanced features of Oracle Database 12c Release 2 (12.2.0.1) amongst different areas such as security, availability, partitioning, performance, and Information Lifecycle Management (ILM).

Benefits To You

Benefit from getting a thorough understanding of the following lessons:

  • The lessons of the Securing Data module cover enhancements in auditing like role based conditional auditing, in privilege administration like new system administrative privilege for RAC, in Privilege Analysis and Data Redaction, in Transparent Sensitive Data Protection with new types of policies for FGA and TDE, and finally also in Transparent Data Encryption (TDE).
  • The lessons of the Making Data Available module cover enhanced features in RMAN like table recovery, transport data across platforms, enhancements related to online operations, and finally ongoing enhancements with Oracle Data Pump, SQL*Loader and external tables.
  • The lesson of the Partitioning Data module covers enhancements and new partitioning methods.
  • The lessons of the Managing Information Lifecycle module introduce Heat Map and Automatic Data Optimization with heat map statistics tracking and ADO policies. The lessons also cover Temporal functionalities such as temporal history and temporal validity. In-Database Archiving provides a new feature, the Row-archival.
  • The lessons of the Monitoring DB Operations and Managing Performance module explain the new features to improve the performance of the databases with SQL Performance Analyzer, DB Replay and SQL Plan Management, and to improve query execution with the Optimizer Statistics Advisor, JOIN processing. You will also learn about In-Memory Database option.

 

 

 

 

 


 

 

Startdatum 24.02.2020 - 06:00
Enddatum 28.02.2020 - 14:00
Anmeldungsende 17.02.2020
Netto Einzelpreis € 3.315,00
Speaker English
Kurs-Nr. Oracle Database 12c R2: New Features for Administrators Part 2
Ort LVC

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.

 

 

 

 

 

Startdatum 24.02.2020 - 09:00
Enddatum 28.02.2020 - 17:00
Anmeldungsende 17.02.2020 - 12:00
Netto Einzelpreis € 2.390,00
Speaker Deutsch
Number Hours 09:00-17:00
Kurs-Nr. D61762:MySQL für Datenbankadministratoren
Ort München

Kurssuche

Von Datum
Bis Datum
Kategorie
Ort