Skip to content
Search

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"
huzaiifaaaa profile

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

#apache #postgres #sql #database
2
Comments
3 min read
Open-source SPL Eliminates Tens of Thousands of Intermediate Tables from Databases
jbx1279 profile

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

#database #programming #sql
Comments
8 min read
SAS Function setDateByNumberBDays
vanhurter profile

SAS Function setDateByNumberBDays

#sas #sql #proc
2
Comments
1 min read
SAS Function isBrHolidayworkingDaysBetweenDates
vanhurter profile

SAS Function isBrHolidayworkingDaysBetweenDates

#sas #sql #proc
2
Comments
1 min read
SAS Functions previous and next BusinessDay
vanhurter profile

SAS Functions previous and next BusinessDay

#sas #sql #datefunctions #proc
2
Comments
1 min read
Create Stored Procedures using Embedded Python
intersystemsdev profile

Create Stored Procedures using Embedded Python

#python #sql #beginners #tutorial
2
Comments
5 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
Comments
3 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
25 SQL tricks for beginners.
brianmk profile

25 SQL tricks for beginners.

#database #sql
4
Comments 1
2 min read
Managing Calendar Availability in Supabase
ivaaan profile

Managing Calendar Availability in Supabase

#tutorial #postgres #sql #react
2
Comments
3 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
1
Comments
10 min read
Managing Dataflow and SQL Database with Concurrency Control
dwarvesf profile

Managing Dataflow and SQL Database with Concurrency Control

#database #concurrency #sql
1
Comments
8 min read
My Favorite Free Courses to Learn Data Science in Depth
javinpaul profile

My Favorite Free Courses to Learn Data Science in Depth

#datascience #machinelearning #sql #python
30
Comments
15 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
Description of important clauses in SQL and Apache age query format part 1
talhahahae profile

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

#sql #postgres #database
Comments
2 min read
Exploring Advanced and Modern Concepts in SQL with Practical Examples.
grayhat profile

Exploring Advanced and Modern Concepts in SQL with Practical Examples.

#datascience #data #sql #mysql
27
Comments 5
4 min read
7 Bad Practices to Avoid When Writing SQL Queries for Better Performance 🚀
abdelrahmanallam profile

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

#sql #performance #database
9
Comments 2
4 min read
BigQuery deduplication strategies
sagnikbanerjeesb profile

BigQuery deduplication strategies

#bigquery #sql #googlecloud #data
1
Comments
5 min read
Postgres Concurrency : What could go wrong (part 1)
yet_anotherdev profile