60 Oracle 1Z0-819 courses

Duration 2 Days 12 CPD hours This course is intended for This course is intended for Data Warehouse Administrator, Database Administrator, Database Designer, Support Engineer, and Technical Administrator. Overview Upon successful completion of this course, students will be able to Install Oracle Grid Infrastructure for a Standalone Server, Configure ASMLIB and create ASM disk groups, Apply the latest patch set updates to the Grid Infrastructure software, Install Oracle Database software, Use Oracle Restart to manage components, Prepare the Linux operating system for Oracle software installation, Upgrade Oracle Database, Create a container database, Install Oracle Grid Infrastructure for an Independent Server, Create an Oracle Database using DBCA, and Install the latest patch set updates to the Oracle database software. This Oracle Database: Deploy, Patch and Upgrade Workshop gives you detailed information to help you install Oracle Database software. In this course, you will be introduced to Oracle Database Cloud Service. ORACLE DATABASE OVERVIEW * Oracle Database Introduction * Oracle Database Architecture Overview * Oracle Database Instance Configurations * Oracle Database Memory Structures * Process Structures * Database Storage Architecture * Logical and Physical Database Structures * Container and Pluggable Database Overview INSTALLING ORACLE GRID INFRASTRUCTURE FOR A STANDALONE SERVER * Overview of Oracle Grid Infrastructure for a Standalone Server * System Requirements for Oracle Grid Infrastructure * Configuring Storage for Oracle Automatic Storage Management (ASM) * Installing Oracle Grid Infrastructure for a Standalone Server * Upgrading Oracle Grid Infrastructure for a Standalone Server INSTALLING ORACLE DATABASE SOFTWARE * Planning Your Installation * System Requirements for Oracle Database * Preparing the Operating System * Using 4 KB Sector Disks * Setting Environment Variables * Checking the System Requirements * Using the Oracle Universal Installer (OUI) * Performing a Silent Mode Installation CREATING AN ORACLE DATABASE BY USING DBCA * Planning the Database Storage Structure * Choosing non-CDB or CDB * Types of Databases (based on workload) * Choosing the Appropriate Character Set * Understanding How Character Sets are Used * Setting the NLS_LANG Initialization Parameter * Using the Database Configuration Assistant (DBCA) USING ORACLE RESTART * Oracle Restart Overview * Oracle Restart Process startup * Controlling Oracle Restart * Choosing the Correct SRVCTL Utility * Oracle Restart Configuration * Using the SRVCTL Utility * Obtaining Help for the SRVCTL Utility * Starting Components by Using the SRVCTL Utility INTRODUCTION TO UPGRADING TO ORACLE DATABASE * Upgrade Methods * Data Migration Methods * Supported Releases for Direct Upgrade * Overview of Upgrade Process * Performing a Rolling Upgrade * Upgrading a CBD PREPARING TO UPGRADE TO ORACLE DATABASE * Developing a Test Plan * Performance Testing * Requirements for Databases Using Oracle Label Security or Oracle Database Vault * Requirement for Databases Using Oracle Warehouse Builder * Using the Pre-Upgrade Information Tool * Backing Up the Database * Installing the Oracle Database Software * Preparing the New Oracle Home UPGRADING TO ORACLE DATABASE * Upgrading by Using the Database Upgrade Assistant (DBUA) * Manually Upgrading to Oracle Database * Migrating a non-CDB to a CDB PERFORMING POST-UPGRADE TASKS * Migrating to Unified Auditing * Performing Post-Upgrade Tasks Following a Manual Upgrade MIGRATING DATA BY USING ORACLE DATA PUMP * Data Pump Overview * Migrating by Using Data Pump * Importing by Using a Network Link

