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.
Automating SQL Queries with LangChain and Gemini : A Step-by-Step Guide
exson_joseph profile

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

#sql #llm #gemini #langchain
5
Comments
4 min read
The Evolution of Databases: Relational vs. NoSQL
satyamlucifer profile

The Evolution of Databases: Relational vs. NoSQL

#database #sql #nosql #productivity
11
Comments
3 min read
7 Best SQL Books for Beginners
bobbyiliev profile

7 Best SQL Books for Beginners

#sql #database #postgres #books
11
Comments 2
3 min read
Postgres 🐘 vs. SQL Server: a Complete Comparison ⚖️ in 2025
op3ratordec profile

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

#postgres #sqlserver #database #sql
6
Comments
7 min read
How to simplify nested SQL in applications with esProc
esproc_spl profile

How to simplify nested SQL in applications with esProc

#discuss #programming #devops #sql
11
Comments
4 min read
Practical SQL Injection Exploitation Cheat Sheet - @verylazytech
verylazytech profile

Practical SQL Injection Exploitation Cheat Sheet - @verylazytech

#programming #sql #cybersecurity #database
5
Comments
3 min read
Mastering System Analysis and Architecture: A Comprehensive Guide
thatohatsi880 profile

Mastering System Analysis and Architecture: A Comprehensive Guide

#database #sql #design #architecture
Comments
6 min read
How to Optimize SQL Queries for Speed and Efficiency
bikodes profile

How to Optimize SQL Queries for Speed and Efficiency

#sql #sqlserver #database #dataengineering
3
Comments 2
5 min read
Calculate the Number of Intersections between Adjacent Subsets after Grouping — From SQL to SPL #14
judith677 profile

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

#database #sql #esprocspl #programming
5
Comments 1
2 min read
Optimising Database Performance Using Dapper
adrianbailador profile

Optimising Database Performance Using Dapper

#sql #programming #csharp #dotnet
11
Comments 1
3 min read
SQLite Database GUI Tool | Design and Visualize with DbSchema
roxana_haidiner profile

SQLite Database GUI Tool | Design and Visualize with DbSchema

#database #sql #dataengineering #development
9
Comments 1
4 min read
Pair and Transpose Adjacent Records within the Group - From SQL to SPL #13
judith677 profile

Pair and Transpose Adjacent Records within the Group - From SQL to SPL #13

#database #dataengineering #sql #esprocspl
6
Comments 1
2 min read
Data Analysis Using SQL
kadoon_verinumbe_93807d68 profile

Data Analysis Using SQL

#sql #database #queries #ai
1
Comments 1
2 min read
DAY5 OF PSQL Using Join Query
elayaraj31 profile

DAY5 OF PSQL Using Join Query

#sql #postgres
3
Comments
2 min read
Calculate a Pair of Minimum Values that Meet the Criteria within the Group — From SQL to SPL #12
judith677 profile

Calculate a Pair of Minimum Values that Meet the Criteria within the Group — From SQL to SPL #12

#sql #database #dataengineering #esprocspl
6
Comments 1
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.