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.
Database Design: "How to Create a Robust and Scalable Data Model"

Database Design: "How to Create a Robust and Scalable Data Model"

2
Comments
3 min read
Open-source SPL Eliminates Tens of Thousands of Intermediate Tables from Databases

Open-source SPL Eliminates Tens of Thousands of Intermediate Tables from Databases

Comments
8 min read
SAS Function setDateByNumberBDays

SAS Function setDateByNumberBDays

2
Comments
1 min read
SAS Function isBrHolidayworkingDaysBetweenDates

SAS Function isBrHolidayworkingDaysBetweenDates

2
Comments
1 min read
SAS Functions previous and next BusinessDay

SAS Functions previous and next BusinessDay

2
Comments
1 min read
Create Stored Procedures using Embedded Python

Create Stored Procedures using Embedded Python

2
Comments
5 min read
How to build a music player part 2: Introduction MySQL database

How to build a music player part 2: Introduction MySQL database

Comments
3 min read
A Quick Guide to AI-Powered Data Visualization: Create a Smart Dashboard with LogicLoop.

A Quick Guide to AI-Powered Data Visualization: Create a Smart Dashboard with LogicLoop.

11
Comments
6 min read
25 SQL tricks for beginners.

25 SQL tricks for beginners.

4
Comments 1
2 min read
Managing Calendar Availability in Supabase

Managing Calendar Availability in Supabase

2
Comments
3 min read
SAS Function isBrHoliday

SAS Function isBrHoliday

2
Comments
1 min read
SAS Function isBusinessDay

SAS Function isBusinessDay

2
Comments
1 min read
pg_hint_plan in views? No. But in UDFs, Yes

pg_hint_plan in views? No. But in UDFs, Yes

1
Comments
10 min read
Managing Dataflow and SQL Database with Concurrency Control

Managing Dataflow and SQL Database with Concurrency Control

1
Comments
8 min read
My Favorite Free Courses to Learn Data Science in Depth

My Favorite Free Courses to Learn Data Science in Depth

30
Comments
15 min read
Description of important clauses in SQL and Apache age query format part 2

Description of important clauses in SQL and Apache age query format part 2

Comments
2 min read
Description of important clauses in SQL and Apache age query format part 1

Description of important clauses in SQL and Apache age query format part 1

Comments
2 min read
Exploring Advanced and Modern Concepts in SQL with Practical Examples.

Exploring Advanced and Modern Concepts in SQL with Practical Examples.

27
Comments 5
4 min read
7 Bad Practices to Avoid When Writing SQL Queries for Better Performance 🚀

7 Bad Practices to Avoid When Writing SQL Queries for Better Performance 🚀

9
Comments 2
4 min read
BigQuery deduplication strategies

BigQuery deduplication strategies

1
Comments
5 min read
Postgres Concurrency : What could go wrong (part 1)

Postgres Concurrency : What could go wrong (part 1)

5
Comments
4 min read
How ACID is CitusDB?(compared to YugabyteDB)

How ACID is CitusDB?(compared to YugabyteDB)

Comments
4 min read
Interpreting Low-Code from the perspective of open-source SPL

Interpreting Low-Code from the perspective of open-source SPL

Comments
8 min read
TiDB: Distributed MySQL with Foreign Key but not Serializable

TiDB: Distributed MySQL with Foreign Key but not Serializable

Comments
5 min read
MySQL 8.0: Invisible Columns

MySQL 8.0: Invisible Columns

3
Comments
2 min read
Generate Random Text Strings in PostgreSQL

Generate Random Text Strings in PostgreSQL

2
Comments
1 min read
PIVOT & UNPIVOT operators

PIVOT & UNPIVOT operators

2
Comments 2
3 min read
Analyzing Uber and Uber Eats Expenses Using DBT, Postgres, Gmail, Python, SQL And PowerBI

Analyzing Uber and Uber Eats Expenses Using DBT, Postgres, Gmail, Python, SQL And PowerBI

Comments
9 min read
Range indexes for LIKE queries in YugabyteDB

Range indexes for LIKE queries in YugabyteDB

Comments
8 min read
Tutorial for Middle/Senior Level Developer: General Query Solution

Tutorial for Middle/Senior Level Developer: General Query Solution

Comments
19 min read
Why ETL Becomes ELT or Even LET?

Why ETL Becomes ELT or Even LET?

Comments
8 min read
When To Use SQL vs NoSQL: An Expert Guide to Databases

When To Use SQL vs NoSQL: An Expert Guide to Databases

1
Comments
11 min read
SQL vs. NoSQL - cutting through the Tech Twitter noise