close
The Wayback Machine - https://web.archive.org/web/20230522075706/https://dev.to/t/sql
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
Image 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
Image Image 2
Comments
1 min read
SAS Function isBrHolidayworkingDaysBetweenDates
vanhurter profile

SAS Function isBrHolidayworkingDaysBetweenDates

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

SAS Functions previous and next BusinessDay

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

Create Stored Procedures using Embedded Python

#python #sql #beginners #tutorial
Image Image 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
Image Image Image Image Image 11
Comments
6 min read
25 SQL tricks for beginners.
brianmk profile

25 SQL tricks for beginners.

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

Managing Calendar Availability in Supabase

#tutorial #postgres #sql #react
Image Image 2
Comments
3 min read
SAS Function isBrHoliday
vanhurter profile

SAS Function isBrHoliday

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

SAS Function isBusinessDay

#sas #sql #datefunctions #proc
Image Image 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
Image 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
Image 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
Image Image Image Image Image 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
Image Image Image Image Image 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
Image 9
Comments 2
4 min read
BigQuery deduplication strategies
sagnikbanerjeesb profile

BigQuery deduplication strategies

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

Postgres Concurrency : What could go wrong (part 1)

#postgres #sql
Image 5
Comments
4 min read
How ACID is CitusDB?(compared to YugabyteDB)
franckpachot profile

How ACID is CitusDB?(compared to YugabyteDB)

#distributed #sql #database #yugabytedb
Comments
4 min read
Interpreting Low-Code from the perspective of open-source SPL
jbx1279 profile

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

#programming #lowcode #sql #datascience
Comments
8 min read
TiDB: Distributed MySQL with Foreign Key but not Serializable
franckpachot profile

TiDB: Distributed MySQL with Foreign Key but not Serializable

#distributed #sql #database #tidb
Comments
5 min read
MySQL 8.0: Invisible Columns
rozhnev profile

MySQL 8.0: Invisible Columns

#mysql #tutorial #sql
Image Image 3
Comments
2 min read
Generate Random Text Strings in PostgreSQL
franckpachot profile

Generate Random Text Strings in PostgreSQL

#postgres #tips #sql #database
Image 2
Comments
1 min read
PIVOT & UNPIVOT operators
notte profile

PIVOT & UNPIVOT operators

#sql #database #dataengineering #datascience
Image 2
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
Comments
9 min read
Range indexes for LIKE queries in YugabyteDB
franckpachot profile

Range indexes for LIKE queries in YugabyteDB

#yugabytedb #postgres #distributed #sql
Comments
8 min read
Tutorial for Middle/Senior Level Developer: General Query Solution
intersystemsdev profile

Tutorial for Middle/Senior Level Developer: General Query Solution

#tutorial #programming #sql
Comments
19 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
When To Use SQL vs NoSQL: An Expert Guide to Databases
domfive profile

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

#sql #database #datascience
Image 1
Comments
11 min read
SQL vs. NoSQL - cutting through the Tech Twitter noise
jmikrut profile

SQL vs. NoSQL - cutting through the Tech Twitter noise

#database #sql #nosql #mongodb
Image 1
Comments
9 min read
How does the in-memory database bring memory’s advantage into play?
jbx1279 profile

How does the in-memory database bring memory’s advantage into play?

#database #sql #bigdata
Comments
12 min read
A Worthy Sequel: An Overview of Next-Gen NoSQL Databases
ndewald profile

A Worthy Sequel: An Overview of Next-Gen NoSQL Databases

#prove #sql #database #learning
Image 2
Comments
4 min read
Creating a database with Azure SQL database.
keneojiteli profile

Creating a database with Azure SQL database.

#azure #sql #learning #cloud
Image 2
Comments
2 min read
MySQL Basic Select challenges
sn0wf1re profile

MySQL Basic Select challenges

#sql #mysql
Comments
2 min read
SQL Constraints 101: Ensuring Data Accuracy and Integrity
aviatorifeanyi profile

SQL Constraints 101: Ensuring Data Accuracy and Integrity

#sql #database #data #datascience
Image Image 1
Comments 4
6 min read
Getting Started with SQLite in Python: Events Database
hercules_dev profile

