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.
Simple query for remove duplicates from table

Simple query for remove duplicates from table

2
Comments
2 min read
SQL Server Performance Tuning

SQL Server Performance Tuning

2
Comments
2 min read
Structure Query Language

Structure Query Language

6
Comments
2 min read
Millions record query - with and without index

Millions record query - with and without index

Comments
2 min read
How to validate your prisma raw query results

How to validate your prisma raw query results

1
Comments
2 min read
How to use sequel.ai to convert natural language queries into SQL queries

How to use sequel.ai to convert natural language queries into SQL queries

Comments
3 min read
YugabyteDB column-level locking for UPDATE

YugabyteDB column-level locking for UPDATE

1
Comments
2 min read
Polars for Analytics an Introduction

Polars for Analytics an Introduction

3
Comments 2
3 min read
How to choose the right streaming database

How to choose the right streaming database

12
Comments
7 min read
Essential SQL Commands For Data Science

Essential SQL Commands For Data Science

Comments
3 min read
Mastering SQLAlchemy Relationships: Exploring the back_populates parameter and different relationship types

Mastering SQLAlchemy Relationships: Exploring the back_populates parameter and different relationship types

Comments 1
5 min read
[GDB] Debugging session PostgreSQL & AGE

[GDB] Debugging session PostgreSQL & AGE

3
Comments
1 min read
Query Real Time Data in Kafka Using SQL

Query Real Time Data in Kafka Using SQL

6
Comments
9 min read
DELETE CASCADE AND UPDATE CASCADE rules in SQL Server foreign key

DELETE CASCADE AND UPDATE CASCADE rules in SQL Server foreign key

Comments
2 min read
Uncovering Hidden Gems: PostgreSQL Window Functions You May Not Know About

Uncovering Hidden Gems: PostgreSQL Window Functions You May Not Know About

1
Comments
2 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
Getting Started With SQL

Getting Started With SQL

5
Comments
4 min read
Full-text search com PostgreSQL

Full-text search com PostgreSQL

Comments
9 min read
Scalable sequences in PostgreSQL / YugabyteDB

Scalable sequences in PostgreSQL / YugabyteDB

Comments
3 min read
Essential SQL Commands for Data Science Tasks

Essential SQL Commands for Data Science Tasks

2
Comments
7 min read
Save $ on public S3 buckets using VPC endpoints via SQL

Save $ on public S3 buckets using VPC endpoints via SQL

Comments
6 min read
ULTIMATE GUIDE TO EXPLORATORY DATA ANALYSIS

ULTIMATE GUIDE TO EXPLORATORY DATA ANALYSIS

Comments
6 min read
SQL 101:INTRODUCTION TO SQL FOR DATA ANALYSIS

SQL 101:INTRODUCTION TO SQL FOR DATA ANALYSIS

1
Comments 1
7 min read
Insight Findings from A Case Study of Customers Leaving Credit Card Services

Insight Findings from A Case Study of Customers Leaving Credit Card Services

Comments
10 min read
CITEXT vs LOWER

CITEXT vs LOWER

Comments
4 min read
Retype a column in YugabyteDB (and PostgreSQL)

Retype a column in YugabyteDB (and PostgreSQL)

3
Comments
5 min read
Creating a SQL generator app with ChatGPT, PostgreSQL, and ToolJet

Creating a SQL generator app with ChatGPT, PostgreSQL, and ToolJet

71
Comments 16
7 min read
SQL Concepts

SQL Concepts

1
Comments
11 min read
SQL Concepts

SQL Concepts

1
Comments
6 min read
Practicing String Manipulation in SQL

Practicing String Manipulation in SQL

2
Comments
7 min read
A Practical Guide to SQL Dates with DuckDB.

A Practical Guide to SQL Dates with DuckDB.

Comments 2
9 min read
Hacking 101: Common Attacks and How to Stop Them

Hacking 101: Common Attacks and How to Stop Them

1
Comments
5 min read
Mastering PostgreSQL Views and CTEs for Rails Developers: A Comprehensive Guide

Mastering PostgreSQL Views and CTEs for Rails Developers: A Comprehensive Guide

4
Comments
5 min read
Infra as SQL is in beta

Infra as SQL is in beta

1
Comments
4 min read
Don't Break the Bank on SQL Queries: BigQuery On-Demand vs Flat-Rate prices. Which Saves You More? 💰😎

Don't Break the Bank on SQL Queries: BigQuery On-Demand vs Flat-Rate prices. Which Saves You More? 💰😎

3
Comments 1
5 min read
Essential SQL Concepts

Essential SQL Concepts

Comments
12 min read
SQL Concepts

SQL Concepts

1
Comments
14 min read
General Questions

General Questions

1
Comments
5 min read
Deeply Nested XML and JSON with SQL

Deeply Nested XML and JSON with SQL

Comments
3 min read
Use ChatGPT to convert function to SQL query

Use ChatGPT to convert function to SQL query

Comments
2 min read
When to use window functions over group by in SQL?

When to use window functions over group by in SQL?

Comments
3 min read
SQL JOIN explained

SQL JOIN explained

65
Comments 3
13 min read
sqlite / sqlx + async

sqlite / sqlx + async

1
Comments
2 min read
Supabase: count and discount raws from the likes table

Supabase: count and discount raws from the likes table

2
Comments
2 min read
Reading and Writing Files in SQLite

Reading and Writing Files in SQLite

1
Comments
4 min read
SQL-DATA ANALYSIS,AN INTRODUCTION

SQL-DATA ANALYSIS,AN INTRODUCTION

3
Comments
6 min read
Deploy SQL Server on Amazon RDS: A Step-by-Step Guide

Deploy SQL Server on Amazon RDS: A Step-by-Step Guide

1
Comments
6 min read
A Tutorial on SQL Window Functions.

A Tutorial on SQL Window Functions.

1
Comments
15 min read
Data Business Logic In Java: jOOQ VS SPL

Data Business Logic In Java: jOOQ VS SPL

2
Comments
4 min read
Record Insert with Relational Validation in One SQL Statement

Record Insert with Relational Validation in One SQL Statement

3
Comments
7 min read
Optimizing Database Performance: Exploring Indexing Techniques in DBMS

Optimizing Database Performance: Exploring Indexing Techniques in DBMS

11
Comments
16 min read
How to limit the number of connections per DB in the PostgreSQL?

How to limit the number of connections per DB in the PostgreSQL?

Comments
1 min read
Essential SQL Commands for Data Science

Essential SQL Commands for Data Science

1
Comments
6 min read
Essential SQL Commands for Data Science

Essential SQL Commands for Data Science

Comments
6 min read
Free AWS BootCamp WEEK 4 PART 2: PostgreSQL Databases

Free AWS BootCamp WEEK 4 PART 2: PostgreSQL Databases

1
Comments
5 min read
PostgreSQL SELECT STATEMENT.

PostgreSQL SELECT STATEMENT.

Comments
1 min read
ChatGPT - Complex Coding Challenges: 7 KYU

ChatGPT - Complex Coding Challenges: 7 KYU

2
Comments
2 min read
Columns to Rows in Oracle SQL

Columns to Rows in Oracle SQL

Comments
4 min read
Free AWS BootCamp WEEK 4: SQL Databases

Free AWS BootCamp WEEK 4: SQL Databases

1
Comments
5 min read
Useful SQL Commands

Useful SQL Commands

2
Comments
4 min read
loading...