Oracle DBA Certification Training

• How does it function? Oracle database, Pre-requisites, and multiple non-CDB’s shares nothing 
• What is the Oracle database? 
• How does it function? 
• Oracle Database 12c installation, multi-tenant architecture 
• Oracle database, Pre-requisites, multiple non-CDB’s shares nothing 
• Multitenant container database, pluggable database Database Introduction 
• What is the Oracle database? 
• Multitenant container database, pluggable database
• Non-CDB oracle system data mixed with user data

• The Architecture of Oracle server 
• The various file types – control files, data files, redo log files, and benefits of CDB 
• The key components – Oracle Instance and Oracle Database 
• Contents of CDB and pluggable DB, redo log files and control files 
• Pluggable database (PDB), easier management of the database, support for Oracle database resource manager, and database instance

• Logical storage units like tablespaces, data blocks, extents, and segments 
• Local user and common user, local privileges and common privileges 
• Operating System blocks, table statement and way to check “create table” 
• The instance, the CDB, containers, root containers, PDB
• Database configuration assistant
• Steps to create a container database 
• The basics of Oracle Storage structures 
• Database Schemas, Schema Objects 
• Creating a container database using sqlplus

• The Oracle Instance consists of memory structures and background processes 
• Steps involved in PDB, using PDB$SEED, without FILE_NAME_CONVERT, synchronization 
• Learn about the Oracle process and memory architecture, redo log buffer, shared pool, and buffer cache Different methods of creating PDB 
• Plug a non-CDB into CDB using DBMS_PDB, Plug a non-CDB to CDB, clone PDBS, plug and unplug, plug unplugged CDB into CDB

• Learn how this can be deployed for Oracle Administration and support
• The Oracle background process errors can be monitored using the Trace Files and Alert Logs

• The methodology of starting a database instance, preparing for a startup, initializing parameter files, and serving user requests 
• Understanding of the Server process and user process 
• Determining which PDB you are in, four functions, opening, closing, and altering the open mode of PDBS Setting the default and temporary tables places for a PDB 
• Instance parameter change impact
• Using the alter system command from within a PDB 
• Administrative activities on PDB, new views associated with PDBS

• What is automatic data optimization, heat map, and ADO? 
• Creating Compression Policies, Creating storage tiering policy, Preparing evolution and execution
• DBA Heat map Segment view, monitoring statistics

• Automatic Data Optimization, Reduction Policies, Alter Policy

• Learn about the powerful Oracle database security features 
• Data privacy, regulatory compliance, “create user” process, altering and dropping users 
• Activity monitoring and blocking
• Generating profiles and limiting resources, auditing

• Understanding of Database Schema objects 
• Learning how data is stored in database tables 
• The various types available like views, tables, clusters, indexes, sequence, database links, packages, and procedures 
• Creating temporary tables and external tables

• Managing resource between PDBs, CDB resource plan basics: share 
• Enabling a CDB resource plan, managing a PDB resource plan
• CDB resource plan basics: Limit 
• Resource manager. Resource manager and pluggable database 
• Creating a CDB resource plan ϖ Creating a CDB resource plan: SQL example

• Deploying a user-generated schema object for generating a sequence 
• Mastering the database Schema objects 
• Learn about data concurrency and data consistency in multi-user databases 
• The concepts of Locking and Deadlocks
• Learning Materialized View 
• The balanced search tree index structure for placing and locating files

• The Oracle Network Environment and database link 
• Starting up an instance, MOUNT, OPEN, SHOUT DOWN, NOMOUNT, PDB, OPEN, clone PDBS
• Connecting to the database 
• Study the client/server Network Environment, configuring the network

• CDB backup and recover, archiving challenges and solutions, in-database archiving 
• New administrative privileges: SYSDG 
• New administrative privileges: SYSKM
• Security and performance: audit architecture 
• Consolidation: a unique audit trail, extended audit information, data pump audit policy 
• New administrative privileges: SYSBACKUP 
• New administrative privileges
• The database testing, database standby, Media recovery options, back up in the offline mode 
• Understand how Oracle database ecosystem backup and recovery is deployed

• Learn about SQL Loader, Oracle Data Pump for import and export and support for External Table
• Management and restoration of entire databases 
• Learn the significance of Oracle Recovery Manager, how it deploys performance  

• Get complete knowledge to work with Oracle DBA, connection access DBA 
• The Oracle Data Dictionary contains information related to database privileges 
• Provisioning new pluggable databases NOARCHIVELOG mode, media failure, flashback CDB, data dictionary views
• Objects, users, and roles 
• Data dictionary views, after CDB creation, alert log file 
• Learn Dynamic Performance Table for identifying instance-level problems

• Introduction to database tuning, ensuring higher throughput 
• Understanding Oracle Chained Rows and Locks
• Index Statistics and Table Statistics for tuning the database 
• Lowering the response time of time-critical applications, optimizing the storage space 
• SQL scripts, deploying Index Selectivity

• Deep diving into Oracle Database Tuning, shared pool tuning 
• Deploying PL/SQL code, code reuse, the database buffer
• Improving performance using Data Dictionary, tuning of Data Dictionary

Project 1: Tuning of the Database

Project 2: Building an airline ticketing website

Project 3: HR management powered by oracle database