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.
The Battle of Databases: SQL, PostgreSQL, MongoDB, and Redis Explored

The Battle of Databases: SQL, PostgreSQL, MongoDB, and Redis Explored

7
Comments
2 min read
How to build an order monitoring system on your own

How to build an order monitoring system on your own

Comments
5 min read
Magic and Muscles: ETL with Mage and DuckDB with data from my powerlifting training

Magic and Muscles: ETL with Mage and DuckDB with data from my powerlifting training

1
Comments
3 min read
SQL Joins Explained: Simple Guide for Beginners

SQL Joins Explained: Simple Guide for Beginners

5
Comments
8 min read
Efficiently Reading Millions of Rows of SQL Data with Python

Efficiently Reading Millions of Rows of SQL Data with Python

8
Comments
2 min read
How to automatically filling excel sheets with SQL query results

How to automatically filling excel sheets with SQL query results

Comments
3 min read
Basic Operations and Integration in Python & SQLite

Basic Operations and Integration in Python & SQLite

Comments
3 min read
Enhancing the SQL Interval syntax: A story of Open Source contribution

Enhancing the SQL Interval syntax: A story of Open Source contribution

1
Comments 2
5 min read
Build an ORM workshop.

Build an ORM workshop.

Comments
5 min read
SSIS: Streamlining Your Data Flow

SSIS: Streamlining Your Data Flow

1
Comments
2 min read
Criei um banco de dados baseado no Universo de One Piece

Criei um banco de dados baseado no Universo de One Piece

1
Comments
4 min read
Changing SQL Dialect From Teradata To SQLite

Changing SQL Dialect From Teradata To SQLite

Comments
14 min read
Key Factors to Consider for Effective Database Design (Constraints, Indexes)

Key Factors to Consider for Effective Database Design (Constraints, Indexes)

Comments
5 min read
First Steps in SQL Operators: A Beginner's Guide

First Steps in SQL Operators: A Beginner's Guide

Comments
2 min read
The impasse of SQL performance optimizing

The impasse of SQL performance optimizing

15
Comments 1
9 min read
A Complete Guide to Different Types of Joins in SQL

A Complete Guide to Different Types of Joins in SQL

1
Comments
8 min read
GitHub Copilot and SQL

GitHub Copilot and SQL

12
Comments 1
6 min read
Optimizing Fuzzy Search Across Multiple Tables: pg_trgm, GIN, and Triggers

Optimizing Fuzzy Search Across Multiple Tables: pg_trgm, GIN, and Triggers

4
Comments
4 min read
From development to production what can go wrong with your databases (and how to avoid and fix them)

From development to production what can go wrong with your databases (and how to avoid and fix them)

1
Comments
6 min read
Revolutionizing Database Migration: From MongoDB to SQL with AI 03:44

Revolutionizing Database Migration: From MongoDB to SQL with AI

2
Comments
3 min read
Unit Testing and TDD With PostgreSQL is Easy

Unit Testing and TDD With PostgreSQL is Easy

4
Comments
9 min read
SQLC & dynamic queries

SQLC & dynamic queries

Comments
5 min read
How to Transpose Columns in Each Group to a Single Row

How to Transpose Columns in Each Group to a Single Row

12
Comments 1
2 min read
Mastering SQL Databases: In-Depth Guide

Mastering SQL Databases: In-Depth Guide

Comments
2 min read
SQL Course: Challanges

SQL Course: Challanges

Comments
2 min read
Performance and Scalability for Database-Backed Applications

Performance and Scalability for Database-Backed Applications

5
Comments 2
6 min read
SQL Course: Self Join

SQL Course: Self Join

Comments
1 min read
SQL Course: Many-to-many relationship and Nested Joins.

SQL Course: Many-to-many relationship and Nested Joins.

1
Comments
2 min read
SQL Course: One-to-many Relationships and Left Joins

SQL Course: One-to-many Relationships and Left Joins

