Introduction You can use the AWS Console Manager to manage the RDS PostgreSQL instance, alternatively, you can manage the RDS…
Database Administrator
How to change MySQL Data Directory on Ubuntu: A Step-by-Step Guide
Introduction In this tutorial, How To Move a MySQL Data Directory to a New Location on Ubuntu. I will change…
Mastering mysqldump: Essential Techniques for Backing Up and Restoring MySQL Databases
In this guide, I will show you how to back up and restore MySQL or MariaDB databases using the mysqldump…
How to Reset MariaDB root password on Centos: A Simple Guide
Introduction MariaDB is free and Open-source. It is the famous fork of the MySQL database. In this tutorial, How to…
Oracle notes for beginners: Your Essential Guide to Getting Started
Introduction In this tutorial, Oracle notes for beginners. How to query commands useful in Oracle database. Diving into the world…
Setting Up Oracle Automatic Startup on Linux: A Comprehensive Guide
Introduction In this tutorial, How to confirm Oracle automatic startup on Linux. How to make Oracle start automatically in Linux.…
How to connect to Pluggable Databases in Oracle 19: A Step-by-Step Guide
Introduction In this tutorial, I used the Default Service for connecting to the PDB. Made in the tnsnames.ora file that…
Install Oracle client 18.3 on centos 7
In this tutorial, How to install Oracle client 18.3 on Centos 7. Bach server (sqlplus,sqlldr, etc) <–> Oracle server Your…
TKPROF using trace analyzer to trace SQL
Introduction In this tutorial, we will explore how to use TKPROF with a trace analyzer to trace SQL in an…
Oracle v$system_parameter: A Guide for Database Administrators
Introduction Discover how to effectively query the Oracle v$system_parameter. You’ll learn essential SQL commands to access and manage system parameters…