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.

Sep 11

How to write Hello World in Oracle SQL

#oracle #sql

1 min read

Meet Rajesh Gor

Sep 15

SQLite dot commands: read command is recursive?

#sql #sqlite #database #programming

2 min read

Sep 11

SQL LIKE Operator: What It Is, How It Works, and Best Practices

#sql #mysql #postgressql

2 min read

Naveens K

Oct 3

Indexing, Hashing & Query Optimization in SQL

#database #performance #algorithms #sql

2 min read

Naveens K

Oct 3

Transactions, Deadlocks & Log Based Recovery in SQL

#acid #deadlock #logging #sql

2 min read

Ayomide Ajewole

Oct 13

Understanding Subqueries in SQL and Building JSON Directly in PostgreSQL

#sql #postgres #webdev #typeorm

5 min read

Naveens K

Oct 3

Understanding ACID Properties in SQL Transactions

#database #architecture #beginners #sql

2 min read

SQLFlash

Sep 18

SQL Rewriting vs. Indexing: How AI-Powered Structural Optimization Achieves 20x Scalability Gains

#sql #mysql #performance #ai

14 min read

Thushitha

Oct 3

🚀 Indexing, Hashing & Query Optimization in SQL (Tutorial Example on Students Table)

#mysql #programming #beginners #sql

2 min read

Naveens K

Oct 2

Demystifying Normalization in RDBMS: From 1NF to 3NF

#dbms #data #sql #normalization

5 min read

Oct 2

Indexing, Hashing, and Query

#database #computerscience #performance #sql

1 min read

Meet Rajesh Gor

Sep 14

SQLite dot commands: read file or standard output

#sqlite #sql #database #programming

3 min read

Oct 1

Fuzzy String Matching in PostgreSQL with pg_trgm (Trigram Search Tutorial)

#postgres #trigram #database #sql

2 min read

Oct 12

Suppose you have duplicate rows in a table. How can you delete all duplicates but keep one copy using SQL only?

#sql #rownumber

1 min read

Santhosh_M

Oct 1

NORMALIZATION

#database #sql #beginners #tutorial

3 min read

Oct 1

From Kafka to Clean Tables: Building a Confluent Snowflake Pipeline with Streams & Tasks

#dataengineering #automation #tutorial #sql

10 min read

SQLFlash

Sep 9

SQL Server Performance Optimization: Window Functions to Double Your Query Efficiency!

#sql #sqlserver #ai

4 min read

SQLFlash

Sep 9

SQLStorm & CogniSQL: An AI-Augmented SQL Dataset(202508)

#sql #database #ai

4 min read

Meet Rajesh Gor

Sep 8

SQLite functions: Generate Series Examples

#sql #sqlite #database #programming

2 min read

Kipngeno Gregory

Sep 21

Beyond Functional: Writing Professional and Performant SQL Queries

#database #performance #sql

2 min read

DataLane

Sep 8

The Ultimate Guide to SQL Joins and Subqueries Explained

#sql #programming #tutorial #database

7 min read

Ayako yk

Oct 11

An Introduction to Commonly Used PL/SQL Data Types

#beginners #database #learning #sql

4 min read

Meet Rajesh Gor

Sep 7

SQLite functions: generate series

#sql #sqlite #database

4 min read

Meet Rajesh Gor

Sep 11

SQLite dot commands: html tables with output and once

#sql #sqlite #database

2 min read

Oct 9

Auto-Generate Snowflake Semantic Views with AI - A Developer's Fast-Track to Cortex Analyst

#snowflake #llm #semanticlayer #sql

11 min read

loading...