Duration 4 Days 24 CPD hours This course is intended for This course is intended for Administrator, Architect, and Database Administrator Overview Upon successful completion of this course, students will be able to Manage PDB snapshots, Encrypt data in PDBs and isolate PDB keystore, Monitor performance in CDBs and PDBs, Audit users in CDB and PDBs, Protect data with Database Vault policies in CDB and PDBs, Manage a CDB fleet, and Manage resource allocation between PDBs and within a PDB. This Oracle Database: Managing Multitenant Architecture course covers all aspects of the multitenant architecture, providing detailed information on the components of an Oracle multitenant container database. 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 ADDITIONAL COURSE DETAILS: Nexus Humans Oracle Database - Managing Multitenant Architecture 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 - Managing Multitenant Architecture 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 Oracle Database Administrator Data Warehouse Administrator Support Engineer Technical Consultant Technical Administrator Overview The student benefits by gaining a deeper understanding of possibly the most important job of a DBA - backup and recovery. The concepts and architecture that support backup and recovery, along with implementation steps in various ways and situations, are presented in detail. Students gain knowledge of the Recovery Manager (RMAN) command-line interface for various backup, failure, restore, and recovery scenarios, including data duplication. The student begins by gaining a deeper understanding of possibly the most important job of a DBA - backup and recovery. The concepts and architecture that support backup and recovery, along with implementation in various ways and situations are covered in detail. Students gain knowledge of the Recovery Manager (RMAN) command-line interface for various backup, failure, restore, and recovery scenarios, including data duplication. INTRODUCTION AND CONFIGURATION * Introduction Getting Started Configuring for Recoverablility Using the RMAN Recovery Catalog BACKUP * Backup Strategies and Terminology Performing Backups Improving Your Backups Using RMAN-Encrypted Backups RECOVERY * Diagnosing Failures Restore and Recovery Concepts Performing Complete Recovery Performing Point-in-Time Recovery Performing Additional Recovery Operations ADDITIONAL TECHNOLOGIES * Using Flashback Technologies Using Flashback Database Transporting Data Duplicating a Database RMAN Troubleshooting and Tuning HANDS-ON * Backup and Recovery Workshop ADDITIONAL COURSE DETAILS: Nexus Humans Oracle Database: Backup and Recovery Workshop 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: Backup and Recovery Workshop 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 beginning DB2 basic course is for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database in a z/OS environment. Overview Describe several services provided in a z/OS environmentExplain workloads in the batch environmentExplain workloads in the online environmentDescribe job roles in a z/OS environmentLog On to TSO/ENavigate TSO/E and ISPFUse TSO commandsSetup and utilize JCL (Job Control Language)Utilize SDSFDescribe the different types of data sets in a z/OS environmentAllocate data sets and list data set information and contentCreate and modify data set contentGive an overview of the DB2 9 environmentDescribe and utilize DB2 ObjectsDescribe and utilize several DB2 UtilitiesDescribe the DB2I (DB2 Interactive Facility) environmentUse SPUFI (SQL Processing Using File Input) to compose and execute SQLSetup and execute DB2 CommandsUnderstand DB2 LoggingDescribe DB2 program preparation processUnderstand DB2 startup and shutdownUnderstand and utilize DB2 recovery strategies This course is intended for students looking to develop fundamental skills or recognition through lectures and hands-on exercises of TSO/E and ISPF, data sets, DB2 objects, Structured Query Language, DB2 commands, JCL and SDSF. DAY 1 * Welcome * Unit 1: Introduction * Unit 2: TSO/E and ISPF * Exercise 1: TSO and ISPF * Exercise 1 Review * Unit 3: Data Sets (Data Sets and Sequential Data Sets) * Exercise 2: Sequential Data Sets * Exercise 2 Review DAY 2 * Unit 3: Data Sets (Partitioned Data Sets) * Exercise 3: Partitioned Data Sets * Exercise 3 Review * Unit 3: Data Sets (VSAM Data Sets) * Exercise 4: VSAM Data Sets * Exercise 4 Review * Unit 4: JCL and SDSF * Exercise 5: JCL and SDSF * Exercise 5 Review DAY 3 * Unit 5: DB2 Relational Database Concepts * Unit 6: Structured Query Language (SQL) and SPUFI * Exercise 6: SQL and SPUFI * Exercise 6 Review * Unit 7: DB2 Objects (Databases and Table Spaces) * Exercise 7: Databases and Table Spaces * Exercise 7 Review * Unit 7: DB2 Objects (Tables, Indexes, and Views) * Exercise 8: Tables, Indexes, and Views * Exercise 8 Review DAY 4 * Unit 7: DB2 Objects (Qualified Names, Implicit Object Creation, and SQL Statements) * Exercise 9: Qualified Names, Implicit Object Creation, and SQL Statements * Exercise 9 Review * Unit 8: The DB2 System * Exercise 10: The DB2 System * Exercise 10 Review * Unit 9: DB2 Commands and Program Preparation * Exercise 11: DB2 Commands * Exercise 11 Review DAY 5 * Unit 10: DB2 Utilities * Exercise 12: DB2 Utilities * Exercise 12 Review * Unit 11: DB2 Shutdown, Startup, and Recovery * Exercise 13: DB2 Recovery * Exercise 13 Review * Unit 12: Course Summary ADDITIONAL COURSE DETAILS: Nexus Humans CV041 IBM z/OS and DB2 Basics for DB2 for z/OS DBA Beginners 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 CV041 IBM z/OS and DB2 Basics for DB2 for z/OS DBA Beginners 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 Administrator, Database Administrator, Security Specialist, and Systems Administrator. Overview Upon successful completion of this course, students will be able to Enumerate Oracle auditing solutions to monitor database security requirements, Implement Oracle Audit Vault and Database Firewall, Configure Oracle Audit Vault and Database Firewall, Explain Oracle Compliance Framework, and Configure basic Compliance Framework rules. In the Oracle Database Security: Detective Controls course, students learn how they can use Oracle Database administration auditing features to meet the compliance requirements of their organization. INTRODUCTION USING UNIFIED AUDIT USING FINE-GRAINED AUDIT INTRODUCTION TO ORACLE AUDIT VAULT AND DATABASE FIREWALL (AVDF) PLANNING THE ORACLE AUDIT VAULT AND DATABASE FIREWALL IMPLEMENTATION INSTALLING THE AUDIT VAULT SERVER CONFIGURING THE AUDIT VAULT SERVER CONFIGURING ORACLE AVDF AND DEPLOYING THE AUDIT VAULT AGENT NETWORKING AND ORACLE AVDF INSTALLING A DATABASE FIREWALL CONFIGURING ORACLE AVDF AND DEPLOYING DATABASE FIREWALL USING HOST MONITORING CONFIGURING HIGH AVAILABILITY CREATING CUSTOM COLLECTION PLUG-INS MANAGING THE AUDIT VAULT SERVER MANAGING THE DATABASE FIREWALLS OVERVIEW OF THE AUDITING AND REPORTING FEATURES PERFORMING ADMINISTRATIVE TASKS CREATING AUDIT POLICIES FOR ORACLE DATABASES CREATING DATABASE FIREWALL POLICIES ORACLE AVDF REPORTS MANAGING ENTITLEMENTS ADDITIONAL COURSE DETAILS: Nexus Humans Oracle Database Security - Detective Controls 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 Security - Detective Controls 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 EXPLORING ORACLE DATABASE ARCHITECTURE ORACLE DATABASE MANAGEMENT TOOLS MANAGING THE DATABASE INSTANCE CONFIGURING THE ORACLE NETWORK ENVIRONMENT ADMINISTERING USER SECURITY MANAGING DATABASE STORAGE STRUCTURES MANAGING SPACE MANAGING UNDO DATA MANAGING DATA CONCURRENCY IMPLEMENTING ORACLE DATABASE AUDITING BACKUP AND RECOVERY: CONCEPTS BACKUP AND RECOVERY: CONFIGURATION PERFORMING DATABASE BACKUPS PERFORMING DATABASE RECOVERY MOVING DATA DATABASE MAINTENANCE MANAGING PERFORMANCE MANAGING PERFORMANCE: SQL TUNING USING DATABASE RESOURCE MANAGER USING ORACLE SCHEDULER TO AUTOMATE TASKS ADDITIONAL COURSE DETAILS: Nexus Humans Oracle Database 12c - Administration I Workshop 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 - Administration I Workshop 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 2 Days 12 CPD hours This course is intended for Oacle Database Administrators System Administrators Developers Overview Understand the concept, benefits, configuration, and usage of the new features and enhancements in database overall area Understand the concept, benefits, configuration, and usage of the new features and enhancements in the security area Understand the concept, benefits, configuration, and usage of the new features and enhancements in the availability area Understand the concept, benefits, configuration, and usage of the new features and enhancements in the performance area Understand the concept, benefits, configuration, and usage of the new features and enhancements in big data and data warehousing area Understand the concept, benefits, configuration, and usage of the new features and enhancements in diagnosability area Understand the concept, benefits, configuration, and usage of the new features and enhancements in sharding area The course provides the Oracle Database 19c new features and enhancements related to database overall, security, availability, performance, data warehousing, and diagnosability. In the lessons, you learn the new and enhanced features of Oracle Database 19c amongst different areas such as database overall, security, availability, performance, big data and warehousing, and diagnosability. USING GENERAL DATABASE OVERALL ENHANCEMENTS USING SECURITY ENHANCEMENTS USING AVAILABILITY ENHANCEMENTS USING PERFORMANCE ENHANCEMENTS USING BIG DATA AND DATA WAREHOUSING ENHANCEMENTS USING DIAGNOSABILITY ENHANCEMENTS SHARDING ENHANCEMENTS