Getting Started with SQLite in Python: Events Database

#python #sql #database #beginners
Image 2
Comments
3 min read
Learning SQL? Here's a grab bag of links.
virtualandy profile
Andy

Learning SQL? Here's a grab bag of links.

#sql #postgres #mysql #postgressql
Image Image 3
Comments
3 min read
SQLAlchemy - the easiest way to use Python and SQL with IRIS's databases
intersystemsdev profile

SQLAlchemy - the easiest way to use Python and SQL with IRIS's databases

#tutorial #python #beginners #sql
Comments
3 min read
Introduction to SQL set operators
aviatorifeanyi profile

Introduction to SQL set operators

#sql #database #datascience #analytics
Image Image Image Image Image 10
Comments 1
5 min read
My Favorite Websites to Learn Database and SQL in 2023
javinpaul profile

My Favorite Websites to Learn Database and SQL in 2023

#sql #database #programming #datascience
Image Image Image Image Image 26
Comments 2
15 min read
SQL Recipe: Ranking Records
nalgeon profile

SQL Recipe: Ranking Records

#sql #analytics
Image Image 5
Comments
2 min read
DBMS Concepts
sd704 profile

DBMS Concepts

#sql #database
Comments
10 min read
How to close a MySQL connection in Node js?
nikhilxd profile

How to close a MySQL connection in Node js?

#node #sql #webdev #programming
Comments
1 min read
Efficient Data Management with "PostgreSQL"
huzaiifaaaa profile

Efficient Data Management with "PostgreSQL"

#apache #postgesql #sql #database
Image 1
Comments
2 min read
CRUD - 4 SQL Commands, their Javascript equivalents and MORE
rickdelpo1 profile

CRUD - 4 SQL Commands, their Javascript equivalents and MORE

#sql #javascript #beginners #tutorial
Image 1
Comments
5 min read
Selecting Things in All of the Nominated Categories
thumbone profile

Selecting Things in All of the Nominated Categories

#django #python #sql #webdev
Comments
7 min read
Demystifying Active Record Associations
minchulan profile

Demystifying Active Record Associations

#database #rails #postgres #sql
Image 1
Comments
3 min read
Delete data with Circular Dependency in SQL
yet_anotherdev profile

Delete data with Circular Dependency in SQL

#sql #postgressql
Image 2
Comments
3 min read
The 5 rules for writing faster SQL
tbperegrine profile

The 5 rules for writing faster SQL

#sql #database #analytics #backend
Image 3
Comments
8 min read
SQL 新增完成後取得 PK
fakestandard profile

SQL 新增完成後取得 PK

#sql
Comments
1 min read
Cypher: How to Determine Degree Centrality and Rank Nodes by Influence Using Cypher Queries
m4rcxs profile

Cypher: How to Determine Degree Centrality and Rank Nodes by Influence Using Cypher Queries

#apacheage #postgres #sql
Image 2
Comments
2 min read
Hash indexes in PostgreSQL
farooquememon385 profile

Hash indexes in PostgreSQL

#apacheage #postgres #sql
Image 3
Comments
4 min read
Multi-Stream Joins With SQL
bobur profile

Multi-Stream Joins With SQL

#sql #database #kafka
Image Image Image Image Image 8
Comments
8 min read
How to Inspect a Lot of Stored Procedures (SP) in MSSQL
ranggakd profile

How to Inspect a Lot of Stored Procedures (SP) in MSSQL

#sql #beginners #tutorial #sqlserver
Comments
2 min read
HTAP database cannot handle HTAP requirements
jbx1279 profile

HTAP database cannot handle HTAP requirements

#database #bigdata #sql #programming
Comments
13 min read
CTE with Multiple Update Statements
ranggakd profile

CTE with Multiple Update Statements

#sql #mssql #beginners #sqlserver
Comments
2 min read
Using KNN Algorithm for Player Matching in Online Games
fabianosalles profile

Using KNN Algorithm for Player Matching in Online Games

#machinelearning #tutorial #sql #gamedev
Comments
4 min read
loading...