Oracle képzések

A legnépszerűbb Oracle képzések érhetőek el kiváló oktatók előadásában a legmodernebb tantermi és szoftverkörnyezetben. A tanfolyamok a nemzetközi Oracle vizsgákra való felkészülésben is segítséget nyújtanak.

  • 1
Vissza

Oracle tanfolyamok

Oracle tanfolyamok

A legnépszerűbb Oracle képzéseket (adatbázis-adminisztráció, PL/SQL programozás, Java programozás, stb.) kínáljuk kíváló Oracle oktatók előadásában, a legmodernebb tantermi és szoftverkörnyezetben.

Oracle_Oracle-Database-11g_Oracle-Database-11g-Administration-Workshop-II.png
480 000 Ft-tól
(Bruttó ár: 609 600 Ft-tól)

Oracle Database 11g: Administration Workshop II Release 2

Kód: D50079

Az Oracle Database 11g: Administration Workshop II Release 2 tanfolyamunk az adatbázis adminisztrátorok egyik legnagyobb felelősségét emeli ki: az adatbázis mentési és visszaállítási lehetőségeket Oracle adatbázis-rendszerek esetén. A hallgatók továbbá betekintést kapnak az adatbázisok teljesítményét befolyásoló tényezőkről, teljesítményoptimalizálási pontokról és konszolidációs lehetőségekről. A képzés által érintett technológiák-funkciók az alábbi pontokban foglalhatók össze: Mentés és visszaállítás lépések RMAN használatával FlashBack technológia alkalmazása korábbi adattartalmak megjelenítéséhez Mentési és visszaállítási szcenáriók Adatbázisok optimális beállítása visszaállításhoz Memóriakezelési eljárások Teljesítményoptimalizálás Időzített feladatok ütemezés Adattartalom tömörítése és deduplikálása   Adatbázis gazdák Támogató mérnökök Konzulensek   A tanfolyamon történő részvételhez feltétel az alábbi Oracle tanfolyamok látogatása: Oracle Database 11g Database Administration Oracle Database 11g: Administration Workshop I Release 2 SQL nyelvben jártasság és PL/SQL csomagok kezelésében tapasztalat   Modul 1 –Oracle adatbázisok alapjai és kezelési eszközei Oracle adatbázis architektúra ASM tárolási koncepciók Adatkapcsolatok kialakítása az adatbázisokhoz és az ASM instance-hez Kezelőeszközök áttekintése Modul 2 – Visszaállítási beállítások Recovery Manager (RMAN) használata Adatbázisok beállítása mentési és visszaállítási feladatokhoz Az Archivelog mód beállítása Flash Recovery Area (FRA) működése és használata Modul 3 – Az RAMN Recovery Catalog használata Mentési adatok követése és tárolása Recovery Catalog beállítása Mentések rögzítése RMAN tárolt eljárások A Recovery Catalog kezelése Modul 4 – Mentések beállítása RMAN beállítás A Control File Autobackup konfigurációja Mentések optimalizálása Haladó beállítások: tömörítés Multisection területek mentése és visszaállítása Modul 5 – Mentések kialakítása RMAN-nal RMAN mentési típusok Backup Set-ek, teljes és inkrementális mentések Fast Incremental mentése Mentési célterületek beállítása Archiválás Modul 6 – Visszaállítási feladatok Visszaállítás Adatvesztések okai Automatikus Tempfile visszaállítás Visszaállítás „Loss of a Redo Log Group” esetén Visszaállítás Lost Index Tablespace esetén A jelszófile újbóli létrehozása Modul 7 – Visszaállás RMAN segítségével Teljes visszaállás menete Image-ek visszaállítása Visszaállítás NOARCHIVELOG módban Visszaállítás control file használatával Visszaállás Autoback használatával Adatbázis visszaállítása új kiszolgálóra Modul 8 – Az RMAN felügyelete és finomhangolása RMAN feladatok kezelése RMAN Multiplexing Szinkron és aszinkron IO A MAXPIECESIZE, FILESPERSET, MAXOPENFILES hatásai Modul 9 – Adatbázisok diagnosztikája DRA – Data Recovery Advisor áttekintése Block meghibásodás ADR – Automatic Diagnostic Repository Egészségi állapot felmérése Az ADR parancssoros használata: ADRCI Modul 10 – A FlashBack technológia A Flashback technológia áttekintése Lekérdezések kialakítása Flashback módszerrel A Flashback tábla Oracle Total Recall A Flashback Drop és Recycle Bin Modul 11 – Flashback adatbázis A Flashback adatbázis beállítás és kezelése Flashback adatbázisok felügyelete Modul 12 – Memóriakezelés Az Oracle memóriakezelés áttekintése Memória paraméterek Automatikus memóriakezelése Shared Memory Memory Advisor használata Modul 13 – Adatbázis teljesítmény-hangolás Activity-k hangolása Statisztikák elemzése és gyűjtése AWR – Automatic Workload Repository A Database Replay előnyei Modul 14 – Teljesítmény optimalizálás SQL hangolással SQL Advisor és SQL Tuning Az SQL Tuning Advisor használata SQL Access Advisor SQL Performance Analyzer áttekintése Modul 15 – Erőforrások kezelése Erőforrás tervek használata Erőforrás használók létrehozása Erőforrás terv direktívák meghatározása és indítása Modul 16 – Feladatok ütemezése Felügyeleti feladatok egyszerűsítése Feladatok, programok és időzítők létrehozása Idő-, eseményalapú és komplex ütemezés Multi-destination Job-ok Modul 17 – Tárkapacitás kezelése a Block-okban Tárkapacitás kezelése és felügyelete Adattömörítés Modul 18 – Tárkapacitás kezelése Segment-eknél Segment-ek létrehozása igény szerint Automatikus hely felszabadítás Segment-ek összezsugorítása Segment Advisor Modul 19 – Tárkapacitás kezelése Adatbázisok esetén 4KB-os diszk szektorok használata Tablespace és Database transport Modul 20 – Adatbázisok többszörözése Adatbázisok klónozásának célja és lehetőségi Adatbázis klónozás RMAN használatával Mentésből történő klónozás Futó instanciák megkettőzése  

Időtartam:5 nap
Nehézségi szint:
  • Haladó
Oracle_Oracle-Database-11g_Oracle-Database-11g-Administration-Workshop-I.png
480 000 Ft-tól
(Bruttó ár: 609 600 Ft-tól)

Oracle Database 11g: Administration Workshop I Release 2

Kód: D50102

Az Oracle Database 11g: Administration Workshop I Release 2 tanfolyamunk az adatbázis-adminisztráció alapjaival ismereti meg a hallgatókat. Szakértő oktatók ismertetik a legfontosabb tudnivalókat a témakörben, amelyeket számos laborgyakorlat kísér. A tanfolyam felkészíti a látogatókat az Oracle Certified Associate vizsgára is. A képzés által érintett technológiák-funkciók az alábbi pontokban foglalhatók össze: Az Oracle Grid infrastruktúra Felhasználók kezelése Oracle Adatbázisok létrehozása és konfigurációja Tároló elemek kialakítása és kezelése Adatbázisok adminisztrációja Oracle adatbázisok architektúrája Mentési és visszaállítási eljárások Teljesítménymonitorozás Adatbázis gazdák Java Fejlesztők Támogató mérnökök Konzulensek A tanfolyamon történő részvételhez ajánlott az alábbi Oracle tanfolyamok látogatása: Oracle : Introduction to SQL – vagy ezzel egyenértékű tudás Modul 1 –Oracle adatbázisok architektúrája Áttekintés Oracle ASM architektúra áttekintése Folyamatok architektúrája Tároló elemek fizikai és logikai komponensei ASM tároló komponensek Modul 2 – Az Oracle komponensek telepítése Egy Oracle adminisztrátor feladati Adminisztrációs eszközök Telepítési követelmények Az Oracle Grid infrastruktúra telepítése Az Oracle adatbázis komponensek telepítése Modul 3 – Oracle adatbázis létrehozása Az adatbázis tervezése A DBCA használata adatbázis létrehozáshoz Jelszavak kezelése Adatbázis design sablonok létrehozása A DBCA használata adatbázisok törléséhez Modul 4 – Oracle adatbázis instanciák Oracle adatbázisok indítása, leállítása Az Oracle Enterprise Manager használata Adatbázis elérése SQLPlus eszközzel Adatbázis telepítési paramétereink beállítása Adatbázisok indulásának lépései Alert Log Teljesítménymutatók megjelenítése Modul 5 – ASM instance-ek kezelése ASM instance-ek indulási környezetének beállítása ASM Instance-ek indítása és leállítása ASM disk group-ok kezelése Modul 6 – A hálózati környezet beállítása Enterprise Manager használata a Listener konfigurálásához Az Oracle Restart beállítása a Listener monitorozásához TNSPING használata hálózati kapcsolatok ellenőrzéséhez Dedikált vagy megosztott kiszolgálók használata Modul 7 – Adatbázis tároló-struktúrák kezelése Tároló struktúrák Adattáblák tárolásának leírása Egy adatbázis block szerepe Táblák tárkapacitás használata OMF – Oracle Managed Files Modul 8 – Felhasználók kezelése Adatbázis felhasználók Alapértelmezett adminisztratív fiókok Szerepkörök előnyei Alapértelmezett Szerepkörök Profile-ok implementációja Modul 9 – Data Concurrency kezelése Data Concurrency (együtthatás) Sorfeldolgozás Zárolási konfliktusok DeadLock-ok Modul 10 – Undo adatok kezelése Adatok manipulációja Tranzakciók és az Undo data Undo megtartás Modul 11 – Hozzáférések auditálása Adatbázis hozzáférések nyomon követésének beállítása Auditálási opciók Modul 12 – Adatbázis felügyelet Optimalizálási lehetőségek AWR-Automatic Workload Repository használata ADDM – Automatic Database Diagnostic Monitor használata Figyelmeztetések definiálása Feladatok ütemezése Modul 13 – Adatbázis teljesítmény-kezelés Teljesítmény ellenőrzés Memória területek ellenőrzése AMM – Automatic Memory Management alkalmazása Automatic Shared Memory Advisor Memory Advisor használata Dinamikus teljesítmény statisztika Hibaelhárítási és hangoló View-k Hibás és nem használható objektumok megjelenítése Modul 14 – Mentési és visszaállítási koncepciók Instance visszaállítás lépései Az MTTR Advisor használata Archív log-ok Modul 15 – Adatbázisok mentése Áttekintés Oracle Secure Backup RMAN - Recovery Manager Mentések beállítása Modul 16 – Visszaállítási feladatok Adatbázisok megnyitása Data Recovery Advisor Loss of a Control File metódus Loss of a Redo Log File metódus Modul 17 – Adatbázisok mozgatása Adatbázis költöztetése Az SQL Loader használata Külső adattáblák használata Oracle Data Pump: adatok exportálása és importálása Modul 18 – Oracle Support Az Enterprise Manager Support Workbench használata Oracle support igénybevétele Service Request-ek feladása Javítások kezelése

Időtartam:5 nap
Nehézségi szint:
  • Kezdő
Oracle_Oracle-Database-11g_Oracle-Database-11g-Performance-Tuning.png
480 000 Ft-tól
(Bruttó ár: 609 600 Ft-tól)

Oracle Database 11g: Performance Tuning DBA Release 2

Kód: D50317

Az Oracle Database 11g: Performance Tuning DBA Release 2 tanfolyamunk során a hallgatók adatbázisok teljesítmény optimalizálási lehetőségeivel ismerkednek meg. A számos laborgyakorlat lehetőséget ad az érdeklődőknek, hogy tapasztalatokat szerezzenek finomhangolási feladatokban. A tanfolyam kiinduló pontjaként a diákok egy ismeretlen eredetű és működésű adatbázist vizsgálnak meg. A modulok során feltárják az adatbázis problémáit és a megfelelő módosításokkal egy ideális teljesítményű rendszerré változtatják. A képzés által érintett technológiák-funkciók az alábbi pontokban foglalhatók össze: Oracle adatbázis finomhangolási metódusok és eszközök Adatbázis Advisor-ok használata a proaktív hangoláshoz AWR – Automatic Workload Repository alkalmazásával történő hangolás SQL kód hangolás Teljesítmény-hibák feltárása és javítása adatbázis instance-ek esetén Az Enterprise Manager teljesítménymutatói Adatbázis gazdák Támogató mérnökök Konzulensek A tanfolyamon történő részvételhez feltétel az alábbi Oracle tanfolyamok látogatása: Oracle Database 11g: Administration Workshop I Release 2 Oracle Database 11g: Administration Workshop II Release 2 Modul 1 – Tanfolyami bevezető A tanfolyam anyagainak áttekintése Modul 2 – Alapvető finomhangoló eszközök Monitorozási eszközök áttekintése Enterprise Manager Nézetek, Statisztikák és számlálók Wait események Modul 3 – Az AWE használata Az Automatic Workload Repository használata AWR snapshot-ok készítése Valós idejű SQL monitorozás Modul 4 – Problémák meghatározása A probléma azonosítása Prioritások megadása TOP SQL riportok Leggyakoribb finomhangolási hibák ADDM Az üzleti igények teljesítmény meghatározása Monitorozó és hangoló eszközök Modul 5 – Számlálók és figyelmeztetések Számlálók, figyelmeztetések és alapszintek Az Oracle 11g számlálói A számlálók elemzésének előnyei Számlálók visszamenőleges megfigyelése Statisztikai hisztogramok és nézetek Szerver-generált figyelmeztetések Figyelmeztetések definiálása Modul 6 – Alapszintek meghatározása Összehasonlító teljesítmény analízis AWR alapszintekkel AWR alapszintek áttekintése és kialakítása Alapszintek kezelése PL/SQL és Nézetekkel Enterprise Manager adaptív küszöbérték konfigurációja Modul 7 – AWR alapú eszközök Automatic Maintenance Tasks ADDM teljesítménymonitorozás Aktív kapcsolatok visszakövetése Modul 8 – Alkalmazások monitorozása A Szerviz funkció meghatározása és attribútumai A Szervizek fogalma egy Single Instance környezetben Szervizek használata kliens alkalmazásoknál EM szervizkezelési lehetőségei Szervizek aggregálása Modul 9 – SQL problémák SQL folyamatofeldolgozás és az Oracle Optimizer szerepe TOP SQL riportok Végrehajtási Tervek SQL*Plus Autotrace funkció Végrehajtási tervek elemzése Nézetekkel Az SQL Trace használata Modul 10 – Az SQL Performance Analyzer használata Alkalmazás monitorozás: áttekintés Az SQL Performance Analyzer: SQL workload-ok nyomonkövetése SQL Performance Analyzer feladatok létrehozása Riportok elemzése Regressing Statement-ek elemzése és megelőzése Változások vizsgálata és Workflow analízis Modul 11 – SQL teljesítménykezelés SQL teljesítmény hangolása Mérőszámok és számlálók begyűjtése és beállítása Automatic SQL Tuning: áttekintés Az SQL Access Advisor használata SQL Plan Management: áttekintés Modul 12 – Adatbázis visszajátszás Felvétel és visszajátszás Visszajátszás beállítása Visszajátszási munkafolyamatok az Enterprise Manager-ben Csomagok és eljárások Adatbázis visszajátszás: PL/SQL példa Modul 13 – Megosztott erőforrások hangolása Megosztott erőforrások architektúrája és működése Diagnosztikai eszközök Hard és Soft feldolgozások elkerülése Megosztott erőforrások méretezése, töredezettség problémák elkerülése Large Pool áttekintés és hangolás Modul 14 – Buffer tárak hangolása Oracle adatbázis architektúra: a buffer tár Adatbázis bufferek Buffer tábla kereséshez Working Set-ek fogalma Buffer tár hangolási technikák Multiblock olvasási eljárás automatikus hangolása Buffer tár ürítése Modul 15 – PGA  hangolás és az Átmeneti táblatér SQL memória használat Az SQL Memory Manager Az automatikus PGA memória kezelés SQL memória használat monitorozása és hangolása Automatic PGA az Enterprise Manager-ben Automatic PGA és AWR riportok Átmenti táblatér kezelés: áttekintés Átmeneti táblatér zsugorítása és létrehozása Modul 16 – Automatikus memóriakezelés Dynamic SGA és a Memory Advisor-ok Granule-ok fogalma és használata SGA komponensek átméretezése Automatikus memória megosztás ASMM – Automatic Share Memory Management használata Modul 17 – Segment-ek tárhasználata Tárterület és kiterjesztések használata Táblaadatok tárolásának menete Block visit-ek minimalizálása A DB_BLOCK_SIZE paraméter Block méretek Block allokáció Modul 18 – I/O hangolás I/O architektúra Filerendszerek jellemzői I/O módok Sávszélesség és a legfontosabb I/O mérőszámok Csíkozás és tükrözés RAID használat Adatbázisok I/O hangolása Legfontosabb ajánlások

