Tutorials
Courses

Similar Topics

Web Technologies32.8K+ articles

Misc8.2K+ articles

Databases2.0K+ articles

SQL1.4K+ articles

DBMS1.3K+ articles

DBMS-SQL527+ articles

Oracle347+ articles

NoSQL53+ articles

dbms46+ articles

DBMS Indexing11+ articles

SQL-basics

26 posts

Difference Between DDL and DML in DBMS

Last Updated: 13 December 2024

DDL is a Data Definition Language that is used to define data structures. For example: creating a table, and altering a table are instructions in SQL. DML is a Data Manip...read more

Lateral Keyword in SQL

Last Updated: 04 September 2023

The lateral keyword represents a lateral join between two or more tables. It joins the output of the outer query with the production of the underlying lateral subquery. It...read more

article_image

Difference Between Trigger and Procedure in DBMS

Last Updated: 30 September 2024

In Relational Database Management Systems (RDBMS), triggers and procedures are two important elements necessary for data manipulation. Still, there are vast differences be...read more

Difference between ALTER and UPDATE Command in SQL

Last Updated: 11 April 2023

1. ALTER Command:ALTER SQL command is a DDL (Data Definition Language) statement. ALTER is used to update the structure of the table in the database (like add, delete, mod...read more

SQL Error Messages

Last Updated: 17 September 2024

SQL error messages are crucial for diagnosing issues in SQL queries and database operations. They provide information about what went wrong during query execution and allo...read more

Join Multiple Tables Using Inner Join

Last Updated: 27 May 2021

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

Working With JSON in SQL

Last Updated: 02 April 2025

JSON stands for Javascript Object Notation. It is mainly used in storing and transporting data. Mostly all NoSQL databases like MongoDB, CouchDB, etc., use JSON format dat...read more

article_image

How to Create User in Oracle Database ?

Last Updated: 21 August 2024

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

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

SQL vs NO SQL vs NEW SQL

Last Updated: 12 January 2023

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

SQL DROP DATABASE

Last Updated: 26 November 2024

The SQL DROP DATABASE statement is an important command used to permanently delete a database from the Database Management System (DBMS). When executed, this command remov...read more

article_image

SQL CREATE DATABASE

Last Updated: 20 June 2025

Creating a database is one of the fundamental tasks in SQL. It is the first step in designing a relational data system. Understanding how to use this command effectively i...read more

article_image

SQL Select Database

Last Updated: 28 April 2025

The USE DATABASE statement is a command in certain SQL-based database management systems that allows users to select and set a specific database as the default for the cur...read more

Working on Oracle Tablespaces for Developers

Last Updated: 07 February 2024

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

Non-Relational Databases and Their Types

Last Updated: 23 January 2025

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