Bijay 
In this PostgreSQL tutorial, we will learn about “PostgreSQL Installation on Linux” with how to solve the error when installing PostgreSQL. Additionally, we will delve into the steps to create a new user, and database, and grant privileges within PostgreSQL. Step 1: Update the System Packages Before installing any new software, it’s essential to update … Read more >>
In this MySQL database tutorial, we will learn how to create a database using MySQL. With the help of a database, we can store our data and files in an organized manner and when required we can manage and access those database files easily. There are two methods to create a database in MySQL, the … Read more >>
In this MySQL Database tutorial, we will discuss creating a new User in MySQL. We will learn to add users through MySQL Workbench and MySQL command line client. In MySQL we have a root user through which we access our database but many times while working on any project we need to give access to … Read more >>
Datatype in MySQL is nothing different than the datatype we study in other languages like Python and Javascript which have datatypes like float, integer, boolean, etc. In this tutorial on MySQL datatypes, we will learn about different datatypes of MySQL like numeric, date and time, string types, spatial types, and JSON data types. Datatypes in MySQL … Read more >>
In this MySQL database tutorial, we will learn how to install MySQL in Windows. MySQL is an open-source Relational Database Management System (RDBMS). It is the most popular and widely used database management system. It has become the go-to choice for millions of developers around the world. Prerequisites to Install MySQL on Windows Before we dive into … Read more >>
In this SQL Server tutorial, we will learn everything about SQL Server Cross Join vs Left Outer Join. SQL Server is a popular relational database management system that provides several types of join operations to combine data from two or more tables. Two commonly used types of join operations in SQL Server are Cross Join … Read more >>
This article will explore the SDO_TOPO_GEOMETRY data type in Oracle 21c, including its syntax, advantages, and example usage. Introduction to Oracle SDO_TOPO_GEOMETRY Datatype Oracle 21c introduced the spatial data type SDO TOPO GEOMETRY, which is intended to facilitate topology in spatial data. SDO TOPO GEOMETRY offers a way to store and manage the relationships between … Read more >>
In this Oracle tutorial, we will learn about the Time datatype in the oracle database. Also, we will demonstrate how to use it to create time columns for a table in Oracle. Introduction to Oracle Time datatype Oracle 21c uses the TIME data type to hold time values without a date component. Similar to the TIMESTAMP data … Read more >>
In this Oracle tutorial, we will learn about the urowid datatype in the oracle database. Also, we will illustrate how to use it to create urowid columns for a table in oracle. Introduction to Oracle urowid Datatype In Oracle 21c, a datatype known as a Universal Rowid (UROWID) is used to hold the actual physical address of … Read more >>
Oracle 21c is the latest version of the Oracle database management system. It introduces several new features and improvements, one of which is the Year datatype. I’ll share everything you need to know about the Oracle Year data type, including how Oracle handles year information, standard methods to work with years, and best practices. Oracle … Read more >>
Download A 40 pages PDF And Learn Now.