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.
Selecting Things in All of the Nominated Categories

Selecting Things in All of the Nominated Categories

Comments
7 min read
Demystifying Active Record Associations

Demystifying Active Record Associations

2
Comments
3 min read
Delete data with Circular Dependency in SQL

Delete data with Circular Dependency in SQL

2
Comments
3 min read
The 5 rules for writing faster SQL

The 5 rules for writing faster SQL

3
Comments 1
8 min read
Hash indexes in PostgreSQL

Hash indexes in PostgreSQL

3
Comments
4 min read
Multi-Stream Joins With SQL

Multi-Stream Joins With SQL

8
Comments
8 min read
How to Inspect a Lot of Stored Procedures (SP) in MSSQL

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

Comments
2 min read
Getting Started with SQLite in Python: Events Database

Getting Started with SQLite in Python: Events Database

2
Comments 1
3 min read
HTAP database cannot handle HTAP requirements

HTAP database cannot handle HTAP requirements

Comments
13 min read
Learning SQL? Here's a grab bag of links.

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

3
Comments 3
3 min read
CTE with Multiple Update Statements

CTE with Multiple Update Statements

Comments
2 min read
A Quick Intro to Relational Database Components

A Quick Intro to Relational Database Components

2
Comments
2 min read
Connecting an App Service to Azure SQL Database and Storage Account using Azure CLI

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

13
Comments
12 min read
Thrilled to share with you all our AI Chatbot tool for data warehouses: Findly.ai!

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

2
Comments
1 min read
Handling NULL in the DBs

Handling NULL in the DBs

5
Comments 1
2 min read
Unwrap Oracle Home .plb

Unwrap Oracle Home .plb

Comments
1 min read
Use Chance.js and Fony.js in your SQL queries😎

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

Comments
20 min read
“Multi-AZ” in Amazon RDS and how it may differ from High Availability

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

7
Comments
12 min read
How to Deploy and configure servers and database for Azure SQL

How to Deploy and configure servers and database for Azure SQL

2
Comments
4 min read
Comand Line Tools to Export SQL Server Query to CSV

Comand Line Tools to Export SQL Server Query to CSV

5
Comments
5 min read
The power of MERGE in PostgreSQL 15

The power of MERGE in PostgreSQL 15

Comments
3 min read
BigQuery deduplication strategies

BigQuery deduplication strategies

1
Comments
5 min read
Understanding SQL Joins: A Beginner's Guide

Understanding SQL Joins: A Beginner's Guide

Comments
5 min read
A Simple Guide to Graph Databases for Beginners.

A Simple Guide to Graph Databases for Beginners.

3
Comments
2 min read
Creating a database with Azure SQL database.

Creating a database with Azure SQL database.

2
Comments
2 min read
TiDB: Distributed MySQL with Foreign Key but not Serializable

TiDB: Distributed MySQL with Foreign Key but not Serializable

Comments
5 min read
🦦 What OtterTune hates the most in PostgreSQL🐘 is solved in YugabyteDB🚀

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

8
Comments
10 min read
Cypher: How to Determine Degree Centrality and Rank Nodes by Influence Using Cypher Queries

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

2
Comments
2 min read
From Zero to Database Hero: A Beginner's Journey into SQL

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

Comments
5 min read
How ACID is CitusDB?(compared to YugabyteDB)

How ACID is CitusDB?(compared to YugabyteDB)

Comments
4 min read
Tutorial for Middle/Senior Level Developer: General Query Solution

Tutorial for Middle/Senior Level Developer: General Query Solution

Comments
19 min read
Using KNN Algorithm for Player Matching in Online Games

Using KNN Algorithm for Player Matching in Online Games

Comments
4 min read
The old MySQL bug (detective story)

The old MySQL bug (detective story)

1
Comments 1
2 min read
When To Use SQL vs NoSQL: An Expert Guide to Databases

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

1
Comments
11 min read
Futuristic Databases

Futuristic Databases

4
Comments 1
7 min read
AI tool to automatically write, optimize, edit, and debug SQL

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

Comments
2 min read
pl/sql tutorial for beginners

pl/sql tutorial for beginners

5
Comments
1 min read
1050. Actors and Directors Who Cooperated At Least Three Times leetcode solution

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

5
Comments
1 min read
620. Not Boring Movies leetcode solution

620. Not Boring Movies leetcode solution

5
Comments
1 min read
610. Triangle Judgement

610. Triangle Judgement

4
Comments
1 min read
The script of AGE (ch. 01)

The script of AGE (ch. 01)

2
Comments
4 min read
AEM: Connect AEM to an External database (Oracle example)

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

Comments
5 min read
Range indexes for LIKE queries in YugabyteDB

Range indexes for LIKE queries in YugabyteDB

Comments
8 min read
607. Sales Person leetcode solution

607. Sales Person leetcode solution

4
Comments
1 min read
Quem é melhor? ORM ou SQL puro?

Quem é melhor? ORM ou SQL puro?

2
Comments 1
9 min read
SQL Versus NoSQL Databases: Which to Use, When, and Why

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

16
Comments
9 min read
Stored Procedures in SQL database

Stored Procedures in SQL database

2
Comments
2 min read
DROP IF EXISTS & CREATE IF NOT EXISTS in Oracle, MySQL, MariaDB, PostgreSQL, YugabyteDB

DROP IF EXISTS & CREATE IF NOT EXISTS in Oracle, MySQL, MariaDB, PostgreSQL, YugabyteDB

1
Comments
5 min read
Transactions - difference between SQL, SQLAlchemy and Django ORM

Transactions - difference between SQL, SQLAlchemy and Django ORM

Comments
2 min read
Simplest pyspark tutorial

Simplest pyspark tutorial

2
Comments
7 min read
Cloud ETL Pipeline in Azure

Cloud ETL Pipeline in Azure

1
Comments
8 min read
SQL 102:Intermediate SQL

SQL 102:Intermediate SQL

Comments
10 min read
SQLAlchemy - the easiest way to use Python and SQL with IRIS's databases

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

Comments
3 min read
When to use (SELCET * FROM CTE) or just LEFT JOIN CTE?

When to use (SELCET * FROM CTE) or just LEFT JOIN CTE?

Comments
2 min read
Loop on static content to upsert many rows in Oracle SQL

Loop on static content to upsert many rows in Oracle SQL

1
Comments
1 min read
Performance Enhancement: Conversion Funnel Analysis

Performance Enhancement: Conversion Funnel Analysis

Comments
9 min read
Quick and Handy Tips for Everyday PostgreSQL Tasks

Quick and Handy Tips for Everyday PostgreSQL Tasks

1
Comments
2 min read
🔄 Self-reference Laravel Model

🔄 Self-reference Laravel Model

6
Comments
3 min read
How to write an anonymous PL/SQL function and use it in your SQL statement

How to write an anonymous PL/SQL function and use it in your SQL statement

Comments
3 min read
Apache AGE:A quick overview.

Apache AGE:A quick overview.

3
Comments
1 min read
loading...