196 Database Administration courses

Duration 3 Days 18 CPD hours This course is intended for This course is geared for anyone needing to interface with an Oracle database such as end users, business analysts, application developers and database administrators / DBAs. Overview 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 participants will explore: Using PL/SQL programming language for database applications and development incorporating PL/SQL modules within the application architecture from the initial design and planning phase The essentials of building executable PL/SQL program units Each of the major segments of a working program and how these interact with each other during program execution Important error or exception handling capabilities of the language. How database-resident program units can be used as part of the overall database application architecture Applying these new skills to the development of PL/SQL packages. Advanced database programming capabilities and benefits How database triggers can be used as part of an advanced database application design Oracle 19c PL/SQL Fundamentals is a three-day, hands-on course that introduces Oracle database programming using the PL/SQL programming language. Throughout the course students will explore the core syntax, structure and features of the language. This course will also lay the foundation for the entire Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications. The course also explores applying the newly learned skills to the development of database applications. Participants will learn how to use database-resident stored program units such as procedures, functions, packages and database triggers. Students will also learn about the latest features in Oracle 19c. SELECTION & SETUP OF THE DATABASE INTERFACE * Considering Available Tools * Selecting the Appropriate Tool * Oracle Net Database Connections * Oracle PAAS Database Connections * Setup SQL Developer * Setup SQL *Plus * Setup JDeveloper * About BIND and Substitution Variables * Using SQL Developer * Using SQL *Plus CHOOSING A DATABASE PROGRAMMING LANGUAGE * What is Database Programming * PL/SQL Programming * PL/SQL Performance Advantages * Integration with Other Languages PL/SQL LANGUAGE ESSENTIALS * PL/SQL Program Structure * Language Syntax Rules * Embedding SQL * Writing Readable Code * Generating Readable Code * Generating Database Output * SQL * Plus Input of Program Block DECLARE SECTION * About the Declare Section * Declare Primitive Types * Declaration Options * Not Null * Constant * Data Dictionary Integration * % Type * Declare Simple User-Defined Types * Type ? Table * Type ? Record * Extended User Defined Types BEGIN SECTION * About the Begin Section * Manipulating Program Data * Logic Control & Braching * GOTO * LOOP * IF-THEN-ELSE * CASE EXCEPTION SECTION * About the Exception Section * Isolating the Specific Exception * Pragma Exception_INIT * SQLCODE &SQLERRM Example * SQL%ROWCOUNT & Select ? Into BEYOND THE BASICS : EXPLICIT CURSORS * About Explicit Cursors * Extend Cursor Techniques * For Update of Clause * Where Current of Clause * Using for ? Loop Cursors INTRODUCTION DATABASE RESIDENT PROGRAMMING UNITS * About Database ? Resident Programs * Physical Storage & Execution * Types of Stored Program Units * Stored Program Unit Advantages * Modular Design Principles CREATING STORED PROCEDURES AND FUNCTIONS * Stored Procedures & Functions * Create Procedure / Create Function * Creating Procedures & Functions * Raise_Salary() Procedure * Salary_Valid() function * The Parameter Specification * Default Clause * System & Object Privileges * Using the Development Tools EXECUTING STORED PROCEDURES AND FUNCTIONS * Calling Procedures & Functions * Unit Testing with Execute * Anonymous Block Unit Testing * Specifying a Parameter Notation * SQL Worksheet Unit Testing * Calling Functions from SQL MAINTAINING STORED PROGRAMMING UNITS * Recompiling Programs * Mass Recompilation Using UTL_RECOMP() * Dropping Procedures & Functions * Drop Procedures & Functions * Drop Procedure / Function * Data Dictionary Metadata * Using USER_OBJECTS * Using USER_SOURCE * Using USER_ERRORS * Using USER_OBJECT_SIZE * Using USER_DEPENDENCIES MANAGING DEPENDENCIES * Dependency Internals * Tracking Dependencies * The Dependency Tracking Utility * SQL Developer Dependency Info * Dependency Strategy Checklists CREATING & MAINTAINING * About Packages * Creating Packages * Maintaining Packages * Performance Considerations ADVANCED PACKAGE CAPABILITIES * Definer & Invoker Rights * White Lists & Accessible By * Persistent Global Objects * Defining Initilization Logic * Object Orientation Support ADVANCED CURSOR TECHNIQUES * Using Cursor Variables * Using SYS_REFCURSOR * Using Cursor Expressions USING SYSTEM SUPPLIED PACKAGES * DBMS_OUTPUT() * UTL_FILE() * FOPEN() Example DATABASE TRIGGER CONCEPTS * About Database Triggers * DML Event Trigger Sub-Types * Database Trigger Scenario * Trigger Exhaustion Mechanisms * Trigger within SQL Worksheet CREATING DATABASE TRIGGERS * Statement Level Triggers * Using Raise Application_Error() * Row-Level Triggers * Examples of Triggers * Employee_Salary_Check Example * Employee_Journal Example * Budget_Event Example * Instead of Triggers * Triggers within and Application MAINTAINING DATABASE TRIGGERS * Call Syntax * Trigger Maintenance Tasks * Show Errors Trigger * Drop Trigger * Alter Trigger * Multiple Triggers for a Table * Handling Mutating Table Issues IMPLEMENTING SYSTEM EVENT TRIGGERS * What are System Event Triggers * Defining the Scope * Available System Events * System Event Attributes

