60 Oracle 1Z0-819 courses

Duration 2 Days 12 CPD hours This course is intended for This basic course is for everyone needing to write, support, or understand SQL queries. This includes but is not limited to end-users, programmers, application designers, database administrators, and system administrators who do not yet have knowledge of Overview Code SQL statements to retrieve data from a DB2 or Informix table, including the SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses Code inner joins and non-correlated subqueries Use SQL arithmetic operations Use scalar and column functions Use UNION and UNION ALL INSERT, UPDATE and DELETE rows Code simple CREATE TABLE and CREATE VIEW statements This course is appropriate for customers working in all DB2 environments, that is, z/OS, VM/VSE, iSeries, Linux, UNIX, and Windows. It is also appropriate for customers working in an Informix environment. OUTLINE * Introduction Simple SQL Queries Retrieving Data from Multiple Tables Scalar Functions and Arithmetic Column Functions and Grouping UNION and UNION ALL Using Subqueries Maintaining data

Duration 3 Days 18 CPD hours This course is intended for This is an introductory level SQL course, appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators. Overview Working in a hands on learning environment led by our expert practitioner, attendees will explore: Basic RDBMS Principles The SQL Language and Tools Using SQL Developer SQL Query Basics WHERE and ORDER BY Functions ANSI 92 Joins ANSI 99 Joins Subqueries Regular Expressions Analytics A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. A full presentation of the basics of relational databases and their use are also covered. BASIC RDBMS PRINCIPLES * Relational design principles * Accessing data through a structured query language * Entity relationship diagrams * Data Domains * Null values * Indexes * Views * Denormalization * Data Model Review THE SQL LANGUAGE AND TOOLS * Using SQL*Plus * Why Use SQL*Plus When * Other Tools Are Available? * Starting SQL*Plus * EZConnect * SQL Commands * PL/SQL Commands * SQL*Plus Commands * The COLUMN Command * The HEADING Clause * The FORMAT Clause * The NOPRINT Clause * The NULL Clause * The CLEAR Clause * Predefined define variables * LOGIN.SQL * Command history * Copy and paste in SQL*Plus * Entering SQL commands * Entering PL/SQL commands * Entering SQL*Plus commands * Default output from SQL*Plus * Entering Queries * What about PL/SQL? USING SQL DEVELOPER * Choosing a SQL Developer version * Configuring connections * Creating A Basic Connection * Creating A TNS Connection * Connecting * Configuring preferences * Using SQL Developer * The Columns Tab * The Data Tab * The Constraints Tab * The Grants Tab * The Statistics Tab * Other Tabs * Queries In SQL Developer * Query Builder * Accessing Objects Owned By Other Users * The Actions Pulldown Menu * Differences between SQL Developer and SQL*Plus * Reporting Commands Missing In SQL Developer * General Commands Missing In SQL Developer * Data Dictionary report * User Defined reports * Using scripts in SQL Developer WHERE AND ORDER BY * WHERE clause basics * Comparison operators * Literals and Constants in SQL * Simple pattern matching * Logical operations * The DUAL table * Arithmetic operations * Expressions in SQL * Character operators * Pseudo columns * Order by clause basics * Ordering Nulls * Accent and case sensitive sorts * Sampling data * WHERE and ORDER BY in SQL Developer * All, Any, Some FUNCTIONS * The basics of Oracle functions * Number functions * Character functions * Date functions * Conversion functions * Other functions * Large object functions * Error functions * The RR format mode; * Leveraging your knowledge ANSI 92 JOINS * Basics of ANSI 92 Joins * Using Query Builder with multiple tables * Table Aliases * Outer joins * Outer Joins In Query Builder * Set operators * Self-referential joins * Non-Equijoins ANSI 99 JOINS * Changes with ANSI99 * CROSS Join * NATURAL Join * JOIN USING * JOIN ON * LEFT / RIGHT OUTER JOIN * FULL OUTER JOIN SUBQUERIES * Why use subqueries? * WHERE clause subqueries * FROM clause subqueries * HAVING clause subqueries * CORRELATED subqueries * SCALAR subqueries * DML and subqueries * EXISTS subqueries * Hierarchical queries * TOP N AND BOTTOM N queries * Creating subqueries using Query Builder REGULAR EXPRESSIONS * Available Regular Expressions * Regular Expression Operators * Character Classes * Pattern matching options * REGEX_LIKE * REGEXP_SUBSTR * REGEXP_INSTR * REGEXP_REPLACE * REGEXP_COUNT ANALYTICS * The WITH clause Reporting aggregate functions Analytical functions User-Defined bucket histograms The MODEL clause PIVOT and UNPIVOT Temporal validity MORE ANALYTICS * RANKING functions * RANK * DENSE_RANK * CUME_DIST * PERCENT_RANK * ROW_NUMBER * Windowing aggregate functions * RATIO_TO_REPORT * LAG / LEAD * Linear Regression functions * Inverse Percentile functions * Hypothetical ranking functions * Pattern Matching ADDITIONAL COURSE DETAILS: Nexus Humans Introduction to SQL Programming Basics (TTSQL002) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Introduction to SQL Programming Basics (TTSQL002) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for individuals who are Application designers and database developers, database administrators and web server administrators. Overview Upon successful completion of this course, students will be able to work with Oracle database programming using the PL/SQL programming language. They will learn the syntax, structure and features of the language. In this course, students will learn the foundation for the programming series and the use of database-resident stored program units for Oracle 12c. SELECTION & SETUP OF THE DATABASE INTERFACE * Considering Available Tools * Selecting the Appropriate Tool * Oracle Net Database Connections * Oracle PAAS Database Connections * Setup SQL Developer * Setup SQL*Plus * Setup Jdeveloper ABOUT BIND & SUBSTITUTION VARIABLES * Using SQL Developer * Using SQL*Plus CHOOSING A DATABASE PROGRAMMING LANGUAGE * What is Database Programming? * PL?SQL Performance Advantages * Integration wth Other Languages PL/SQL LANGUAGE FUNDAMENTALS * PL/SQL Program Structure * LANGUAGE SYNTAX RULES * EMBEDDING SQL * WRITING READABLE CODE * GENERATING DATABASE OUTPUT * SQL*PLUS INPUT OF A PROGRAM BLOCK DECLARE SECTION * About the Declare Section * DECLARE PRIMITIVE TYPES * DECLARATION OPTIONS * NOT NULL * CONSTANT * DATA DICTIONARY INTEGRATION * %TYPE * DECLARE SIMPLE USER---DEFINED TYPES * TYPE... TABLE * TYPE... RECORD * EXTENDED USER---DEFINED TYPES BEGIN SECTION * About the Begin Section * Manipulating Program Data * Logic Control & Branching * GOTO * LOOP * IF-THEN-ELSE * CASE EXCEPTION SECTION * ABOUT THE EXCEPTION SECTION * ISOLATING THE SPECIFIC EXCEPTION * PRAGMA EXCEPTION_INIT * SQLCODE &SQLERRM Example * SQL%ROWCOUNT &SELECT...INTO BEYOND THE BASICS: EXPLICIT CURSORS * ABOUT EXPLICIT CURSORS * EXTENDED CURSOR TECHNIQUES * FOR UPDATE OF Clause * WHERE CURRENT OF Clause * Using FOR?LOOP Cursors BEYOND THE BASICS: NESTED BLOCKS BEYOND THE BASICS: DECLARED SUBPROGRAMS * USING DECLARED SUBPROGRAMS * DECLARED PROCEDURE * DECLARED FUNCTION INTRODUCING DATABSE-RESIDENT PROGRAM UNITS * ABOUT DATABASE---RESIDENT PROGRAMS * PHYSICAL STORAGE & EXECUTION * TYPES OF STORED PROGRAM UNITS * STORED PROGRAM UNIT ADVANTAGES * MODULAR DESIGN PRINCIPLES CREATING STORED PROCEDURES & FUNCTIONS * STORED PROCEDURES & FUNCTIONS * CREATE PROCEDURE / CREATE FUNCTION * CREATING PROCEDURES & FUNCTIONS * RAISE_SALARY() Procedure * SALARY_VALID() Function * THE PARAMETER SPECIFICATION * DEFAULT Clause * SYSTEM & OBJECT PRIVILEGES * USING THE DEVELOPMENT TOOLS EXECUTING STORED PROCEDURES & FUNCTIONS * CALLING PROCEDURES & FUNCTIONS * UNIT TESTING WITH EXECUTE * ANONYMOUS BLOCK UNIT TESTING * SPECIFYING A PARAMETER NOTATION * SQL WORKSHEET UNIT TESTING * CALLING FUNCTIONS FROM SQL MAINTAINING STORED PROGRAM UNITS * RECOMPILING PROGRAMS * Mass Recompilation Using UTL_RECOMP() * DROPPING PROCEDURES & FUNCTIONS * DROP PROCEDURE / FUNCTION * DATA DICTIONARY METADATA * Using USER_OBJECTS * Using USER_SOURCE * Using USER_ERRORS * Using USER_OBJECT_SIZE * Using USER_DEPENDENCIES MANAGING DEPENDENCIES * DEPENDENCY INTERNALS * TRACKING DEPENDENCIES * THE DEPENDENCY TRACKING UTILITY * SQL DEVELOPER DEPENDENCY INFO * DEPENDENCY STRATEGY CHECKLISTS CREATING & MAINTAINING PACKAGES * ABOUT PACKAGES * CREATING PACKAGES * MAINTAINING PACKAGES * PERFORMANCE CONSIDERATIONS ADVANCED PACKAGE CAPABILITIES * DEFINER & INVOKER RIGHTS * WHITE LITS & ACCESSIBLE BY * PERSISTENT GLOBAL OBJECTS * DEFINING INITIALIZATION LOGIC * OBJECT ORIENTATION SUPPORT ADVANCED CURSOR TECHNIQUES * USING CUSROS VARIABLES * USING SYS_REFCURSOR * USING CURSOR EXPRESSIONS USING SYSTEM-SUPPLIED PACKAGE * DBMS_OUTPUT() * UTL_FILE() * FOPEN() EXAMPLE DATABASE TRIGGER CONCEPTS * ABOUT DATABASE TRIGGERS * DML EVENT TRIGGER SUB---TYPES * DATABASE TRIGGER SCENARIO * TRIGGER EXECUTION MECHANISMS * TRIGGERS WITHIN SQL WORKSHEET CREATING DATABASE TRIGGERS * STATEMENT-LEVEL TRIGGERS * Using RAISE_APPLICATION_ERROR() * ROW---LEVEL TRIGGERS * EXAMPLES OF TRIGGERS * EMPLOYEE_SALARY_CHECK Example * EMPLOYEE_JOURNAL Example * BUDGET_EVENT Example * INSTEAD OF TRIGGERS * TRIGGERS WITHIN AN APPLICATION MAINTAINING DATABASE TRIGGERS * CALL SYNTAX * TRIGGER MAINTENANCE TASKS * SHOW ERRORS TRIGGER * DROP TRIGGER * ALTER TRIGGER * MULTIPLE TRIGGERS FOR A TABLE * HANDLING MUTATING TABLE ISSUES IMPLEMENTING SYSTEM EVENT TRIGGERS * WHAT ARE SYSTEM EVENT TRIGGERS? * DEFININGTHE SCOPE * AVAILABLE SYSTEM EVENTS * SYSTEM EVENT ATTRIBUTES ADDITIONAL COURSE DETAILS: Nexus Humans Oracle 12c PL/SQL Fundamentals training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Oracle 12c PL/SQL Fundamentals course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for individuals who are Application designers and database developers, database administrators and web server administrators. Overview Upon successful completion of this course, students will be able to work with Oracle database programming using the PL/SQL programming language. They will learn the syntax, structure and features of the language. In this course, students will learn the foundation for the programming series and the use of database-resident stored program units for Oracle 12c. SELECTION & SETUP OF THE DATABASE INTERFACE * Considering Available Tools * Selecting the Appropriate Tool * Oracle Net Database Connections * Oracle PAAS Database Connections * Setup SQL Developer * Setup SQL*Plus * Setup Jdeveloper ABOUT BIND & SUBSTITUTION VARIABLES * Using SQL Developer * Using SQL*Plus CHOOSING A DATABASE PROGRAMMING LANGUAGE * What is Database Programming? * PL?SQL Performance Advantages * Integration wth Other Languages PL/SQL LANGUAGE FUNDAMENTALS * PL/SQL Program Structure * LANGUAGE SYNTAX RULES * EMBEDDING SQL * WRITING READABLE CODE * GENERATING DATABASE OUTPUT * SQL*PLUS INPUT OF A PROGRAM BLOCK DECLARE SECTION * About the Declare Section * DECLARE PRIMITIVE TYPES * DECLARATION OPTIONS * NOT NULL * CONSTANT * DATA DICTIONARY INTEGRATION * %TYPE * DECLARE SIMPLE USER---DEFINED TYPES * TYPE... TABLE * TYPE... RECORD * EXTENDED USER---DEFINED TYPES BEGIN SECTION * About the Begin Section * Manipulating Program Data * Logic Control & Branching * GOTO * LOOP * IF-THEN-ELSE * CASE EXCEPTION SECTION * ABOUT THE EXCEPTION SECTION * ISOLATING THE SPECIFIC EXCEPTION * PRAGMA EXCEPTION_INIT * SQLCODE &SQLERRM Example * SQL%ROWCOUNT &SELECT...INTO BEYOND THE BASICS: EXPLICIT CURSORS * ABOUT EXPLICIT CURSORS * EXTENDED CURSOR TECHNIQUES * FOR UPDATE OF Clause * WHERE CURRENT OF Clause * Using FOR?LOOP Cursors BEYOND THE BASICS: NESTED BLOCKS BEYOND THE BASICS: DECLARED SUBPROGRAMS * USING DECLARED SUBPROGRAMS * DECLARED PROCEDURE * DECLARED FUNCTION INTRODUCING DATABSE-RESIDENT PROGRAM UNITS * ABOUT DATABASE---RESIDENT PROGRAMS * PHYSICAL STORAGE & EXECUTION * TYPES OF STORED PROGRAM UNITS * STORED PROGRAM UNIT ADVANTAGES * MODULAR DESIGN PRINCIPLES CREATING STORED PROCEDURES & FUNCTIONS * STORED PROCEDURES & FUNCTIONS * CREATE PROCEDURE / CREATE FUNCTION * CREATING PROCEDURES & FUNCTIONS * RAISE_SALARY() Procedure * SALARY_VALID() Function * THE PARAMETER SPECIFICATION * DEFAULT Clause * SYSTEM & OBJECT PRIVILEGES * USING THE DEVELOPMENT TOOLS EXECUTING STORED PROCEDURES & FUNCTIONS * CALLING PROCEDURES & FUNCTIONS * UNIT TESTING WITH EXECUTE * ANONYMOUS BLOCK UNIT TESTING * SPECIFYING A PARAMETER NOTATION * SQL WORKSHEET UNIT TESTING * CALLING FUNCTIONS FROM SQL MAINTAINING STORED PROGRAM UNITS * RECOMPILING PROGRAMS * Mass Recompilation Using UTL_RECOMP() * DROPPING PROCEDURES & FUNCTIONS * DROP PROCEDURE / FUNCTION * DATA DICTIONARY METADATA * Using USER_OBJECTS * Using USER_SOURCE * Using USER_ERRORS * Using USER_OBJECT_SIZE * Using USER_DEPENDENCIES MANAGING DEPENDENCIES * DEPENDENCY INTERNALS * TRACKING DEPENDENCIES * THE DEPENDENCY TRACKING UTILITY * SQL DEVELOPER DEPENDENCY INFO * DEPENDENCY STRATEGY CHECKLISTS CREATING & MAINTAINING PACKAGES * ABOUT PACKAGES * CREATING PACKAGES * MAINTAINING PACKAGES * PERFORMANCE CONSIDERATIONS ADVANCED PACKAGE CAPABILITIES * DEFINER & INVOKER RIGHTS * WHITE LITS & ACCESSIBLE BY * PERSISTENT GLOBAL OBJECTS * DEFINING INITIALIZATION LOGIC * OBJECT ORIENTATION SUPPORT ADVANCED CURSOR TECHNIQUES * USING CUSROS VARIABLES * USING SYS_REFCURSOR * USING CURSOR EXPRESSIONS USING SYSTEM-SUPPLIED PACKAGE * DBMS_OUTPUT() * UTL_FILE() * FOPEN() EXAMPLE DATABASE TRIGGER CONCEPTS * ABOUT DATABASE TRIGGERS * DML EVENT TRIGGER SUB---TYPES * DATABASE TRIGGER SCENARIO * TRIGGER EXECUTION MECHANISMS * TRIGGERS WITHIN SQL WORKSHEET CREATING DATABASE TRIGGERS * STATEMENT-LEVEL TRIGGERS * Using RAISE_APPLICATION_ERROR() * ROW---LEVEL TRIGGERS * EXAMPLES OF TRIGGERS * EMPLOYEE_SALARY_CHECK Example * EMPLOYEE_JOURNAL Example * BUDGET_EVENT Example * INSTEAD OF TRIGGERS * TRIGGERS WITHIN AN APPLICATION MAINTAINING DATABASE TRIGGERS * CALL SYNTAX * TRIGGER MAINTENANCE TASKS * SHOW ERRORS TRIGGER * DROP TRIGGER * ALTER TRIGGER * MULTIPLE TRIGGERS FOR A TABLE * HANDLING MUTATING TABLE ISSUES IMPLEMENTING SYSTEM EVENT TRIGGERS * WHAT ARE SYSTEM EVENT TRIGGERS? * DEFININGTHE SCOPE * AVAILABLE SYSTEM EVENTS * SYSTEM EVENT ATTRIBUTES

