Tagged articles

21 articles

Page 1 of 1

Aug 8, 2025 · Databases

Master SQL Execution Order, Joins, CTEs & Window Functions

This article provides a comprehensive guide to essential SQL concepts for backend developers and data engineers, covering query execution order, core commands, various join types, common table expressions (including recursive CTEs), window functions, and performance optimization techniques such as table scans and indexing, complete with practical code examples and visual illustrations.

CTEJoinsPerformance Optimization

0 likes · 10 min read

Master SQL Execution Order, Joins, CTEs & Window Functions

Java Tech Enthusiast

Jul 14, 2025 · Databases

13 Proven SQL Optimization Tricks to Supercharge Your Queries

This article presents a comprehensive set of practical SQL optimization techniques—including proper indexing, selective column retrieval, efficient joins, query planning, and database‑specific features—to dramatically improve query speed, reduce resource consumption, and enhance overall application performance.

Joinsindexesperformance

0 likes · 12 min read

13 Proven SQL Optimization Tricks to Supercharge Your Queries

IT Xianyu

Apr 18, 2025 · Databases

Comprehensive Guide to SQL Basics, Advanced Queries, and Performance Optimization

This article provides a thorough tutorial on SQL fundamentals, including statement order, core clause rules, templates for SELECT/INSERT/UPDATE/DELETE, practical multi‑table query cases, join and subquery techniques, common pitfalls, index optimization strategies, experimental performance data, and a structured learning path for mastering database development.

JoinsSubqueriesindexing

0 likes · 7 min read

Comprehensive Guide to SQL Basics, Advanced Queries, and Performance Optimization

Java Backend Technology

Mar 11, 2025 · Databases

Why IN and NOT IN Slow Down Your Queries – Pitfalls and Faster Alternatives

This article explains why the SQL IN and NOT IN operators often cause performance bottlenecks and subtle bugs, demonstrates real‑world examples with large tables, shows how NULL values can produce wrong results, and recommends using EXISTS, NOT EXISTS or JOINs for reliable and efficient queries.

EXISTSIN operatorJoins

0 likes · 6 min read

Why IN and NOT IN Slow Down Your Queries – Pitfalls and Faster Alternatives

Liangxu Linux

Apr 7, 2024 · Databases

8 Proven MySQL Query Optimizations to Slash Execution Time

This article explains common MySQL performance pitfalls such as large‑offset pagination, implicit type conversion, inefficient UPDATE/DELETE joins, mixed ordering, EXISTS subqueries, predicate push‑down, early data reduction, and intermediate result set push‑down, and provides concrete rewrites that turn multi‑second queries into millisecond‑level executions.

CTEJoinsindexing

0 likes · 13 min read

8 Proven MySQL Query Optimizations to Slash Execution Time

Liangxu Linux

Nov 29, 2023 · Databases

Essential SQL Queries for the IDC_Evaluating Database – From Simple Selects to Complex Joins

This guide presents a comprehensive set of SQL statements for the idc_evaluating database, illustrating how to retrieve rows by province or IP, count and delete active IPs, describe table structures, perform conditional aggregations, and execute inner‑join queries with calculated fields.

Joinsdata analysisdatabase

0 likes · 12 min read

Essential SQL Queries for the IDC_Evaluating Database – From Simple Selects to Complex Joins

Java Interview Crash Guide

Aug 24, 2023 · Databases

Why Avoid MySQL Joins? Application‑Layer Strategies for Faster Queries

This article explains why MySQL joins and subqueries can become performance bottlenecks on large tables, recommends fetching data via indexed single‑table queries and merging in the application layer, outlines advantages, use cases, drawbacks of joins, and offers practical alternatives and tuning tips.

Application LayerDatabase designJoins

0 likes · 6 min read

Why Avoid MySQL Joins? Application‑Layer Strategies for Faster Queries

Selected Java Interview Questions

Feb 24, 2023 · Databases

Why Avoid MySQL Joins and Use Application‑Level Data Merging

The article advises against using MySQL subqueries and joins for large datasets, recommending single‑table queries merged in application code, and outlines the benefits, scenarios, drawbacks, and alternatives for application‑level data association while also noting when joins can still be useful.

Application LayerDatabase PerformanceJoins

0 likes · 6 min read

Why Avoid MySQL Joins and Use Application‑Level Data Merging

DataFunSummit

Feb 9, 2023 · Databases

Comprehensive Guide to Multi-Table Queries and Joins in SQL

This article explains multi‑table SQL queries, detailing Cartesian products, various join types (inner, left/right/full outer, self‑join, natural join, USING), UNION operations, and provides practical examples and exercises to illustrate correct join syntax and performance considerations.

Cross JoinJoinsSQL99

0 likes · 18 min read

Comprehensive Guide to Multi-Table Queries and Joins in SQL

Selected Java Interview Questions

Apr 9, 2022 · Databases

Comprehensive SQL Basics, Interview Questions, and Advanced Query Techniques

This article provides a thorough guide to SQL fundamentals—including SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT, aggregate functions, joins, set operations, and Oracle-specific objects—followed by a collection of common interview questions with detailed solutions, top‑N queries, and row‑to‑column transformations, while also containing promotional notes for related resources.

JoinsOracleaggregation

0 likes · 25 min read

Comprehensive SQL Basics, Interview Questions, and Advanced Query Techniques

