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.
Choosing the Right Database: A Simplified Guide

Choosing the Right Database: A Simplified Guide

7
Comments
4 min read
SQL Basic and Intermediate Questions for Interview

SQL Basic and Intermediate Questions for Interview

5
Comments 4
7 min read
Understanding the Differences Between NoSQL and SQL Databases

Understanding the Differences Between NoSQL and SQL Databases

1
Comments 1
2 min read
MySQL vs SQLite أيهما أفضل ؟

MySQL vs SQLite أيهما أفضل ؟

3
Comments 2
1 min read
🇩🇪 Datenmanipulation und Abfragen mit SQL

🇩🇪 Datenmanipulation und Abfragen mit SQL

Comments
8 min read
🚀 Struggling with MySQL Performance?

🚀 Struggling with MySQL Performance?

1
Comments
1 min read
SQL: Multi field mixed deduplication followed by numbering #eg81

SQL: Multi field mixed deduplication followed by numbering #eg81

6
Comments
2 min read
What is SQL, and Why is it Essential in Modern Computing?

What is SQL, and Why is it Essential in Modern Computing?

Comments
1 min read
Learn SQL in 30 Days

Learn SQL in 30 Days

Comments 1
2 min read
SQL Injection คืออะไร? และวิธีการป้องกัน

SQL Injection คืออะไร? และวิธีการป้องกัน

Comments
1 min read
Cost Comparison: Neon vs. Azure Database for PostgreSQL Flexible Server

Cost Comparison: Neon vs. Azure Database for PostgreSQL Flexible Server

10
Comments
7 min read
3 Hot Trends In Database Reliability

3 Hot Trends In Database Reliability

Comments
4 min read
SSIS for Modern Data Integration

SSIS for Modern Data Integration

1
Comments
3 min read
How To Use Materialized Views

How To Use Materialized Views

1
Comments
5 min read
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

16
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
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
loading...