Similar Topics

Web Technologies32.1K+ articles

Misc7.7K+ articles

SQL1.4K+ articles

MongoDB694+ articles

DBMS-SQL531+ articles

PostgreSQL386+ articles

mysql355+ articles

SQL-Server319+ articles

MongoDB209+ articles

MongoDB-operators44+ articles

Databases / SQL

SQL

1.4K+ posts

Errors and Exceptions in SQL

Last Updated: 13 February 2026

Errors and exceptions are inevitable when working with SQL databases, ranging from syntax errors to more complex issues like constraint violations and transaction errors. ...read more

article_image

Working with Dates in SQL

Last Updated: 13 February 2026

SQL provides built-in date functions to extract and manipulate parts of a date value. These functions help analyze and organize time-based data efficiently.Functions like ...read more

article_image

Data Cleaning in SQL

Last Updated: 13 February 2026

Data cleaning is the process of preparing raw data by correcting errors, handling missing values and removing inconsistencies. It ensures that data is accurate and suitabl...read more

Set Operators in SQL

Last Updated: 03 February 2026

Set Operators in SQL are used to combine, compare or filter data by performing operations between two or more sets, enabling deeper and more flexible analysis. They allow ...read more

article_image

SELECT TOP Clause

Last Updated: 29 January 2026

The SELECT TOP clause in SQL only returns the specified number of rows from the table. It is valuable on enormous tables with a large number of records. Returning countles...read more

Last Updated: 15 November 2025

SQL functions are built-in operations that perform calculations, manipulate data, and return results in queries, making data handling simpler without writing complex code....read more

article_image

Aggregate Function

Last Updated: 13 November 2025

SQL aggregate functions are used to perform calculations on a set of values and return a single summarised result. Aggregate functions operate on multiple rows but return ...read more

article_image

Applications of SQL

Last Updated: 01 April 2026

SQL (Structured Query Language) allows users to store, retrieve, update and delete data efficiently. SQL is widely used across industries because it provides a robust, rel...read more

article_image

Index Optimization

Last Updated: 19 December 2025

Index Optimization in SQL involves creating and managing indexes on database tables to speed up data retrieval. It works like a book index, allowing the database to find r...read more

article_image

Subquery Optimization

Last Updated: 28 October 2025

Subquery optimization is the process of improving the performance of SQL queries that use subqueries by reducing redundant executions, rewriting them efficiently, and leve...read more

article_image

Guide to Databases

Last Updated: 30 August 2025

This is a complete guide to databases, where you’ll learn the foundations and advanced concepts of the most widely used database technologies -SQL: The standard language t...read more

Advanced SQL and Optimization Interview Questions - SQL

Last Updated: 02 September 2025

Advanced SQL and Optimization covers performance tuning and complex features that make SQL powerful. Topics include stored procedures, triggers, window functions, CTEs, in...read more

Data Manipulation and Querying Interview Questions - SQL

Last Updated: 21 September 2025

Data Manipulation and Querying (DML + Query Processing) in SQL focuses on how data is retrieved and modified. DML commands (INSERT, UPDATE, DELETE, MERGE) handle data chan...read more

Week 1: SQL Course Overview

Last Updated: 13 August 2025

Welcome toWeek 1of your SQL learning journey!This week introduces you to the solid foundation for understanding databases, the power of SQL and how to start writing basic ...read more

article_image

CREATE and ALTER Commands

Last Updated: 08 August 2025

In SQL, the CREATE and ALTER commands are part of the Data Definition Language (DDL). These commands help define and modify the structure of your database objects like tab...read more

...