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.
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
Why ETL Becomes ELT or Even LET?
jbx1279 profile

Why ETL Becomes ELT or Even LET?

#database #bigdata #sql #programming
Comments
8 min read
SQL Recipe: Ranking Records
nalgeon profile

SQL Recipe: Ranking Records

#sql #analytics
5
Comments
2 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
DBMS Concepts
sd704 profile

DBMS Concepts

#sql #database
Comments
10 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
How to close a MySQL connection in Node js?
nikhilxd profile

How to close a MySQL connection in Node js?

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

Efficient Data Management with "PostgreSQL"

#apache #postgesql #sql #database
1
Comments
2 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
1
Comments
9 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
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
2
Comments
3 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
60
Comments 3
15 min read
The 5 rules for writing faster SQL
tbperegrine profile

The 5 rules for writing faster SQL

#sql #database #analytics #backend
3
Comments 1
8 min read
Delete data with Circular Dependency in SQL
yet_anotherdev profile

Delete data with Circular Dependency in SQL

#sql #postgressql
3
Comments
3 min read
Hash indexes in PostgreSQL
farooquememon385 profile

Hash indexes in PostgreSQL

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

Multi-Stream Joins With SQL

#sql #database #kafka
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
Getting Started with SQLite in Python: Events Database
hercules_dev profile

Getting Started with SQLite in Python: Events Database

#python #sql #database #beginners
3
Comments 1
3 min read
HTAP database cannot handle HTAP requirements
jbx1279 profile

HTAP database cannot handle HTAP requirements

#database #bigdata #sql #programming
Comments
13 min read
Learning SQL? Here's a grab bag of links.
virtualandy profile

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

#sql #postgres #mysql #postgressql
3
Comments 3
3 min read
CTE with Multiple Update Statements
ranggakd profile

CTE with Multiple Update Statements

#sql #mssql #beginners #sqlserver
8
Comments
2 min read
A Quick Intro to Relational Database Components
_estheradebayo profile

A Quick Intro to Relational Database Components

#webdev #database #sql #tutorial
2
Comments
2 min read
Managing Dataflow and SQL Database with Concurrency Control
dwarvesf profile

Managing Dataflow and SQL Database with Concurrency Control

#database #concurrency #sql
2
Comments
8 min read
Connecting an App Service to Azure SQL Database and Storage Account using Azure CLI
danielfavour profile

Connecting an App Service to Azure SQL Database and Storage Account using Azure CLI

#azure #sql #storage
19
Comments
12 min read
Thrilled to share with you all our AI Chatbot tool for data warehouses: Findly.ai!
findlyai profile

Thrilled to share with you all our AI Chatbot tool for data warehouses: Findly.ai!

#saas #ai #sql
2
Comments
1 min read
Handling NULL in the DBs
irinabezgina profile

Handling NULL in the DBs

#database #dataengineering #sql
5
Comments 1
2 min read
Unwrap Oracle Home .plb
franckpachot profile

Unwrap Oracle Home .plb

#oracle #troubleshooting #sql #database
11
Comments
1 min read
Use Chance.js and Fony.js in your SQL queries😎
loiclefevre profile

Use Chance.js and Fony.js in your SQL queries😎

#javascript #backend #database #sql
Comments
20 min read
“Multi-AZ” in Amazon RDS and how it may differ from High Availability or resilience to failures
franckpachot profile

“Multi-AZ” in Amazon RDS and how it may differ from High Availability or resilience to failures

#sql #database #resilience #availability
12
Comments
12 min read
How to Deploy and configure servers and database for Azure SQL
sipsdaoracle profile

How to Deploy and configure servers and database for Azure SQL

#cloudcomputing #sql #database #azuresql
2
Comments
4 min read
Comand Line Tools to Export SQL Server Query to CSV
jfraziz profile

Comand Line Tools to Export SQL Server Query to CSV

#sql #database #productivity #tooling
7
Comments
5 min read
The power of MERGE in PostgreSQL 15
rozhnev profile

The power of MERGE in PostgreSQL 15

