107 AWS Certified Database courses

Duration 5 Days 30 CPD hours This course is intended for This intermediate-level course requires students have incoming experience working with Oracle Database 18 or higher. Overview Working in a hands-on learning environment led by our expert facilitator, you'll explore: The Oracle Database Architecture Query Optimizer Tuning Container Databases and Pluggable Databases Oracle 19c Tuning features Evaluating Execution Plans Oracle Tuning Tools Using Automatic Workload Repository Join Types AWR Using Baselines Additional AWR performance tools Optimizer Statistics Monitoring a Service Bind Variables and database parameters Oracle's Real Application Testing (RAT) SQL Tuning Advisor Automatic Sql Tuning Sql Plan Management Shared Pool Tuning Tuning the database buffer cache Tuning the PGA (Program Global Area) Automatic Memory Management (AMM) Tuning Segment Space Utilization (ASSM) Automatic Storage Management Oracle 19C Database Tuning is an intermediate level course for Oracle database experienced attendees that explores core tuning skills such as Database parameters, SQL Tuning Advisor, SQL Access Advisor, Adaptive SQL plans and more. OVERVIEW ORACLE DATABASE ARCHITECTURE * Instance Definition * Define SGA * Define Background Processes * Datafile Definition QUERY OPTIMIZER * SQL Parsing * Optimizing Terms * Optimizing Methods * Query Plan Generation * Query Plan Control TUNING CONTAINER DATABASES AND PLUGGABLE DATABASES * Pluggable tuning parameters * Define Container tuning structure * Using PDB$SEED * Create a new PDB * Plug and unplug a PDB ORACLE 12C TUNING FEATURES * Identifying and Using Oracle's Heat Map * 12c Compression Levels and Types EVALUATING EXECUTION PLANS * Defining SQL execution plans * Automatic Workload Repository * Reading execution plans ORACLE TUNING TOOLS * Monitoring tools overview * Enterprise Manager * Dynamic Performance Views * Automatic Workload Repository * Automatic Database Diagnostic Monitor * Sql Tuning Advisor * SQL Access Advisor * Sql Access Advisor * DB operation Tuning * DB operation Active Reporting USING AUTOMATIC WORKLOAD REPOSITORY * Defining AWR * AWR Settings * Creating AWR Baselines METRICS, ALERTS, AND THRESHOLDS * Defining Metrics * Setting Alerts * Setting Corrective Actions * User Defined Metrics * Metric Dynamic Views JOIN TYPES * Nested Loops Join * Sort Merge join * Hash Join and Cartesian Join * Equijoins and Nonequijoins * Outer Joins * Semijoins AWR USING BASELINES * Creating AWR baselines * Creating AWR Repeating baselines * Moving Window Baseline ADDITIONAL AWR PERFORMANCE TOOLS * Automatic Maintenance Tasks * Segment Advisor * Statistics Gathering * Automatic Tuning Optimizer * Automatic Database Diagnostic Monitor * Active Session History (ASH) OPTIMIZER STATISTICS * Optimizer Statistics Overview * Table and Index Statistics * Statistic Preferences * Statistics Gathering * e) Locking Statistics, Export/Import Statistics * Pending and published statistics * Optimizer Hints * Optimizer Paths * Cost Base Optimization MONITORING A SERVICE * Overview of what is an Oracle Service * Creating an Oracle Service for Single instance and RAC * Monitoring a Service * Resource Management and a Service * Enterprise Manager and a Service BIND VARIABLES AND DATABASE PARAMETERS * Bind variable definition * Cursor_sharing parameter * Adaptive Cursor Sharing ORACLE'S REAL APPLICATION TESTING (RAT) * Sql Performance Analyzer overview * Sql Performance Analyzer Options * Database Parameter changes * Database version changes * Creating SQL Tuning Sets * Database Replay Overview * Database Replay Configuration * Database Replay Options SQL TUNING ADVISOR * SQL Tuning Advisor: Overview * SQL Tuning Advisor Limited Mode * Sql Tuning Advisor Comprehensive mode * Sql Tuning Profiles SQL ACCESS ADVISOR * SQL Access Advisor: Overview * Sql Access Advisor options * SQL Access Advisor and Sql Tuning Sets * Sql Access Advisor and AWR * Results and Implementation AUTOMATIC SQL TUNING * Automatic Sql Tuning Maintenance Task * Automatic Tuning Optimization implementation(ATO) * Automatic Tuning Optimization Results * Enable/Disable Automatic Tuning Optimization SQL PLAN MANAGEMENT * Sql plan Management and baseline overview * Enable sql plan management * Loading Sql Plan baselines into the SGA * Adaptive plan management SHARED POOL TUNING * Shared pool architecture * Shared pool parameters * Library Cache * Dictionary cache * Large pool considerations and contents TUNING THE DATABASE BUFFER CACHE * Database buffer cache overview * Database buffer cache parameters * Oracle and Dirty reads and writes * Automatic Shared Memory Management (ASMM) * Buffer Cache goals and responsibility * Buffer Cache pools TUNING THE PGA (PROGRAM GLOBAL AREA) * PGA Overview * PGA Database Parameters * Temporary Segments * Temporary Tablespace * Sizing the PGA AUTOMATIC MEMORY MANAGEMENT (AMM) * Oracle's Automatic Memory Management Overview * Database Auto-tuned Parameters * Database Non Auto-tuned Parameters * Automatic Memory Management Hints and Sizing suggestions * AMM versus ASMM TUNING SEGMENT SPACE UTILIZATION (ASSM) * Overview of Automatic Segment Space Management * Defining the DB_BLOCK_SIZE * Defining DB_nk_CACHE_SIZE parameter * The DB_BLOCK_SIZE Parameter * Overview of table compression, block chaining, and block migration AUTOMATIC STORAGE MANAGEMENT * Overview of ASM * Definition of Grid Infrastructure * ASM Instance * ASM Diskgroups * ASM Diskgroup parameters and templates * ASMCMD