Duration 5 Days 30 CPD hours This course is intended for Data Warehouse Administrator Database Administrators Support Engineer Technical Administrator Technical Consultant Overview Use Oracle Flashback Technologies to recover from human error Use Recovery Manager (RMAN) to create backups and perform recovery operations Use the Data Recovery Advisor to diagnose and repair failures Plan effective backup and recovery procedures Describe the Oracle Database architecture components related to backup and recovery operations Perform an encrypted database backup and restore Perform tablespace point-in-time recovery Configure the database for recoverability Describe Cloud Tooling for Backup and Recovery Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure In this Oracle Database 12c R2: Backup and Recovery Workshop, students learn how to perform backup and recovery based on the related Oracle Database architecture components. Various backup, failure, restore, and recovery scenarios are provided so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. This course includes an interactive workshop, with scenarios that provide participants with opportunities to diagnose and recover from several failure situations. INTRODUCTION * Curriculum Context * Assess your recovery requirements * Categories of failures * Oracle backup and recovery solutions * Oracle Maximum Availability Architecture * Oracle Secure Backup * Benefits of using Oracle Data Guard * Basic Workshop Architecture GETTING STARTED * Core Concepts of the Oracle Database, critical for Backup and Recovery * Oracle DBA Tools for Backup and Recovery * Connecting to Oracle Recovery Manager (RMAN) CONFIGURING FOR RECOVERABLILITY * RMAN commands * Configuring and managing persistent settings * Using the Fast Recovery Area (FRA) * Control File * Redo Log File * Archiving Logs USING THE RMAN RECOVERY CATALOG * Creating and Configuring the Recovery Catalog * Managing Target Database Records in the Recovery Catalog * Using RMAN Stored Scripts * Maintaining and Protecting the Recovery Catalog * Virtual Private Catalogs BACKUP STRATEGIES AND TERMINOLOGY * Backup Solutions Overview and Terminology * Balancing Backup and Restore Requirements * Backing Up Read-Only Tablespaces * Data Warehouse Backup and Recovery: Best Practices * Additional Backup Terminology PERFORMING BACKUPS * RMAN Backup Types * Incrementally Updated Backups * Fast Incremental Backup * Block Change Tracking * Oracle-Suggested Backup * Reporting on Backups * Managing Backups IMPROVING YOUR BACKUPS * Compressing Backups * Using a Media Manager * Backup and Restore for Very Large Files * Creating RMAN Multi-section Backups, Proxy Copies, Duplexed Backup Sets and Backups of Backup Sets * Creating and Managing Archival Backups * Backing Up Recovery Files * Backing Up the Control File to a Trace File * Cataloging Additional Backup Files USING RMAN-ENCRYPTED BACKUPS * Creating RMAN-Encrypted Backups * Using Transparent-Mode Encryption * Using Password-Mode Encryption * Using Dual-Mode Encryption DIAGNOSING FAILURES * Reducing Problem Diagnosis Time * Automatic Diagnostic Repository * Data Recovery Advisor * Handling Block Corruption RESTORE AND RECOVERY CONCEPTS * Restoring and Recovering * Instance Failure and Instance/Crash Recovery * Media Failure * Complete Recovery (Overview) * Point-in-Time Recovery (Overview) * Recovery with the RESETLOGS Option PERFORMING RECOVERY, PART I * RMAN Recovery in NOARCHIVELOG Mode * Performing Complete Recovery (of critical and noncritical data files) * Restoring ASM Disk Groups * Recovery with Image Files * Performing Point-in-Time (PITR) or Incomplete Recovery PERFORMING RECOVERY, PART II * Recovery of Server Parameter File, Control File (One and All) * Redo Log File Loss and Recovery * Password Authentication File Re-creation * Index, Read-Only Tablespace, and Temp file Recovery * Restoring the Database to a New Host * Disaster Recovery * Restoring RMAN Encrypted Backups RMAN AND ORACLE SECURE BACKUP * Oracle Secure Backup Overview and Interface Options * RMAN and OSB: Overview and Basic Process Flow * Starting with Oracle Secure Backup * Configuring Oracle Secure Backup for RMAN * RMAN Backup and Restore Operations * Oracle Secure Backup Jobs * Displaying OSB log files and transcripts for RMAN activities USING FLASHBACK TECHNOLOGIES * Flashback Technology: Overview and Setup * Using Flashback Technology to Query Data * Flashback Table * Flashback Transaction (Query and Back out) * Flashback Drop and the Recycle Bin * Flashback Data Archive USING FLASHBACK DATABASE * Flashback Database Architecture * Configuring Flashback Database * Performing Flashback Database * Best Practices for Flashback Database TRANSPORTING DATA * Transporting Data Across Platforms * Transporting Data with Backup Sets * Database Transport: Using Data Files PERFORMING POINT-IN-TIME RECOVERY * When to use TSPITR * TSPITR Architecture * Performing RMAN TS Point-in-time Recovery * Recovering Tables from Backups DUPLICATING A DATABASE * Using a Duplicate Database * Duplicating Database with 'push' and 'pull' techniques * Choosing Database Duplication Techniques * Creating a Backup-up Based Duplicate Database * Understanding the RMAN Duplication Operation RMAN TROUBLESHOOTING AND TUNING * Interpreting RMAN Message Output * Tuning Principles * Diagnosing Performance Bottlenecks * RMAN Multiplexing * Restore and Recovery Performance Best Practices CLOUD TOOLING FOR BACKUP AND RECOVERY * Backup Destinations * Customize Backup Configuration * On-Demand Backup and Recovery * Oracle Backup Cloud Service * Installing the Backup Module BACKUP AND RECOVERY WORKSHOP * Workshop Structure and Approach * Business Requirements for Database Availability and Procedures * Diagnosing the Failures

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