Duration 2 Days 12 CPD hours This course is intended for This course is intended for experienced Oracle Database Administrators, System Administrators, and Developers. Overview Upon completion of this course, the student should be able to: Understand the concept, benefits, configuration, and usage of the new features and enhancements in database overall area, security area, availability area, performance area, big data and data warehousing area and enhancements in diagnosability area and in sharding area. The course provides the Oracle Database 19c new features and enhancements related to database overall, security, availability, performance, data warehousing, and diagnosability. The course provides the Oracle Database 19c new features and enhancements related to database overall, security, availability, performance, data warehousing, and diagnosability.

Duration 5 Days 30 CPD hours This course is intended for Database DesignersSupport EngineerTechnical AdministratorDatabase AdministratorsData Warehouse Administrator Overview Use Oracle Restart to manage components.Upgrade database to Oracle Database 12c.Install Oracle Grid Infrastructure for a Standalone Server.Create a container database.Create an Oracle DatabaseInstall Oracle Database 12c software.Monitor the Database.Manage Database Performance.Implement Database Auditing.Configure the Database Instance Such That Resources Are Appropriately Allocated Among Sessions and Tasks.Schedule Jobs to Run Inside or Outside of the Database.Configure Oracle Net Services.Configure your Database For Backup and Recovery Operations.Describe Oracle Database Architecture.Manage the Oracle Database Instance.Manage Oracle Database Storage structures. This course will will teach you about the Oracle Database architecture and you will discover how to effectively manage an Oracle Database instance. You will also be provided key information on how to install and administer Oracle Database 12c. This course will will teach you about the Oracle Database architecture and you will discover how to effectively manage an Oracle Database instance. You will also be provided key information on how to install and administer Oracle Database 12c.

