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.
Understanding Subqueries in SQL and Building JSON Directly in PostgreSQL
og_wunderkind profile

Understanding Subqueries in SQL and Building JSON Directly in PostgreSQL

#sql #postgres #webdev #typeorm
Comments
5 min read
Understanding ACID Properties in SQL Transactions
naveens_k_403279738dbcab6 profile

Understanding ACID Properties in SQL Transactions

#database #architecture #beginners #sql
3
Comments
2 min read
🚀 Indexing, Hashing & Query Optimization in SQL (Tutorial Example on Students Table)
thushitha_tk_ffd2acfb6067 profile

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

#mysql #programming #beginners #sql
Comments
2 min read
Demystifying Normalization in RDBMS: From 1NF to 3NF
naveens_k_403279738dbcab6 profile

Demystifying Normalization in RDBMS: From 1NF to 3NF

#dbms #data #sql #normalization
3
Comments
5 min read
Indexing, Hashing, and Query
harshitha_s_c436fb6552a2a profile

Indexing, Hashing, and Query

#database #computerscience #performance #sql
1
Comments
1 min read
SQLite dot commands: read file or standard output
mr_destructive profile

SQLite dot commands: read file or standard output

#sqlite #sql #database #programming
1
Comments
3 min read
Fuzzy String Matching in PostgreSQL with pg_trgm (Trigram Search Tutorial)
talemul profile

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

#postgres #trigram #database #sql
2
Comments
2 min read
Suppose you have duplicate rows in a table. How can you delete all duplicates but keep one copy using SQL only?
sachin_ghatage profile

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

#sql #rownumber
Comments
1 min read
NORMALIZATION
santhosh_m_7dcc3d605279c5 profile

NORMALIZATION

#database #sql #beginners #tutorial
1
Comments
3 min read
From Kafka to Clean Tables: Building a Confluent Snowflake Pipeline with Streams & Tasks
kepha_mwandiki profile

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

#dataengineering #automation #tutorial #sql
3
Comments 1
10 min read
Beyond Functional: Writing Professional and Performant SQL Queries
gregory42266270 profile

Beyond Functional: Writing Professional and Performant SQL Queries

#database #performance #sql
3
Comments
2 min read
The Ultimate Guide to SQL Joins and Subqueries Explained
datalane profile

The Ultimate Guide to SQL Joins and Subqueries Explained

#sql #programming #tutorial #database
11
Comments
7 min read
An Introduction to Commonly Used PL/SQL Data Types
ayako_yk profile

An Introduction to Commonly Used PL/SQL Data Types

#beginners #database #learning #sql
1
Comments
4 min read
Implementing Hierarchical Data Structures in PostgreSQL: LTREE vs Adjacency List vs Closure Table
dowerdev profile

Implementing Hierarchical Data Structures in PostgreSQL: LTREE vs Adjacency List vs Closure Table

#database #postgres #sql
5
Comments 1
18 min read
SQLite dot commands: html tables with output and once
mr_destructive profile

SQLite dot commands: html tables with output and once

#sql #sqlite #database
1
Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.