Időtartam:5 nap
Nehézségi szint:
  • Haladó
800 000 Ft-tól
(Bruttó ár: 1 016 000 Ft-tól)

Oracle BI 11g R1: Create Analyses and Dashboards

Kód: D63510

This Oracle BI 11g R1: Create Analyses and Dashboards course for Release 11.1.1.7.0 provides step-by-step instructions for creating Oracle BI analyses and dashboards in business intelligence applications. You'll begin by building basic analyses to include in dashboards, with more complexity as the course progresses. Learn To: Build analyses and dashboards. Build and use views and graphs in analyses. Create and work with KPIs and scorecards. Create and modify Oracle BI dashboards. Use Oracle Business Intelligence Mobile to access BI content. Create mobile applications with Oracle Business Intelligence Mobile App Designer. Integrate BI content into MS Office applications using Oracle Hyperion Smart View for Office. Administer objects in the Presentation Services Catalog. Benefits to You Transform your organization’s data into intelligence for improved decision making. Provide time-critical, relevant and accurate insights. Become more efficient at modifying analyses and dashboards. Explore Oracle Hyperion Smart View for Office You'll also learn to use Oracle Hyperion Smart View for Office to integrate Oracle BI data and views in presentations and spreadsheets. Walk away from this course with the knowledge and skills to design mobile applications for BI content using the trial edition of the Oracle BI Mobile App Designer. Furthermore, you'll explore the use of Oracle BI Briefing Books, while learning to administer objects in the Oracle BI Presentation Catalog. Application Developers Business Analysts Business Intelligence Developer Developer End Users Functional Implementer Technical Administrator Technical Consultant   Introduction to Oracle Business Intelligence Enterprise Edition Introduction to Oracle BI EE Architecture overview Oracle BI EE sample application Overview of Oracle Exalytics Machine Working with Oracle Business Intelligence Analyses Introduction to Oracle BI Analysis Editor Oracle BI column types Working with analyses in Oracle BI Adding basic formatting Setting analysis properties Using advanced formatting Filtering Data for Analyses Introduction to filters and selections Creating, editing, and grouping filters Adding prompts to analyses Dynamic filtering Using saved analyses as filters Selecting and Grouping Data in Analyses Creating selection steps Creating groups Creating calculated items Creating direct database analysis requests Including advanced SQL clauses in your analysis Adding Views to Analyses Introduction to views, graphs, and editors Working with views in Compound Layouts Creating and editing graphs Performing common view tasks Showing Results with Pivot Tables OLAP data source compatibility Creating, arranging, and formatting a pivot table Using hierarchical columns Sorting in pivot tables Setting aggregation and using totals Showing an item's relative value Building calculations and displaying running sums Working with Additional Views in Analyses Creating simple and advanced trellis views Creating performance tile views Working other view types Linking master-detail views Visualizing Data: Gauges and Maps Working with Gauge views Oracle spatial components Managing map data Creating and editing Map views Interacting with map views Other applications and points of integration for map views Scorecards and Key Performance Indicators Objects and components of Oracle Scorecard and Strategy Management Key Performance Indicator (KPI) overview Scorecard document types Measuring Results with Scorecards and KPIs Creating scorecards and KPIs Creating scorecard documents Editing scorecards and KPIs Creating Oracle Business Intelligence Dashboards Creating and editing dashboards Using the Dashboard Builder Exploring dashboard object properties and options Publishing dashboard pages Creating personal customizations and using other page options Configuring Oracle Business Intelligence Dashboards Exploring types of dashboard content Embedding content in dashboards Creating Dashboard Prompts and Variables Understanding variables Adding a named dashboard prompt to a dashboard Adding a hidden named dashboard prompt to a dashboard Creating additional prompt page and setting page preferences Adding variable prompts to a dashboard Integrating BI Content with MS Office Overview of the Oracle BI Add-in for Microsoft Office Installing Smart View Creating Oracle BI EE connections in Smart View Inserting BI views in to Smart View clients Working with BI Content in Smart View Working with Views in Smart View Clients Customizing BI data in MS Office Copying and pasting views between Smart View clients Copying and pasting views from Oracle BI Presentation services to Smart View Creating and publishing views using the View Designer Federating data from multiple data sources Oracle Business Intelligence Mobile Downloading and using the Oracle BI mobile application Navigating the Oracle BI mobile application Working with favorites and local content Working with BI content Oracle BI Mobile Security Toolkit Creating Mobile Applications with Oracle Business Intelligence Mobile App Designer Creating basic mobile apps Previewing mobile apps Creating apps with tile pages Creating subpages and navigation pages Using Oracle Business Intelligence Delivers Configuring delivery devices and adding delivery profiles Adding an Alert Section to a dashboard Configuring an Agent Using Analysis and KPI conditions to deliver content with Agents Subscribing to an Agent Administering the Presentation Catalog Oracle BI and catalog security overview Managing security using roles Understanding security inheritance Setting object permissions Setting system privileges Archiving catalog items Working with Oracle BI Briefing Books

Időtartam:5 nap
Nehézségi szint:
  • Haladó
800 000 Ft-tól
(Bruttó ár: 1 016 000 Ft-tól)

Oracle BI 11g R1: Build Repositories

Kód: D63514

This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository; you'll begin by using the Oracle BI Administration Tool to construct a simple repository to address a fictitious company's business requirements. Learn To: Build and execute analyses to test and verify a dimensional business model. Use the Oracle BI Adminstration Tool to administer Oracle BI Server. Use the Oracle BI Administration Tool to build, manage and maintain an Oracle BI repository. Build a dimensional business model to address business intelligence requirements. Validate your work by creating and running analyses, and verifying query results using the query log. Benefits to You By taking this course, you'll walk away with the ability to transform your organization’s data into intelligence, which will improve your day-to-day decision making. This new knowledge will help you provide time-critical, relevant and accurate insights. Furthermore, you'll develop skills that will help you become more efficient at building repositories. Build Logical Business Models This course will also teach you how to import schemas, design and build logical business models and expose business models to users in the Oracle BI user interface. While constructing the repository, you'll learn how to build physical and logical joins, simple measures and calculation measures. Model Logical Dimension Hierarchies You'll then extend the initial repository and learn how to model more complex business requirements. This includes logical dimension hierarchies, multiple logical table sources, aggregate tables, partitions and time series data. Implement Oracle BI Server Security Oracle University instructors will also walk you through implementing the Oracle BI Server security and managing the Oracle BI Server cache. You'll learn how to set up a multi-user development environment and use Administration Tool wizards and utilities to manage, maintain and enhance repositories.   Application Developers Business Analysts Business Intelligence Developer Data Modelers Data Warehouse Administrator Data Warehouse Analyst Reports Developer Technical Consultant Knowledge on Basic SQL Knowledge on Data warehouse design Knowledge on Dimensional modeling Oracle BI 11g R1: Create Analyses and Dashboards Repository Basics Exploring Oracle BI architecture components Exploring a repository's structure, features, and functions Using the Oracle BI Administration Tool Creating a repository Loading a repository into Oracle BI Server Installing the BI Client software Overview of Exalytics Machine Building the Physical Layer of a Repository Importing data sources Setting up Connection Pool properties Defining keys and joins Examining physical layer object properties Creating alias tables Printing the physical layer diagram Building the Business Model and Mapping Layer of a Repository Building a business model Building logical tables, columns, and sources Defining logical joins Building measures Examining business model object properties Printing the business model and mapping layer diagram Building the Presentation Layer of a Repository Exploring presentation layer objects Creating presentation layer objects Modifying presentation layer objects Examining presentation layer object properties Nesting presentation tables Controlling presentation layer object visibility Testing and Validating a Repository Checking repository consistency Turning on logging Uploading the repository through Enterprise Manager Executing analyses to test the repository Inspecting the query log Managing Logical Table Sources Adding multiple logical table sources to a logical table Specifying logical content Adding Calculations to a Fact Creating new calculation measures based on logical columns Creating new calculation measures based on physical columns Creating new calculation measures using the Calculation Wizard Creating measures using functions Working with Logical Dimensions Creating logical dimension hierarchies Creating level-based measures Creating share measures Creating dimension-specific aggregation rules Creating presentation hierarchies Creating parent-child hierarchies Creating ragged and skipped-level hierarchies Enabling Usage Tracking Creating the usage tracking tables Setting up the sample usage tracking repository Tracking and storing Oracle BI Server usage at the detailed query level Using usage tracking statistics to optimize query performance and aggregation strategies Using Model Checker and Aggregates Using Model Check Manager Modeling aggregate tables to improve query performance Using the Aggregate Persistence Wizard Testing aggregate navigation Setting the number of elements in a hierarchy Using Partitions and Fragments Exploring partition types Modeling partitions in an Oracle BI repository Using Repository Variables Creating session variables Creating repository variables Creating initialization blocks Using the Variable Manager Using dynamic repository variables as filters Modeling Time Series Data Using time comparisons in business analysis Using Oracle BI time series functions to model time series data Modeling Many-to-Many Relationships Using bridge tables to resolve many-to-many relationships between dimension tables and fact tables Setting an Implicit Fact Column Ensuring the correct results for dimension-only queries Selecting a predetermined fact table source Specifying a default join path between dimension tables Importing Metadata from Multidimensional Data Sources Importing a multidimensional data source into a repository Incorporating horizintal federation into a business model Incorporating vertical federation into a business model Adding Essbase measures to a relational model Displaying data from multidimensional sources in Oracle BI analyses and dashboards Security Exploring Oracle BI default security settings Creating users and groups Creating application roles Setting up object permissions Setting row-level security (data filters) Setting query limits and timing restrictions Cache Management Restricting tables as non-cacheable Using Cache Manager Inspecting cache reports Purging cache entries Modifying cache parameters and options Seeding the cache Exploring the Summary Advisor Tool Setting up Summary Advisor Running the Summary Advisor wizard to create the aggregate script Running the aggregate script to create the aggregates Using Administration Tool Utilities Using the various Administration Tool utilities Using BI Server XML API to create XML representation of repository metadata Multiuser Development Setting up a multiuser development environment Developing a repository using multiple developers Tracking development project history Performing a Patch Merge Comparing repositories Equalizing objects Creating a patch Applying a patch Making merge decisions

Időtartam:5 nap
Nehézségi szint:
  • Haladó
575 000 Ft-tól
(Bruttó ár: 730 250 Ft-tól)

Transition to Oracle Solaris 11 Ed 5

Kód: D73488

