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.
I built a zero-friction SQLite Playground for my students

I built a zero-friction SQLite Playground for my students

1
Comments
2 min read
Why `SUM() OVER (ORDER BY ...)` Sometimes Feels Wrong: A Practical Guide to SQL Window Frames

Why `SUM() OVER (ORDER BY ...)` Sometimes Feels Wrong: A Practical Guide to SQL Window Frames

1
Comments
9 min read
From Scratch to Queries: Building a School Database with SQL – My Nairobi Academy Project.

From Scratch to Queries: Building a School Database with SQL – My Nairobi Academy Project.

2
Comments
3 min read
SQL Basics: DDL, DML, Filtering & Data Transformation

SQL Basics: DDL, DML, Filtering & Data Transformation

3
Comments
3 min read
Databases: The Backbone of Modern Applications

Databases: The Backbone of Modern Applications

Comments
5 min read
Building an AI tool that generates SQL queries from natural language

Building an AI tool that generates SQL queries from natural language

Comments
2 min read
SQL Indexes Explained: Write Queries That Don't Make Your Database Cry

SQL Indexes Explained: Write Queries That Don't Make Your Database Cry

Comments
6 min read
How I Learned SQL by Creating a Simple School Database

How I Learned SQL by Creating a Simple School Database

3
Comments 2
5 min read
PostgreSQL Query Performance: The Complete EXPLAIN ANALYZE Guide for Developers Who've Had Enough

PostgreSQL Query Performance: The Complete EXPLAIN ANALYZE Guide for Developers Who've Had Enough

Comments
14 min read
SQL Joins and Window Functions

SQL Joins and Window Functions

Comments
6 min read
TypeScript knows your SQL is broken before your tests even run

TypeScript knows your SQL is broken before your tests even run

2
Comments
3 min read
Getting Started with SQL subqueries. A complete beginner guide with examples.

Getting Started with SQL subqueries. A complete beginner guide with examples.

Comments
9 min read
[EP.04] SQL Injection — How 77 Million Sony PSN Accounts Were Exposed

[EP.04] SQL Injection — How 77 Million Sony PSN Accounts Were Exposed

11
Comments
3 min read
SQL fundamentals: DDL, DML, filtering, and CASE WHEN

SQL fundamentals: DDL, DML, filtering, and CASE WHEN

1
Comments
3 min read
Connecting Power BI to SQL database.

Connecting Power BI to SQL database.

1
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.