Duration 3 Days 18 CPD hours This course is intended for This intermediate course is for application programmers who need to write embedded SQL COBOL or PL/I programs in either a DB2 9 or DB2 10 for z/OS environment. Overview Incorporate static SQL statements in an application program Prepare the program for execution Validate execution results are correct Produce code to support multiple rows being returned from the database manager using cursors Identify considerations regarding units of work, concurrency, and restart of programs Identify differences between static and dynamic SQL Provide test data for applications Discuss program and DB2 options relative to performance of static SQL This course enables you to acquire the skills necessary to produce application programs that manipulate DB2 databases. Emphasis is on embedding Structured Query Language (SQL) statements and preparing programs for execution. CV720G;CF82G;DB2 CONCEPTS * Identify DB2 family products * Explain DB2 workstation component functions * Identify DB2 objects * Identify the key differences between static SQL and other application alternatives for accessing DB2 data PROGRAM STRUCTURE I * Embed INSERT, UPDATE, DELETE and single-row SELECT statements in application programs * Effectively communicate with DB2 when processing NULL values and determining success of statement execution * Demonstrate use of DB2 coding aids * Code CONNECT statements within an application program * Identify connection types and impacts on a unit of work * Program for the Call Attach Facility (CAF) PROGRAM PREPARATION * Identify the additional steps necessary to prepare a program that contains embedded SQL for execution * Describe the functions of the DB2 PRECOMPILE and BIND processes * Describe factors relevant to the BIND process, including RUNSTATS positioning, package status, parameters, and authorization requirements * PROGRAM STRUCTURE II * Use DECLARE, OPEN, FETCH, and CLOSE CURSOR statements to handle select criteria that may return multiple rows in application programs * Issue positioned UPDATE and DELETE statements * Identify how scrollable cursors can be used RECOVERY AND LOCKING CONCEPTS * Define a unit of recovery * Identify the basic locking strategies used by DB2 DYNAMIC SQL INTRODUCTION * Describe the difference between static and dynamic SQL * List the types of dynamic statements * Code dynamic SQL in a program MANAGING TEST DATA * Identify methods to insert data into a table * Use the LOAD or IMPORT utility * Identify the purpose of the RUNSTATS utility * Identify the purpose of the REORG utility PERFORMANCE CONSIDERATIONS * Use programming techniques that enhance DB2 application performance by following general guidelines, using indexable predicates, and avoiding unnecessary sorts * Identify the access paths available to DB2 * List common causes of deadlocks and avoid such causes when possible * Use the EXPLAIN tools as aids to develop applications that emphasize performance ADDITIONAL COURSE DETAILS: Nexus Humans CV722 IBM DB2 11 for z/OS Application Programming Workshop 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 CV722 IBM DB2 11 for z/OS Application Programming Workshop 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.