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.
SQL Filtering and Sorting with Real-life Examples

SQL Filtering and Sorting with Real-life Examples

1
Comments
4 min read
Reading Parallel Plans Correctly

Reading Parallel Plans Correctly

Comments
5 min read
Entity Relationship Diagram[ERD]

Entity Relationship Diagram[ERD]

Comments
2 min read
SQL Basic Question for interview

SQL Basic Question for interview

17
Comments 7
4 min read
Beyond LIKE: Advanced Text Search and Keyword Matching in Postgres using Full Text Search

Beyond LIKE: Advanced Text Search and Keyword Matching in Postgres using Full Text Search

2
Comments
4 min read
PostgreSQL Connection Pooling vs No Pooling: Benchmark Analysis

PostgreSQL Connection Pooling vs No Pooling: Benchmark Analysis

Comments
3 min read
SQL Quick Reference: Simplifying Database Management

SQL Quick Reference: Simplifying Database Management

Comments
4 min read
13 Tips to Improve PostgreSQL Insert Performance

13 Tips to Improve PostgreSQL Insert Performance

17
Comments 2
11 min read
Front-End to Full-Stack Journey Part 2: SQL & SQLite

Front-End to Full-Stack Journey Part 2: SQL & SQLite

Comments
3 min read
Migrating from Azure Database for PostgreSQL to Neon

Migrating from Azure Database for PostgreSQL to Neon

9
Comments
7 min read
Enhancing Time Zone-Sensitive Business Engagement: SQL Logic for Business Hour Validation by Time Zone

Enhancing Time Zone-Sensitive Business Engagement: SQL Logic for Business Hour Validation by Time Zone

Comments
7 min read
Easily Display Record Counts in SQL Server Using COUNT(*) OVER()

Easily Display Record Counts in SQL Server Using COUNT(*) OVER()

Comments
3 min read
Boosting SQL Query Flexibility with CROSS APPLY

Boosting SQL Query Flexibility with CROSS APPLY

Comments
2 min read
Optimizing Your MySQL Queries for Maximum Efficiency

Optimizing Your MySQL Queries for Maximum Efficiency

Comments
3 min read
ROLLUP

ROLLUP

Comments
2 min read
SQL Window functions: Understanding PARTITION BY

SQL Window functions: Understanding PARTITION BY

1
Comments
5 min read
Validatorian

Validatorian

Comments
4 min read
Understanding Data Partitioning vs. Sharding: Key Concepts for Effective Data Management

Understanding Data Partitioning vs. Sharding: Key Concepts for Effective Data Management

Comments
3 min read
Avoid SELECT *, even on a single-column tables

Avoid SELECT *, even on a single-column tables

1
Comments
4 min read
100 Essential SQL Questions Every Developer Should Master

100 Essential SQL Questions Every Developer Should Master

Comments
3 min read
Understanding ACID Properties: The Pillars of Reliable Databases

Understanding ACID Properties: The Pillars of Reliable Databases

Comments
3 min read
SQL Transactions: Ensuring Data Integrity and Consistency

SQL Transactions: Ensuring Data Integrity and Consistency

Comments
3 min read
Understanding Stored Procedures: A Guide to Efficient SQL Programming

Understanding Stored Procedures: A Guide to Efficient SQL Programming

Comments
3 min read
Understanding SQL Triggers: Automating Database Tasks with Ease

Understanding SQL Triggers: Automating Database Tasks with Ease

Comments
3 min read
Mastering SQL Views: Simplify, Secure, and Optimize Your Database Queries

Mastering SQL Views: Simplify, Secure, and Optimize Your Database Queries

Comments
3 min read
loading...