Duration 2 Days 12 CPD hours This course is intended for Application Developers Business Analysts Developer End Users Functional Implementer Java Developer System Analysts Technical Administrator Overview Create administrator-level personalizations Personalize configurable pages Utilize advanced personalization features Implement flexfields on OA Framework-based pages Create custom look and feel definitions Create user-level personalizations This course will be applicable for customers who have implemented Oracle E-Business Suite Release 12 or Oracle E-Business Suite 12.1. This course will be applicable for customers who have implemented Oracle E-Business Suite Release 12 or Oracle E-Business Suite 12.1.

Duration 5 Days 30 CPD hours This course is intended for Administrator Architect Database Administrator Overview To provide an acceptable response time to users and manage resources effectively, you learn how to monitor performance and manage resources within the multitenant container database and its pluggable databases, and within each pluggable database. Another important aspect is the data movement between non-CDBs and pluggable databases, and between pluggable databases. It is also important to understand the procedures of upgrading an Oracle Database multitenant container database or an Oracle Database pluggable database. Finally, students discover the way multitenant container database and pluggable databases are created and monitored in the Cloud. This course covers all aspects of the multitenant architecture, providing detailed information on the components of an Oracle multitenant container database and its regular and application pluggable databases. You learn why and how to create and manage a multitenant container database and its regular and application pluggable databases, with storage structures appropriate for the business applications. You practice cold and hot cloning, plugging unplugged pluggable databases in multitenant container databases using various methods. CDB BASICS CDB AND REGULAR PDBS APPLICATION PDBS AND APPLICATION INSTALLATION PDB CREATION CDB AND PDB MANAGEMENT STORAGE SECURITY BACKUP AND DUPLICATE RECOVERY AND FLASHBACK PERFORMANCE MONITORING RESOURCES ALLOCATION DATA MOVEMENT UPGRADE METHODS