1
Comments
1 min read
How the performance improvement by orders of magnitude happened

How the performance improvement by orders of magnitude happened

12
Comments 1
7 min read
SQL Course: One-to-one Relationships and Inner Joins.

SQL Course: One-to-one Relationships and Inner Joins.

Comments
2 min read
SQL Course: Get Started.

SQL Course: Get Started.

1
Comments
1 min read
Data for World Map Panel Plugin in Grafana from MySQL

Data for World Map Panel Plugin in Grafana from MySQL

Comments
4 min read
Tractorscope - The developer’s data visualization tool

Tractorscope - The developer’s data visualization tool

Comments 1
1 min read
How to Build an SQLite GUI (Fast & Easy Tutorial)

How to Build an SQLite GUI (Fast & Easy Tutorial)

1
Comments 1
23 min read
.present? VS .any? VS .exists?

.present? VS .any? VS .exists?

1
Comments
2 min read
What kind of OLAP do we need?

What kind of OLAP do we need?

5
Comments 1
5 min read
How SQL Query works? SQL Query Execution Order for Tech Interview

How SQL Query works? SQL Query Execution Order for Tech Interview

95
Comments 4
9 min read
All Sub-queries in SQL

All Sub-queries in SQL

1
Comments
2 min read
Difference between MySQL and PostgreSQL

Difference between MySQL and PostgreSQL

Comments 1
10 min read
[Rails] count vs length vs size with Samples and a Diagram

[Rails] count vs length vs size with Samples and a Diagram

7
Comments
2 min read
Gather Oracle Stats for Schema, Table and Indexes

Gather Oracle Stats for Schema, Table and Indexes

4
Comments
2 min read
How to Query Spark Tables from Serverless SQL Pools in Azure Synapse

How to Query Spark Tables from Serverless SQL Pools in Azure Synapse

Comments
2 min read
Refactoring..(Part 3)

Refactoring..(Part 3)

Comments
3 min read
A difficult backend problem I had to solve

A difficult backend problem I had to solve

2
Comments 1
2 min read
SQL Injection: Understanding the Threat and How to Avoid It

SQL Injection: Understanding the Threat and How to Avoid It

Comments 1
4 min read
Metis Enables your teams to own their databases with ease

Metis Enables your teams to own their databases with ease

Comments
5 min read
Banking management system

Banking management system

Comments
1 min read
How to Identify Tables Containing a Specific Column in PostgreSQL

How to Identify Tables Containing a Specific Column in PostgreSQL

4
Comments
2 min read
Verifying Column Types in Your Database Schema

Verifying Column Types in Your Database Schema

2
Comments
2 min read
SQL Server + Docker Compose: como criar e popular bancos de dados ao inicializar os containers

SQL Server + Docker Compose: como criar e popular bancos de dados ao inicializar os containers

6
Comments 1
5 min read
Don't worry! Deploy! Metis has your database covered.

Don't worry! Deploy! Metis has your database covered.

1
Comments
4 min read
Laravel Create Virtual Database Column

Laravel Create Virtual Database Column

3
Comments
3 min read
Generar colores hexadecimales aleatorios con Postgres

Generar colores hexadecimales aleatorios con Postgres

Comments
2 min read
SQL VS NoSQL

SQL VS NoSQL

1
Comments
2 min read
Postgres Arrays

Postgres Arrays

2
Comments
4 min read
Experience completing LeetCode SQL 50 (1/?)

Experience completing LeetCode SQL 50 (1/?)

1
Comments
1 min read
PostgreSQL on steroids - how to ace your database configuration

PostgreSQL on steroids - how to ace your database configuration

Comments
8 min read
Understanding set orientation from the comparison between SQL and Java, and what are the advantages of SQL over Java?

Understanding set orientation from the comparison between SQL and Java, and what are the advantages of SQL over Java?

6
Comments 1
5 min read
Unlock your career in data analytics 2024

Unlock your career in data analytics 2024

Comments 1
1 min read
loading...