Duration 3 Days 18 CPD hours This course is intended for This course is 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 pracitioner you'll learn how to: Add Data, Retrieve, Sort and Organize a SQL Database Combine Data, Set Operators and Subqueries Manipulate Data and Data Definition Languages in SQL Work with Data Dictionary Views and Create Sequences, Indexes and Views Use Database Objects and Subqueries Perform Data and access control Perform other Advanced Level Database operations. Oracle 19C SQL Programming Fundamentals Is a three-day, hands-on course designed to equip you with the fundamental skills needed to set up, run and manage SQL databases using Oracle Database Technology. You will also be discovering all the tools and concepts required to organize data efficiently. Our engaging instructors and mentors are highly-experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working within in a hands-on learning environment, guided by our expert team, attendees will develop a practical approach to Oracle Database Technology. Throughout the course, you will learn the key elements of a database, and the way Oracle systems facilitate their induction in the system. You?ll also learn the tools and strategies you can implement to store, retrieve, compare and organize data according to your requirements. You?ll also explore the process of creating simple to complex reports from existing data. By the end of this course, you will also have hands-on knowledge of SQL systems that are required to proceed to other advanced to professional programs. ADDING DATA, RETRIEVING, SORTING AND ORGANIZING A SQL DATABASE * The building blocks of a database. * How to add data to the database. * The process of retrieving data using SQL functions. * Multiple methods of sorting and organizing data. * Using SQL functions to get the required simple to complex output. * Various strategies for using functions and conditions to organize data. COMBINING DATA, SET OPERATORS AND SUBQUERIES * Consolidating data using multiple functions and group operators. * Fetching intelligent data reports using simple functions. * Fetching data from multiple sources in the tables. * Using Subqueries to compile data as required. * Using Set operators to create smart data reports. DATA MANIPULATION AND DATA DEFINITION LANGUAGES IN SQL * Describing and managing data transaction using Data Definition Language. * Categorize and review data tables using Data Definition Language. DATA DICTIONARY VIEWS AND CREATING SEQUENCES, INDEXES AND VIEWS * How to manage and query Data Dictionary Views. * The process of creating and using Sequences. * How to create various types of Synonyms and Indexes. * Creating simple and complex views and retrieving data. UNDERSTANDING AND USING DATABASE OBJECTS AND SUBQUERIES * Core concept and application of Schema Objects. * Fetching required data with Subqueries. * Using Subqueries to organize Data in SQL. DATA AND ACCESS CONTROL * Assigning and revoking data access. * Managing data access control according to user levels. PERFORMING ADVANCED LEVEL DATABASE OPERATIONS. * Using advanced functions and performing data queries. * Creating and managing time zone-based databases.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for Administrator, Database Administrator, Network Administrator, Systems Administrator. Overview Upon successful completion of this course, students will be able to Configure and use Transparent Data Encryption, Understand and use Oracle Key Vault, Understand Oracle Data Redaction, Understand and use Oracle Data Masking and Subsetting, Understand security risks and identify appropriate Oracle solutions, Configure general authentication and authorization, Understand and implement Global Users, Set up and maintain a simple wallet, Install and use Oracle Database Vault, and Configure and use Transparent Sensitive Data Protection. In the Oracle Database Security: Preventive Controls course, students learn how they can use Oracle Database Security products and technologies to meet the security, privacy and compliance requirements of their organization. In the Oracle Database Security: Preventive Controls course, students learn how they can use Oracle Database Security products and technologies to meet the security, privacy and compliance requirements of their organization. ADDITIONAL COURSE DETAILS: Nexus Humans Oracle Database Security - Preventive 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 - Preventive 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 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 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 4 Days 24 CPD hours This course is intended for Architect Database Administrators Overview Configure and use Policy-Based Cluster Management in conjunction with Policy-Managed Database and Oracle Multitenant Architecture Migrate from a standard cluster to a Flex Cluster and configure highly available application resources on Flex Cluster Leaf Nodes Implement Oracle Database In-Memory on an existing Oracle RAC database Configure an Oracle RAC database to use Application Continuity Configure and use Global Data Services in conjunction with Oracle RAC and Data Guard Upgrade an existing database to use Oracle ASM Filter Driver Migrate from standard ASM to Flex ASM and examine the effect of using Flex ASM Perform a database rolling upgrade, from Oracle Database 11gR2 to Oracle Database 12c, using a transient logical standby database Practice configuring, administering and using noteworthy features associated with Oracle Database 12c RAC and Grid Infrastructure. Practice configuring, administering and using noteworthy features associated with Oracle Database 12c RAC and Grid Infrastructure. ADDITIONAL COURSE DETAILS: Nexus Humans Oracle Database 12c - RAC and Grid Infra Deployment 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 - RAC and Grid Infra Deployment 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 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 Database and system administrators Overview Manage physical data replacement and storageCreate, backup and restore databasesCreate and manage multiple temporary databases In this course, students learn how to manage physical data replacement and storage, create, backup and restore databases, and create and manage multiple temporary databases. SAP ADAPTIVE SERVER ENTERPRISE (ASE) * Explaining SAP ASE * Describing the Database Architecture * Using Query Editors INSTALLATION * Installing Servers * Identifying Installation Parameters * Starting and Stopping SAP ASE * Connecting Clients to the Server DATABASE SERVER CONFIGURATION * Explaining the Server Configuration File * Modifying the Server Configuration File * Explaining Memory Mechanisms * Configuring Memory * Configuring the Size of Caches SPACE MANAGEMENT * Creating Devices * Managing Devices * Mirroring Devices * Creating Databases * Managing Databases * Managing Disk Resources * Managing Temporary Databases SECURITY * Managing Roles * Creating Logins * Managing Logins * Managing Database Users * Managing Creation Permissions * Managing Object Permissions * Creating Groups * Creating Roles MAINTENANCE * Using SAP ASE Extraction Utilities * Using the Bulk Copy Utility * Explaining Automatic Recovery * Ensuring Database Consistency * Setting Up the High Speed Consistency Checker BACKUP * Planning for Backups * Executing Database Backups * Restoring Database Backups * Performing Transaction Log Backups * Using Advanced Backup Techniques MONITORING * Using SAP DB Control Center * Monitoring SAP ASE ADDITIONAL COURSE DETAILS: Nexus Humans EDB358 SAP System and Database Administration - Adaptive Server Enterprise 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 EDB358 SAP System and Database Administration - Adaptive Server Enterprise 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 AdministratorDatabase Administrators Overview Describe the components of ASMExplain and apply Automatic Storage Management (ASM) initialization parametersManage ASM instances and associated processesMonitor ASM using the V$ASM dynamic performance viewsUnderstand Flex ASM architecture and componentsUnderstand ASM Deployment AlternativesInstall and configure Flex ASMManage Flex ASMEmploy ASM space management techniquesCreate and delete Automatic Storage Management (ASM) disk groupsSet the attributes of an existing ASM disk groupPerform ongoing maintenance tasks on ASM disk groupsExplain key performance and scalability considerations for ASM disk groupsDescribe the Automatic Storage Management (ASM) architectureUse different client tools to access ASM filesDescribe the format of a fully qualified ASM file name This Oracle Database 12c: ASM Administration training teaches you about Oracle ASM architecture. Expert Oracle University instructors will help you develop a deeper understanding of both standard ASM and Flex ASM applications. This Oracle Database 12c: ASM Administration training teaches you about Oracle ASM architecture. Expert Oracle University instructors will help you develop a deeper understanding of both standard ASM and Flex ASM applications.

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job. The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases. Overview After completing this course, you will be able to: Authenticate and authorize users Assign server and database roles Authorize users to access resources Use encryption and auditing features to protect data Describe recovery models and backup strategies Backup and Restore SQL Server databases Automate database management Configure security for the SQL Server agent Manage alerts and notifications Managing SQL Server using PowerShell Trace access to SQL Server Monitor a SQL Server infrastructure Troubleshoot a SQL Server infrastructure Import and export data This course will provide training in how to administer and maintain SQL Server, Azure SQL Database and other cloud-based SQL Server databases. IT professionals who work in environments where databases play a key role in their job will find this material useful. By using demonstrations and hands-on lab exercises, students will learn to carry out these important tasks. This course covers content that was in retired Microsoft Course 20764: Administering a SQL Database Infrastructure. 1 - CREATING ADVANCED FUNCTIONS * Lesson 1: Converting a command into an advanced function * Lesson 2: Creating a script module * Lesson 3: Defining parameter attributes and input validation * Lesson 4: Writing functions that accept pipeline input * Lesson 5: Producing complex pipeline output * Lesson 6: Using comment-based Help * Lesson 7: Using Whatif and Confirm parameters 2 - USING MICROSOFT .NET FRAMEWORK AND REST API IN WINDOWS POWERSHELL * Lesson 1: Using .NET Framework in PowerShell * Lesson 2: Using REST API in PowerShell 3 - WRITING CONTROLLER SCRIPTS * Lesson 1: Understanding controller scripts * Lesson 2: Writing controller scripts with a user interface * Lesson 3: Writing controller scripts that create reports 4 - HANDLING SCRIPT ERRORS * Lesson 1: Understanding error handling * Lesson 2: Handling errors in a script 5 - USING XML, JSON, AND CUSTOM-FORMATTED DATA * Lesson 1: Working with XML formatted data * Lesson 2: Working with JSON formatted data * Lesson 3: Working with custom-formatted data 6 - ENHANCING SERVER MANAGEMENT WITH DESIRED STATE CONFIGURATION AND JUST ENOUGH ADMINISTRATION * Lesson 1: Implementing Desired State Configuration * Lesson 2: Implementing Just Enough Administration 7 - ANALYZING AND DEBUGGING SCRIPTS * Lesson 1: Debugging in Windows PowerShell * Lesson 2: Analyzing and debugging an existing script 8 - UNDERSTANDING WINDOWS POWERSHELL WORKFLOW * Lesson 1: Understanding Windows PowerShell Workflows * Lesson 2: Running Windows PowerShell Workflows