Similar Topics

Web Technologies32.1K+ articles

Databases1.9K+ articles

SQL1.4K+ articles

DBMS1.3K+ articles

DBMS-SQL531+ articles

mysql355+ articles

Oracle354+ articles

SQL-Query196+ articles

NoSQL53+ articles

SQLmysql50+ articles

SQL-basics

38 posts

Non-Relational Databases and Their Types

Last Updated: 12 January 2026

In the area of database management, the data is arranged in two ways which are Relational Databases (SQL) and Non-Relational Databases (NoSQL). While relational databases ...read more

article_image

DBMS-Relational Model

Working on Oracle Tablespaces for Developers

Last Updated: 23 July 2025

A database, as defined by Oracle, is an organized collection of information typically stored electronically in a computer system. The explanation is simple, however, it’s ...read more

article_image

SQL Select Database

Last Updated: 06 February 2026

The USE DATABASE statement in SQL sets a specific database as the default for the current session. It helps users run queries and manage objects within that selected datab...read more

article_image

SQL CREATE DATABASE

Last Updated: 03 April 2026

To create a new database in SQL, we use CREATE DATABASE command followed by the database name. Database names cannot contain spaces; if needed, an underscore (_) can be us...read more

article_image

SQL DROP DATABASE

Last Updated: 07 April 2026

The SQL DROP DATABASE statement permanently deletes a database and all its objects such as tables, views, indexes and stored procedures from the DBMS. This action is irrev...read more

article_image

Last Updated: 21 November 2025

SQL CROSS JOIN creates a Cartesian product of two tables, meaning it returns every possible combination of rows from both tables. It does not use a join condition, and the...read more

article_image

Last Updated: 21 November 2025

SQL Self Join is used when a table needs to be joined with itself to compare rows within the same table. It helps in finding relationships between records in a single tabl...read more

article_image

SQL vs NO SQL vs NEW SQL

Last Updated: 23 July 2025

SQL stands for Structured Query Language. Which is based on relational algebra and schema is fixed in this which means data is stored in the form of columns and tables. SQ...read more

Difference Between

How to Update Current Timestamp in MySQL?

Last Updated: 30 November 2021

MySQL is an easy-to-use RDBMS. Many organizations prefer to use it because of its easy maintainability, easier to prepare schemas, stored procedures, triggers, and databas...read more

article_image

How to Create User in Oracle Database ?

Last Updated: 23 July 2025

In Oracle databases, creating and managing users is a critical task for database administrators to control access and maintain security. The CREATE USER command is used to...read more

article_image

Structured Query Language (SQL)

Last Updated: 17 March 2026

Structured Query Language (SQL) is the standard language used to interact with relational databases. It allows users to store, retrieve, update and manage data efficiently...read more

article_image

SQL HAVING Clause

Last Updated: 09 February 2026

The SQL HAVING clause filters the results of grouped data after using the GROUP BY clause. It is used with aggregate functions such as SUM(), COUNT(), or AVG() to display ...read more

article_image

Multiple Joins in SQL

Last Updated: 14 November 2025

In SQL, multiple joins allow you to combine data from more than one table in a single query. This helps efficiently retrieve complex datasets without running multiple sepa...read more

article_image

Technical Scripter

Working With JSON in SQL

Last Updated: 13 April 2026

JSON (JavaScript Object Notation) is a lightweight and widely used data format for storing and exchanging data. It is easy to read, write and understand, making it ideal f...read more

article_image

Join Multiple Tables Using Inner Join

Last Updated: 23 July 2025

To retrieve data from the single table we use SELECT and PROJECTION operations but to retrieve data from multiple tables we use JOINS in SQL. There are different types of ...read more

article_image

1 2 3