DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Don't Make This Mistake: Choosing the Wrong Database Could Cost You!

Don't Make This Mistake: Choosing the Wrong Database Could Cost You!

12
Comments 4
3 min read
Multi combination condition grouping and aggregation #eg93

Multi combination condition grouping and aggregation #eg93

7
Comments
1 min read
The Importance of Minimizing Database Queries in Backend Development

The Importance of Minimizing Database Queries in Backend Development

Comments
1 min read
"Тайны Pawsgresville: Дело об исчезнувших данных". Идексы Postgres.

"Тайны Pawsgresville: Дело об исчезнувших данных". Идексы Postgres.

1
Comments
2 min read
One-to-Many and Many-to-Many Relationships in Python with SQLite

One-to-Many and Many-to-Many Relationships in Python with SQLite

Comments
3 min read
Simple SQL Statements Only Exist in Coursebooks and Training Courses

Simple SQL Statements Only Exist in Coursebooks and Training Courses

6
Comments
7 min read
SQL Basic and Intermediate Questions for Interview

SQL Basic and Intermediate Questions for Interview

5
Comments 4
7 min read
DBA Considered Harmful

DBA Considered Harmful

Comments
4 min read
Improve Your SQL Server Database Design and Management in 2025 with a GUI Tool

Improve Your SQL Server Database Design and Management in 2025 with a GUI Tool

3
Comments 1
6 min read
Normalização dos Bancos de Dados Relacionais (Handbook)

Normalização dos Bancos de Dados Relacionais (Handbook)

1
Comments
4 min read
Sql Resumo

Sql Resumo

Comments
2 min read
BigQuery SQL

BigQuery SQL

Comments
3 min read
SQL Query basicos.

SQL Query basicos.

Comments
4 min read
Introduction to SQL: Day 1 - A Beginner's Guide to Databases

Introduction to SQL: Day 1 - A Beginner's Guide to Databases

Comments
3 min read
Connect to multiple databases, make or generate SQL queries, analyze or visualize.

Connect to multiple databases, make or generate SQL queries, analyze or visualize.

Comments
3 min read
SQL 101 | Summary of Most Used SQL Syntax for Data Analysis

SQL 101 | Summary of Most Used SQL Syntax for Data Analysis

Comments
2 min read
Introduction to Database Management Systems

Introduction to Database Management Systems

1
Comments 1
8 min read
SQL (Structured Query Language)

SQL (Structured Query Language)

Comments
4 min read
SQL Exercicios.

SQL Exercicios.

1
Comments
9 min read
The Justin Beiber database problem!

The Justin Beiber database problem!

1
Comments
1 min read
Designing a Production-Grade Database for High-Traffic Applications on AWS RDS MySQL

Designing a Production-Grade Database for High-Traffic Applications on AWS RDS MySQL

Comments
4 min read
Day 2: SQL Querying Basics - WHERE, ORDER BY, LIMIT, Aggregate Functions, GROUP BY, and HAVING : Mastering

Day 2: SQL Querying Basics - WHERE, ORDER BY, LIMIT, Aggregate Functions, GROUP BY, and HAVING : Mastering

8
Comments
2 min read
Calculate the hierarchy of recursive references :From SQL to SPL

Calculate the hierarchy of recursive references :From SQL to SPL

10
Comments
2 min read
SQL 101 | Chapter 2: Setting Up Your Database Environment

SQL 101 | Chapter 2: Setting Up Your Database Environment

10
Comments
5 min read
Entity Framework Core | Object Relation Mapping | C# | A Beginner's Guide : Mastering

Entity Framework Core | Object Relation Mapping | C# | A Beginner's Guide : Mastering

6
Comments
3 min read
Advancing Data Access with Text to SQL Technology

Advancing Data Access with Text to SQL Technology

Comments
5 min read
Semantic search with Azure MS SQL and EF Core

Semantic search with Azure MS SQL and EF Core

1
Comments 1
2 min read
LIBRARY MANAGEMENT SYSTEM USING JAVA AND SQL

LIBRARY MANAGEMENT SYSTEM USING JAVA AND SQL

Comments
1 min read
SQL: Recursive calculation of tree like hierarchical structure #eg83

SQL: Recursive calculation of tree like hierarchical structure #eg83

6
Comments
2 min read
A Quick Review of SQL Window Functions with Examples