The Transition to Oracle Solaris 11 training builds on your system administration experience with Oracle Solaris 10 and teaches you the skills and knowledge to transition from Oracle Solaris 10 to Oracle Solaris 11. It's ideal for system administrators who have experience with Oracle Solaris 10 and IT architects responsible for planning and performing transitioning tasks. Learn To: Examine various aspects of planning for the transition from Oracle Solaris 10 to Oracle Solaris 11. Understand the new features delivered with Oracle Solaris 11 including Automated Installer (AI), Image Packaging System (IPS), and network virtualization. Describe and use new features introduced in Oracle Solaris 11.3. Practice transitioning to the Oracle Solaris 11 operating environment by performing a series of guided hands-on labs. Benefits to You The System Administrator will benefit from this course because they will be exposed to the new features delivered with Oracle Solaris 11.3 including verified boot for Kernel Zones, Kernel Zones live migration for SPARC, virtualized clocks for zones, first boot service creation tool, secure live migration, and non-root live migration. Operating System Migration Activities You'll engage in lab exercises that will walk you through critical tasks associated with operating system migration activities. These labs include case studies that showcase best practices when transitioning from Oracle Solaris 10 to Oracle Solaris 11. Throughout the course, you'll transition to the Oracle Solaris 11 operating environment by performing a series of guided hands-on labs that walk you through critical tasks associated with operating system activities. Don't Have Oracle Solaris 10 System Administration Experience? You should consider taking the Oracle Solaris 11 System Administration course followed by the Oracle Solaris 11 Advanced System Administration course. There are a number of new technologies that were introduced in Oracle Solaris 10 which teach you expected prerequisite knowledge you should have before taking this course. Without skills in those areas, you may not be able to keep pace with the course; this course takes you through rapid, in-depth coverage of Oracle Solaris 11 technologies and builds on your Oracle Solaris 10 knowledge.   System administrators who have experience with Oracle Solaris 10 System Administration for the Oracle Solaris 10 OS, Part 1 System Administration for the Oracle Solaris 10 OS, Part 2 Introducing the Oracle Solaris 11 New Features and Enhancements Describe the Oracle Solaris 11 features and enhancements Compare the features of Oracle Solaris 10 and Oracle Solaris 11 Describe a strategy for transitioning from Oracle Solaris 10 to Oracle Solaris 11 Managing Software Packages by Using IPS Explain the Image Packaging System (IPS) Configure a local IPS repository Manage software packages Describe the use of IPS in packaging the Oracle Solaris OS Update a system to Oracle Solaris 11.3 Manage boot environments Installing the Oracle Solaris 11 Operating System Perform interactive installations of Oracle Solaris 11 Configure an AI server for automated installation of Oracle Solaris 11 Distinguish between JumpStart and AI Build custom Oracle Solaris images by using distribution constructor Configuring the Network Explain the fundamentals of Oracle Solaris 11 network Configure the network in Oracle Solaris 11 Configure a virtual network Configure network high availability Configure Packet Filter to control network access Manage network resources for optimum utilization Monitor network traffic by using observability tools Administering Oracle Solaris 11 Zones Explain the fundamentals of Oracle Solaris 11 zones Migrate Oracle Solaris 10 systems Configure Oracle Solaris kernel zones Configure zones by using AI Monitor zone resource consumption Managing ZFS File System Explain Oracle Solaris 11 ZFS file system features Migrate UFS and ZFS file systems Split a mirrored ZFS storage pool Identify ZFS snapshot differences Configure ZFS deduplication Securing the Oracle Solaris 11 OS Describe the Oracle Solaris 11 security features Explain the Cryptographic Framework feature of Oracle Solaris Implement security for automated installations Describe ZFS file system encryption Manage read-only zones Verify file integrity by using BART Monitor the audit service Assess the compliance of an Oracle Solaris system  

Időtartam:5 nap
Nehézségi szint:
  • Haladó
800 000 Ft-tól
(Bruttó ár: 1 016 000 Ft-tól)

Exadata Database Machine Administration Workshop Ed 3

Kód: D73668

This Exadata Database Machine Administration Workshop Ed 3 training introduces you to Oracle Exadata Database Machine. You'll learn about the various Exadata Database Machine features and configurations, with emphasis on the unique capabilities delivered by Exadata Storage Server. Learn To: Describe Exadata Storage Server and how is it 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. Benefits to You Maximize the efficiency and effectiveness of your Exadata Database Machines by understanding and implementing the best practices taught in this course.   Database Administrators Sales Consultants System Administrator Technical Administrator Technical Consultant A working knowledge of Unix/Linux along with an understand of general networking, storage and system administration concepts. Prior knowledge and understanding of Oracle Database 11g Release 2, including Automatic Storage Management (ASM) and Real Application Clusters (RAC) Oracle Database 12c: Administration Workshop Oracle Database 12c: Administration Workshop Ed 2 NEW Oracle Database 12c: Backup and Recovery Workshop Oracle Database 12c: Backup and Recovery Workshop Ed 2 NEW UNIX and Linux Essentials Introduction Course Objectives Audience and Prerequisites Course Contents Terminology Additional Resources Introducing the Laboratory Environment Exadata Database Machine Overview Introducing Database Machine Introducing Exadata Storage Server Exadata Storage Server Architecture: Overview Exadata Storage Server Features: Overview Exadata Storage Expansion Racks InfiniBand Network Database Machine Support: Overview Exadata Database Machine Architecture Database Machine Architecture: Overview Database Machine Network Architecture InfiniBand Network Architecture InfiniBand Network Topology Interconnecting Multiple Racks Database Machine Software Architecture: Overview Disk Storage Entities and Relationships Key Capabilities of Exadata Database Machine Classic Database I/O and SQL Processing Model Exadata Smart Scan Model Exadata Smart Storage Capabilities Exadata Hybrid Columnar Compression Exadata Smart Flash Cache Exadata Storage Index Database File System I/O Resource Management Exadata Database Machine Initial Configuration Database Machine Implementation: Overview Database Machine Site Preparation Using Oracle Exadata Deployment Assistant Choosing the Right Disk Redundancy Setting Configuring Oracle Exadata Database Machine The Result After Installation and Configuration Supported Additional Configuration Activities Exadata Storage Server Configuration Exadata Storage Server Administration: Overview Testing Storage Server Performance Using CALIBRATE Configuring the Exadata Cell Server Software Starting and Stopping Exadata Cell Server Software Configuring Cell Disks and Grid Disks Configuring ASM and Database Instances to Access Exadata Cells Reconfiguring Exadata Storage Exadata Storage Security Implementation I/O Resource Management I/O Resource Management Concepts IORM Architecture Getting Started with IORM Enabling Intradatabase Resource Management Setting Database I/O Utilization Limits Interdatabase Plans and Database Roles Using Database I/O Metrics IORM and Exadata Storage Server Flash Memory Recommendations for Optimizing Database Performance Flash Memory Usage Influencing Caching Priorities Choosing the Flash Cache Mode Compression Usage Index Usage ASM Allocation Unit Size Minimum Extent Size Exadata Specific System Statistics Using Smart Scan Exadata Smart Scan: Overview Smart Scan Requirements Monitoring Smart Scan in SQL Execution Plans Smart Scan Join Processing with Bloom Filters Other Situations Affecting Smart Scan Exadata Storage Server Statistics: Overview Exadata Storage Server Wait Events: Overview Consolidation Options and Recommendation Consolidation: Overview Different Consolidation Types Recommended Storage Configuration for Consolidation Alternative Storage Configurations Cluster Configuration Options Isolating Management Roles Schema Consolidation Recommendations Maintenance Considerations Migrating Databases to Exadata Database Machine Migration Best Practices: Overview Performing Capacity Planning Database Machine Migration Considerations Choosing the Right Migration Path Logical Migration Approaches Physical Migration Approaches Post-Migration Best Practices Migrating to Database Machine Using Transportable Tablespaces Bulk Data Loading using Oracle DBFS Bulk Data Loading Using Oracle DBFS: Overview Preparing the Data Files Staging the Data Files Configuring the Staging Area Configuring the Target Database Loading the Target Database Exadata Database Machine Platform Monitoring Introduction Monitoring Technologies and Standards Simple Network Management Protocol (SNMP) Intelligent Platform Management Interface (IPMI) Integrated Lights Out Manager (ILOM) Exadata Storage Server Metrics, Thresholds, and Alerts Automatic Diagnostic Repository (ADR) Enterprise Manager Cloud Control 12c Enterprise Manager Database Control Configuring Enterprise Manager Cloud Control 12c to Monitor Exadata Database Machine Enterprise Manager Cloud Control 12c Architecture: Overview Cloud Control Monitoring Architecture for Exadata Database Machine Configuring Cloud Control to Monitor Exadata Database Machine Pre-discovery Configuration and Verification Deploying the Oracle Management Agent Discovering Exadata Database Machine Discovering Additional Targets Post-discovery Configuration and Verification Monitoring Exadata Storage Servers Exadata Metrics and Alerts Architecture Monitoring Exadata Storage Server with Metrics and Alerts Isolating Faults with Monitoring Exadata Storage Server with Enterprise Manager: Overview Monitoring Hardware Failure and Sensor State Monitoring Exadata Storage Server Availability Comparing Metrics Across Multiple Storage Servers Monitoring Exadata Database Machine Database Servers Monitoring Database Servers: Overview Monitoring Hardware Monitoring the Operating System Monitoring Oracle Grid Infrastructure Monitoring Oracle Database Monitoring Oracle Management Agent Database Monitoring with Enterprise Manager Cloud Control 12c Monitoring the InfiniBand Network InfiniBand Network Monitoring: Overview InfiniBand Network Monitoring with Monitoring the InfiniBand Switches Monitoring the InfiniBand Switch Ports Monitoring the InfiniBand Ports Monitoring the InfiniBand Fabric: Monitoring Other Exadata Database Machine Components Monitoring the Cisco Ethernet Switch Monitoring the Sun Power Distribution Units Monitoring the KVM Switch Other Useful Monitoring Tools Exachk: Overview Running Exachk Exachk Daemon DiagTools: Overview Using ADRCI on Exadata Storage Servers Imageinfo: Overview Imagehistory: Overview OSWatcher: Overview Backup and Recovery Using RMAN with Database Machine General Recommendations for RMAN Disk-Based Backup Strategy Disk-Based Backup Recommendations Disk-Based Backup on Tape-Based Backup Strategy Tape-Based Backup Architecture and Recommendations Backup and Recovery of Database Machine Software Exadata Database Machine Maintenance Tasks Database Machine Maintenance: Overview Powering Database Machine Off and On Safely Shutting Down a Single Exadata Storage Server Replacing a Damaged Physical Disk Replacing a Damaged Flash Card Moving All Disks from One Cell to Another Using the Exadata Cell Software Rescue Procedure Patching Exadata Database Machine Patching and Updating: Overview Maintaining Exadata Storage Server Software Maintaining Database Server Software Assisted Patching Using OPlan Assisted Patching Using Maintaining Other Software Recommended Patching Process Test System Recommendations

Időtartam:5 nap
Nehézségi szint:
  • Haladó
480 000 Ft-tól
(Bruttó ár: 609 600 Ft-tól)

Oracle Database 12c R1: New Features for Administrators Ed 2

Kód: D77758

  In the Oracle Database 12c: New Features for Administrators Ed2 course, you’ll learn about the new and enhanced features and options of Oracle Database 12c. Expert instructors will teach you how these features and options increase security, manageability and performance Learn To: Manage the Oracle multitenant container databases and pluggable databases. Configure Heat Map and use Automatic Data Optimization. Benefit from Online Datafile Move. Understand the new Temporal capabilities as well as In-Database Archiving with Row-archival. Enforce security with the Unified Auditing, the new administrative privileges, Privilege Analysis, and Data Redaction. Increase SQL performance with the Database In-Memory option, and Full Database In-Memory Caching and the Automatic Big Table Caching features. Benefit from optimizer enhancements such as Adaptive Execution Plans and SQL Plan Directives, Real-Time ADDM and Compare Period ADDM. Use enhanced features of Resource Manager in multitenant container databases and pluggable databases. Understand how and when to use enhancements in Data Pump, partitioning, and SQL. 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. Hands-on Practices and Demonstrations Hands-on practices and available demonstrations help you learn how to use these new or enhanced features of Oracle Database 12c. You'll explore using Oracle Enterprise Manager Cloud Control and other tools like Oracle Enterprise Manager Database Express SQL Developer to manage, monitor and administer your data center. You will also learn about performance new features of the first patchset of Oracle Database 12c: Full Database In-Memory Caching, the In-Memory Column Store which is one of the most important features of the 12.1 first patchset, and Automatic Big Table Caching. AdministratorDatabase AdministratorsSystem Administrator Good knowledge of Oracle Database 11g Suggested Prerequisites: Oracle Database 12c: Install and Upgrade Workshop Using Oracle Enterprise Manager Cloud Control 12c Ed 2 Enterprise Manager and Other Tools Enterprise Manager (EM) Cloud Control home page Enterprise Manager Express home page versus Enterprise Manager Database Control SQL Developer with new functionalities OUI, DBCA Basics of Multitenant Container Database (CDB) Benefits of the multitenant architecture Differences between the root container and pluggable database containers Structure of the root Structure of Pluggable Database (PDB) CDB_xxx and DBA_xxx views Impacts in Security, Data Guard, Oracle GoldenGate, Oracle Streams, XStream, and Scheduler Configuring and Creating CDB and PDBs Tools: DBCA and SQL*Plus Configuration and creation of CDB Exploring the Structure (CDB_xxx views and EM) Tools used: SQL Developer, DBCA and SQL*Plus and EM Database Express Create a new PDB from PDB$SEED Create a PDB from a non-CDB Clone a PDB into the same CDB or into another CDB using DB links Plug in an unplugged PDB Managing CDB and PDBs Connect to CDB as administrator Connect to a PDB using a service name Start up a CDB Open / Close a PDB (SQL*Plus, srvctl, EM) Open / Close all PDBs Shut down a CDB Preserve or discard the PDBs open mode when the CDB restarts Change PDB state Managing Tablespaces, Common and Local Users, Privileges and Roles Create permanent tablespaces in the root and PDBs Manage common and local schemas and users in the root and PDBs Manage system and object privileges to common and local grantees granted "commonly" or "locally" Manage common and local roles granted "commonly" or "locally" Managing Backup / Recovery / Flashback Backup a whole CDB Backup a PDB Recover CDB from redo log files, control files, undo datafiles loss Recover PDB from PDB datafiles loss Flashback at CDB level Explain the two methods of migration Online Datafile Move and Automatic Data Optimization Data classification in 12c : tablespace, group, object, row levels Configure heat map Automatic movement and compression Compression levels and types Policy declaration: simple declarative SQL extension Customized automated action execution with user-defined function Execution in scheduled maintenance windows and by MMON Customized schedule with DBMS_ILM package In-Database Archiving Challenges of old data in tables and 11g solutions In-database archiving new solutions Use ROW ARCHIVAL clause to enable row lifecycle state for applications Set ROW ARCHIVAL VISIBILITY for session level visibility control Use predicate on ORA_ARCHIVE_STATE column Temporal Validity versus Temporal History (Transaction Time of FDA) New clause of CREATE / ALTER TABLE to set a Temporal Validity: PERIOD FOR New SQL temporal data type Auditing Enhancements Review of 11g R2 audit trail implementation Overview of the Unified Audit Trail Enabling the Unified Audit Trail Creating a separate tablespace for the unified audit trail Granting the AUDIT_ADMIN role to a user for audit trail configuration and management Configuring the Unified Audit Trail to set a tolerance level for loss of audit records Creating audit policies Privileges Enhancements Implementing Separation of Duty for Database Administration Tasks Using Database Privilege Analysis Overview of Database Privilege Analysis Granting the CAPTURE_ADMIN role to enable management of privilege captures Creating and starting/stopping privilege captures Viewing privilege profile data Querying DBA_PRIV_CAPTURES Explaining the purpose of the default ORA$DEPENDENCY profile Oracle Data Redaction Overview of Oracle Data Redaction Types of Masking Policies Administering the EXEMPT REDACTION POLICY system privilege to enable a user to view unmasked values Managing Masking Policies Best practices for defining policy expressions Understanding Masking of Statements Containing Subqueries Viewing Information About Masking Policies by Querying REDACTION_POLICIES and REDACTION_COLUMNS General RMAN New Features and FDA Enhancements Making Database Connections With RMAN Using the SYSBACKUP Privilege Using SQL, DESCRIBE Command, Duplication Operation with the NOOPEN option Backing up and Restoring Very Large Files Creating Multisection Backups Transporting Data Across Platforms Prerequisites and Limitations Transporting Data: Processing steps Monitoring DB Operations Overview Use cases Current Tools Define a DB operation Monitoring: Bracketing an Operation Monitoring the Progress of Operations DB Operation Tuning DB Operation Active Report Real-Time ADDM and Compare Period Advisor Emergency Monitoring Real time ADDM Use cases Goals Define Workload dimensions Reported items Root Causes Requirements for a report ADR and Network Enhancements ADR file types New File types New File locations New command for ADRCI Improve performance by Compression Setup Compression In-Memory Column Store In-Memory Database option goals and benefits Row format and columnar format New SGA component: IMCU synchronization Deployment and behaviors Compression ratio New dictionary tables and added columns New statistics: IM % In-Memory Caching Setting up Full Database In-Memory Caching Using Full Database In-Memory Caching Explaining the two buffer replacement algorithms of Automatic Big Table Caching Configuring Automatic Big Table Caching with PARALLEL_DEGREE_POLICY and DB_BIG_TABLE_CACHE_PERCENT_TARGET initialization parameters Using Automatic Big Table Caching SQL Tuning Adaptive Execution Plans SQL Plan Directives Statistics Gathering Performance Improvements Histogram Enhancements Enhancements to Extended Statistics Adaptive SQL Plan Management Resource Manager and Other Performance Enhancements Manage resources between PDBs Manage resources within a PDB Manage resources with CDB and PDBs plans Manage runaway queries Control the in-memory database repopulation resource consumption Automated maintenance tasks Current Architecture: Unix multiprocess / one thread, NT/Windows one process / multithread New Architecture: Multiprocess / MultiThread Index and Table Enhancements Multiple indexes on the same set of columns as long as some characteristic is different Create table with INVISIBLE columns Support for invisible columns Describe online redefinition supports Explain LOCK timeout during FINISH_REDEF_TABLE Describe the Advanced Row Compression Using the following DDL statements in an online manner

