Database
MySQL, PostgreSQL, Oracle and database management
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...
Oracle Database Learning: Part 1 – Architecture & Core Concepts
Begin your Oracle DBA journey by understanding the database architecture — instance, memory structures, background proce...