AITB International Conference, 2019

Kathmandu, Nepal

My Youtube Channel

Please Subscribe

Flag of Nepal

Built in OpenGL

World Covid-19 Data Visualization

Choropleth map

Word Cloud in Python

With masked image

Showing posts with label database. Show all posts
Showing posts with label database. Show all posts
Thursday, May 29, 2025

List of important Data Dictionary queries in Oracle 19c

›
 Here's a comprehensive list of important Data Dictionary queries in Oracle 19c and the useful information you can extract from each. ...

ERD of Oracle HR Schema

›
 

Process to import SAKILA Schema in Oracle database

›
 #####Create a directory for sakila files mkdir /u01/app/oracle/sakila cd /u01/app/oracle/sakila -------------------------------------------...
Monday, May 26, 2025

Explanation of Parameters of Control file used while creation in Oracle Database

›
  CREATE CONTROLFILE REUSE DATABASE "ORCLTRN" NORESETLOGS  ARCHIVELOG     MAXLOGFILES 16     MAXLOGMEMBERS 3     MAXDATAFILES 100 ...
Wednesday, September 11, 2024

Classification of SQL Queries

›
SQL (Structured Query Language) is a standard language for managing and manipulating databases. SQL is divided into different languages or s...

Query to Connect all tables of Sakila Database of MYSQL

›
select g1.first_name, g1.last_name, g1.film_id, g1.actor_id, g1.title, g1.release_year, g1.language_id, g1.rating, g1.inventory_id, g1.store...
Thursday, March 21, 2024

What is RMAN (Recovery Manager) in Oracle Database ?

›
RMAN stands for " Recovery Manager " and it is a key component of the Oracle database management system. RMAN is used for backup a...
Saturday, February 3, 2024

Solved: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

›
Follow the given steps to solve the issue. The commands here are for CentOS 8. The solution is same for other OS as well so modify the comma...
Thursday, February 1, 2024

Steps to install oci8 on centos 8

›
The following steps is valid for Oracle 11g, you can modify as per your oracle version in a similar fashion. 1. Install the Oracle Instant C...
Tuesday, January 30, 2024

Defining and differentiating Super key and Candidate Key based on two properties

›
Candidate keys and super keys are concepts in relational database theory that relate to the uniqueness and irreducibility of attributes with...
Tuesday, September 26, 2023

Immutable backup and how it is achieved ?

›
An immutable backup refers to a type of data backup that cannot be modified, altered, or deleted once it has been created. The term "...
Tuesday, August 22, 2023

Physical IP Vs Virtual IP Vs SCAN IP (with Examples)

›
Physical IP, Virtual IP, and SCAN IP are terms often used in the context of networking and IT infrastructure. Let's break down the diffe...
Saturday, August 5, 2023

Uninstall MariaDB completely along with its dependencies from the Centos

›
 To uninstall MariaDB on CentOS 8, you can use the `yum` package manager. Follow these steps to uninstall MariaDB: 1. **Stop the MariaDB ser...

Install MariaDB on Centos

›
 To install MariaDB on CentOS 8, follow these steps: 1. Update the system packages:    Before installing any software, it's a good idea ...

Solved: MariaDB failed to start with error message "job for mairadb.service failed because the control process exited with error code"

›
Here are some steps you can follow to resolve the issue: 1. **Check for Running Processes**: As the logs indicate, another process is alrea...

Solution for "error 1045: access denied for user 'root'@'localhost' (using password: no)"

›
The error message "1045: Access denied for user 'root'@'localhost' (using password: no)" indicates that you are tr...

Will "mysqli" extension work for MariaDB database?

›
Yes, `mysqli` can work with MariaDB in PHP. The `mysqli` extension stands for "MySQL Improved" and is designed to work with both M...

Install oci8 on centos 8

›
  Install oci8 on centos 8   Now that you have the necessary tools and libraries installed, you can proceed with the next steps to install t...