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.
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
Don't Make This Mistake: Choosing the Wrong Database Could Cost You!

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

13
Comments 4
3 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

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

Calculate the hierarchy of recursive references :From SQL to SPL

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

SQL 101 | Chapter 2: Setting Up Your Database Environment

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

A Quick Review of SQL Window Functions with Examples

24
Comments 6
4 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

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
Practice SQL using Cricket Dataset (Moneybowl)

Practice SQL using Cricket Dataset (Moneybowl)

1
Comments 2
1 min read
Things Platform Engineers Lack When Dealing With Databases

Things Platform Engineers Lack When Dealing With Databases

Comments
3 min read
How to Build an IoT Pipeline for Real-Time Analytics in PostgreSQL

How to Build an IoT Pipeline for Real-Time Analytics in PostgreSQL

Comments
16 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 🗓️

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

Optimizing Performance using Efficient LINQ queries

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

Choosing the Right Database: A Simplified Guide

7
Comments
4 min read
PostgreSQL table partitioning

PostgreSQL table partitioning

Comments
7 min read
SQL Basic and Intermediate Questions for Interview

SQL Basic and Intermediate Questions for Interview

5
Comments 4
7 min read
Understanding the Differences Between NoSQL and SQL Databases

Understanding the Differences Between NoSQL and SQL Databases

1
Comments 1
2 min read
Understanding SQL Transactions: Implicit vs Explicit and the nuances of transaction management in SQL Server

Understanding SQL Transactions: Implicit vs Explicit and the nuances of transaction management in SQL Server

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

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

3
Comments 2
1 min read
loading...