Időtartam:5 nap
Nehézségi szint:
  • Haladó
480 000 Ft-tól
(Bruttó ár: 609 600 Ft-tól)

Oracle Database 12c: Administration Workshop Ed 2

Kód: D78846

The Oracle Database 12c: Administration Workshop will teach you about the Oracle Database architecture. You will discover how to effectively manage an Oracle Database instance, configure the Oracle Network Environment and perform database maintenance. In this course, you will be introduced to Oracle Database Cloud Service. Learn To: Create and manage an Oracle Database Instance. Create and manage Storage Structures. Configure the Oracle Network Environment. Create and manage users. Monitor the database and manage performance. Learn basic information on backup and recovery techniques. Use the Oracle Support Workbench and My Oracle Support to update your Oracle Database software. Gain an understanding of the Oracle Database Cloud Service. 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. Participate in Hands-On Practices and Demonstrations Expert instruction and hands-on demonstrations will provide you with real world experience. By engaging in hands-on exercises to reinforce your learning, you'll develop in demand skills to effectively manage an Oracle Database.   Data Warehouse Administrator Database Administrators Database Designers Technical Administrator Working knowledge of SQL and use of PL/SQL packages Basic knowledge of Linux operating system Introduction Course Objectives Course Schedule Overview of Oracle Database 12c Overview of Oracle Cloud Overview of the HR Schema Exploring the Oracle Database Architecture Oracle Database Architecture: Overview Oracle Database Instance Configurations Connecting to the Oracle Database Instance Oracle Database Memory Structures Process Architecture Process Structures Process Startup Sequence Database Storage Architecture Managing the Database Instance Introducing Oracle Database Management Tools Understanding the Enterprise Manager Management Framework Logging in to Oracle Enterprise Manager Database Express Using the Enterprise Manager Database Express Home Page Using Enterprise Manager Cloud Control Using SQL*PlusUsing SQL Developer Initialization Parameter Files Configuring the Oracle Network Environment Oracle Net Services Overview Oracle Net Listener Overview Establishing Oracle Network Connections Tools for Configuring and Managing the Oracle Network Using the Listener Control Utility Using Oracle Net Configuration Assistant Using Oracle Net Manager Using Enterprise Manager Cloud Control Managing Database Storage Structures Understanding Storage of Data Database Block Contents Exploring the Storage Structure Creating a New Tablespace Overview of Tablespaces Created by Default Managing Tablespaces Viewing Tablespace Information Using Oracle Managed Files Administering User Security Database User Accounts Predefined Administrative Accounts Creating a User Authentication Unlocking a User Account and Resetting the Password Privileges Roles Profiles Managing Data Concurrency Overview of Locks Locking Mechanism Data Concurrency DML Locks Enqueue Mechanism Lock Conflicts Managing Undo Data Undo Data Overview Transactions and Undo Data Storing Undo Information Comparing Undo Data and Redo Data Managing Undo Configuring Undo Retention Guaranteeing Undo Retention Changing an Undo Tablespace to a Fixed Size Implementing Oracle Database Auditing Separation of Responsibilities Database Security Monitoring for Compliance Standard Database Auditing Unified Audit Data Trail Separation for Duties for Audit Administration (AUDIT_ADMIN and AUDIT_VIEWER roles) Configuring the Audit trail Specifying Audit Options Performing Database Maintenance Database Maintenance Viewing the Alert History Terminology Automatic Workload Repository (AWR) Statistic Levels Automatic Database Diagnostic Monitor (ADDM) Advisory Framework Enterprise Manager and Advisors Managing Performance Performance Monitoring Tuning Activities Performance Planning Instance Tuning Performance Tuning Methodology Performance Tuning Data Monitoring Performance Managing Memory Managing Performance: SQL Tuning SQL Tuning Oracle Optimizer SQL Plan Directives Adaptive Execution Plans SQL Advisors Automatic SQL Tuning Results Implement Automatic Tuning Recommendations SQL Tuning Advisor Managing Resources by Using Database Resource Manager Database Resource Manager Overview Database Resource Manager Concepts Using the Resource Manager Default Maintenance Resource Manager Plan Default Plan Example Resource Manager Workflow Specifying Resource Plan Directives Resource Allocation Methods for Resource Plans Automating Tasks by Using Oracle Scheduler Simplifying Management Tasks Understanding a Simple Job Core Components Basic Work Flow Persistent Lightweight Jobs Using a Time-Based or Event-Based Schedule Creating a Time-Based Job Creating an Event-Based Schedule Managing Space Space Management Overview Block Space Management Row Chaining and Migration Free Space Management Within Segments Types of Segments Allocating Extents Allocating Space Creating Tables Without Segments Backup and Recovery Concepts Categories of Failures Flashback Technology Understanding Instance Recovery Phases of Instance Recovery Tuning Instance Recovery Using the MTTR Advisor Media Failure Configuring for Recoverability Moving Data Moving Data: General Architecture Oracle Data Pump SQL*Loader External Tables Working with Oracle Support Using the Support Workbench Using Enterprise Manager Working with Oracle Support My Oracle Support Integration Researching an Issue Logging Service Requests Managing Patches Applying a Patch Release Oracle Database Cloud Service: Overview Database as a Service Architecture, Features and Tooling Software Editions: Included Database Options and Management Packs Automated Database Provisioning Managing the Compute Node Associated With a Database Deployment Enabling Access to a Compute Node Port Scaling a Database Deployment & Patching Database as a Service Using the Oracle Database Cloud Service Console to Manage Patches

Időtartam:5 nap
Nehézségi szint:
  • Haladó
480 000 Ft-tól
(Bruttó ár: 609 600 Ft-tól)

Oracle Database 12c: Backup and Recovery Workshop Ed 2

Kód: D78850

This Oracle Database 12c: Backup and Recovery Workshop will teach you how to evaluate your own recovery requirements. You'll develop appropriate strategies for backup, restore and recovery procedures from provided scenarios. In this course, you will be introduced to Oracle Database Cloud Service. 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. Gain an understanding of the Oracle Database Cloud Service. 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. Perform Backup and Recovery Expert instructors will begin by helping you gain a deeper understanding of possibly the most important job of a Database Administrator – backup and recovery. The concepts and architecture that support backup and recovery, along with the steps required to carry it out in various ways and situations, are covered in detail. Recovery Manager Command Line and Graphical Interfaces This course will teach you about Recovery Manager (RMAN) command line and graphical interfaces for various backup, failure, restore and recovery scenarios. Participate in Hands-on Practices and Workshops Participating in extensive hands-on practices and workshops will help you gain experience in a realistic technical environment. Interactive workshops give you the opportunity to diagnose and recover from numerous failure scenarios, based on backup and recovery case studies. Key Takeaways Upon completing this course, you will know how to evaluate your own recovery requirements. You'll have the skills to develop an appropriate strategy for backup and recovery procedures. Data Warehouse Administrator Database Administrators Support Engineer Technical Administrator Knowledge of SQL and PL/SQL Knowledge of Oracle Database 12c Oracle Database 12c: Administration Workshop Ed 2 Using Oracle Enterprise Manager Cloud Control 12c Ed 2 Introduction Curriculum Context Assess your Recovery Requirements Categories of failures Oracle Backup and Recovery Solutions Oracle Maximum Availability Architecture Oracle Secure Backup Benefits of using Oracle Data Guard Basic Workshop Architecture Getting Started Core Concepts of the Oracle Database, Critical for Backup and Recovery Oracle DBA Tools for Backup and Recovery Connecting to Oracle Recovery Manager (RMAN) Quick Start: A Problem-Solution Approach Configuring for Recoverablility RMAN commands Configuring and managing persistent settings Using the Fast Recovery Area (FRA) Control File Redo Log File Archiving Logs Using the RMAN Recovery Catalog Creating and Configuring the Recovery Catalog Managing Target Database Records in the Recovery Catalog Using RMAN Stored Scripts Maintaining and Protecting the Recovery Catalog Virtual Private Catalogs Backup Strategies and Terminology Backup Solutions Overview and Terminology Balancing Backup and Restore Requirements Backing Up Read-Only Tablespaces Best Practices for Data Warehouse Backups Additional Backup Terminology Performing Backups RMAN Backup Types Incrementally Updated Backups Fast Incremental Backup Block Change Tracking Oracle-Suggested Backup Reporting on Backups Managing Backups Improving Your Backups Compressing Backups Using a Media Manager Creating RMAN Multisection Backups, Proxy Copies, Duplexed Backup Sets and Backups of Backup Sets Creating and Managing Archival Backups Backing Up Recovery Files Backing Up the Control File to a Trace File Cataloging Additional Backup Files Backing Up ASM Disk Group Metadata Using RMAN-Encrypted Backups Creating RMAN-Encrypted Backups Using Transparent-Mode Encryption Using Password-Mode Encryption Using Dual-Mode Encryption Diagnosing Database Failures Reducing Problem Diagnosis Time Automatic Diagnostic Repository Interpreting RMAN Message Output and Error Stacks Data Recovery Advisor Diagnosing Data File Loss (file system and ASM) Handling Block Corruption Restore and Recovery Concepts Restoring and Recovering Instance Failure and Instance/Crash Recovery Media Failure Complete Recovery (Overview) Point-in-Time Recovery (Overview) Recovery Through RESETLOGS Performing Recovery, Part 1 RMAN Recovery in NOARCHIVELOG Mode Performing Complete Recovery (of critical and noncritical data files) Restoring ASM Disk Groups Recovery with Image Files Performing Point-in-Time (PITR) or Incomplete Recovery Table Recovery from Backups Performing Recovery, Part 2 Recovery of Server Parameter File, Control File Redo Log File Loss and Recovery Password Authentication File Re-creation Index, Read-Only Tablespace, and Tempfile Recovery Restoring the Database to a New Host Disaster Recovery Restoring RMAN Encrypted Backups RMAN and Oracle Secure Backup Oracle Secure Backup Overview Oracle Database Disk and Tape Backup Solution Backing Up the Fast Recovery Area to Tape Defining Retention for RMAN Backups RMAN and Oracle Secure Backup Basic Process Flow Integration with Cloud Control RMAN Database Backup to Tape Performing Tape Backups and Restores Scheduling Backups with EM Oracle-Suggested Backup RMAN and OSB Process Flow RMAN and Oracle Secure Backup Jobs Managing Database Tape Backups Performing Database Recovery RMAN Automatic Failover to Previous Backup Using Flashback Technologies Flashback Technology: Overview and Setup Using Flashback Technology to Query Data Flashback Table Flashback Transaction (Query and Backout) Flashback Drop and the Recycle Bin Flashback Data Archive Using Flashback Database Flashback Database Architecture Configuring Flashback Database Performing Flashback Database Best Practices for Flashback Database Managing Backup Space or Transporting Data Transporting Tablespaces Transporting Databases Duplicating a Database Using a Duplicate Database Choosing Database Duplication Techniques Creating a Backup-up Based Duplicate Database Understanding the RMAN Duplication Operation Using Cloud Control to Clone a Database RMAN Performance and Tuning Tuning Principles RMAN Multiplexing Diagnosing Performance Bottlenecks Restore and Recovery Performance Best Practices Backup and Recovery Workshop Workshop Structure Workshop Approach to Solving Failure Scenarios Business Requirements for Database Availability and Procedures Oracle Database Cloud Service: Overview Database as a Service Architecture & Features and Tooling Automated Database Provisioning Managing the Compute Node Associated With a Database Deployment Backing Up and Recovering Databases on Database as a Service Backup Configuration & Creating an On-Demand Backup Customizing the Backup Configuration: Single-Instance Databases Performing Recovery by Using the Service Console Restoring and Recovering: Single-Instance Databases

