| Oracle Database 19c: SQL | Overview of Relational Database Management Concepts and Terminologies |
| SQL Statements list used in SQL Course |
| Human Resources (HR) Schema Description |
| Database objects Concept |
| Concept of Table structure |
| Using Basic SELECT Statements |
| Using Concatenation in SQL Statement |
| Using DISTINCT KEYWORD in SQL Statement |
| Using Calculations in SQL Statement |
| Using Column Alias in SQL Statement |
| Using Where Clause in SQL Statement |
| Using Order by Clause in SQL Statement |
| Using TO_CHAR and TO_DATE function in SQL Statement |
| Using UPPER, LOWER, INITCAP function in SQL Statement |
| Using ROUND, TRUNC function in SQL Statement |
| Using LPAD, RPAD function in SQL Statement |
| Using NVL Function in SQL Statement |
| Using CASE Expression in SQL Statement |
| Using Decode function in SQL Statement |
| Using Group Functions in SQL Statement |
| Using Group by Clause in SQL Statement |
| Using Having Clause in SQL Statement |
| Using JOIN in SQL Statement |
| Using NATURAL JOIN in SQL Statement |
| Using Clouse in SQL Statement |
| Using ON Clause in SQL Statement |
| Using Subquery in SQL Statement |
| Using With clause in SQL Statement |
| Concept of Data types |
| Concept of Constraints |
| Creating Table as Schema object |
| Oracle Database 19c: Administration Workshop |
| Introduction | Course Objectives |
| Enterprise Cloud Computing |
| Database Architecture | Oracle Database Server Architecture: Overview |
| Instance: Database Configurations |
| Connecting to the Database Instance |
| Understanding the Multitenant Architecture |
| Database Architecture (Memory) | Understanding the Memory Architecture (This is important as understanding this will help you solve lot of critical performance issues) |
| Understanding the Shared pool |
| Understanding the Database buffer cache |
| Understanding the Redo Log Buffer |
| Understanding the Large pool |
| Understanding the Java pool |
| Understanding the Streams pool |
| Understanding the Program Global Area (PGA) |
| Database Architecture (In-Memory) | Understanding the In-Memory Column Store and Full Database In-Memory Caching (This is important as understanding this will help you solve lot of critical performance issues) |
| In-Memory Column Store: Introduction |
| Understanding the In-Memory Column Store |
| Full Database In-Memory Caching |
| Database Architecture (Process) | Understanding the Process Architecture (This is important as understanding this will help you solve lot of critical performance issues) |
| Understanding the Database Writer Process (DBWn) |
| Understanding the Log Writer Process (LGWR) |
| Understanding the Checkpoint Process (CKPT) |
| Understanding the System Monitor process (SMON) |
| Understanding the Process Monitor process (PMON) |
| Understanding the Recoverer Process (RECO) |
| Understanding the Listener Registration Process (LREG) |
| Understanding the Archiver Processes (ARCn) |
| Database Architecture (Storage) | Understanding the Logical and Physical Database Structures |
| Understanding the Segments, Extents, and Blocks |
| Understanding the Tablespaces and Data Files |
| Understanding the SYSTEM and SYSAUX Tablespaces |
| Oracle Container Database | Understanding the Oracle Container Database |
| Understanding the Oracle Database 11g architecture |
| Understanding the Multitenant Architecture |
| Understanding the Interaction with an Oracle Database: Memory, Processes, and Storage |
| Installing Oracle Database | Installing Oracle Database 19c |
| Configuring and Creating CDB and PDBs |
| Connect to a PDB using a service name |
| Database Management Tools | Using SQL*Plus |
| Oracle SQL Developer: Connections |
| Oracle SQL Developer: DBA Actions |
| Configuring Enterprise Manager |
| Managing the Database Instance(Parameter files)) | Initialization Parameter Files |
| Types of Initialization Parameters |
| Simplified Initialization Parameters |
| Initialization Parameters: Examples |
| Using SQL*Plus to View Parameters |
| Changing Initialization Parameter Values |
| Changing Parameter Values: Examples |
| Managing the Database Instance(Startup)) | Describe database startup options |
| Starting Up an Oracle Database Instance: NOMOUNT |
| Starting Up an Oracle Database Instance: MOUNT |
| Starting Up an Oracle Database Instance: OPEN |
| Startup Options: Examples |
| Managing the Database Instance(Shutdown)) | Describe database shutdown options |
| Shutdown Modes |
| Shutdown Options |
| Shutdown Options: Examples |
| View the alert log, Access dynamic performance views |
| Dynamic Performance Views: Considerations |
| Data Dictionary: Overview |
| Data Dictionary Views |
| Configuring the Oracle Network Environment | Oracle Net Services: Overview |
| Oracle Net Services |
| Oracle Net Listener |
| Establishing Oracle Network Connections |
| Connecting to an Oracle Database |
| Name Resolution |
| Establishing a Connection |
| Easy Connect |
| Local Naming |
| Tools for Configuring and Managing the Oracle Network |
| Defining Oracle Net Services Components |
| Using Oracle Net Manager |
| Using Oracle Net Configuration Assistant |
| Listener Control Utility |
| Listener Control Utility Syntax |
| Testing Oracle Net Connectivity |
| Comparing Dedicated Server and Shared Server Configurations |
| User Sessions: Dedicated Server Process |
| User Sessions: Shared Server Processes |
| SGA and PGA Usage |
| Shared Server Configuration Considerations |
| Configuring Communication between Databases |
| Connecting to another Database |
| Administering User Security | Database User Accounts |
| Predefined Administrative Accounts |
| Administrative Privileges |
| Protecting Privileged Accounts |
| Authenticating Users |
| Administrator Authentication |
| Creating and Authenticating a User’s |
| Unlocking a User Account and Resetting the Password |
| Privileges |
| System Privileges & Object Privileges |
| System Privileges |
| Revoking System Privileges with ADMIN OPTION |
| Granting Object Privileges |
| Object Privileges |
| Revoking Object Privileges with GRANT OPTION |
| Role Management | Using Roles to Manage Privileges |
| Assigning Privileges to Roles and Roles to Users |
| Predefined Roles |
| Creating a Role |
| Profiles and Users |
| Implementing Password Security Features |
| Creating a Password Profile |
| Supplied Password Verification Functions |
| Modifications to the Default Profile |
| Creating a User |
| Assigning Roles to Users |
| Assigning Quota to Users |
| Managing Database Storage Structures | How Table Data Is Stored |
| Database Block: Contents |
| Manage the Navigation Menu |
| Exploring the Storage Structure |
| Tablespaces Created by Default: Overview |
| Creating a Permanent Tablespace |
| Creating and Altering a Temporary Tablespace |
| Creating and Altering Undo Tablespace |
| Dropping Tablespaces |
| Oracle Managed Files (OMF) |
| Managing Undo Data | Undo Data |
| Transactions and Undo Data |
| Storing Undo Information |
| Undo Data Versus Redo Data |
| Managing Undo |
| Configuring Undo Retention |
| Categories of Undo |
| Guaranteeing Undo Retention |
| Changing an Undo Tablespace to a Fixed Size |
| Temporary Undo: Overview |
| Temporary Undo: Benefits |
| Enabling Temporary Undo |
| Managing Data Concurrency | Locks |
| Locking Mechanism |
| Data Concurrency |
| DML Locks |
| Enqueue Mechanism |
| Lock Conflicts |
| Possible Causes of Lock Conflicts |
| Detecting Lock Conflicts |
| Resolving Lock Conflicts |
| Resolving Lock Conflicts Using SQL |
| Deadlocks |
| Implementing Oracle Database Auditing | Database Security |
| Monitoring for Compliance |
| Types of Activities to be audited |
| Backup and Recovery Concepts | Part of DBA's Job |
| Categories of Failure |
| Statement Failure |
| User Process Failure |
| Network Failure |
| User Error |
| Instance Failure |
| Understanding Instance Recovery: Checkpoint (CKPT) Process |
| Understanding Instance Recovery: Redo Log Files and Log Writer |
| Instance Recovery |
| Phases of Instance Recovery |
| Tuning Instance Recovery |
| Media Failure |
| Configuring for Recoverability |
| Configuring the Fast Recovery Area |
| Multiplexing Control Files |
| Multiplexing the Redo Log |
| Archive Log Files |
| The Archiver (ARCn) Process |
| Enabling ARCHIVELOG Mode |
| Performing Database Backups | Backup Solutions: Overview |
| Oracle Secure Backup |
| User-Managed Backup |
| Understanding Backup Terminology |
| Understanding Types of Backups |
| RMAN Backup Types |
| Using RMAN Commands to Create Backups |
| Performing Database Recovery | Opening a Database |
| Keeping a Database Open |
| Loss of a Control File |
| Loss of a Redo Log File |
| Loss of a Data File in NOARCHIVELOG Mode |
| Loss of a Noncritical Data File in ARCHIVELOG Mode |
| Loss of a System-Critical Data File in ARCHIVELOG Mode |
| Moving Data | Moving Data: General Architecture |
| Oracle Data Pump: Overview |
| Oracle Data Pump: Benefits |
| Directory Objects for Data Pump |
| Creating Directory Objects |
| Data Pump Export and Import Clients: Overview |
| Data Pump Utility: Interfaces and Modes |
| Performing a Data Pump Export |
| Performing a Data Pump Import |
| Data Pump Import: Transformations |
| SQL*Loader: Overview |
| SQL*Loader Control File |
| Loading Methods |
| Loading Data |
| SQL*Loader Express Mode |
| External Tables |
| External Table: Benefits |
| Defining an External Tables with ORACLE_LOADER |
| External Table Population with ORACLE_DATAPUMP |
| Using External Tables |
| Using Oracle Scheduler to Automate Tasks | Simplifying Management Tasks |
| Understanding a Simple Job |
| Oracle Scheduler Core Components |
| Using Oracle Scheduler |
| Oracle Database: 19c | New Features |
| Oracle Database: 21c | New Features |