#sql #postgres #tutorial
Comments
3 min read
BigQuery deduplication strategies
sagnikbanerjeesb profile

BigQuery deduplication strategies

#bigquery #sql #googlecloud #data
4
Comments
5 min read
Understanding SQL Joins: A Beginner's Guide
katerinamykhailyk profile

Understanding SQL Joins: A Beginner's Guide

#sql #beginners #database #programming
Comments
5 min read
A Simple Guide to Graph Databases for Beginners.
chidera profile

A Simple Guide to Graph Databases for Beginners.

#apacheage #postgres #sql
3
Comments
2 min read
Creating a database with Azure SQL database.
keneojiteli profile

Creating a database with Azure SQL database.

#azure #sql #learning #cloud
2
Comments
2 min read
TiDB: Distributed MySQL with Foreign Key (not production ready) and not Serializable
franckpachot profile

TiDB: Distributed MySQL with Foreign Key (not production ready) and not Serializable

#distributed #sql #database #tidb
Comments
5 min read
🦦 What OtterTune hates the most in PostgreSQL🐘 is solved in YugabyteDB🚀
franckpachot profile

🦦 What OtterTune hates the most in PostgreSQL🐘 is solved in YugabyteDB🚀

#postgres #yugabytedb #distributed #sql
9
Comments
10 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
3
Comments
2 min read
From Zero to Database Hero: A Beginner's Journey into SQL
jr_shittu profile

From Zero to Database Hero: A Beginner's Journey into SQL

#sql #database #beginners #datascience
Comments
5 min read
How ACID is Citus? (compared to YugabyteDB)
franckpachot profile

How ACID is Citus? (compared to YugabyteDB)

#distributed #sql #database #yugabytedb
4
Comments
4 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
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
The old MySQL bug (detective story)
rozhnev profile

The old MySQL bug (detective story)

#sql #mysql #bug
1
Comments 1
2 min read
Futuristic Databases
norbybaru profile

Futuristic Databases

#rdms #database #sql
5
Comments 1
7 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
2
Comments
11 min read
AI tool to automatically write, optimize, edit, and debug SQL
getlogicloop profile

AI tool to automatically write, optimize, edit, and debug SQL

#sql #ai #datascience #database
7
Comments
2 min read
pl/sql tutorial for beginners
realnamehidden1_61 profile

pl/sql tutorial for beginners

#sql #plsql #database
5
Comments
1 min read
1050. Actors and Directors Who Cooperated At Least Three Times leetcode solution
realnamehidden1_61 profile

1050. Actors and Directors Who Cooperated At Least Three Times leetcode solution

#mysql #leetcode #sql #databse
5
Comments
1 min read
620. Not Boring Movies leetcode solution
realnamehidden1_61 profile

620. Not Boring Movies leetcode solution

#mysql #sql #database #leetcode
5
Comments
1 min read
610. Triangle Judgement
realnamehidden1_61 profile

610. Triangle Judgement

#leetcode #mysql #database #sql
4
Comments
1 min read
The script of AGE (ch. 01)
rrrokhtar profile

The script of AGE (ch. 01)

#apacheage #database #postgres #sql
2
Comments
4 min read
AEM: Connect AEM to an External database (Oracle example)
theopendle profile

AEM: Connect AEM to an External database (Oracle example)

#aem #oracle #sql #osgi
Comments
5 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
607. Sales Person leetcode solution
realnamehidden1_61 profile

607. Sales Person leetcode solution

#leetcode #sql #database #mysql
4
Comments
1 min read
Quem é melhor? ORM ou SQL puro?
lucas_jdev profile

Quem é melhor? ORM ou SQL puro?

#orm #sql #programming #productivity
3
Comments 1
9 min read
SQL Versus NoSQL Databases: Which to Use, When, and Why
yuvalhazaz profile

SQL Versus NoSQL Databases: Which to Use, When, and Why

#sql #postgres #mongodb #database
16
Comments
9 min read
Stored Procedures in SQL database
roywanyoike profile

Stored Procedures in SQL database

#database #sql #backend #mongodb
2
Comments
2 min read
loading...