Database
MySQL, PostgreSQL, Oracle and database management
Oracle Data Guard Configuration on Oracle Linux 7.8 & Database 19c
Oracle Data Guard is a comprehensive disaster recovery and high availability solution built into Oracle Database. It mai...
Oracle Database DataPump expdp impdp
Oracle Data Pump is a powerful utility for exporting and importing database objects and data. It was introduced in Oracl...
Oracle database architecture
Oracle Database is a Relational DataBase Management system (RDBMS) that is widely used for enterprise-level applications...
Oracle Database 19c Installation
Oracle Database 19c is the latest long-term support release of the Oracle Database software from Oracle Corporation. It...
Configuring the Database Archiving Mode in Oracle 12C
To back up the database while it is open (database open mode), or to be able to perform complete or point-in-time media...
Oracle Database Learning: Part 4 – Advanced SQL: Joins, Subqueries & Analytical Functions
Take your SQL skills further with multi-table JOINs, correlated subqueries, CTEs (WITH clause), PIVOT/UNPIVOT, and power...
Oracle Database Learning: Part 5 – PL/SQL Essentials: Blocks, Cursors & Procedures
Learn Oracle PL/SQL from scratch — anonymous blocks, variables, control flow, explicit and implicit cursors, procedures,...
Oracle Database Learning: Part 3 – SQL Fundamentals: DDL & DML
Master Oracle SQL from the ground up — data types, DDL (CREATE, ALTER, DROP), DML (INSERT, UPDATE, DELETE, MERGE), const...
Oracle Database Learning: Part 2 – Installation & Initial Configuration
Step-by-step guide to installing Oracle 19c on Linux, configuring the listener, creating a database with DBCA, and setti...