Skip to content

DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Mar 28

Simple query for remove duplicates from table

#sql #mysql #postgres #tutorial

2 min read

Kingsley Amankwah

Mar 27

SQL Server Performance Tuning

#performance #sql #community #beginners

2 min read

Muhammad Rameez

Mar 25

Structure Query Language

#sql #data #dataengineering #blog

2 min read

Mar 24

Millions record query - with and without index

#postgres #sql

2 min read

Jordan Quagliatini

Mar 27

How to validate your prisma raw query results

#prisma #sql #typescript

2 min read

Mar 24

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

#javascript #sql #webdev #openai

3 min read

Franck Pachot for YugabyteDB

Mar 19

YugabyteDB column-level locking for UPDATE

#yugabytedb #distributed #sql #lock

2 min read

Mar 20

Polars for Analytics an Introduction

#sql #python

3 min read

Bobur Umurzokov

Mar 16

How to choose the right streaming database

#database #datascience #sql #stream

7 min read

Brendah Achieng

Mar 15

Essential SQL Commands For Data Science

#database #datascience #sql

3 min read

Mar 27

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

#sql #sqlalchemy #python #orm

5 min read

MOKHTAR

Mar 26

[GDB] Debugging session PostgreSQL & AGE

#postgres #sql #age #opensource

1 min read

Bobur Umurzokov

Mar 23

Query Real Time Data in Kafka Using SQL

#sql #kafka #database #datascience

9 min read

Mar 23

DELETE CASCADE AND UPDATE CASCADE rules in SQL Server foreign key

#sql #beginners #foreignkey #mssql

2 min read

Asif

Mar 22

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

#sql #postgres #webdev #database

2 min read

Gerald Venzl 🚀

Mar 20

How to write an anonymous PL/SQL function and use it in your SQL statement

#sql #oracle #database #plsql

3 min read

Mar 18

Getting Started With SQL

#sql #programming #mysql #beginners

4 min read

Mar 5

Full-text search com PostgreSQL

#postgres #sql

9 min read

Franck Pachot for YugabyteDB

Mar 14

Scalable sequences in PostgreSQL / YugabyteDB

#yugabytedb #distributed #sql #postgres

3 min read

Itsdru

Mar 14

Essential SQL Commands for Data Science Tasks

#datascience #sql #programming #computerscience

7 min read

depombo for IaSQL

Mar 23

Save $ on public S3 buckets using VPC endpoints via SQL

#s3 #aws #sql #cloud

6 min read

Mar 1

ULTIMATE GUIDE TO EXPLORATORY DATA ANALYSIS

#python #sql

6 min read

Mar 1

SQL 101:INTRODUCTION TO SQL FOR DATA ANALYSIS

#sql #database

7 min read

Aldi Fianda Putra

Feb 27

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

#datascience #database #sql

10 min read

Rudy Zidan

Mar 17

CITEXT vs LOWER

#postgres #citext #btree #sql

4 min read

Franck Pachot for YugabyteDB

Mar 16

Retype a column in YugabyteDB (and PostgreSQL)

#yugabytedb #distributed #sql #postgres

5 min read

Teja Kummarikuntla for ToolJet

Mar 21

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

#sql #tooljet #javascript #chatgpt

7 min read

Feb 22

SQL Concepts

#sql #postgres

11 min read

NK1FC

Feb 22

SQL Concepts

#sql #postgres #programming #beginners

6 min read

Mar 6

Practicing String Manipulation in SQL

#sql #datascience #tutorial