Időtartam:5 nap
Nehézségi szint:
  • Haladó
192 000 Ft-tól
(Bruttó ár: 243 840 Ft-tól)

Oracle Database 12c: Fundamentals for Developers and System Administrators

Kód: D79228

This course is ideal for Database Administrators of small to medium sized businesses. This Oracle Database 12c: Fundamentals for Developers and System Administrators course helps you perform basic Oracle Database 12c administration tasks needed to keep the database operational.In this course, you will be introduced to Oracle Database Cloud Service. Learn To: Install Oracle Database 12c software and create a database. Use Enterprise Manager Database Express to manage the database. Manage database storage structures and schema objects. Administer users and security. Backup and recover the Oracle Database. Monitor the database and use the Advisors. Gain an understanding of the Oracle Database Cloud Service. 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. Install and Manage Oracle Database 12c The goal of this course is to teach you how to install the Oracle Database 12c software and perform the tasks required to manage an Oracle database. You will start with installation of the Oracle Software and reviewing installation configuration details. Self-Managing Capabilities and Automatic Features of Oracle Database 12c Throughout this course, expert Oracle instructors will teach you how to quickly accomplish required tasks using Enterprise Manager. This training places particular emphasis on the self-managing capabilities and automatic features of Oracle Database 12c.     Database Administrators Support Engineer Technical Administrator Technical Consultant Basic understanding of the Linux operating system Course Overview Course Objectives Course Agenda Course Environment Additional Resources Oracle Database: Overview Relational Databases: Introduction Relational Database Terminology Relating Multiple Tables Structured Query Language (SQL) SQL Statements Using SQL to Access the Database Development Tools for Oracle Database Oracle Instance and Database: Overview Installing and Creating a Database Installation Workflow Oracle Universal Installer Installation Prerequisites Setting Environment Variables Installation Steps Configuring Security Updates Downloading Software Updates Specifying Installation Options Using Oracle Enterprise Manager Database Express and SQL-Based Management Tools Management Framework Enterprise Manager Database Express: Overview Configuring the HTTPS Port for EM Express Accessing EM Express Using the Database Home Page Navigating Through EM Express Granting Access to EM Express SQL*Plus Configuring the Oracle Network Environment Network Configuration: Overview Oracle Net Listener: Configuration and Management Tools for Configuring and Managing the Oracle Network Using the Listener Control Utility Connecting to an Oracle Database Name Resolution Oracle Net: Naming Methods Managing the Oracle Instance Oracle Instance Management Initialization Parameters Oracle Processes Oracle Memory Structures Starting and Shutting Down an Instance States of an Instance Stopping and Starting an Instance by Using SQL*Plus Stopping and Starting an Instance by Using SQL Developer Managing Database Storage Structures Oracle Database Structures Exploring the Storage Structure of the Oracle Database Control File Redo Log Files Multiplexing the Redo Log Tablespaces and Data Files Tablespaces in the Preconfigured Database Enlarging the Database Administering Users and Security Overview of Users and Security Oracle-Defined Users Creating Users Modifying Users Dropping Users Locking and Unlocking Accounts Unlocking a User Account and Resetting the Password Setting the Password Policy Managing Schema Objects What Is a Schema? Schemas Accessing Schema Objects Specifying Data Types in Tables Creating and Modifying Tables Modifying a Table Understanding Data Integrity Defining Constraints Performing Backup and Recovery Oracle Recovery Features Backup File Types Types of Backups Media Recovery Options Media Recovery Step Configuring the Database for Backup and Recovery Configuring the Fast Recovery Area Credentials Required to Perform Backup and Recovery Monitoring the Database and Using the Advisors Proactive Database Monitoring Monitoring General Database State and Workload Monitoring Performance Diagnosing Performance Problems Types of ADDM Findings Viewing a Summary of ADDM Performance Findings Responding to Findings Using Advisors Managing the Software Understanding Software Management and Patch Releases Patching Oracle Database Software Using the Database Upgrade Assistant to Upgrade the Database Removing Oracle Database Software Oracle Database Cloud Service: Overview Database as a Service Architecture, Features and Tooling Software Editions: Included Database Options and Management Packs Automated Database Provisioning Managing the Compute Node Associated With a Database Deployment Managing Network Access to Database as a Service Enabling Access to a Compute Node Port Scaling a Database Deployment & Patching Database as a Service Using the Oracle Database Cloud Service Console to Manage Patches

Időtartam:2 nap
Nehézségi szint:
  • Haladó
480 000 Ft-tól
(Bruttó ár: 609 600 Ft-tól)

Oracle Database 12c: Performance Management and Tuning

Kód: D79236

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. Data Warehouse Administrator Database Administrators Oracle Database 12c: Administration Workshop Ed 2 Oracle Database 12c: Install and Upgrade Workshop Introduction Course Objectives Course Organization Course Agenda Topics Not Included in the Course Who Tunes? What Does the DBA Tune? How to Tune Tuning Methodology Basic Tuning Diagnostics Performance Tuning Diagnostics Performance Tuning Tools Tuning Objectives Top Timed Events DB Time CPU and Wait Time Tuning Dimensions Time Model Dynamic Performance Views Using Automatic Workload Repository   Automatic Workload Repository Overview Automatic Workload Repository Data Enterprise Manager Cloud Control and AWR Snapshots Reports Compare Periods Defining the Scope of Performance Issues Defining the Problem Limiting the Scope Setting the Priority Top SQL Reports Common Tuning Problems Tuning During the Life Cycle ADDM Tuning Session Performance Versus Business Requirements Using Metrics and Alerts Metrics and Alerts Overview Limitation of Base Statistics Benefits of Metrics Viewing Metric History Information Viewing Histograms Server-Generated Alerts Setting Thresholds Metrics and Alerts Views Using Baselines Comparative Performance Analysis with AWR Baselines Automatic Workload Repository Baselines Moving Window Baseline Baselines in Performance Page Settings Baseline Templates AWR Baseslines Creating AWR Baselines Managing Baselines with PL/SQL Using AWR-Based Tools   Automatic Maintenance Tasks ADDM Performance Monitoring Using Compare Periods ADDM Active Session History New or Enhanced Automatic Workload Repository Views Emergency Monitoring Real-time ADDM Real-Time Database Operation Monitoring Overview Use Cases Defining a Database Operation Scope of a Composite Database Operation Database Operation Concepts Identifying a Database Operation Enabling Monitoring of Database Operations Identifying, Starting, and Completing a Database Operation Monitoring Applications What is a Service? Service Attributes Service Types Creating Services Managing Services in a Single-Instance Environment Where are Services Used? Using Services with Client Applications Services and Pluggable Databases Identifying Problem SQL Statements SQL Statement Processing Phases Role of the Oracle Optimizer Identifying Bad SQL Top SQL Reports SQL Monitoring What is an Execution Plan? Methods for Viewing Execution Plans Uses of Execution Plans Influencing the Optimizer Functions of the Query Optimizer Selectivity Cardinality and Cost Changing Optimizer Behavior Optimizer Statistics Extended Statistics Controlling the Behavior of the Optimizer with Parameters Enabling Query Optimizer Features Reducing the Cost of SQL Operations Reducing the Cost Index Maintenance SQL Access Advisor Table Maintenance for Performance Table Reorganization Methods Space Management Extent Management Data Storage Using SQL Performance Analyzer Real Application Testing: Overview Real Application Testing: Use Cases SQL Performance Analyzer: Process Capturing the SQL Workload Creating a SQL Performance Analyzer Task SQL Performance Analyzer: Tasks Parameter Change SQL Performance Analyzer Task Page SQL Performance Management Maintaining SQL Performance Maintaining Optimizer Statistics Automated Maintenance Tasks Statistic Gathering Options Setting Statistic Preferences Restore Statistics Deferred Statistics Publishing Automatic SQL Tuning Using Database Replay Using Database Replay The Big Picture System Architecture Capture Considerations Replay Considerations: Preparation Replay Considerations Replay Options Replay Analysis Tuning the Shared Pool Shared Pool Architecture Shared Pool Operation The Library Cache Latch and Mutex Diagnostic Tools for Tuning the Shared Pool Avoiding Hard Parses Reducing the Cost of Soft Parses Sizing the Shared Pool Tuning the Buffer Cache Oracle Database Architecture: Buffer Cache Buffer Cache: Highlights Database Buffers Buffer Hash Table for Lookups Working Sets Buffer Cache Tuning Goals and Techniques Buffer Cache Performance Symptoms Buffer Cache Performance Solutions Tuning PGA and Temporary Space SQL Memory Usage Performance Impact Automatic PGA Memory SQL Memory Manager Configuring Automatic PGA Memory Setting PGA_AGGREGATE_TARGET Initially Limiting the size of the Program Global Area (PGA) SQL Memory Usage Automatic Memory Oracle Database Architecture Dynamic SGA Granule Memory Advisories Manually Adding Granules to Components Increasing the Size of an SGA Component Automatic Shared Memory Management: Overview SGA Sizing Parameters: Overview Performance Tuning Summary with Waits Commonly Observed Wait Events Additional Statistics Top 10 Mistakes Found in Customer Systems Symptoms Oracle Database Cloud Service: Overview Database as a Service Architecture, Features and Tooling Software Editions: Included Database Options and Management Packs Accessing the Oracle Database Cloud Service Console & Automated Database Provisioning Managing the Compute Node Associated With a Database Deployment Managing Network Access to Database as a Service & Scaling a Database Deployment Performance Management in the Database Cloud Environment Performance Monitoring and Tuning What Can be Tuned in a DBCS Environment?

Időtartam:5 nap
Nehézségi szint:
  • Haladó
288 000 Ft-tól
(Bruttó ár: 365 760 Ft-tól)

Oracle Database: SQL Tuning for Developers

Kód: D79995

In the Oracle Database: SQL Tuning for Developers course, you learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code. Learn the different ways in which data can be accessed efficiently. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service. Learn To: Use Oracle tools to identify inefficient SQL statements. Use Automatic SQL Tuning. Use Real Time SQL monitoring. Write more efficient SQL statements. Monitor and trace high load SQL statements. Manage optimizer statistics on database objects. Understand the optimizer process steps and operators. Interpret execution plans. Perform application tracing. Gain an understanding of the Oracle Database Exadata Express Cloud Service. Benefits To You: Benefit from gaining a deeper understanding of Oracle SQL statement tuning and how write well-tuned SQL statements appropriate for the Oracle database in this application development-centric course. You will learn how to decipher, decide and then apply tuning to your SQL code. Various tuning techniques are demonstrated. Application Developers Data Warehouse Developer Developer PL/SQL Developer Support Engineer Familiarity with database architecture Knowledge of SQL and PL/SQL Oracle Database 12c: Introduction to SQL Ed 1.1 Introduction Course Objectives, Course Agenda and Appendixes Used in this Course Audience and Prerequisites Sample Schemas Used in the Course Class Account Information SQL Environments Available in the Course Workshops, Demo Scripts, and Code Example Scripts Appendices in the Course Introduction to SQL Tuning SQL Tuning Session SQL Tuning Strategies Development Environments: Overview SQLTXPLAIN (SQLT) Diagnostic Tool Using Application Tracing Tools Using the SQL Trace Facility: Overview Steps Needed Before Tracing Available Tracing Tools: Overview The trcsess Utility Formatting SQL Trace Files: Overview Understanding Basic Tuning Techniques Developing Efficient SQL statement Scripts Used in This Lesson Table Design Index Usage Transformed Index Data Type Mismatch NULL usage Tune the ORDER BY Clause Optimizer Fundamentals SQL Statement Representation SQL Statement Processing Why Do You Need an Optimizer? Components of the Optimizer Query Transformer Cost-Based Optimizer Adaptive Query Optimization Optimizer Features and Oracle Database Releases Generating and Displaying Execution Plans Execution Plan? The EXPLAIN PLAN Command Plan Table AUTOTRACE V$SQL_PLAN View Automatic Workload Repository SQL Monitoring Interpreting Execution Plans and Enhancements Interpreting a Serial Execution Plan Adaptive Optimizations Optimizer: Table and Index Access Paths Row Source Operations Main Structures and Access Paths Full Table Scan Indexes Common Observations Optimizer Join Operations Join Methods Join Types Other Optimizer Operators SQL operators Other N-Array Operations Result Cache operators Introduction to Optimizer Statistics Concepts Optimizer Statistics Types of Optimizer Statistics Gather and Manage Optimizer Statistics: Overview Using Bind Variables Cursor Sharing and Different Literal Values Cursor Sharing and Bind Variables SQL Plan Management Maintaining SQL Performance SQL Plan Management Workshops Workshop 1 Workshop 2 Workshop 3 Workshop 4 Workshop 5 Workshop 6 & 7 Workshop 8 Workshop 9 Oracle Cloud Overview Introduction to Oracle Cloud & Oracle Cloud Services Cloud Deployment Models Evolving from On-premises to Exadata Express What is in Exadata Express? Exadata Express for Users & Developers Oracle Exadata Express Cloud Service Getting Started with Exadata Express Service Console & Web Access through Service Console

Időtartam:3 nap
Nehézségi szint:
  • Haladó
480 000 Ft-tól
(Bruttó ár: 609 600 Ft-tól)

Oracle WebLogic Server 12c: Administration I

Kód: D80149

