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.
Las 15 Consultas SQL Desde Lo Más Básico Hasta Lo No Tan Básico

Las 15 Consultas SQL Desde Lo Más Básico Hasta Lo No Tan Básico

Comments
3 min read
Preventing SQL Injection with Golang

Preventing SQL Injection with Golang

105
Comments 7
8 min read
Manipulating Dates with SQL Server

Manipulating Dates with SQL Server

1
Comments
5 min read
Optimizing PostgreSQL Trigger Execution: Balancing Precision with Control

Optimizing PostgreSQL Trigger Execution: Balancing Precision with Control

2
Comments
3 min read
HackTheBox - Writeup Analytics

HackTheBox - Writeup Analytics

Comments
9 min read
Learn SQL with PostgreSQL: Building a Budget Tracking Application

Learn SQL with PostgreSQL: Building a Budget Tracking Application

Comments
5 min read
Deletion of Data = Integrity Impact, Deletion of Data Availability Impact

Deletion of Data = Integrity Impact, Deletion of Data Availability Impact

Comments
2 min read
SQL Pro Tips : industrial Oracle SQL using WITH

SQL Pro Tips : industrial Oracle SQL using WITH

3
Comments
4 min read
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

7
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

6
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

9
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
SQL Injection attack

SQL Injection attack

Comments
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
YugabyteDB Transactional Load with Non-transactional COPY

YugabyteDB Transactional Load with Non-transactional COPY

1
Comments 1
3 min read
What's the equivalent of pageinspect in YugabyteDB?

What's the equivalent of pageinspect in YugabyteDB?

1
Comments
15 min read
Understanding ON DELETE CASCADE and ON UPDATE CASCADE in SQL Foreign Key Relationships

Understanding ON DELETE CASCADE and ON UPDATE CASCADE in SQL Foreign Key Relationships

17
Comments
3 min read
My Data Engineering Library

My Data Engineering Library

Comments
2 min read
Empowering Efficiency: Transforming Text into SQL with Lyzr SDK

Empowering Efficiency: Transforming Text into SQL with Lyzr SDK

Comments
3 min read
Unlock SQLite: Easy Data Analysis for Busy Software Engineers

Unlock SQLite: Easy Data Analysis for Busy Software Engineers

Comments
1 min read
Adding sequence duplicate records in MySQL without a window function

Adding sequence duplicate records in MySQL without a window function

21
Comments
3 min read
SQL MASTERY - P00 ( Introduction to SQL and It's Technicality

SQL MASTERY - P00 ( Introduction to SQL and It's Technicality

1
Comments
2 min read
Handling NULL Values in SQL: A Guide to `ISNULL`, `NULLIF`, and `COALESCE`

Handling NULL Values in SQL: A Guide to `ISNULL`, `NULLIF`, and `COALESCE`

Comments
2 min read
How to Move Your WordPress Site to a New Host

How to Move Your WordPress Site to a New Host

Comments
3 min read
The Ultimate SQL SELECT Cheat Sheet

The Ultimate SQL SELECT Cheat Sheet

4
Comments
3 min read
Exploring PostgreSQL Joins: A Comprehensive Guide Using Sales Data and Product Information

Exploring PostgreSQL Joins: A Comprehensive Guide Using Sales Data and Product Information

Comments
3 min read
Como permitir valores nulos do Golang na Base de Dados?

Como permitir valores nulos do Golang na Base de Dados?

Comments
1 min read
Understanding How Databases Utilize Indexes

Understanding How Databases Utilize Indexes

1
Comments
5 min read
Portfolio Website / Bible App - Devlog #9

Portfolio Website / Bible App - Devlog #9

1
Comments
1 min read
Introducing Hatchify: Low-code libraries for React, Node, and Sequelize

Introducing Hatchify: Low-code libraries for React, Node, and Sequelize

10
Comments
4 min read
Choosing Between Insert Functions and Raw Queries: A Practical Guide

Choosing Between Insert Functions and Raw Queries: A Practical Guide

1
Comments 1
4 min read
Mastering Pattern Matching in SQL: A Practical Guide from PATINDEX to LIKE

Mastering Pattern Matching in SQL: A Practical Guide from PATINDEX to LIKE

2
Comments
3 min read
All joins in PostgreSQL: Tutorial

All joins in PostgreSQL: Tutorial

Comments
2 min read
ActiveRecord::Originator, a RubyGem indicating the origin of the SQL

ActiveRecord::Originator, a RubyGem indicating the origin of the SQL

3
Comments
4 min read
PostGreSql-StoryFrom(Day89-100)

PostGreSql-StoryFrom(Day89-100)

1
Comments
19 min read
Frugal SQL data access with Athena and Blue / Green support

Frugal SQL data access with Athena and Blue / Green support

6
Comments
4 min read
Streamlining String Concatenation in SQL Server with CONCAT_WS

Streamlining String Concatenation in SQL Server with CONCAT_WS

Comments
1 min read
How to use pgbench to test PostgreSQL® performance

How to use pgbench to test PostgreSQL® performance

2
Comments
5 min read
Optimizing Database Performance with Views Functions and Triggers in PostgreSQL

Optimizing Database Performance with Views Functions and Triggers in PostgreSQL

1
Comments
6 min read
Oracle Database: How to Create/Delete New User and Grant Privilege?

Oracle Database: How to Create/Delete New User and Grant Privilege?

Comments
2 min read
loading...