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 Learned SQL in College - But Nobody Told Me Where to Actually Use It

I Learned SQL in College - But Nobody Told Me Where to Actually Use It

6
Comments 2
3 min read
Acacia DB for VS Code: Map your database usage in source code (1.0.0 1.2.0)

Acacia DB for VS Code: Map your database usage in source code (1.0.0 1.2.0)

Comments
5 min read
PostgreSQL Aggregate and Window Function Tuning

PostgreSQL Aggregate and Window Function Tuning

Comments
9 min read
Subqueries vs CTEs in SQL: Master Nested Queries and Write Cleaner, Smarter Code

Subqueries vs CTEs in SQL: Master Nested Queries and Write Cleaner, Smarter Code

Comments
3 min read
Salesforce Data Engineering Interview Questions

Salesforce Data Engineering Interview Questions

Comments
41 min read
SQL Interview Problems for Data Engineers: 30 Patterns That Actually Get Asked

SQL Interview Problems for Data Engineers: 30 Patterns That Actually Get Asked

3
Comments
15 min read
DuckDB 1.5.2, PostgreSQL Linux 7.0 Regression, & SQLite Formal Verification

DuckDB 1.5.2, PostgreSQL Linux 7.0 Regression, & SQLite Formal Verification

Comments
3 min read
The Data Engineering Take-Home Assessment: How to Turn a 4-Hour Test Into a Job Offer

The Data Engineering Take-Home Assessment: How to Turn a 4-Hour Test Into a Job Offer

1
Comments
14 min read
PostgreSQL for Data Engineers: Indexes, Bulk Loads, and the Patterns That Actually Matter

PostgreSQL for Data Engineers: Indexes, Bulk Loads, and the Patterns That Actually Matter

1
Comments
13 min read
Aggregations: Counting, Summing, and Averaging Your Data

Aggregations: Counting, Summing, and Averaging Your Data

Comments
7 min read
PostgreSQL Subquery and CTE Optimization

PostgreSQL Subquery and CTE Optimization

1
Comments
8 min read
Database Indexing Mistakes That Kill SaaS Performance at Scale

Database Indexing Mistakes That Kill SaaS Performance at Scale

1
Comments 1
6 min read
5 SQL queries developers always have to look up (with copy-paste answers)

5 SQL queries developers always have to look up (with copy-paste answers)

1
Comments
2 min read
SQL Pattern Series #2: The Match Pattern

SQL Pattern Series #2: The Match Pattern

Comments
3 min read
SQL Basics: Talking to a Database for the First Time

SQL Basics: Talking to a Database for the First Time

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