This Oracle WebLogic Server 12c: Administration I training teaches you how to install and configure Oracle WebLogic Server 12c. It gives administrators an overview of the basic concepts and architecture of WebLogic Server. Learn how to: Install, configure, and administer Oracle WebLogic Server. Monitor domain resources. Deploy applications. Create a domain. Start servers. Monitor domain resources. Set up and use node manager. Deploy applications. Configure database resources. Configure a cluster. Benefits to You After taking this course, you'll be able to improve the performance and scalability of your organization's applications and services with the #1 application server. You'll simplify deployment and significantly improve time-to-market. Kinek ajánljuk Developer J2EE Developer System Administrator Systems Architects Technical Administrator Some experience using basic Linux commands Some system administration experience WebLogic Server Overview WebLogic Server Architecture Application Services Administration Tools Java Cloud Service Installing and Patching WebLogic Server Installing WebLogic Server Patching WebLogic Server Zero Downtime Patching Creating Domains Domain Planning Domain Modes Domain Creation Tools Domain Templates Using the Configuration Wizard Multitenancy concepts Starting Servers Server Lifecycle Starting and Stopping Servers Domain scripts Customizing Domain Scripts Restarting Failed Servers Using the Administration Console Using the Administration Console for Configuration Change Management Architecture Creating and Modifying Managed Servers Enterprise Manager Cloud Control Configuring JDBC JDBC Review Datasource Types Configuring a JDBC Data Source JDBC and RAC Connection Pools Monitoring a Domain Working with WebLogic Server Logs Monitoring WebLogic Server JMX, MBeans and Monitoring Monitoring Dashboards Node Manager Node Manager Concepts Configuring and Using Node Manager Node Manager Setup Tasks Node Manager and Scripting Node Manager Best Practices Deploying Applications Deployment Overview and Lifecycle Deployment Descriptor Concepts WebLogic Deployment Tools Deploying an Application Load Testing an Application Network Channels and Virtual Hosts Configuring a Network Channel Configuring the Admin Port Creating a Virtual Host Clusters: Overview, Create, & Config Clustering Review Configuring a Cluster Configuring a Dynamic Cluster Clusters: Proxies & Sessions Web-tier and Cluster Proxies Oracle Traffic Director and Oracle HTTP Server Configuring a Cluster Proxy Configuring Replication Groups Clusters: Communication, Planning & Troubleshooting Cluster Communication Concepts Multicast and Unicast Replication Channels Scaling and Troubleshooting Clusters Transactions Transaction Overview Configuring Transaction Persistence Transaction Logs Transactions and Persistent Stores Monitoring Transactions WebLogic Server Security WebLogic Security Architecture Configuring an Authentication Provider LDAP Authentication Troubleshooting Authentication Backing Up a Domain and Upgrading WebLogic Server Backup/Recovery Concepts Backup Types Backing Up and Restoring a Domain

Időtartam:5 nap
Nehézségi szint:
  • Haladó
480 000 Ft-tól
(Bruttó ár: 609 600 Ft-tól)

Oracle WebLogic Server 12c: Administration II

Kód: D80153

This Oracle WebLogic Server 12c: Administration II training 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 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 Taking this course will help you increase the reliability, availability, scalability, and performance (RASP) of your organization’s applications and services with the #1 application server. You'll be better equipped to 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 Administrators will learn how to perform 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. Administrator Java EE Developers Security Administrators System Administrator Technical Administrator Technical Consultant Web Administrator WebLogic Admin I Oracle WebLogic Server 12c: Administration I Course Overview Objectives Prerequisites Schedule WebLogic Server Review WebLogic Server: Overview WebLogic Server Domain Administration Server and Managed Server Machines, Node Manager, and Clusters Start Scripts WebLogic Tools: Administration Console and WLST Deployment Upgrading WebLogic Server Upgrade definition Rolling Upgrade Rolling Upgrade Process Creating and Using Domain Templates Domain Template Review Domain Template Concepts Extension Template Concepts Custom Templates WebLogic Server Startup and Crash Recover Node Manager Review Configure Node Manager to Start on System Boot Server Automatic Crash Recovery Restart WebLogic Scripting Tool (WLST) Jython Concepts WLST Concepts Java Management eXtension (JMX) concepts Common WLST tasks WebLogic Server and REST WLS and REST Accessing WLS via REST WLS REST Operations Secure Sockets Layer (SSL) SSL Concepts WebLogic SSL Scenarios Keystores Configuring WebLogic SSL Shared Java EE Libraries Shared Java EE Library Concepts Deploying a Shared Library Application Work Managers Default WebLogic Request Handling Work Manager Concepts Creating a Work Manager Security Realms Security Review Embedded LDAP Authentication System Configure Auditing Disaster Recovery and Migration Disaster Recovery Backing Up the Administration Servers Service-Level Migration Whole Server Migration Domain Partitions Introduction to Multitenancy Working with Domain Partitions Managing Data Sources General Architecture Diagnostic Images Harvesters Watches and Notifications Diagnostic Framework General Architecture Diagnostic Images Harvesters Policies and Actions Scaling and WLDF Coherence Coherence Overview Coherence*Web Session Persistence Managed Coherence Servers (Optional)Application Staging and Deployment Plans Review Server staging modes Deploying an application to multiple environments Java EE deployment descriptors and annotations Deployment plans Deployment plan tools (Optional)Production Redeployment HTTP Sessions and Redeployment Redeployment Strategies Production Redeployment Application Versioning Requirements and Restrictions

Időtartam:5 nap
Nehézségi szint:
  • Haladó
480 000 Ft-tól
(Bruttó ár: 609 600 Ft-tól)

Oracle Database 12c: Introduction to SQL Ed 1

Kód: D80174

This Oracle Database: 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.   Application Developers Business Analysts Data Warehouse Administrator Developer Forms Developer PL/SQL Developer System Analysts Familiarity with data processing concepts and techniques Data processing Introduction Course Objectives, Course Agenda and Appendixes Used in this Course Overview of Oracle Database 12c and Related Products Overview of relational database management concepts and terminologies Introduction to SQL and its development environments What is Oracle SQL Developer? Starting SQL*Plus from Oracle SQL Developer The Human Resource (HR) Schema Tables used in the Course Retrieving Data using the SQL SELECT Statement Capabilities of the SELECT statement Arithmetic expressions and NULL values in the SELECT statement Column aliases Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword Use of the DESCRIBE command Restricting and Sorting Data Limiting the Rows Rules of precedence for operators in an expression Substitution Variables Using the DEFINE and VERIFY command Using Single-Row Functions to Customize Output Describe the differences between single row and multiple row functions Manipulate strings with character function in the SELECT and WHERE clauses Manipulate numbers with the ROUND, TRUNC and MOD functions Perform arithmetic with date data Manipulate dates with the date functions Using Conversion Functions and Conditional Expressions Describe implicit and explicit data type conversion Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions Nest multiple functions Apply the NVL, NULLIF, and COALESCE functions to data Use conditional IF THEN ELSE logic in a SELECT statement Reporting Aggregated Data Using the Group Functions Group Functions Creating Groups of Data Restricting Group Results Displaying Data from Multiple Tables Using Joins Introduction to JOINS Types of Joins Natural join Self-join Non equijoins OUTER join Using Subqueries to Solve Queries Introduction to Subqueries Single Row Subqueries Multiple Row Subqueries Using the SET Operators Set Operators UNION and UNION ALL operator INTERSECT operator MINUS operator Matching the SELECT statements Using ORDER BY clause in set operations Managing Tables using DML statements Data Manipulation Language Database Transactions Introduction to Data Definition Language Data Definition Language Introduction to Data Dictionary Views Introduction to Data Dictionary Describe the Data Dictionary Structure Using the Data Dictionary views Querying the Data Dictionary Views Creating Sequences, Synonyms, Indexes Overview of sequences Overview of synonyms Overview of indexes Creating Views Overview of views Managing Schema Objects Managing constraints Creating and using temporary tables Creating and using external tables Retrieving Data by Using Subqueries Retrieving Data by Using a Subquery as Source Working with Multiple-Column subqueries Using Scalar subqueries in SQL Correlated Subqueries Working with the WITH clause Manipulating Data by Using Subqueries Using Subqueries to Manipulate Data Inserting by Using a Subquery as a Target Using the WITH CHECK OPTION Keyword on DML Statements Using Correlated Subqueries to Update and Delete rows Controlling User Access System privileges Creating a role Object privileges Revoking object privileges Manipulating Data Overview of the Explicit Default Feature Using multitable INSERTs Using the MERGE statement Performing flashback operations Tracking Changes in Data Managing Data in Different Time Zones Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP Working with INTERVAL data types

Időtartam:5 nap
Nehézségi szint:
  • Haladó
288 000 Ft-tól
(Bruttó ár: 365 760 Ft-tól)

Oracle Database 12c: Advanced PL/SQL

Kód: D80343

This Oracle Database 12c: Advanced PL/SQL training teaches you how to use the advanced features of PL/SQL to design and tune PL/SQL to interface with the database and other applications. Expert Oracle University instructors will help you explore advanced features of program design, packages, cursors, extended interface methods and collections. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service. Learn To: Write powerful PL/SQL programs. Explore programming efficiency. Use external C and Java routines. Apply PL/SQL designing best practices. Create PL/SQL applications that use collections. 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. Gain an understanding of the Oracle Database Exadata Express Cloud Service. Benefits to You Discover how to write PL/SQL routines that analyze the PL/SQL applications and caching techniques that can improve performance. By investing in this course, you'll be introduced to the Virtual Private Database(VPD) to implement security policies and explore techniques and tools to strengthen your applications against SQL injection attacks. Expand programming resources by creating PL/SQL programs that interface with C and Java code.     Application Developers Database Administrators Basic Knowledge of SQL, PL/SQL Familiarity with programming languages Oracle Database: Develop PL/SQL Program Units Oracle Database: SQL Workshop I Introduction Course Objectives Course Agenda Describe the development environments Identify the tables, data, and tools used in this course PL/SQL Programming Concepts: Review Identify PL/SQL block structure Packages, procedures and functions Cursors Handle exceptions Dependencies Designing PL/SQL Code Describe the predefined data types Create subtypes based on existing types for an application List the different guidelines for cursor design Describe cursor variables White List Overview of Collections Overview of collections Use Associative arrays Navigate using associative methods Use Nested tables Use Varrays Compare nested tables and varrays Using Collections Write PL/SQL programs that use collections Use Collections effectively Enhancements to PL/SQL Type Binds Manipulating Large Objects Working with LOBs Overview of SecureFile LOBs Using Advanced Interface Methods Calling External Procedures from PL/SQL Benefits of External Procedures Understand how an external routine is called from PL/SQL C advanced interface methods Java advanced interface methods Performance and Tuning Understand and influence the compiler Tune PL/SQL code Enable intra unit inlining Identify and tune memory issues Recognize network issues Improving Performance with Caching Describe result caching Use SQL query result cache Use PL/SQL function cache Review PL/SQL function cache considerations Analyzing PL/SQL Code Finding Coding Information PL/Scope Concepts DBMS_METADATA Package PL/SQL Enhancements Profiling and Tracing PL/SQL Code Tracing PL/SQL Execution Tracing PL/SQL: Steps 12:Implementing VPD with Fine-Grained Access Control Understand how fine-grained access control works overall Describe the features of fine-grained access control Describe an application context Create an application context Set an application context List the DBMS_RLS procedures Implement a policy Query the dictionary views holding information on fine-grained access Safeguarding Your Code Against SQL Injection Attacks SQL Injection Overview Reducing the Attack Surface Filtering Input with DBMS_ASSERT Oracle Cloud Overview Introduction to Oracle Cloud & Oracle Cloud Services Cloud Deployment Models Evolving from On-premises to Exadata Express What is in Exadata Express? Exadata Express for Users & Developers Oracle Exadata Express Cloud Service Getting Started with Exadata Express Service Console & Web Access through Service Console

Időtartam:3 nap
Nehézségi szint:
  • Haladó
460 000 Ft-tól
(Bruttó ár: 584 200 Ft-tól)

Oracle Database 12c: Clusterware Administration

Kód: D81246

This Oracle Database 12c: Clusterware Administration training will explore general cluster concepts and Oracle Clusterware architecture. Work with expert Oracle University instructors through interactive instruction and hands-on exercises to reinforce your learning.In this course, you will be introduced to Oracle Database Exadata Cloud Service. Learn To: Perform Grid Infrastructure pre-installation tasks. Install both Standard and Flex clusters. Add and remove nodes from a cluster in addition to upgrading and patching existing Grid Homes. Manage and administer both Standard Clusters and Policy-Managed Clusters. Use Oracle Clusterware to make applications highly available. Gain an understanding of the Oracle Database Exadata Cloud Service. Benefits to You Learn how to make applications highly available using Oracle Clusterware. You'll walk away with the ability to install, configure, manage and troubleshoot both standard and flex clusters. Furthermore, you will have developed the skills to upgrade and patch Clusterware environments. Administrator Database Administrators Working knowledge of Oracle Database 11g: Release 2 on Linux Operating System   Oracle Database 11g: RAC Administration Release 2 Oracle Grid Infrastructure 11g: Manage Clusterware and ASM - Release 2 Working knowledge of Oracle Clusterware, ASM & RAC on Linux Introduction to Grid Infrastructure What is a Cluster? What is a Flex Cluster? Clusterware Characteristics Oracle Clusterware Hardware and Software Concepts (High level) Shared Storage Overview Oracle Clusterware Architecture Cluster Storage Requirements Clusterware Initialization and OHASD Clusterware Process Architecture Location Independent Names, Addresses and Name Resolution (GNS, SCAN, VIP..) Shared GNS Background and Architecture Configuring shared GNS Migrating to shared GNS Moving GNS to Another Cluster Flex Cluster Architecture Flex Cluster Architecture Configuring Flex Cluster Flex Clusters and Node Failure Grid Infrastructure Pre-Installation Tasks Shared Storage for Oracle Clusterware Checking System Requirements Single Client Access Name for the Cluster Redundant Interconnect Usage Kernel Requirements Groups and Users Shell Settings Oracle Validated Configuration Installing Grid Infrastructure Installing Oracle Grid Infrastructure Installing Flex Cluster Verifying the Oracle Clusterware Installation Managing Cluster Nodes Adding Oracle Clusterware Homes Prerequisites for Running addNode.sh Adding a Node with addNode.sh Configuring the node role Removing a Node from the Cluster Traditional Clusterware Management Oracle Clusterware startup and shutdown Administering the Voting Disk file Administering the Oracle Cluster Registry Disk file Network Administration What-If Command Evaluation Clusterware Admin Tools Review Policy-Based Cluster Management Policy-Based Cluster Management Overview Server Categorization Policy Set Patching Grid Infrastructure Out-of-Place Oracle Clusterware Upgrade Types of Patches Obtaining Oracle Clusterware Patches Rolling Patches Installing a Rolling Patchset with OUI OPatch Overview Installing a Rolling Patch with OPatch OPatch Automation Troubleshooting Oracle Clusterware Diagnostic Framework Support for CRS Cluster Health Monitor Enhancements Overview Component level checks - cluvfy with -comp Resource Debugging - Java Tools and Dynamic Debugging Troubleshooting Node Evictions Log files and Diagnostic Collection The oclumon Utility Making Applications Highly Available Overview of Using Oracle Clusterware to Enable HA Oracle Clusterware HA Components Resource Management Options Server Pools Overall flow diagram of HA lifecycle (crs_profile, crs_register, crs_start....) Clusterware Resource Modeling Creating an Application VIP ONS and FAN overviews Oracle Database Exadata Cloud Service Overview Introducing Exadata Cloud Service Service Configuration Options & Service Connection Options Service Architecture & Availability Management Responsibilities Storage Configuration & Management Details Simple Web-Based Provisioning & Management REST APIs Migrating to Exadata Cloud Service  

