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.
MySQL Basic Select challenges
sn0wf1re profile

MySQL Basic Select challenges

#sql #mysql
Comments
2 min read
Managing Calendar Availability in Supabase with SQL generate_series
ivaaan profile

Managing Calendar Availability in Supabase with SQL generate_series

#tutorial #postgres #sql #react
3
Comments
3 min read
SQL Constraints 101: Ensuring Data Accuracy and Integrity
aviatorifeanyi profile

SQL Constraints 101: Ensuring Data Accuracy and Integrity

#sql #database #data #datascience
1
Comments 4
6 min read
SAS Function isBrHoliday
vanhurter profile

SAS Function isBrHoliday

#sas #sql #datefunctions #procfcmp
2
Comments
1 min read
SAS Function isBusinessDay
vanhurter profile

SAS Function isBusinessDay

#sas #sql #datefunctions #proc
2
Comments
1 min read
pg_hint_plan in views? No. But in UDFs, Yes
franckpachot profile

pg_hint_plan in views? No. But in UDFs, Yes

#postgres #yugabytedb #distributed #sql
3
Comments
10 min read
MySQL 8.0: Invisible Columns
rozhnev profile

MySQL 8.0: Invisible Columns

#mysql #tutorial #sql
3
Comments
2 min read
Introduction to SQL set operators
aviatorifeanyi profile

Introduction to SQL set operators

#sql #database #datascience #analytics
11
Comments 1
5 min read
Generate Random Text Strings in PostgreSQL
franckpachot profile

Generate Random Text Strings in PostgreSQL

#postgres #tips #sql #database
3
Comments
1 min read
How to build a music player part 2: Introduction MySQL database
themba_sishuba profile

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

#database #webdev #beginners #sql
2
Comments
3 min read
How to rotate data using Pivot & Unpivot operators
notte profile

How to rotate data using Pivot & Unpivot operators

#sql #database #dataengineering #mssql
3
Comments 2
3 min read
Analyzing Uber and Uber Eats Expenses Using DBT, Postgres, Gmail, Python, SQL And PowerBI
stefentaime profile

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

#powerbi #dbt #sql #python
1
Comments
9 min read
Why ETL Becomes ELT or Even LET?
jbx1279 profile

Why ETL Becomes ELT or Even LET?

#database #bigdata #sql #programming
Comments
8 min read
A Quick Guide to AI-Powered Data Visualization: Create a Smart Dashboard with LogicLoop.
bellatrick profile

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

#beginners #tutorial #sql #analytics
11
Comments
6 min read
Description of important clauses in SQL and Apache age query format part 2
talhahahae profile

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

#apache #apacheage #postgressql #sql
Comments
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.