Forem

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.
DuckDB 🦆: Unleashing the Powerhouse Query Engine Within
Cover image for DuckDB 🦆: Unleashing the Powerhouse Query Engine Within

DuckDB 🦆: Unleashing the Powerhouse Query Engine Within

3
Comments
6 min read
(Beyond) The Art of Database Indexing
Cover image for (Beyond) The Art of Database Indexing

(Beyond) The Art of Database Indexing

1
Comments
3 min read
Desire for Structure (read “SQL”)
Cover image for Desire for Structure (read “SQL”)

Desire for Structure (read “SQL”)

1
Comments
10 min read
SQL Temporary Tables: A Quick and Practical Guide

SQL Temporary Tables: A Quick and Practical Guide

1
Comments
2 min read
Basic Relational Database Schemas 📚 to amplify development
Cover image for Basic Relational Database Schemas 📚 to amplify development

Basic Relational Database Schemas 📚 to amplify development

Comments
2 min read
Automating SQL Queries with LangChain and Gemini : A Step-by-Step Guide
Cover image for Automating SQL Queries with LangChain and Gemini : A Step-by-Step Guide

Automating SQL Queries with LangChain and Gemini : A Step-by-Step Guide

5
Comments
4 min read
DAY-8 PSQL, Difference Function vs. Procedure

DAY-8 PSQL, Difference Function vs. Procedure

Comments
2 min read
The Evolution of Databases: Relational vs. NoSQL
Cover image for The Evolution of Databases: Relational vs. NoSQL

The Evolution of Databases: Relational vs. NoSQL

11
Comments
3 min read
7 Best SQL Books for Beginners
Cover image for 7 Best SQL Books for Beginners

7 Best SQL Books for Beginners

11
Comments 2
3 min read
I Will Teach You SQL in 3 Minutes
Cover image for I Will Teach You SQL in 3 Minutes

I Will Teach You SQL in 3 Minutes

6
Comments 1
2 min read
Postgres 🐘 vs. SQL Server: a Complete Comparison ⚖️ in 2025
Cover image for Postgres 🐘 vs. SQL Server: a Complete Comparison ⚖️ in 2025

Postgres 🐘 vs. SQL Server: a Complete Comparison ⚖️ in 2025

6
Comments
7 min read
Desvendando SQL: Functions
Cover image for Desvendando SQL: Functions

Desvendando SQL: Functions

1
Comments
3 min read
SQL 101 | Chapter 9: Common Table Expression (CTE)
Cover image for SQL 101 | Chapter 9: Common Table Expression (CTE)

SQL 101 | Chapter 9: Common Table Expression (CTE)

Comments
5 min read
Practical SQL Injection Exploitation Cheat Sheet - @verylazytech

Practical SQL Injection Exploitation Cheat Sheet - @verylazytech

5
Comments
3 min read
DAY-7 PRIMARY KEY,FOREIGN KEY,INDEX,TRANSACTION

DAY-7 PRIMARY KEY,FOREIGN KEY,INDEX,TRANSACTION

Comments
2 min read
How to simplify nested SQL in applications with esProc

How to simplify nested SQL in applications with esProc

11
Comments
4 min read
Mastering System Analysis and Architecture: A Comprehensive Guide

Mastering System Analysis and Architecture: A Comprehensive Guide

Comments
6 min read
Top Websites for Learning Back-End Development in 2025

Top Websites for Learning Back-End Development in 2025

Comments
5 min read
How to Optimize SQL Queries for Speed and Efficiency
Cover image for How to Optimize SQL Queries for Speed and Efficiency

How to Optimize SQL Queries for Speed and Efficiency

3
Comments 2
5 min read
How I Migrate My Clients’ SQL Databases To DynamoDB
Cover image for How I Migrate My Clients’ SQL Databases To DynamoDB

How I Migrate My Clients’ SQL Databases To DynamoDB

Comments
3 min read
Calculate the Number of Intersections between Adjacent Subsets after Grouping — From SQL to SPL #14
Cover image for Calculate the Number of Intersections between Adjacent Subsets after Grouping — From SQL to SPL #14

Calculate the Number of Intersections between Adjacent Subsets after Grouping — From SQL to SPL #14

5
Comments 1
2 min read
Desvendando SQL: Procedures
Cover image for Desvendando SQL: Procedures

Desvendando SQL: Procedures

1
Comments
2 min read
INTRODUCTION TO DATA ANALYTICS

INTRODUCTION TO DATA ANALYTICS

Comments
2 min read
Some Random SQL Error Handling Techniques for Reliability and Transactional Integrity
Cover image for Some Random SQL Error Handling Techniques for Reliability and Transactional Integrity

Some Random SQL Error Handling Techniques for Reliability and Transactional Integrity

Comments
7 min read
SQL Injection
Cover image for SQL Injection

SQL Injection

Comments
1 min read
loading...