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.
Managing Calendar Availability in Supabase with SQL generate_series

Managing Calendar Availability in Supabase with SQL generate_series

3
Comments
3 min read
SQL Constraints 101: Ensuring Data Accuracy and Integrity

SQL Constraints 101: Ensuring Data Accuracy and Integrity

1
Comments 4
6 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

3
Comments
10 min read
MySQL 8.0: Invisible Columns

MySQL 8.0: Invisible Columns

3
Comments
2 min read
Introduction to SQL set operators

Introduction to SQL set operators

11
Comments 1
5 min read
Generate Random Text Strings in PostgreSQL

Generate Random Text Strings in PostgreSQL

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

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

2
Comments
3 min read
How to rotate data using Pivot & Unpivot operators

How to rotate data using Pivot & Unpivot operators

3
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

1
Comments
9 min read
Why ETL Becomes ELT or Even LET?

Why ETL Becomes ELT or Even LET?

Comments
8 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
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
DBMS Concepts

DBMS Concepts

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