Tutorials
Courses
Tracks

Similar Topics

Web Technologies32.1K+ articles

Misc7.7K+ articles

SQL1.4K+ articles

MongoDB672+ articles

DBMS-SQL531+ articles

PostgreSQL386+ articles

mysql346+ articles

SQL-Server319+ articles

MongoDB188+ articles

MongoDB-operators44+ articles

Databases / SQL

SQL

1.4K+ posts

Index Optimization

Last Updated: 23 September 2025

Index Optimization in SQL means creating and using indexes on database tables to improve query performance. An index works like a "book index," allowing the database engin...read more

article_image

Subquery Optimization

Last Updated: 03 September 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

Introduction to SQL

Last Updated: 01 August 2025

SQL or Structured Query Language, is a tool for communicating with databases to store, retrieve and manage data efficiently. Imagine running a bookstore with thousands of ...read more

article_image

SQL Career Path: Roles, Skills & Salaries

Last Updated: 07 August 2025

SQL (Structured Query Language) is an essential skill for anyone working with data, from software testers to data scientists, developers and database administrators. With ...read more

article_image

SQL for Data Analytics & Developers

Last Updated: 01 August 2025

Imagine running a busy coffee shop with orders, customers and sales tracked on paper. Finding out who ordered what or which drink sells best would take forever! SQL (Struc...read more

article_image

Bookstore Analytics with SQL

Last Updated: 21 July 2025

Bookstore analytics involves using data to understand customer preferences, product trends, inventory health and marketing performance in a retail bookstore. Ever wondered...read more

article_image

SQL Database Operations

Last Updated: 26 June 2025

SQL databases or relational databases are widely used for storing, managing and organizing structured data in a tabular format. These databases store data in tables consis...read more

article_image

Calculate Moving Averages in SQL

Last Updated: 23 July 2025

In data analysis, smoothing out short-term fluctuations in time-series data is essential for identifying long-term trends. One effective method for achieving this is throu...read more

article_image

Market Basket Analysis with SQL

Last Updated: 23 July 2025

Market Basket Analysis (MBA) is a powerful data mining technique used in retail and e-commerce to identify relationships between products frequently purchased together. By...read more

article_image

Time-Series Data Analysis Using SQL

Last Updated: 23 July 2025

Time-series data analysis is essential for businesses to monitor trends, forecast demand, and make strategic decisions. One effective method is calculating a 7-day moving ...read more

article_image

...