Duration 3 Days 18 CPD hours This course is intended for This intermediate-level hands-on course is geared for experienced Administrators, Analysts, Architects, Data Scientists, Database Administrators and Implementers Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our Oracle Certified expert facilitator, students will learn how to: Administer ODI resources and setup security with ODI Apply ODI Topology concepts for data integration Describe ODI Model concepts Describe architecture of Oracle Data Integrator Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations Explore, audit data, and enforce data quality with ODI Implement Changed Data Capture with ODI Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements from high-volume, high-performance batch loads, to event-driven integration processes and SOA-enabled data services. Oracle Data Integrator's Extract, Load, Transform (E-LT) architecture leverages disparate RDBMS engines to process and transform the data - the approach that optimizes performance, scalability and lowers overall solution costs. Throughout this course participants will explore how to centralize data across databases, performing integration, designing ODI Mappings, and setting up ODI security. In addition, Oracle Data Integrator can interact with the various tools of the Hadoop ecosystem, allowing administrators and data scientists to farm out map-reduce operations from established relational databases to Hadoop. They can also read back into the relational world the results of complex Big Data analysis for further processing. Working in a hands-on learning environment led by our Oracle Certified expert facilitator, students will learn how to: Administer ODI resources and setup security with ODI Apply ODI Topology concepts for data integration Describe ODI Model concepts Describe architecture of Oracle Data Integrator Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations Explore, audit data, and enforce data quality with ODI Implement Changed Data Capture with ODI INTRODUCTION TO INTEGRATION AND ADMINISTRATION * Oracle Data Integrator: Introduction * Oracle Data Integrator Repositories ADMINISTERING ODI REPOSITORIES * Create and connect to the Master Repository * Export and import the Master Repository * Create, connect, and set a password to the Work Repository ODI TOPOLOGY CONCEPTS * ODI Topology: Overview * Data Servers and Physical Schemas * Defining Topology * Agents in Topology * Planning a Topology DESCRIBING THE PHYSICAL AND LOGICAL ARCHITECTURE * Topology Navigator * Creating Physical Architecture * Creating Logical Architecture SETTING UP A NEW ODI PROJECT * ODI Projects * Using Folders * Understanding Knowledge Modules * Exporting and Importing Objects * Using Markers ORACLE DATA INTEGRATOR MODEL CONCEPTS * Understanding the Relational Model * Understanding Reverse-Engineering * Creating Models ORGANIZING ODI MODELS AND CREATING ODI DATASTORES * Organizing Models * Creating Datastores * Constraints in ODI * Creating Keys and References * Creating Conditions * Exploring Your Data * Constructing Business Rules ODI MAPPING CONCEPTS * ODI Mappings * Expressions, Join, Filter, Lookup, Sets, and Others * Behind the Rules * Staging Area and Execution Location * Understanding Knowledge Modules * Mappings: Overview DESIGNING MAPPINGS * Multiple Sources and Joins * Filtering Data * Overview of the Flow in ODI Mapping * Selecting a Staging Area * Configuring Expressions * Execution Location * Selecting a Knowledge Module MAPPINGS: MONITORING AND TROUBLESHOOTING * Monitoring Mappings * Working with Errors DESIGNING MAPPINGS: ADVANCED TOPICS 1 * Working with Business Rules * Using Variables * Datasets and Sets * Using Sequences DESIGNING MAPPINGS: ADVANCED TOPICS 2 * Partitioning * Configuring Reusable Mappings * Using User Functions * Substitution Methods * Modifying Knowledge Modules USING ODI PROCEDURES * Procedures: Overview * Creating a Blank Procedure * Adding Commands * Adding Options * Running a Procedure USING ODI PACKAGES * Packages: Overview * Executing a Package * Review of Package Steps * Model, Submodel, and Datastore Steps * Variable Steps * Controlling the Execution Path STEP-BY-STEP DEBUGGER * Starting a Debug Session * New Functions * Menu Bar Icons MANAGING ODI SCENARIOS * Scenarios * Managing Scenarios * Preparing for Deployment USING LOAD PLANS * What are load plans? * Load plan editor * Load plan step sequence * Defining restart behavior ENFORCING DATA QUALITY WITH ODI * Data Quality * Business Rules for Data Quality * Enforcing Data Quality with ODI WORKING WITH CHANGED DATA CAPTURE * CDC with ODI * CDC implementations with ODI * CDC implementation techniques * Journalizing * Results of CDC ADVANCED ODI ADMINISTRATION * Setting Up ODI Security * Managing ODI Reports * ODI Integration with Java

