52 Oracle SQL courses

Duration 5 Days 30 CPD hours This course is intended for Database Administrators Data Warehouse Administrator Support Engineer Technical Consultant Technical Administrator Overview Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure. Describe the Oracle Database architecture components related to backup and recovery operations. Plan effective backup and recovery procedures. Configure the database for recoverability. Use Recovery Manager (RMAN) to create backups and perform recovery operations. Use the Data Recovery Advisor to diagnose and repair failures. Use Oracle Flashback Technologies to recover from human error. Perform an encrypted database backup and restore. Perform tablespace point-in-time recovery. Describe additional high availability features such as Oracle Data Guard. 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. 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. ADDITIONAL COURSE DETAILS: Nexus Humans Oracle Database 12c - 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 12c - 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 hands-on course is geared for experienced DBAs with basic Oracle 19c skills. Overview This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs andexercises. Working in a hands-on learning environment led by our expert facilitator, students will explore: Creating CDBs and Regular PDBs Managing CDBs and PDBs Backup and Duplicate Upgrading and Transporting CDBs and Regular PDBs Backup Strategies and Terminology Restore and Recovery Concepts Using Flashback Technologies Duplicating a Database Installing Grid Infrastructure and Oracle Database Patching Grid Infrastructure and Oracle Database Upgrading to Oracle Grid Infrastructure Using General Overall Database Enhancements Monitoring and Tuning Database Performance Managing Application PDBs Managing Security in Multitenant databases Recovery and Flashback Configuring and Using RMAN Diagnosing Failures Performing Recovery Transporting Data RMAN Troubleshooting and Tuning Creating an Oracle Database by using DBCA Oracle Restart Upgrading the Oracle Database Installing Grid Infrastructure for a Standalone server Using Availability Enhancements Tuning SQL Statements Geared for participants experienced with Oracle 19c DBA essentials Oracle 19c Database Administration II (Oracle DBA II) expands their understanding of Oracle database administration. Throughout the course students will explore coverage of Multitenant (CDB/PDB), database tuning, SQL tuning, and backup and recovery: the skills needed to keep a database running reliably and efficiently. The current release of the database is used for exercises and demonstrations, and the content back-ported as necessary for previous releases. CREATING CDBS AND REGULAR PDBS * Configure and create a CDB * Create a new PDB from the CDB seed * Explore the structure of PDBs MANAGE CDBS AND PDBS * Manage PDB service names and connections * Manage startup, shutdown and availability of CDBs and PDBs * Change the different modes and settings of PDBs * Evaluate the impact of parameter value changes * Performance management in CDBs and PDBs * Control CDB and PDB resource usage with the Oracle Resource Manager BACKUP AND DUPLICATE * Perform Backup and Recover CDBs and PDBs * Duplicate an active PDB * Duplicate a Database UPGRADING AND TRANSPORTING CDBS AND REGULAR PDBS * Upgrade an Oracle Database * Transport Data BACKUP STRATEGIES AND TERMINOLOGY * Perform Full and Incremental Backups and Recoveries * Compress and Encrypt RMAN Backups * Use a media manager * Create multi-section backups of exceptionally large files * Create duplexed backup sets * Create archival backups * Backup of recovery files * Backup non database files * Back up ASM meta data RESTORE AND RECOVERY CONCEPTS * Employ the best Oracle Database recovery technology for your failure situation * Describe and use Recovery technology for Crash, Complete, and Point-in-time recovery USING FLASHBACK TECHNOLOGIES * Configure your Database to support Flashback * Perform flashback operations DUPLICATING A DATABASE * Duplicate Databases INSTALL GRID INFRASTRUCTURE AND ORACLE DATABASE * Install Grid Infrastructure for a Standalone server Install Oracle Database software PATCHING GRID INFRASTRUCTURE AND ORACLE DATABASE * Patch Grid Infrastructure and Oracle Database UPGRADING TO ORACLE GRID INFRASTRUCTURE * Upgrade Oracle Grid Infrastructure USING GENERAL OVERALL DATABASE ENHANCEMENTS * Install Oracle Database software Create, Delete and Configure Databases using DBCA Creating CDBs and Regular PDBs Use Miscellaneous 19c New Features MONITORING AND TUNING DATABASE PERFORMANCE * Managing Memory Components Understanding the Automatic Workload Repository (AWR) Understanding the Advisory Framework Monitoring Wait Events, Sessions, and Services Managing Metric Thresholds and Alerts Understanding and Using the Performance Tuning Methodology Performing Performance Planning Understanding the Automatic Database Diagnostic Monitor (ADDM) MANAGE APPLICATION PDBS * Explain the purpose of application root and application seed Define and create application PDBs Install, upgrade and Patch applications Create and administer Application PDBS Clone PDBs and Application containers Plug and unplug operations with PDBs and application containers Comparing Local Undo Mode and Shared Undo Mode MANAGE SECURITY IN MULTITENANT DATABASES * Manage Security in Multitenant databases Manage PDB lockdown profiles Audit Users in CDBs and PDBs Manage other types of policies in application containers RECOVERY AND FLASHBACK * Restore and Recovering Databases with RMAN Perform CDB and PDB flashback CONFIGURING AND USING RMAN * Configure RMAN and the Database for Recoverability Configure and Using an RMAN recovery catalog DIAGNOSING FAILURES * Detect and repair database and database block corruption Diagnosing Database Issues PERFORMING RECOVERY * Restore and Recovering Databases with RMAN Perform Non RMAN database recovery TRANSPORTING DATA * Transport Data RMAN TROUBLESHOOTING AND TUNING * Interpret the RMAN message output Diagnose RMAN performance issues CREATING AN ORACLE DATABASE BY USING DBCA * Create, Delete and Configure Databases using DBCA ORACLE RESTART * Configure and use Oracle Restart to manage components UPGRADE THE ORACLE DATABASE * Plan for Upgrading an Oracle Database Upgrade an Oracle Database Perform Post-Upgrade tasks INSTALL GRID INFRASTRUCTURE FOR A STANDALONE SERVER * Rapid Home Provisioning USING AVAILABILITY ENHANCEMENTS * Use an RMAN recovery catalog Use Flashback Database TUNING SQL STATEMENTS * Understanding the Oracle Optimizer Using the SQL Tuning Advisor Managing Optimizer Statistics Using the SQL Access Advisor Understanding the SQL Tuning Process ADDITIONAL COURSE DETAILS: Nexus Humans Oracle 19c Database Administration II (DBA II) (TTOR20619) 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 19c Database Administration II (DBA II) (TTOR20619) 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 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 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 understand configuration for installation, configuration of a host system, using Oracle Restart framework, troubleshooting tips, how the database fits with other systems, internals of the database, database failures and other topics. In this course, students will focus on configuration on supported systems. Also how the database fits in with other systems. ORACLE DATABASE ARCHITERCTURE OVERVIEW * The Database Instance * Database Memory Structures * Database Process Structures * Database Storage Architecture * Oracle Clusterware CONFIGURING THE HOST FOR STANDALONE INSTALLLATION * Host Configuration Overview * Choosing a Database Host * Choosing an Operating System * Proprietary Unix vs Open-Source Linux * Making the OS Selection * Prepare an Oracle LINUX Installation * Perform Oracle LINUX Installation * Configure the LINUX Host * Step 1 - Confirm General System Requirements * Step 2 - Confirm The Operating System Platform * Step 3 - Confirm LINUX Package Requirements * Step 4 - Confirm Network Configuration * Configure Host for Virtualization * VM Technologies * Configure Oracle Linux for Virtualization * Step 1 - Download Linux Updates * Step 2 - Check Linux Kernel * Step 3 - Download Latest yum Configuration File * Step 4 - Enable Oracle Linux Add-ons * Step 5 - Install VirtualBox * Oracle Optimal Flexible Architecture * OFA Goals * ORACLE_BASE * ORACLE_HOME * Database Files * Multiple ORACLE_HOMEs * Databse Software Upgrades * Mutliple Oracle Software Installations GRID INFRASTRUCTURE CONFIGURATION * Configure the Linux Installation * About ASM Devices * Configure Linux Devices for ASM * Partioning a Device * Oracle ASMLib * Configue MS Windows Devices GRID INFRASTRUCTURE INSTALLATION * Perform the Installation * Download * Unpack the Installation Package * Launch the Installation Session * The Installation Dialog * Verify the Installation * Operating System Confirmation * Oracle Utilities Setup * SQL*Plus Confirmation * Using EM Cloud Control * Troubleshooting Problems DATABASE INSTALLATION CONFIGURAION * Configure a Linux Installation * System Groups & Users * Configure Kernel Parameters * Create the Physical Directories * Configure MS Windows Installation * Prerequisite Checks & Fixup Utility DATABASE INSTALLATION * ABOUT THE INSTALLATION * The Installation Tools * About The Installation Dialog * The Installation Session Log * PERFORM INSTALLATION ON LINUX * Download * Unpack The Installation Files * Set Environment Variables * Launch The Installation * SERVER CLASS INSTALLATION DIALOG * More About The Global Database Name * About Enterprise Manager Cloud Control * Secure The New Database * PERFORM INSTALLATION ON WINDOWS * Launch The Installation * POST---INSTALLATION CONFIGURATION * Required Environment Variables * Defining The Environment Variables * About SSH * VERIFY THE INSTALLATION * SQL*PlusConfirmation * Operating System Confirmation * Firewall Configuration * Accessing EM Database Express CREATING DATABSES USING DBCA * About DBCA * DBCA Templates * Are You Sure? * DEFAULT CONFIGURATION DATABASE * ADVANCED MODE DATABASE * File Location Variables * Database Vault and Label Security * CONFIGURE AN EXISTING DATABASE * DELETE A DATABASE * MANAGE TEMPLATES * MANUALLY CREATE A DATABASE * The CREATE DATABASE Command USING ORACLE RESTART * WHAT IS ORACLE RESTART? * What Oracle Restart Does * Is Oracle Restart Deprecated? * Registering With Oracle Restart * More About srvctl * Terminal Session Configuration * COMPONENT STATUS USING SRVCTL * Database Status * Grid Infrastructure Status * Oracle Home Status * CONFIGURATION USING SRVCTL * Examining A Database Configuration * Examining The Listener Configuration * Examining The ASM Configuration * Manual Registration * ListenerConfiguration Modification * Database ConfigurationModification * STARTUP/SHUTDOWN USING SRVCTL * Why Use srvctl? * MANAGING ORACLE RESTART * Obtaining Oracle Restart Status * Start/Stop Oracle Restart PREPARING FOR A DATABASE UPGRADE * What is a Database Upgrade? * Database Upgrade Methods * Real World Database Upgrade * Develop A Database Upgrade Plan * ABOUT THE DATABASE VERSION * Direct Upgrade * The COMPATIBLE Database Parameter * PRE-UPGRADE PREPARATIONS * Oracle Warehouse Builder * Oracle Label Security (OLS) * Oracle Database Vault * Locating The Older Database Installations * THE PRE-UPGRADE INFORMATION TOOL * Pre-Upgrade Information Tool Files * Run The Pre---Upgrade Information Tool * Examining The Pre---Upgrade Information Tool Results UPGRADE TO ORACLE DATABSE 12C * Launch DBUA * Database Upgrade Dialog POST-UPGRADE TASKS * Post-Upgrade Checklist * Enable Unified Auditing * Migrate to Unified Auditing * Database Parameter Changes * Enable New Features * Source Destination Specific Post-Upgrade Tasks ORACLE ARCHITECTURE: THE SYSTEMS INFRASTRUCTURE * About Enterprise Architectures * The Relational Database * Legacy Computing Models * The Multi-Tiered Computing Model * Scaling Up * Cloud-Based Deployment * ORACLE INFRASTRUCTURE ECOSYSTEM * USING ORACLE ENTERPRISE MANAGER * More About EM * Using EM Database Express * Using EM Cloud Control ORACLE ARCHITECTURE: THE DATABASE HOST * The Database Server Stack * PROCESSOR LAYER * CPU Resources * Memory Resources * I/O & STORAGE PROCESSING * OS LAYER PROCESSING MODES * DATABASE SERVER VIRTUALIZATION * STORAGE VIRTUALIZATION * ORACLE DATABASE SERVER STACK * ORACLE ENGINEERED SYSTEMS * Oracle Exadata Database Platform * Exalogic Cloud Machine * Exalytics BI Machine ORACLE ARCHITECTURE: PRINCILPLES & TECHNOLOGY CONCEPTS * Grid Computing Principles * Why Grid Computing? * What Is Grid Computing? * PARALLELIZATION PRINCIPLES * Hardware Parallelization * Grid Computing Devices * Clustered Database Servers * CLOUD COMPUTING PRINCIPLES * Multi-Tenancy ORACLE ARCHITECTURE: THE RDBMS INSTALLATION & THE DATABASE INSTANCE * The Database Server Software * Database Versions & Releases * Database Editions * Using PRODUCT_COMPONENT_VERSION View * The Core Database Components * Using V$VERSION View * Understanding The Database Version Number * The COMPATIBLE Database Parameter * DATABASE INSTANCE ELEMENTS * Individual Elements Of A Database Instance * Physical Database Elements * An Operational Database installation * DATABASE INSTANCE CONFIGURATIONS * Single Instance * Parameter Files & Instance Configuration * MAX_STRING_SIZE Parameter Example * Independent Instances * Clustered Instances * The Database Instance In A Multi-tenant Configuration * RECONFIGURING A DATABASE INSTANCE * Static Vs. Dynamic Parameters * Dynamic Parameter Setting * Parameter Setting Scope * Parameter Setting Level * Setting Upgrade Related Parameters * DATABASE COMPONENTS * Advanced Data Functionality Components * Security Components * High-Performance Components * Administration Components * Database F

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