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 Convert Dates in One Group into An Interval

How to Convert Dates in One Group into An Interval

10
Comments
2 min read
PostgreSQL index Correlation with UPDATE

PostgreSQL index Correlation with UPDATE

12
Comments 7
17 min read
Building a project in DBT

Building a project in DBT

Comments
5 min read
Primeros Pasos en SQL: La Piedra Angular de la Ingeniería de Datos

Primeros Pasos en SQL: La Piedra Angular de la Ingeniería de Datos

Comments
2 min read
How come there are tens of thousands of tables in a database

How come there are tens of thousands of tables in a database

2
Comments 1
5 min read
Desentrañando el Proceso ETL: La Columna Vertebral de la Ciencia de Datos

Desentrañando el Proceso ETL: La Columna Vertebral de la Ciencia de Datos

Comments
2 min read
Understanding Database Normalization and the Importance of 1NF

Understanding Database Normalization and the Importance of 1NF

2
Comments
3 min read
Bulk Insert, Bulk Delete, Bulk Update with Dapper by Bulk.Dapper

Bulk Insert, Bulk Delete, Bulk Update with Dapper by Bulk.Dapper

9
Comments
2 min read
Mastering Performance Troubleshooting with sys.dm_exec_requests in Azure SQL

Mastering Performance Troubleshooting with sys.dm_exec_requests in Azure SQL

7
Comments
2 min read
SQL subqueries: [Step-By-Step] Guide

SQL subqueries: [Step-By-Step] Guide

Comments
4 min read
SQL vs. Sequel: Navigating the Pronunciation Landscape

SQL vs. Sequel: Navigating the Pronunciation Landscape

Comments
1 min read
🤩 Free Oracle Database: Download, Install, Tutorial… My Getting Started Guide 🚀🦭🐳

🤩 Free Oracle Database: Download, Install, Tutorial… My Getting Started Guide 🚀🦭🐳

Comments
3 min read
Streamlining SQL Queries with the WINDOW Keyword

Streamlining SQL Queries with the WINDOW Keyword

2
Comments
2 min read
Integrating Predictive Analytics Models into SQL Queries

Integrating Predictive Analytics Models into SQL Queries

13
Comments
14 min read
Stalactite ORM 2.0.0 is out ! 🚀

Stalactite ORM 2.0.0 is out ! 🚀

Comments
1 min read
How can we implement a mysql restoration algorithm in Bash

How can we implement a mysql restoration algorithm in Bash

Comments
1 min read
Query Documents from PostgreSQL like MongoDB

Query Documents from PostgreSQL like MongoDB

Comments
1 min read
B-Tree vs. LSM-Tree: measuring the write amplification on Oracle Database and YugabyteDB

B-Tree vs. LSM-Tree: measuring the write amplification on Oracle Database and YugabyteDB

Comments 9
10 min read
Fast SQL Bulk Inserts With C# and EF Core

Fast SQL Bulk Inserts With C# and EF Core

Comments
7 min read
Optimizing PostgreSQL Queries with Function Volatility: Volatile, Stable, and Immutable

Optimizing PostgreSQL Queries with Function Volatility: Volatile, Stable, and Immutable

2
Comments
3 min read
How To Master PostgreSQL Performance Like Never Before

How To Master PostgreSQL Performance Like Never Before

1
Comments
14 min read
Harnessing SQL's PRECEDING and FOLLOWING: Advanced Data Analysis with Window Functions

Harnessing SQL's PRECEDING and FOLLOWING: Advanced Data Analysis with Window Functions

5
Comments 1
8 min read
Integrate sqlite with Nodejs ! 🔥

Integrate sqlite with Nodejs ! 🔥

18
Comments 1
2 min read
Handling NEW and OLD Immutability in PostgreSQL Triggers

Handling NEW and OLD Immutability in PostgreSQL Triggers

1
Comments
2 min read
Exploring the Database Spectrum. A Look at SQL and NoSQL Technologies.

Exploring the Database Spectrum. A Look at SQL and NoSQL Technologies.

1
Comments
11 min read
loading...