A Quick Review of SQL Window Functions with Examples

14
Comments 5
4 min read
Things Platform Engineers Lack When Dealing With Databases

Things Platform Engineers Lack When Dealing With Databases

Comments
3 min read
Packages in Oracle SQL | Package specification | Package body

Packages in Oracle SQL | Package specification | Package body

Comments
1 min read
Efficient Temporary Storage in SQL: Ditching Cursors for Table Variables

Efficient Temporary Storage in SQL: Ditching Cursors for Table Variables

Comments
3 min read
From Chaos to Clarity: A Journey Through Random SQL Code: Practical Examples for Developers

From Chaos to Clarity: A Journey Through Random SQL Code: Practical Examples for Developers

Comments
14 min read
Crossing the Line before the Finish Line. Also the line before that.

Crossing the Line before the Finish Line. Also the line before that.

Comments
2 min read
Database Tools 🛢️🔧 in 2024: A Year in Review 🗓️

Database Tools 🛢️🔧 in 2024: A Year in Review 🗓️

105
Comments 4
3 min read
Optimizing Performance using Efficient LINQ queries

Optimizing Performance using Efficient LINQ queries

Comments
2 min read
Choosing the Right Database: A Simplified Guide

Choosing the Right Database: A Simplified Guide

10
Comments
4 min read
Understanding Data Partitioning vs. Sharding: Key Concepts for Effective Data Management

Understanding Data Partitioning vs. Sharding: Key Concepts for Effective Data Management

Comments
3 min read
Understanding the Differences Between NoSQL and SQL Databases

Understanding the Differences Between NoSQL and SQL Databases

2
Comments 1
2 min read
MySQL vs SQLite أيهما أفضل ؟

MySQL vs SQLite أيهما أفضل ؟

3
Comments 2
1 min read
🇩🇪 Datenmanipulation und Abfragen mit SQL

🇩🇪 Datenmanipulation und Abfragen mit SQL

Comments
8 min read
🚀 Struggling with MySQL Performance?

🚀 Struggling with MySQL Performance?

1
Comments
1 min read
SQL: Multi field mixed deduplication followed by numbering #eg81

SQL: Multi field mixed deduplication followed by numbering #eg81

6
Comments
2 min read
What is SQL, and Why is it Essential in Modern Computing?

What is SQL, and Why is it Essential in Modern Computing?

Comments
1 min read
Learn SQL in 30 Days

Learn SQL in 30 Days

Comments 1
2 min read
SQL Injection คืออะไร? และวิธีการป้องกัน

SQL Injection คืออะไร? และวิธีการป้องกัน

Comments
1 min read
Cost Comparison: Neon vs. Azure Database for PostgreSQL Flexible Server

Cost Comparison: Neon vs. Azure Database for PostgreSQL Flexible Server

11
Comments
7 min read
3 Hot Trends In Database Reliability

3 Hot Trends In Database Reliability

Comments
4 min read
SSIS for Modern Data Integration

SSIS for Modern Data Integration

1
Comments
3 min read
How To Use Materialized Views

How To Use Materialized Views

1
Comments
5 min read
SQL Filtering and Sorting with Real-life Examples

SQL Filtering and Sorting with Real-life Examples

Comments
4 min read
Reading Parallel Plans Correctly

Reading Parallel Plans Correctly

Comments
5 min read
Entity Relationship Diagram[ERD]

Entity Relationship Diagram[ERD]

Comments
2 min read
SQL Basic Question for interview

SQL Basic Question for interview

17
Comments 7
4 min read
Beyond LIKE: Advanced Text Search and Keyword Matching in Postgres using Full Text Search

Beyond LIKE: Advanced Text Search and Keyword Matching in Postgres using Full Text Search

2
Comments
4 min read
PostgreSQL Connection Pooling vs No Pooling: Benchmark Analysis

PostgreSQL Connection Pooling vs No Pooling: Benchmark Analysis

Comments
3 min read
SQL Quick Reference: Simplifying Database Management

SQL Quick Reference: Simplifying Database Management

Comments
4 min read
13 Tips to Improve PostgreSQL Insert Performance

13 Tips to Improve PostgreSQL Insert Performance

14
Comments 2
11 min read
Front-End to Full-Stack Journey Part 2: SQL & SQLite

Front-End to Full-Stack Journey Part 2: SQL & SQLite

Comments
3 min read
loading...