ITPUB

Nov 9, 2021 · Databases

Essential MySQL Optimization Tips for Faster Queries

This guide presents practical MySQL performance tricks—including choosing minimal field types, using NOT NULL, preferring JOIN over sub‑queries, leveraging UNION, applying proper transaction control, foreign keys, table locking, indexing strategies, and query‑writing best practices—to dramatically speed up data retrieval and reduce resource consumption.

JoinsQueriesTransactions

0 likes · 19 min read

Essential MySQL Optimization Tips for Faster Queries

ITPUB

Aug 18, 2021 · Databases

Master SQL Basics: From Core Concepts to Advanced Queries and Database Management

This comprehensive guide covers fundamental SQL concepts, syntax, and terminology, then walks through CRUD operations, subqueries, joins, unions, functions, ordering, grouping, data definition, transaction control, permission management, stored procedures, cursors, and triggers, providing clear examples for each.

CRUDJoinsStored Procedures

0 likes · 28 min read

Master SQL Basics: From Core Concepts to Advanced Queries and Database Management

Laravel Tech Community

Mar 9, 2021 · Databases

Understanding Various SQL Join Types and Their Differences

This article explains the different SQL join types—including equi‑join, natural join, inner join, self‑join, outer joins, and cross join—detailing their syntax, behavior, and practical usage with example queries and optimization tips.

Cross JoinINNER JOINJoins

0 likes · 8 min read

Understanding Various SQL Join Types and Their Differences

Practical DevOps Architecture

Dec 27, 2020 · Databases

Common MySQL SELECT Commands: Multi‑Table Join Queries

This article demonstrates how to create two MySQL tables, populate them with sample data, and use various SELECT statements—including inner joins, filtered joins, and UNION operations—to retrieve combined information across the tables.

JoinsTutorialdatabase

0 likes · 7 min read

Common MySQL SELECT Commands: Multi‑Table Join Queries

Selected Java Interview Questions

Nov 11, 2020 · Databases

Understanding the Relational Model and SQL Operations: A Comprehensive Guide

This article provides a comprehensive overview of the relational model and SQL, covering fundamental concepts, set‑based operations such as SELECT, WHERE, GROUP BY, UNION, and various JOIN types, along with practical code examples and explanations of integrity constraints and DML statements.

JoinsSet Theorydata manipulation

0 likes · 12 min read

Understanding the Relational Model and SQL Operations: A Comprehensive Guide

Efficient Ops

Aug 15, 2019 · Fundamentals

Master SQL SELECT: 10 Steps to Understand Execution Order and Joins

This comprehensive guide explains how SQL's declarative nature, the mismatch between syntax and execution order, table references, various join types, derived tables, GROUP BY behavior, and key keywords like DISTINCT, UNION, ORDER BY, and OFFSET work together to help readers master SELECT statements.

Database FundamentalsJoinsQuery Execution

0 likes · 20 min read

Master SQL SELECT: 10 Steps to Understand Execution Order and Joins

ITPUB

Feb 13, 2017 · Databases

Mastering SQL: Joins, Normal Forms, Indexes, and Optimization Techniques

This article explains SQL join types, the three normal forms, table creation and alteration commands, data integrity constraints, practical query‑optimization tips, the roles and differences of clustered and non‑clustered indexes, and the distinctions between stored procedures and functions.

Database designJoinsStored Procedures

0 likes · 7 min read

Mastering SQL: Joins, Normal Forms, Indexes, and Optimization Techniques

Architecture Digest

Jun 7, 2016 · Databases

10 Simple Steps to Fully Understand SQL

This article explains SQL’s declarative nature, the difference between its syntactic and execution order, core concepts like table references, joins, derived tables, GROUP BY, and common keywords, providing ten clear steps and examples to help developers master SQL queries.

DeclarativeJoinsquery

0 likes · 23 min read

ITPUB

May 3, 2016 · Databases

Practical Tips for Optimizing Oracle SQL Execution Plans

This guide outlines concrete strategies to reduce I/O and CPU overhead in Oracle queries, covering scope reduction, partition pruning, join simplification, hint usage, bind variables, and common pitfalls like Cartesian products and inefficient filters.

Database OptimizationJoinsOracle

0 likes · 8 min read

Practical Tips for Optimizing Oracle SQL Execution Plans

21CTO

Oct 1, 2015 · Databases

Visualizing SQL Joins with Venn Diagrams: Inner, Outer & Cross Join Explained

An in‑depth guide shows how to illustrate various SQL join types—including inner, full outer, left outer, and cross joins—using Venn diagrams and concrete table examples, highlighting result sets, null handling, and the pitfalls of Cartesian products for large tables.

Cross JoinINNER JOINJoins

0 likes · 5 min read

Visualizing SQL Joins with Venn Diagrams: Inner, Outer & Cross Join Explained

MaGe Linux Operations

Jul 10, 2015 · Databases

Master SQL Joins: Inner, Outer, and Cross Join Explained with Examples

This article explains the three types of SQL joins—inner, outer, and cross—detailing their variations such as equi‑join, non‑equi‑join, natural join, left/right/full outer joins, and provides clear example queries and result illustrations to help readers understand how to combine tables effectively.

Cross JoinINNER JOINJoins

0 likes · 5 min read

Master SQL Joins: Inner, Outer, and Cross Join Explained with Examples