Időtartam:4 nap
Nehézségi szint:
  • Haladó
460 000 Ft-tól
(Bruttó ár: 584 200 Ft-tól)

Oracle Database 12c: RAC Administration Ed 1

Kód: D81250

This Oracle Database 12c: RAC Administration training will teach you about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion. In this course, you will be introduced to Oracle Database Exadata Cloud Service. Learn To: Install Oracle RAC software. Create cluster databases. Administer both administrator and policy-managed Oracle RAC databases. Monitor and address performance issues. Learn about services in a RAC environment as well as highly available connection features including Application Continuity and Transaction Guard. Create and administer a RAC One Node Database. Create and manage multitennant RAC databases. Gain an understanding of the Oracle Database Exadata Cloud Service. 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. Administrator Database Administrators Oracle Database 12c: Oracle Automatic Storage Management Administration Oracle Database 12c: Grid Infrastructure Administration Working knowledge of Oracle Database 11g: Release 2, including Clusterware, ASM and RAC. or Oracle Database 12c: ASM Administration Oracle Database 12c: Clusterware Administration Grid Infrastructure Overview and Review What is a Cluster? What is a Flex Cluster Clusterware Characteristics Oracle Clusterware Hardware and Software Concepts (High level) RAC Databases Overview & Architecture Overview of Oracle RAC RAC One Node Cluster-Aware Storage Solutions Benefits of Using RAC Scaleup and Speedup I/O Throughput Balanced Global Resources RAC and Flex ASM Installing and Configuring Oracle RAC Installing the Oracle Database Software Installation options Creating the Cluster Database Post-installation Tasks Single Instance to RAC Conversion Cleaning Up Unsuccessful Installs Oracle RAC Administration Parameters and RAC - SPFILE, Identical and Unique Parameters Instance Startup, Shutdown and Quiesce Undo Tablespaces Redo Threads Use Enterprise Manager Cluster Database Pages RAC Alerts RAC Metrics Managing Backup and Recovery for RAC Overview of Upgrades and Patching Release and Patch Set Upgrades PSU, CPU and Interim Patches Merge Patches Performing Out Of Place Database Upgrades Planning and Preparing for Upgrade Performing Out of Place Release Install or Upgrade Post Upgrade Tasks RAC Backup and Recovery Instance Failure And Recovery In RAC - LMON and SMON Redo Threads and Archive Log Configurations and Admin Parameter Settings Affecting Parallel Recovery and MTTR Instance Failure And Recovery In RAC - LMON and SMON RAC and the Fast Recovery Area RMAN Configuration RMAN Admin For RAC: Channels, Instances, Backup Distribution RMAN Restore And Recovery RAC Considerations RAC Global Resource Management and Cache Fusion Globally Managed Resources and Management Library Cache Management Row cache management Buffer cache fusion Buffer Cache Management Requirements Accessing single blocks in RAC Multi-block read considerations in RAC Undo and read consistency considerations in RAC RAC Database Monitoring and Tuning OCPU and Wait Time Latencies Wait Events for RAC Common RAC Tuning Session and System Statistics RAC specific V$ Views Automatic Database Diagnostic Monitor for RAC Managing High Availability of Services in a RAC Environment Oracle Services Services for Policy - and Administrator-Managed Databases Creating Services Managing Services Use Services with Client Applications Services and Connection Load Balancing Services and Transparent Application Failover Services and the Resource Manager Managing High Availability of Connections Types of Workload Distribution Client-Side Load Balancing Server-Side Load Balancing Runtime Connection Load Balancing and Connection Pools Fast Application Notification The Load Balancing Advisory FAN Event Server-Side Callouts Configuring the Server-Side ONS Application Continuity What is AC? What problem does it solve? Benefits of AC How AC works AC Architecture Side Effects Restrictions Application requirements RAC One Node RAC One Node Concepts Online database migration Adding Oracle RAC One Node Database to an Existing Cluster Convert an Oracle RAC One Node database to a RAC database Convert an Oracle RAC database to a RAC One Node database Use DBCA to convert a single instance database to a RAC One Node database Multitenant Architecture and RAC Non-CDB Architecture Multitenant Architecture: Benefits CDB in a Non-RAC Environment Containers Terminology and Data Dictionary Views Connection to a Non-RAC CDB Oracle RAC and Multitenant Configuration Oracle RAC and Multitenant Architecture Quality of Service Management QOS Management concepts Describe the benefits of using QoS Management QoS Management components QoS Management functionality Oracle Database Exadata Cloud Service Overview Introducing Exadata Cloud Service Service Configuration Options & Service Connection Options Service Architecture & Availability Management Responsibilities Storage Configuration & Management Details Simple Web-Based Provisioning & Management REST APIs Migrating to Exadata Cloud Service

Időtartam:4 nap
Nehézségi szint:
  • Haladó
192 000 Ft-tól
(Bruttó ár: 243 840 Ft-tól)

Oracle WebLogic Server 12c: Troubleshooting Workshop

Kód: D83175

This Oracle WebLogic Server 12c: Troubleshooting Workshop training teaches administrators how to diagnose and troubleshoot Oracle WebLogic Server 12c problems and issues. Emphasizing hands-on practices rather than lectures, the course requires prior WebLogic Server 12c administration experience. Learn How To: Diagnose WebLogic Server problems. Enable debugging for a WebLogic Server feature. Troubleshoot common WebLogic Server problems. Benefits to You Knowing how to diagnose and troubleshoot Oracle WebLogic Server issues increases the performance and scalability of your organization’s applications and services. Use Troubleshooting Tools You learn how to use tools to assist in troubleshooting, including the WebLogic Server Administration Console, the Monitoring Dashboard, and the WebLogic Diagnostic Framework. In hands-on practices, you solidify your understanding of new topics by learning how to apply this knowledge to your daily job. Practice Troubleshooting Problems Enrolling in this course gives you a chance to practice troubleshooting problems. You'll use Oracle WebLogic server itself, along with the Java Virtual Machine, deployment of Java Enterprise Edition applications, Java Database Connectivity, Node Manager, WebLogic Server clusters, and WebLogic Server security. Administrator System Administrator Technical Administrator Oracle WebLogic Server 12c: Administration I Basic knowledge of UNIX commands and navigation System administration experience Troubleshooting: Overview Troubleshooting Tools Troubleshooting Methodology WebLogic Server Diagnostic Framework: Overview WLDF: Overview Metric Collectors Review: Monitoring Dashboard Diagnostic Instrumentation Monitors Request Tracking JVM Troubleshooting JVM: Overview JVM Issues JVM Tools Troubleshooting Servers Server Diagnostics Startup Errors Threading Issues Work Managers Stuck Thread Detection Overloaded Server Detection Troubleshooting Applications Java Exceptions Java Stack Traces Library Issues Common Java Errors Application Diagnostics Troubleshooting JDBC JDBC: Review JDBC WLDF Monitoring: Review Common Errors Data Source Availability Troubleshooting Node Manager Node Manager: Review Node Manager Logging Node Manager Monitoring Common Configuration Errors Configuration of Node Manager Credentials Troubleshooting Clusters Cluster Proxy Diagnostics Common Proxy Problems Session Replication Diagnostics Session Monitoring Session Instrumentation Common Replication Issues Troubleshooting Security Security Realm: Review LDAP: Review Security Realm Debug Flags Auditing Provider JP

Időtartam:2 nap
Nehézségi szint:
  • Haladó
575 000 Ft-tól
(Bruttó ár: 730 250 Ft-tól)

Oracle BPM 12c: Essentials Ed 1

Kód: D84807

This Oracle BPM 12c: Essentials Ed 1 training teaches you how to work with business architecture (BA) projects. Expert Oracle University instructors will teach you how to design forms, rules and data definitions. Learn To: Model, implement, play and deploy business processes. Choose either business-friendly Business Process Composer or BPM Studio, the developer's tool of choice. Use integrated Oracle BPM monitoring tools and BA reports. Use Oracle BAM to measure both standard and process-specific business indicators. Navigate Oracle BAM to measure both standard and process-specific business indicators. Raise alerts on abnormal business conditions. Benefits to You By taking this course and learning how to implement Business Process Management, you can enable a more agile, flexible enterprise that can adapt to new business demands and to changes in underlying IT systems. Oracle Business Process Management Suite is a natural complement to Oracle SOA Suite that can help you apply SOA to higher-value business opportunities.   Business Analysts Developers Familiarity with BPM modeling concepts The BPM Life Cycle and the Oracle BPM Suite About Business Process Management Explaining the BPM Life Cycle About the Oracle BPM Suite Discussing Case Study Creating Business Architecture Projects Discussing Business Architecture Describing Business Process Analysis Explaining Goals, Objectives, and Strategies About Enterprise Maps and Value Chain Models Discussing Metrics and Measures: Key Performance Indicators About Process Criticality Reports and Impact Analysis Reports Getting Started with Oracle Business Process Composer Generating and Displaying Reports Modeling a Process Using Oracle Business Process Composer Creating a BPM Project Modeling a BPM Process Saving and Publishing a BPM Project Documenting BPM Projects Discussing End-user and Internal Documentation Using the Graphical View Using the Narrative View Running Process Reports Collaborating on BPM Projects Collaborating Among Business Process Composer Users Collaborating Between Business Process Composer Users and BPM Studio Users Importing and Exporting Projects and Process Models Creating and Using Data Objects How Information Is Handled? Discussing Basic Versus Complex Data Objects Explaining Arguments Describing Data Object Scope, Lifespan, and Access Creating Business Objects and Data Objects Configuring Branching for Exclusive Gateways Validating the ProjectImplementing User Tasks Discussing Human Interaction in a Business Process Explaining Patterns in Human Workflow Implementing User Tasks Creating Web Forms Discussing Form-First Workflow Versus Data-First Workflow Mapping Data Implementing Business Rule Tasks What are Business Rules? Describing Anatomy of a Business Rule About Global Variables Explaing Value Sets Discussing Three Types of Rule Sets Creating Business Rules Mapping Data Between the Process and the Business rule Discussing Best Practices: Enabling Business Users to Customize Rules Implementing Service Tasks About Service Component Architecture Explaining Exposed Services, Components, and External References Implementing Service Tasks Creating a Service or Reference Binding a Service Task to the Service or Reference Mapping Data Playing the Process What Is Process Player? Describing Steps for Using Process Player Mapping Users and Groups to Process Roles Explaining Process Player User Interface Deploying the Process Deploying a Project from Business Process Composer Deploying a Project from BPM Studio Participating in a Running Process Launching and Logging In to Oracle Business Process Workspace Discussing Business Process Workspace Interface Describing Tasks Discussing Case Management Discussing Process Tracking Explaining Standard Dashboards, Custom Dashboards, and Process Monitoring Customizing Business Process Workspace Participating in a Running Process Using Additional BPMN Flow Objects Discussing Non-Interactive Tasks Discussing Interactive Tasks Explaining Gateways Discussing Events Communicating Between Processes What is Synchronous Communication? What is Asynchronous Communication? Explaining Peer Process Communication Describing Types of Subprocesses Handling Exceptions Designing Beyond the "Happy Path" Handling Errors: Options and Tradeoffs Discussing Business Exceptions Versus System Exceptions Creating a Business Exception Specifying the Errors to Catch and Thrown Mapping Error DataAbout Policy-Driven Exception Handling Monitoring the Process Discussing End-to-End Process Analytics About Built-in Metrics Overivew of Process Monitor Explaining Standard BPM Dashboards About Custom Metrics: Counters, Measures, and Dimensions Creating and Using Custom Metrics Discussing Business Process Workspace: Three Types of Dashboards Creating Real-Time Dashboards Using BAM Describing Out-of-the-Box BAM Dashboards About Oracle BAM Composer OEP Integration: Continuous Query Language Building a Simple BAM Dashboard Surfacing KPIs in Business Architecture Reports Linking from an Enterprise Map to a BPM Process Rolling KPIs Up from a BPM Process Model to a Business Architecture Report Generating and Displaying a Process Criticality Report  

Időtartam:5 nap
Nehézségi szint:
  • Haladó
340 000 Ft-tól
(Bruttó ár: 431 800 Ft-tól)

Java SE 8 Programming

Kód: D84838

