Filter by Topic
Filter by Vendor
Oracle Database 11g: RAC Administration eLearning
Course Description: In this course, you will be introduced to …
What you'll learn
Install Oracle Clusterware and RAC
Administer a RAC Database and Oracle Clusterware
RAC Performance Tuning
Configure, Manage, and Use Database Services in a RAC environment
Administer Oracle Clusterware
Diagnose Oracle Clusterware and Node Management
High Availability in RAC
Add/Remove a node to/from a cluster
Patch Oracle Clusterware and RAC software
Oracle11g Admin eLearning
Course Description: Oracle Database 11g delivers economies of scale on …
What you'll learn
Elements of the Oracle Database 11g architecture and the tools and steps required to install the Oracle Database 11g software
Steps for creating a new Oracle Database 11g database and then configuring it and managing the instance
Steps for configuring new Oracle Net Listeners and database connectivity
Steps for maintaining storage structures and automating storage management in Oracle Database 11g and for managing privileges, roles, and other security features for users
Steps for managing schema objects, such as tables, views, and indexes, and recognize ways to use SQL and PL/SQL commands to manipulate data and ensure data concurrency
Steps required to manage undo information, secure an Oracle Database 11g database, and maintain it by monitoring statistics, automated tasks and alert thresholds
Steps for ensuring an Oracle Database 11g database is available to users when needed by monitoring its performance, anticipating and avoiding database failure, setting up instance recovery options, and creating backups
Ways to make use of Oracle Database 11g’s tools for moving and recovering data, reporting on problems, and installing updates to enhance a database
Oracle 11g: Programing with PL/SQL eLearning
Course Description: Oracle Database 11g delivers economies of scale on …
What you'll learn
Steps for getting started with PL/SQL, benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules
Steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures.
Ways to create user-defined PL/SQL records and INDEX BY tables and steps for declaring and controlling explicit cursors and cursors with parameters
Ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables
Steps for getting started with PL/SQL, benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules
Steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures
Ways to create user-defined PL/SQL records and INDEX BY tables and steps for declaring and controlling explicit cursors and cursors with parameters
Ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables
Steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their ex
Steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code
Steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warnings
Steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies
Oracle 11g: Administration II eLearning
Course Description: Oracle Database 11g delivers economies of scale on …
What you'll learn
Structural elements in Oracle Database 11g’s architecture, including and Automatic Storage Management (ASM), and the steps for managing storage using disk groups
Steps for configuring all aspects of backup and recovery functionality in Oracle Database 11g using ARCHIVELOG mode, retention policies, a Flash Recovery Area, and an RMAN recovery catalog
Steps for preparing a database for backup and for performing various types of RMAN backups and monitoring them using reports and dynamic performance views
Steps for performing user-managed backups and recoveries
Ways to use RMAN to ensure that data is not lost in Oracle Database 11g by performing complete and incomplete recoveries as well as disaster recoveries, by cloning databases, and by restoring a tablespace to a particular point in time
Steps for making sure that you can recover data quickly by tuning RMAN to avoid bottlenecks and for making sure that any changes to a database can be easily reversed, if necessary, using Oracle Database 11g’s flashback features
Steps for diagnosing and repairing database problems with the help of Oracle Support using Automatic Diagnostic Repository, Support Workbench, and health checks, and for enabling and configuring automatic memory management and automatic shared memory management
Steps for making sure your Oracle Database 11g database is performing well and has adequate space, by monitoring statistics, tuning SQL, testing workloads, managing space, and transporting tablespaces
Ways to ensure that resources are being put to best use and database jobs are performed when they should be using the Database Resource Manager and the Scheduler
Steps for utilizing Oracle Database 11g’s globalization support features to ensure that information and data is displayed in a user’s native language and that territory and language-dependent conventions are adhered to
Oracle Database 19c Backup and Recovery (TTOR21619)
Geared for DBAs and other technical support staff, Oracle Database …
What you'll learn
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
Oracle 19C Database Multitenant Architecture (TTOR20719)
Oracle 19c Database Multitenant Architecture is a hands-on, three-day course …
What you'll learn
<b>CDB Management Skills</b>: Gain expertise in managing Container Databases (CDBs), including setup, configuration, and maintenance.
<b>PDB Operations Proficiency</b>: Develop the ability to efficiently handle Pluggable Database (PDB) operations like creation, cloning, and management.
<b>Database Security Measures</b>: Learn to implement and manage security protocols in both CDBs and PDBs, ensuring data integrity and compliance.
<b>Backup and Recovery Techniques</b>: Master the techniques for performing backups and recoveries of CDBs and PDBs, ensuring data safety and continuity.
<b>Performance Optimization</b>: Acquire skills to optimize the performance of databases within the Oracle Multitenant environment, including tuning and resource allocation.
<b>Data Movement and Storage Management</b>: Understand and apply methods for effective data movement and storage management in a Multitenant architecture.
Oracle 19c Database Administration I (Oracle 19c DBA I) (TTOR20519)
Oracle 19C Database Administration I (Oracle DBA I) is a …
What you'll learn
How to use tools to access an Oracle Database
Generate database creation scripts by using DBCA
How to create a container database (CDB) by using the CREATE DATABASE command
Learn about Startup and shut down Oracle databases
Initialization parameter files and initialization parameters
Tools that are used to administer Oracle Net Services
How to use the Oracle Connection Manager Control utility to administer Oracle Connection Manager
How to create a new PDB from the PDB seed
Logical and physical storage structures in an Oracle database
Usage of Oracle Database features that save space
Explanation of DML and undo data generation
Learn about general architecture of Oracle Data Pump and SQL*Loader
How to use SQL*Loader to load data from a non-Oracle database (or user files)
<b>Bonus Content / Time Permitting:</b> Explanation of maintenance windows
<b>Bonus Content / Time Permitting:</b> Employ basic monitoring procedures and manage performance
Oracle 19c PL/SQL Fundamentals (TTOR12019)
Oracle 19c PL/SQL Fundamentals is a three-day, hands-on technical course …
What you'll learn
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.