Duration 5 Days 30 CPD hours This course is intended for The target audience for this textbook is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this textbook will be helpful are: ? Business and non-IT professionals ? Application designers and database developers ? Business Intelligence (BI) analysts and consumers ? Database administrators ? Web server administrators Overview The first portion of this textbook considers the logical models upon which a relational database is based and the various configurations and environments in which you may work with the Oracle database. The next segment focuses on the actual SQL syntax for writing database queries. You will begin with the simplest of queries and then proceed onto moderately complex query scenarios. Finally, this textbook covers the DDL, DML and transaction control portions of the SQL language that allow one to create, maintain and manipulate application database objects and application data. This textbook takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle. RELATIONAL DATABASES & DATA MODELS * About Data Models * About the Relational Model * The Electronics Data Model * About the Relational DBMS SELECTION & SETUP OF THE DATABASE INTERFACE * Considering Available Tools * Selecting the Appropriate Tool * Oracle Net Database Connections * Oracle PAAS Database Connections * Setup SQL Developer * Setup SQL*Plus * Setup Jdeveloper USING THE DATABASE INTERFACE * About Bind & Substitution Variables * Using SQL Developer * Using SQL*Plus INTRODUCTION TO THE SQL LANGUAGE * About the SQL Language * Characteristics of SQL * Introducing SQL Using Select * SQL Rules THE SELECT STATEMENT * The Select Statement * Distinct/Unique Keyword * Using Alias Names RESTRICTING RESULTS WITH THE WHERE CLAUSE * About Logical Operators * Equality Operator * Boolean Operators * REGEXP_LIKE() * In Operator SORTING DATA WITH THE ORDER BY CLAUSE * About the Order by Clause * Multiple Column Sorts * Specify the Sort Sequence * About Null Values within Sorts * Using Column Aliases PSEUDO COLUMNS, FUNCTIONS & TOP-N QUERIES * Rowid Pseudo Column * ORA_ROWSCN PSEUDO Column * ROWNUM Pseudo Column * About the Built-In Functions * SYSDATE * User & UID * SESSIONTIMEZONE Function * Using the Dual Table * Row Limiting & Top-N Queries * FETCH First x Rows Only Clause * OFFSET x Rows Clause * FETCH?PERCENT Clause * The WITH TIES Option JOINING TABLES * About Joins * Inner Joins * Reflexive Join * Non-Key Join * Outer Join USING THE SET OPERATORS * About the Set Operators * SQL Set Operator Examples * UNION Example * INTERECT Example * MINUS Example * UNION All SUMMARY FUNCTIONS USING SUB-QUERIES * Finding Data with Sub-Queries * Standard Sub-Queries * Correlated Sub-Queries * The EXISTS Operator AGGREGATING DATA WITHIN GROUPS * About Summary Groups * Find Groups within the Tables * Select Data From the Base Tables * Select Groups from the Results USE DDL TO CREATE & MANAGE TABLES * Create Table Statement * Column Data Types * Not Null * Default * Describe * Alter Table Statement * Drop Table Statement * Table DDL Using SQL Developer * Alter User Statement * Alter Session Statement * NLS_Language * NLS_Date USE DML TO MANIPULATE DATA * The Insert Statement * The Delete Statement * The Update Statement * About Transactions * Transaction Rollback * Transaction Commit * Transaction Savepoint * The Set Transaction Statement * Set Transaction Read Only Statement Rules UNDERSTANDING THE DATA MODELS * The Company Data Model * The Electronics Data Model ABOUT THE SQL-99 STANDARD * SQL-92 & SQL-99 * Cross Joins * Natural Joins * Inner Joins * Implicit Inner Join * Outer Joins * Anti Joins * Named Sub-Queries * ENHANCING GROUPS WITH ROLLUP & CUBE * Using Rollup * The Grouping() Function * Using Cube SQL FUNCTIONS: CHARACTER HANDLING * What are the SQL Functions? * String Formatting Functions * UPPER(), LOWER() Example * INITCAP() Example * Character Codes Functions * CHR((), ASCII() Examples * PAD & TRIM Functions * RPAD() Example * RTRIM() Example * TRIM() Example * String Manipulation Functions * DECODE () Example * SUBSTR() Example * INSTR() Example * TRANSLATE() Example * REPLACE() Example * String Comparison Functions * LEAST() Example * Phonetic Search Function * SOUNDEX() Example SQL FUNCTIONS: NUMERIC HANDLING * About the Numeric Data Functions * GREATEST() Example * ABS() Example * ROUND() Example * TRUNC() Example * SIGN() Example * TO_NUMBER() Example & Data ype Conversions * NULL VALUES FUNCTIONS * NVL() & NVL2() Function * NVL() Example (Character) * NVL() Example (Numeric Loss of Data) * NVL() Example (Numeric Output) * NVL2() Example * COALESCE() Function * NULLIF() Function SQL FUNCTIONS: DATE HANDLING * Date Formatting Functions * TO_CHAR() & TO_DATE() Format Patterns * TO_CHAR() Examples * TO_DATE() Examples * EXTRACT() Example * Date Arithmetic Functions * MONTHS_BETWEEN() Example * ADD_MONTHS() Example * LAST_DAY() Example * NEXT_DAY() Example * TRUNC(), ROUND() Dates Example * NEW_ TIME() Example * About V$TIMEZONE_NAMES * CAST() FUNCTION & TIME ZONES DATABASE OBJECTS: ABOUT DATABASE OBJECTS * About Database Objects * About Schemas * Making Object References DATABASE OBJECTS: RELATIONAL VIEWS * About Relations Views * The Create View Statement * Why Use Views? * Accessing Views with DML * Maintaining View Definitions * Alter View * Drop View * DDL Using SQL Developer * DATABASE OBJECTS: INDEXES * About Indexes * Create & Drop Index Statements * Indexes & Performance * Data Dictionary Storage DATABASE OBJECTS: CREATING OTHER OBJECTS * About Sequences * Referencing NEXTVAL * Referencing CURRVAL * Within the DEFAULT Clause * Alter Sequence & Drop Sequence * ALTER SEQUENCE * DROP SEQUENCE * About Identity Columns * CREATE TABLE?GENERATED AS IDENTITY * ALTER TABLE?GENERATED AS IDENTITY * Start With Limit Value * ALTER TABLE...DROP IDENTITY * About Synonyms * CREATE & DROP SYNONYM Statements * CREATE SYNONYM * DROP SYNONYM * Public Vs Private Synonyms * CREATE SCHEMA AUTHORIZATION DATABASE OBJECTS: OBJECT MANAGEMENT USING DDL * The RENAME Statement * TABLESPACE Placement * CREATE TABLE?TABLESPACE * The Comment Statement * The TRUNCATE TABLE Statement DATABASE OBJECTS: SECURITY * About Object Security * Grant Object Privileges * Revoke Object Privileges * Object Privileges & SQL Developer DATA INTEGRITY USING CONSTRAINTS * About Constraints * NOT NULL Constraint * NOT NULL Example * CHECK Constraint * UNIQUE Constraint * PRIMARY KEY Constraint * REFERENCES Constraint * ON DELETE CASCADE Example * ON DELETE SET NULL Example * Constraints on Existing Tables * Constraints & SQL Developer MANAGING CONSTRAINT DEFINITIONS * RENAMING & DROPPING Constraints * ENABLING & DISABLING Constraints * DEFERRED Constraint Enforcement * SET CONSTRAINTS * Handling Constraint Exceptions * Constraints with Views * DATA Dictionary Storage THE DATA DICTIONARY STRUCTURE * More About the Data Dictionary * OBJECT-SPECIFIC Dictionary Views * USER_UPDATABLE_COLUMNS * The Dictionary Structure * METADATA & SQL Developer ADDITIONAL COURSE DETAILS: Nexus Humans Oracle 12c SQL Fundamentals training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Oracle 12c SQL Fundamentals course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 3 Days 18 CPD hours This course is intended for This hands-on course is geared for experienced DBAs already working with Oracle. Overview This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert facilitator, you'll learn how to: Implement backup and recovery settings and perform backup operations to the media of your choice. Move data between databases and files Use Oracle Database recovery processes to recover from media and other failures. Diagnose and repair data failures Use flashback technologies and data duplication to complement backup and recovery procedures Secure the availability of their database using backup and recovery strategies Geared for DBAs and other technical support staff, Oracle Database 19c Backup and Recovery is a hands-on course that allows you to develop appropriate backup and recovery procedures to address their business model and requirements. Throughout the course you?ll explore how to implement basic backup and recovery procedures, move data between databases and files, and employ basic monitoring procedures. You?ll also learn how to secure the availability of a database by using appropriate backup and recovery strategies, how to how to perform backup and recovery operations using RMAN, and how to use Flashback features to recover from human error. This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert facilitator, you?ll learn how to:Implement backup and recovery settings and perform backup operations to the media of your choice.Move data between databases and filesUse Oracle Database recovery processes to recover from media and other failures.Diagnose and repair data failuresUse flashback technologies and data duplication to complement backup and recovery proceduresSecure the availability of their database using backup and recovery strategies BACKUP METHODS * User Managed Backups * Oracle Managed Backups Types of Failures * Types of Recoveries RECOVERY CONFIGURATION * Configuring the Database for Archivelog * Configuring the Database for No-Archivelog * Configuring the Flash Recovery Area CONFIGURING RMAN * RMAN Default Settings * Command Line * Enterprise Manager RMAN BACKUPS * Full RMAN Backup * Compressed Backups * Uncompressed Backups * Partial RMAN Backup * Incremental Backups * Change Tracking File MANAGING BACKUPS * Backup Reports * Backup Maintenance * Backup Catalog * Backup Crosscheck RMAN COMPLETE RECOVERY * RMAN Complete Recovery * Database Recovery * Tablespace Recovery * Datafile Recovery RMAN IN-COMPLETE RECOVERY * Time Based Recovery * Sequence Based Recovery * SCN Based Recovery NON-DATABASE FILE RECOVERY * Spfile Recovery * Controlfile Recovery * Incremental Recovery * Flash Recovery Area for a Fast Recovery USER MANAGED BACKUP * Configuring User Managed Backups * Perform a User Managed Backup USER MANAGED RECOVERY * User Managed Complete Recovery * User Managed Incomplete Recovery CONFIGURING FLASHBACK * Flashback Query * Flashback Drop * Flashback Database PERFORMING FLASHBACK RECOVERIES * Flashback Query * Flashback Drop * Flashback Transaction Query * Flashback Versions Query PERFORMING FLASHBACK DATABASE * Determining the FRA Size * FRA Retention * Performing a Flashback Database RMAN DUPLICATE COMMAND * Setting up for a Duplicate Database * Creating the Duplicate spfiles * Performing the Duplicate Command. RMAN RECOVERY CATALOG * Configuring for the Recovery Catalog * Creating the Recovery Catalog BACKUPS WITH THE RECOVERY CATALOG * Registering the Database with the Recovery Catalog * Performing Backups with the Recovery Catalog RECOVERIES WITH THE RECOVERY CATALOG * Identifying Type of Recoveries with the Recovery Catalog * Performing Recoveries with the Recovery Catalog RECOVERY CATALOG MAINTENANCE * Registering Additional Databases with the Recovery Catalog * Cataloging Additional Backups with the Recovery Catalog * Recovery Catalog Scripts DATAPUMP * Configuring Datapump * DataPump Exports * DataPump Imports TUNING RMAN * RMAN Sessions * RMAN Channels * RMAN Job Progress ADDITIONAL COURSE DETAILS: Nexus Humans Oracle 19c Database Backup and Recovery (TTOR21619) 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 Backup and Recovery (TTOR21619) 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 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.