This Java SE 8 Programming training covers the core language features and Application Programming Interfaces (API) you will use to design object-oriented applications with Java Standard Edition 8 (Java SE 8) Platform. Learn To: Create Java technology applications with the latest JDK Technology Develop your object-oriented skills Identify good practices in the use of the language to create robust Java application Use Lambda expressions in Java applications Store and manipulate data using collections Manipulate files, directories and file systems Connect to databases using standard SQL queries through JDBC Create high-performance multi-threaded applications Benefits to You You can use this course to further develop your skills with the Java language and prepare for the Oracle Certified Professional, Java SE 8 Programmer Exam! Kinek ajánljuk Developer Java Developers Java EE Developers Java SE 8 Fundamentals Java Platform Overview Defining how the Java language achieves platform independence Differentiating between the Java ME, Java SE, and Java EE Platforms Evaluating Java libraries, middle-ware, and database options Defining how the Java language continues to evolve Java Syntax and Class Review Creating simple Java classes Creating primitive variables Using operators Creating and manipulate strings Using if-else and switch statements Iterating with loops: while,do-while,for,enhanced for Creating arrays Using Java fields, constructors, and methods Encapsulation and Subclassing Using encapsulation in Java class design Modeling business problems using Java classes Making classes immutable Creating and use Java subclasses Overloading methods Overriding Methods, Polymorphism, and Static Classes Using access levels: private, protected, default, and public. Overriding methods Using virtual method invocation Using varargs to specify variable arguments Using the instanceof operator to compare object types Using upward and downward casts Modeling business problems by using the static keyword Implementing the singleton design pattern Abstract and Nested Classes Designing general-purpose base classes by using abstract classes Constructing abstract Java classes and subclasses Applying final keyword in Java Distinguish between top-level and nested classes Interfaces and Lambda Expressions Defining a Java interface Choosing between interface inheritance and class inheritance Extending an interface Defaulting methods Anonymous inner classes Defining a Lambda Expression Collections and Generics Creating a custom generic class Using the type inference diamond to create an object Creating a collection by using generics Implementing an ArrayList Implementing a TreeSet Implementing a HashMap Implementing a Deque Ordering collections Collections Streams, and Filters Describing the Builder pattern Iterating through a collection using lambda syntax Describing the Stream interface Filtering a collection using lambda expressions Calling an existing method using a method reference Chaining multiple methods together Defining pipelines in terms of lambdas and collections Lambda Built-in Functional Interfaces Listing the built-in interfaces included in java.util.function Core interfaces - Predicate, Consumer, Function, Supplier Using primitive versions of base interfaces Using binary versions of base interfaces Lambda Operations Extracting data from an object using map Describing the types of stream operations Describing the Optional class Describing lazy processing Sorting a stream Saving results to a collection using the collect method Grouping and partition data using the Collectors class Exceptions and Assertions Defining the purpose of Java exceptions Using the try and throw statements Using the catch, multi-catch, and finally clauses Autoclose resources with a try-with-resources statement Recognizing common exception classes and categories Creating custom exceptions Testing invariants by using assertions Java Date/Time API Creating and manage date-based events Creating and manage time-based events Combining date and time into a single object Working with dates and times across time zones Managing changes resulting from daylight savings Defining and create timestamps, periods and durations Applying formatting to local and zoned dates and times I/O Fundamentals Describing the basics of input and output in Java Read and write data from the console Using streams to read and write files Writing and read objects using serialization File I/O (NIO.2) Using the Path interface to operate on file and directory paths Using the Files class to check, delete, copy, or move a file or directory Using Stream API with NIO2 Concurrency Describing operating system task scheduling Creating worker threads using Runnable and Callable Using an ExecutorService to concurrently execute tasks Identifying potential threading problems Using synchronized and concurrent atomic to manage atomicity Using monitor locks to control the order of thread execution Using the java.util.concurrent collections The Fork-Join Framework Parallelism The need for Fork-Join Work stealing RecursiveTask RecursiveTask Parallel Streams Reviewing the key characteristics of streams Describing how to make a stream pipeline execute in parallel List the key assumptions needed to use a parallel pipeline Defining reduction Describing why reduction requires an associative function Calculating a value using reduce Describing the process for decomposing and then merging work Listing the key performance considerations for parallel streams Database Applications with JDBC Defining the layout of the JDBC API Connecting to a database by using a JDBC driver Submitting queries and get results from the database Specifying JDBC driver information externally Performing CRUD operations using the JDBC API Localization Describing the advantages of localizing an application Defining what a locale represents Read and set the locale by using the Locale object Building a resource bundle for each locale Calling a resource bundle from an application Changing the locale for a resource bundle

Időtartam:5 nap
Nehézségi szint:
  • Haladó
575 000 Ft-tól
(Bruttó ár: 730 250 Ft-tól)

R12.2 Oracle Applications System Administrator Fundamentals

Kód: D87283

In this intensive course, you'll learn the concepts and functions that are critical to the System Administrator role. This includes managing security, managing concurrent processing, monitoring your system using Oracle Applications Manager, SOA and web services for system administration, and other related topics. Learn To: Set up and administer security-related features. Monitor Oracle E-Business Suite activities using OAM. Understand the fundamentals of Oracle Workflow, including its setup. Configure flexfields and understand how they are used by Oracle E-Business Suite. Set up and manage profile options, printers, personalizations, and other features. Describe service-oriented architecture (SOA) and manage service life cycle activities. Benefits to You Better understand how to effectively control security, monitor your system, and handle day-to-day system administrator tasks for Oracle E-Business Suite applications, so that your organization can more rapidly realize the full value of Oracle E-Business Suite. Build a Foundation The System Administrator Fundamentals course gives you the foundation to effectively control security and ensure smooth operations for an E-Business Suite installation. Demonstrations and hands-on activities reinforce the fundamental concepts of configuring an Oracle E-Business Suite, as well as handling day-to-day system administrator tasks. Application Developers Functional Implementer Support Engineer Technical Administrator Oracle E-Business Suite System Administrative Responsibilities System Administrative Responsibilities System Administration Responsibility System Administrator Responsibility Functional Administrator and Functional Developer Responsibility Integrated SOA Gateway Responsibility Oracle E-Business Suite Security Successive Layers of Access Control Function Security Data Security Role Based Access Control (RBAC) Delegated Administration Simplified User Management Function Security Users Custom Applications Menus Responsibilities Functions Data Security Objects Grants Permissions and Permission Sets Data Security Policies Oracle User Management Access Control Model RBAC Delegated Administration Self-Service and Approval features Concurrent Programs and Requests Lifecycle of a Concurrent Request Managing Concurrent Requests Request Sets Viewing Request Output Defining a Custom Concurrent Program Administering Concurrent Managers Generic Service Management (GSM) Concurrent Managers Concurrent Manager Workshifts Conflict Domains Internal Concurrent Managers Internal Monitors Transaction Managers Parallel Concurrent Processing Oracle Applications Manager (OAM) Benefits of Oracle Applications Manager OAM Dashboard OAM Site Map System Monitoring Diagnostic Tools in OAM Support Cart Profile Options Personal Profile Values System Profile Values Profile Hierarchy Levels Profile Categories Oracle Workflow Business Processes System Integration with Oracle Workflow Workflow Architecture Workflow Engine Workflow Builder Notofication System Workflow Manager Directory Services SOA and Web Services SOA in Oracle E-Business Suite Integrated SOA Gateway Generating SOAP Services Deploying SOAP Services Deploying REST Services Searching SOAP Messages Service Invocation Framework (SIF) Purging SOAP Messages, Audits, and Logs Auditing System Resources Auditing User Activity Signon Audit Printers Printer Components Printing with the Pasta printing feature Using Pasta with Oracle XML Publisher Flexfields Key Flexfields Descriptive Flexfields Value Sets Validation of Flexfield Segment Values Personalizations Overview of Personalizations Oracle Forms Personalizations OA Framework Personalizations User Personalizations Personalizations vs. Extensions

Időtartam:5 nap
Nehézségi szint:
  • Haladó
230 000 Ft-tól
(Bruttó ár: 292 100 Ft-tól)

Oracle SOA Suite 12c: New Features and Capabilities Ed 1

Kód: D93509

This Oracle SOA Suite 12c: New Features and Capabilities Ed 1 training teaches you about the new features and capablities of the SOA Suite 12c product release as compared to the SOA Suite 11g product version. Before taking this course, you're expected to have a solid background developing 11g SCA composite applications, especially with using BPEL components; while the SOA Suite 12c product includes a number of diffferent components, the scope of the course is focused on developing SCA composite applications. Learn To: Describe the new features of SOA Suite 12c. Understand how, when and why to use the new features of SOA Suite 12c. Use the new features of SOA Suite 12c to become more productive as a developer. Benefits to You By taking this course, you'll learn to make the most of the new features of Oracle SOA Suite 12c. While the focus is on Oracle SCA application development, you will get chance to explore new wizards and tools available in 12c. You'll get a chance to participate in hands-on exercises to gain real-world experience using new features and new wizards, along with other development tools. Explore REST Bindings and Correlation Sets The training covers new wizards for REST bindings and correlation sets, as well as encypting PII data and creating fault policies. Expert Oracle University instructors will dive into the new SOA debugger, templates, and BPEL subprocesses.    Kinek ajánljuk Application Developers Developer Java Developers SOA Architect Experience using JDeveloper Oracle SOA Suite 11g Design and Development Experience XML Programming Experience Oracle SOA Suite 11g: Administration SOA Adoption and Architecture Fundamentals Overview Understanding the four themes of the 12c release Reviewing all of the changes and upgraded capabilities for developing SCA composite applications Becoming familiar with the scope of this course Quick Start for Developers Understanding and running the new Quick Start installer Starting the new JDeveloper 12c IDE Becoming familiar with Quick Start domain configuration options Installing both the Integrated WebLogic Server domain as well as the Stand-Alone domain Creating a new Application Server connection in JDeveloper Getting Familiar with 12c Describing the new features of the Enterprise Manager Fusion Middleware Control Understanding the new Error Hospital Becoming familiar with the new security features of SOA partitions Understanding Work Manager groups for SOA partitions Managing Global Token variables for mulitiple SOA composite applications Migrating SOA 11g composites to 12c JDeveloper Changes Locating components in the Application Navigator project folders Viewing the detailed structure of the composite in the Structure window Configuring the Component Palette list and Icon views Creating TODO tasks to help organize development and design work Refactoring and renaming components and artifacts Managing shared design-time artifacts using the new file-based MDS Repository Exploring component and artifact dependencies with the new Dependency Explorer Testing and Debugging Debugging SOA composite applications with the new SOA debugger Setting breakpoints and launching the SOA debugger Creating test suites and test cases with the new Test Suite wizard in JDeveloper Running test suites and viewing results from within JDeveloper Viewing and modifying variable values within a debug session Specifying activity assertions within a BPEL process BPEL Editor New Features Editing BPEL activities in the Properties window Using the new Correlation wizard to create BPEL correlation sets Exploring additional capablities within the toolbar and BPEL designer settings Understanding the new Oracle Enterprise Scheduler Service (OESS) Adding an OESS Job Activity to a BPEL process Transformations Translating native format data within a Mediator routing rule Translating native format data using the new BPEL Translate activity Creating an nXSD schema using the Native Format Builder Using XQuery transformation mapping within a Mediator routing rule Creating XQuery transformations using the new BPEL XQuery Transform activity Protecting PII Data Encrypting and decrypting specific fields of messages within SCA composite applications Creating a Credential Store Framework (CSF) key Adding the policy credential to the WebLogic domain Fault Policy and Encryption/Decryption Reviewing the capabilities of the Fault Management Framework Creating a Fault Policy document with the new Fault Policy wizard Defining and configuring fault policy alerts Specifying Fault bindings with the new Fault Policy wizard Accessing a recoverable fault in the Fusion Middleware Control REST Binding Wizard Reviewing and understanding the format of REST services Comparing REST and SOAP Exposing SOA composite applications as RESTful services Adding a reference binding to a remote RESTful service Generating REST mapping XML schemas Using the REST binding wizard New Adapters & MFT Leveraging use cases involving the Managed File Transfer (MFT) adapter for transferring files Understanding the features of the new LDAP adapter Becoming familiar with Coherence and the new Coherence adapter Understanding the SOA Suite Cloud Adapter SDK and the Salesforce Cloud Adapter Templates & Subprocesses Creating and using SOA composite templates Creating and using component templates Creating and using BPEL scope activity templates Creating and using BPEL inline subprocesses Creating and using BPEL stand-alone subprocesses Managing templates Additional Enhancements Understanding additional Event Delivery Network (EDN) features Become familiar with BPEL business indicators and new built-in process analytics Editing custom business indicators for BPEL processes Configuring analytic sampling points for SOA composites and components Becoming familiar with the new out-of-the-box BAM dashboards for monitoring BPEL processes Appendix A: Oracle Enterprise Scheduler Service Describing the basic features and capabilities of OESS Installing the OESS product Configuring OESS jobs and related metadata Administering running and completed OESS jobs Creating Job Sets and Schedules

Időtartam:2 nap
Nehézségi szint:
  • Haladó

Oracle on demand

Kód: ORACLEONDEMAND

Tanuljon angol nyelven az Oracle University legjobb oktatóitól rugalmasan: bárhol és amikor az Ön ideje engedi. Nincs előre meghatározott tantermi időponthoz kötve, távolról saját számítógépén keresztül szerezheti be a hasznos tudást. Miért érdemes ezt a képzési formát választani? Biztosan induló tanfolyamok! A tantermi képzésekkel ellentétben itt nem kell arra várni, hogy egy tanfolyamra legyen elég jelentkező és biztosan elinduljon. A megrendelést követő napokban már meg is kezdheti a tanulást!  Önnek megfelelő időpontban induló tanfolyamok Könnyen a munkájához tudja igazítani a továbbképzést, így nem kell azzal sakkozni, mikor tud elszabadulni a feszített tempó közben. Nem kell más hallgatókhoz alkalmazkodni Saját tempójában tanulhat. Ön dönti el, mire szeretne több időt szánni a saját szintjének és előképzettségének megfelelően. Széles tanfolyami választék Szinte az összes Oracle képzést megtalálja ebben a képzési formában is. Részletesen az Oracle University oldalán tájékozódhat. Részletes, online elérhető információk Már a képzés kiválasztását is rengeteg online elérhető angol nyelvű információ segíti: bemutató videók, és részletes tematika, szükséges előképzettség meghatározások. Ezek mellett digitális tananyag jár a hallgatónak a képzés megrendelését követően. Beszámít az Oracle minősítések rendszerébe Minden Oracle on demand tanfolyam teljes értékű, hivatalos, minősített Oracele képzésnek számít. A látogatási igazolást a tanfolyam elvégzése után letöltheti az online felületről. 

Tanfolyami naptár