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 Transpose Columns in Each Group to a Single Row

How to Transpose Columns in Each Group to a Single Row

7
Comments
2 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
PostGreSql-StoryFrom(Day89-100)

PostGreSql-StoryFrom(Day89-100)

Comments
19 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
Streamlining String Concatenation in SQL Server with CONCAT_WS

Streamlining String Concatenation in SQL Server with CONCAT_WS

Comments
1 min read
Optimising Database Performance: The Pitfalls of ‘SELECT * FROM’ Queries

Optimising Database Performance: The Pitfalls of ‘SELECT * FROM’ Queries

Comments
4 min read
All joins in PostgreSQL: Tutorial

All joins in PostgreSQL: Tutorial

Comments
2 min read
YAML-based Database Docu

YAML-based Database Docu

Comments
2 min read
Which Scenarios Does ClickHouse Applies to?

Which Scenarios Does ClickHouse Applies to?

6
Comments
5 min read
Migrating SQL Server to Azure SQL Database with SQL Server Management Studio (SSMS)

Migrating SQL Server to Azure SQL Database with SQL Server Management Studio (SSMS)

Comments
4 min read
From dbf to PostgreSQL with Python

From dbf to PostgreSQL with Python

Comments
2 min read
Bagaimana cara menggunakan PostgreSQL tanpa melakukan instalasi?

Bagaimana cara menggunakan PostgreSQL tanpa melakukan instalasi?

Comments
3 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
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
Manipulando Datas com SQL Server

Manipulando Datas com SQL Server

2
Comments
7 min read
Mastering SQL Query Optimization: Techniques for Maximum Database Performance

Mastering SQL Query Optimization: Techniques for Maximum Database Performance

Comments
13 min read
RisingWave workshop

RisingWave workshop

1
Comments
5 min read
Supercharge Your Database: 25 Essential MySQL Query Optimization Techniques

Supercharge Your Database: 25 Essential MySQL Query Optimization Techniques

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

Frugal SQL data access with Athena and Blue / Green support

4
Comments
4 min read
Integrating Apache Hive — Offline Data for OpenMLDB

Integrating Apache Hive — Offline Data for OpenMLDB

Comments
4 min read
Unraveling the Web: A Comprehensive Guide to Mastering SQL Joins

Unraveling the Web: A Comprehensive Guide to Mastering SQL Joins

Comments
3 min read
DATABASE INDEXING IN PoatgreSQL

DATABASE INDEXING IN PoatgreSQL

Comments
4 min read
Beyond the Basics: Leveraging ACID for Advanced Database Management

Beyond the Basics: Leveraging ACID for Advanced Database Management

Comments
2 min read
Building a project in DBT

Building a project in DBT

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

Understanding Database Normalization and the Importance of 1NF

2
Comments
3 min read
Retrieving records in bulk with a list of primary key values in CrateDB

Retrieving records in bulk with a list of primary key values in CrateDB

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

How to use pgbench to test PostgreSQL® performance

Comments
5 min read
Query Documents from PostgreSQL like MongoDB

Query Documents from PostgreSQL like MongoDB

Comments
1 min read
MYSQL VS POSTGRESQL: CHOOSING THE RIGHT DATABASE FOR YOUR NEEDS

MYSQL VS POSTGRESQL: CHOOSING THE RIGHT DATABASE FOR YOUR NEEDS

Comments
3 min read
How to track Cloudtrail API calls from all Organizations AWS accounts using Athena

How to track Cloudtrail API calls from all Organizations AWS accounts using Athena

2
Comments
3 min read
SQL Injection attack

SQL Injection attack

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
Utilizando o Prisma com TypeScript e SQLite: Um Guia Prático

Utilizando o Prisma com TypeScript e SQLite: Um Guia Prático

Comments
4 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
Python Database Connectivity and SQL Basics for EDA 🐍📊

Python Database Connectivity and SQL Basics for EDA 🐍📊

6
Comments
4 min read
SQL for Beginners

SQL for Beginners

Comments
2 min read
SQL vs NoSQL: Choosing the Right One, Future Trends & Best Practices

SQL vs NoSQL: Choosing the Right One, Future Trends & Best Practices

6
Comments
11 min read
Handling Migrations on NestJS with TypeORM

Handling Migrations on NestJS with TypeORM

7
Comments
2 min read
The Ultimate SQL SELECT Cheat Sheet

The Ultimate SQL SELECT Cheat Sheet

4
Comments
3 min read
Understanding How Databases Utilize Indexes

Understanding How Databases Utilize Indexes

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

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

9
Comments
4 min read
What is a Relational Database for Beginners

What is a Relational Database for Beginners

3
Comments
2 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
ActiveRecord::Originator, a RubyGem indicating the origin of the SQL

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

2
Comments
4 min read
Comparing Snowflake Dynamic Tables with dbt

Comparing Snowflake Dynamic Tables with dbt

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
4 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
Crafting DDL Statements for an Online Food Ordering Service Database

Crafting DDL Statements for an Online Food Ordering Service Database

Comments
2 min read
Why You Should Use a Database

Why You Should Use a Database

1
Comments
3 min read
OLAP Cubes and Multidimensional Modeling with SQL Server Analysis Services

OLAP Cubes and Multidimensional Modeling with SQL Server Analysis Services

1
Comments
8 min read
ORM vs Pure SQL: Which to Choose?

ORM vs Pure SQL: Which to Choose?

33
Comments 18
1 min read
SQL Database Normalization with Easy Examples

SQL Database Normalization with Easy Examples

Comments
2 min read
ER Diagram Sample for Ecommerce Project

ER Diagram Sample for Ecommerce Project

5
Comments
3 min read
SQLite3 Replication: A Wizard's Guide🧙🏽

SQLite3 Replication: A Wizard's Guide🧙🏽

2
Comments
4 min read
Fortifying Postgres With Byzantine Fault Tolerance

Fortifying Postgres With Byzantine Fault Tolerance

Comments
8 min read
Indexing Best Practices

Indexing Best Practices

Comments
4 min read
Effective Strategies for Troubleshooting and Resolving 'Failure to Find WAL Records' Errors in PostgreSQL

Effective Strategies for Troubleshooting and Resolving 'Failure to Find WAL Records' Errors in PostgreSQL

Comments
2 min read
Practical PostgreSQL #1 - Basics

Practical PostgreSQL #1 - Basics

Comments
3 min read
Reset IDs postgresql database - snippet

Reset IDs postgresql database - snippet

Comments
1 min read
loading...