Skip to content

DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

tag moderators

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Huzaifa

May 18

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

#apache #postgres #sql #database

3 min read

jbx1279

May 21

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

#database #programming #sql

8 min read

Dutra

May 18

SAS Function setDateByNumberBDays

#sas #sql #proc

1 min read

Dutra

May 18

SAS Function isBrHolidayworkingDaysBetweenDates

#sas #sql #proc

1 min read

Dutra

May 18

SAS Functions previous and next BusinessDay

#sas #sql #datefunctions #proc

1 min read

InterSystems Developer for InterSystems

May 18

Create Stored Procedures using Embedded Python

#python #sql #beginners #tutorial

5 min read

May 15

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

#database #webdev #beginners #sql

3 min read

May 12

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

#beginners #tutorial #sql #analytics

6 min read

H.Brian

May 20

25 SQL tricks for beginners.

#database #sql

2 min read

May 18

Managing Calendar Availability in Supabase

#tutorial #postgres #sql #react

3 min read

Dutra

May 17

SAS Function isBrHoliday

#sas #sql #datefunctions #procfcmp

1 min read

Dutra

May 18

SAS Function isBusinessDay

#sas #sql #datefunctions #proc

1 min read

Franck Pachot for AWS Heroes

May 17

pg_hint_plan in views? No. But in UDFs, Yes

#postgres #yugabytedb #distributed #sql

10 min read

Dwarves Foundation

May 4

Managing Dataflow and SQL Database with Concurrency Control

#database #concurrency #sql

8 min read

javinpaul

May 19

My Favorite Free Courses to Learn Data Science in Depth

#datascience #machinelearning #sql #python

15 min read

Talha Munir 🇵🇸

May 12

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

#apache #apacheage #postgressql #sql

2 min read

Talha Munir 🇵🇸

May 12

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

#sql #postgres #database

2 min read

Mwenda Harun Mbaabu

May 19

Exploring Advanced and Modern Concepts in SQL with Practical Examples.

#datascience #data #sql #mysql

4 min read

Abdelrahman Mohamed Allam

May 19

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

#sql #performance #database

4 min read

Sagnik Bandyopadhyay

Apr 30

BigQuery deduplication strategies

#bigquery #sql #googlecloud #data

5 min read

May 18

Postgres Concurrency : What could go wrong (part 1)

#postgres #sql

4 min read

Franck Pachot for YugabyteDB

Apr 26

How ACID is CitusDB?(compared to YugabyteDB)

#distributed #sql #database #yugabytedb

4 min read

jbx1279

Apr 29

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

#programming #lowcode #sql #datascience

8 min read

Apr 28

TiDB: Distributed MySQL with Foreign Key but not Serializable

#distributed #sql #database #tidb

5 min read

May 16

MySQL 8.0: Invisible Columns

#mysql #tutorial #sql

2 min read

Franck Pachot for AWS Heroes

May 15

Generate Random Text Strings in PostgreSQL

#postgres #tips #sql #database