Duration 5 Days 30 CPD hours This course is intended for Data Warehouse Administrator Database Administrators Database Designers Support Engineer Technical Administrator Overview Back up, restore, and patch DBCS database deployments Describe the DBaaS and on-premises Oracle Database architectures Manage database instances Manage UNDO data Move data between databases Implement basic backup and recovery procedures Monitor and tune database performance Tune SQL to improve performance Manage resources with Oracle Database Resource Manager Create pluggable databases (PDBs) Configure the Oracle network environment Administer user security and implement auditing Create and manage tablespaces Manage storage space Create and manage Database as a Cloud Service (DBCS) database deployments Register databases and manage performance with Enterprise Manager Cloud Control The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide students with a firm foundation in administration of an Oracle Database. In this course students will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner. EXPLORING ORACLE DATABASE ARCHITECTURE * Introducing Oracle Database * Relation Database Models * Oracle SQL and PL/SQL * Oracle Database Server Architecture * Connecting to Oracle Databases * Oracle Database Tools * Oracle-Supplied User Accounts * Querying the Oracle Data Dictionary MANAGING DATABASE INSTANCES * Initialization Parameter Files * Starting Up Oracle Databases * Shutting Down Oracle Databases * Opening and Closing PDBs * Working with the Automatic Diagnostic Repository (ADR) * Querying Dynamic Performance Views CREATING PDBS * Methods and Tools to Create PDBs * Creating PDBs from Seed with SQL*Plus * Cloning PDBs with SQL*Plus * Unplugging and Pluggin In PDBs with SQL*Plus * Dropping PDBs with SQL*Plus CONFIGURING THE ORACLE NETWORK ENVIRONMENT * Oracle Net Services * How Listeners Work * Configuring Listeners for Dynamic Service Registration * Configuring Listeners for Static Service Registration * Configuring Local Naming for Connections * Testing Oracle Net Connectivity with tnsping * Configuring Communication Between Databases * Dedicated Versus Shared Server Configurations ADMINISTERING USER SECURITY * Creating Users * Granting Privileges * Creating and Granting Roles * Revoking Privileges and Roles * Creating and Assigning Profiles * Authenticating Users * Assigning Quotas to Users * Applying the Principal of Least Privilege CREATING AND MANAGING TABLESPACES * How Table Data is Stored * Creating Tablespaces in SQL*Plus * Altering and Dropping Tablespaces in SQL*Plus * Viewing Tablespace Information in SQL*Plus * Implementing Oracle Managed Files * Moving and Renaming Online Data Files in SQL*Plus MANAGING STORAGE SPACE * Oracle Database Space Management Features * Block Space Management * Row Chaining and Migration * Free Space Management Within Segments * Types of Segments * Allocating Extents * Understanding Deferred Segment Creation * Space-Saving Features MANAGING UNDO DATA * Undo Data: Overview * Transactions and Undo Data * Storing Undo Information * Comparing Undo Data and Redo Data * Managing Undo * Local Undo Mode Versus Shared Undo Mode * Configuring Undo Retention * Categories of Undo MOVING DATA * Moving Data: General Architecture * Oracle Data Pump: Overview * Oracle Data Pump: Benefits * Data Pump Export and Import Clients * Data Pump Utility: Interfaces and Modes * Data Pump Import: Transformations * SQL*Loader Overview * Loading Methods BACKUP AND RECOVERY CONCEPTS * DBA Responsibilities * Categories of Failure * Understanding Instance Recovery * Understanding Types of Backups * Comparing Complete and Incomplete Recovery * Oracle Data Protection Solutions * Flashback Technology MONITORING AND TUNING DATABASE PERFORMANCE * Managing Performance Activities * Performance Planning Considerations * Database Maintenance * Automatic Workload Repository (AWR) * Automatic Database Diagnostic Monitor * Performance Monitoring * Performance Tuning Methodology * Database Server Statistics and Metrics SQL TUNING * SQL Tuning Process * Oracle Optimizer * Optimizer Statistics * SQL Plan Directives * Adaptive Execution Plans * SQL Tuning Advisor * SQL Access Advisor * SQL Performance Analyzer ORACLE DATABASE RESOURCE MANAGER * Oracle Database Resource Manager: Overview * Resource Manager Elements * Using Resource Manager to Allocate Resources * Creating a Simple Resource Plan * Creating a Complex Resource Plan * Using the Active Session Pool Feature * Limiting CPU Utilization at the Database Level * Limiting CPU Utilization at the Server Level ENTERPRISE MANAGER CLOUD CONTROL * Controlling the Enterprise Manager Cloud Control Framework * Starting the Enterprise Manager Cloud Control Framework * Stopping the Enterprise Manager Cloud Control Framework INTRODUCTION TO ORACLE DATABASE CLOUD SERVICE * Oracle Cloud: Overview * Database Cloud Service Offerings * DBCS Architecture * Features and Tooling * Additional Database Configuration Options CREATING DBCS DATABASE DEPLOYMENTS * Automated Database Provisioning * Creating a Database Deployment * How SSH Key Pairs are Used * Creating an SSH Key Pair * Storage Used for Database Files MANAGING DBCS DATABASE DEPLOYMENTS * Cloud Tooling * Accessing Tools and Features from the DBCS Console * Managing the Compute Node Associated With a Database Deployment * Managing Network Access to DBCS * Enabling Access to a Compute Node Port * Scaling a Database Deployment BACKING UP AND RESTORING DBCS DATABASE DEPLOYMENTS * Backing Up and Recovering Databases on DBCS * Backup Destination Choices * Backup Configuration * Creating an On-Demand Backup * Customizing the Backup Configuration * Performing Recovery by Using the Console * Performing Recovery by Using the dbaascli Utility PATCHING DBCS DATABASE DEPLOYMENTS * Patching DBCS * Using the DBCS Console to Manage Patches * Using the dbaascli Utility to Manage Patches CREATING MASTER ENCRYPTION KEYS FOR PDBS * CDB and PDB Master Encryption Keys * Determining Whether You Need to Create and Activate and Encryption Key for a PDB * Creating and Activating an Encryption Key TABLESPACE ENCRYPTION BY DEFAULT * Tablespace Encryption by Default in DBCS * Transparent Data Encryption (TDE) Overview * Components of TDE * Using TDE * Defining the Keystore Location * Controlling Tablespace Encryption by Default * Managing the Software Keystore and Master Encryption Key * Managing the Keystore in CDBs and PDBs ADDITIONAL COURSE DETAILS: Nexus Humans Oracle Database 12c R2 - Administration Workshop Ed 3 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Oracle Database 12c R2 - Administration Workshop Ed 3 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for This course is for all Oracle Professionals. Specifically Database Administrators, Web Server Administrators, System Administrators, CIOs and other IT Management Professionals. Overview Upon successful completion of this course, students will be able to perform many of the day-to-day administration tasks required of an Oracle database administrator. This course introduces many of the powerful capabilities of the Oracle database. In this course, students will learn about day-to-day administration tasks. It will also address administration sub-specialties. INTRODUCTION: MANAGING THE DATABASE INSTANCE * The Database Management Tools * EM Database Express * EM Cloud Control * SQL Developer * Database Administrator INTRODUCTION: DATABASE ARCHITECTURE REVIEW * Database Instance Configurations * Memory Structures * Process Structures * Storage Architecture INTRODUCTION: STARTING & STOPPING DATABSE SERVICES * Start & Stop the Database Listener * ABOUT DATABASE STARTUP/SHUTDOWN * SYSOPER * SYSDBA * DATABASE STATE & STAGES * STARTUP WITH EM CLOUD CONTROL * STARTUP WITH SQL*PLUS * SHUTDOWN WITH EM CLOUD CONTROL * SHUTDOWN WITH SQL*PLUS * USING MS WINDOWS SERVICES INTRODUCTION: ORACLE NETWORK ENVIRONMENT * Oracle Net Services Architecture * ORACLE NET CONFIGURATION ASSISTANT * ORACLE NET MANAGER * USING EM CLOUD CONTROL * ADVANCED NETWORK COMPRESSION * TROUBLESHOOTING NETWORK PROBLEMS INTRODUCTION: DIAGNOSTICS & ORACLE SUPPORT * About Database Diagnostics * Fault Diagnosability Infrastructure * DATABASE INSTANCE HEALTH SNAPSHOT * THE SUPPORT WORKBENCH * PROACTIVE DATABASE HEALTH CHECKS * PACKAGE DIAGNOSTIC DATA * WORKING WITH THE KNOWLEDGE BASE STORAGE: TABLESPACE MANAGEMENT * Starter Tablespaces * CREATE TABLESPACE WITH EM CC * CREATE TABLESPACE WITH SQL * MANAGE TABLESPACES WITH EM CC * MANAGE TABLESPACES WITH EM DE * MANAGE TABLESPACES WITH SQL * DROP TABLESPACE * ALTER TABLESPACE * STORAGE: ADVANCED TABLESPACE MANAGEMENT * Managing Temporary Tablespaces * TEMP TABLESPACE GROUPS WITH EM * TEMP TABLESPACE GROUPS WITH SQL * DEFAULT PERMANENT TABLESPACES * BIGFILE TABLESPACES * MANAGING THE SYSAUX TABLESPACE STORAGE: DATA FILES & TEMP FILES MANAGEMENT * Manage Data Files with EM * ACCESS METADATA WITH SQL * MANAGE DATA FILES WITH SQL * MANAGE TEMP FILES * ORACLE-MANAGED FILES (OMF) STORAGE: UNDO DATA & UNDO TABLESPACES * About UNDO Space Management * GUARANTEE UNDO RETENTION * MONITOR UNDO SPACE WITH SQL * USE THE EM UNDO ADVISOR SECURITY & SCHEMAS: SECURITY OVERVIEW & DATABASE PRIVILEGES * Database Security Principles * DATABASE SYSTEM PRIVILEGES * DATABASE OBJECT PRIVILEGES * SUPER ADMINISTRATOR ROLES * PRIVILEGE ANALYSIS SECURITY & SCHEMAS: USER SECURITY * Create & Manage User Accounts * MANAGE USERS WITH EM * MANAGE USERS WITH SQL * CREATE USER * ALTER USER * DROP USER * GRANT & REVOKE PRIVILEGES * RESOURCE LIMITS VIA PROFILES * ALTER PROFILE * DROP PROFILE * PASSWORD MANAGEMENT VIA PROFILES * ROLE-BASED SECURITY MANAGEMENT * ALTER USER...DEFAULT ROLE * SET ROLE * DELEGATING PRIVILEGE AUTHORIZATION * WITH ADMIN OPTION & System Privileges * WITH GRANT OPTION & Object Privileges * PRINCIPLE OF LEAST PRIVILEGE CHECKLIST SECURITY & SCHEMAS: DATABASE AUDITING * Auditing Database Activity * Traditional Auditing * Unified Auditing * Create Audit Policy SECURITY & SCHEMAS: SQL LOADER * Loader Concepts * Loader From the Command Line * control File Options * Load Methods * Loader Express Mode * Loader From EM SECURITY & SCHEMAS: EXPORT & IMPORT * Manage Directory Objects * The Data Pump Architecture * Data Pump Export * Data Pump Import * Data Pump Dictionary Views * Using the EM CC Interface PERFORMANCE & AVAILABILITY: MANAGING PERFORMANCE & SQL TUNING * Management Advisory Framework * Performance Monitoring & AWR * The SQL Tuning Advisor * Monitoring Exceptions with Metrics PERFORMANCE & AVAILABILITY: DATA CONCURRENCY * About System & User Locks * Monitor & Manage User Locks * Moitor Locks with Data Dictionary * Manage Locks with EM PERFORMANCE & AVAILABILITY: BACKUP & RECOVERY CONCEPTS * Backup & Recovery Structures * Managing REDO Data * Configuring for Recoverability * Instance Recovery * Recoverability Checklist ADDITIONAL COURSE DETAILS: Nexus Humans Oracle 12c Administration II training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Oracle 12c Administration II course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for IT professionals who will be responsible for the support of guests and other virtual machines running in the z/VM environment. It assumes that these persons will have little or no experience in the z/VM environment. Additionally anyone responsible for installing, customizing, and maintaining Linux on System z. Overview Describe the process of running guests under z/VM Define virtual machines to z/VM and reload the directory Customize the CP component of the z/VM system Customize the TCP/IP files on z/VM Apply service to the z/VM system Install SUSE Linux on System z Install additional packages Describe zLinux system management process Describe zLinux backup and recovery procedures Manage and update zLinux network connectivity issues Implement the z/VM Performance Toolkit Prerequisite to z/VM and Linux Connectivity and Management (ZV100) Prerequisite to z/VM RACF and DirMaint Implementation (ZV200) Introduces system programmers to the tasks required to support a z/VM operating system; providing an overview of the processes required to install z/VM & perform the required tailoring steps to support guest operating system virtual machines & CMS users. Z/VM AND ZLINUX OVERVIEW * . INSTALLATION * . DIRECTORY * . CP SYSTEM CONFIGURATION * . Z/VM NETWORKING * . VMSES/E * . INSTALLING SUSE LINUX ON SYSTEM Z * . INSTALLING ADDITIONAL PACKAGES * . NETWORK CONNECTIVITY * . SYSTEM MANAGEMENT * . BACKUP AND RECOVERY * . Z/VM PERFORMANCE TOOLKIT CONFIGURATION * .