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.

Jul 12

The Ultimate SQL Tutorial: Learn to Query Like a Pro

#sql #tutorial

4 min read

Dmitry Romanoff

Jul 12

Querying a Nested Array with `elemMatch` in Amazon DocumentDB

#aws #database #sql #coding

3 min read

Gervais Yao Amoah

Aug 14

Advanced SQL Part 1: Window Functions Explained with Precision

#sql #tutorial #beginners

4 min read

Faruk

Jul 11

SQL Indexing: Your Database's Secret Weapon for Speed 🚀

#programming #database #sql #postgres

4 min read

Aug 14

SQL Learning...

#webdev #database #sql #postgres

1 min read

Data Lanes

Aug 14

Building a Data Career: The Skills That Truly Matter

#datascience #dataengineering #career #sql

5 min read

Jul 10

SQL REPLACE Function: Quick Guide with Real Examples

#sql

2 min read

Ibrahim

Jul 10

Using CASE to Sort ENUM Values in MySQL

#mysql #sql #database #data

2 min read

Jul 9

Do you know what a distributed database is?

#programming #database #sql #distributedsystems

2 min read

Aug 12

Cursor in Database Management System (DBMS): Types, Properties, and Examples

#cursor #database #dbms #sql

6 min read

Kamruzzaman Kamrul

Aug 12

Why Large Language Models Love Graph Databases

#programming #webdev #sql #llm

3 min read

Apoorv Tripathi

Jul 9

From Research to Production: How I Built a Customer Churn Prediction API That Actually Works

#fastapi #machinelearning #sql #datascience

5 min read

Romans Malinovskis

Jul 8

SQL Expressions in Rust

#rust #sql

3 min read

Romans Malinovskis

Jul 7

Hello Dev.to

#rust #sql #php

3 min read

Aug 10

Snowflake AI_TRANSCRIBE - Transform Audio to Insights with SQL in Seconds

#snowflake #sql #ai #llm

9 min read

Jul 7

SQL ORDER BY: Quick Sorting Examples and Tips

#sql #mysql

2 min read

Vahid Yousefzadeh

Jul 6

CHECKSUM Function in Oracle 21c

#oracle #devops #linux #sql

2 min read

saba diasamidze

Jul 11

Sqlite3 module in python

#python #database #sql #programming

2 min read

Roxana Maria Haidiner

Aug 8

What Is a Primary Key in SQL? Learn with Examples

#sql #database #data #dataengineering

3 min read

Roxana Maria Haidiner

Aug 8

Free SQL Tool to Understand Your Database Visually

#sql #database #tooling #mysql

3 min read

Godbless Lucky Osu

Jul 6

Getting Started with Databases: SQL & MySQL

#sql #mysql #database #learning

9 min read

Ayra Jett for Bytebase

Aug 7

Supabase ⚡️ vs. Firebase 🔥: a Complete Comparison ⚔️ in 2025

#supabase #firebase #database #sql

5 min read

Akanle Tolulope

Jul 8

How I Built a Hospital Patient Management System Using SQL

#database #sql #outreachy #beginners

2 min read

SQLFlash

Jul 4

Outer Join Optimization: Proven Performance Gains

#sql #database #nl2sql #programming

5 min read

coder7475

Aug 7

Database Normalization and Denormalization

#database #sql #programming #backend

5 min read

loading...