Forem

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.
Introducing MindsDB’s Integration with Gong: AI Analytics on Call Data
Cover image for Introducing MindsDB’s Integration with Gong: AI Analytics on Call Data

Introducing MindsDB’s Integration with Gong: AI Analytics on Call Data

5
Comments
7 min read
Battling Laravel's Sneaky DELETEs: How I Got ORDER BY and LIMIT to Play Nice with Joins
Cover image for Battling Laravel's Sneaky DELETEs: How I Got ORDER BY and LIMIT to Play Nice with Joins

Battling Laravel's Sneaky DELETEs: How I Got ORDER BY and LIMIT to Play Nice with Joins

5
Comments 2
3 min read
How to write Hello World in Oracle SQL
Cover image for How to write Hello World in Oracle SQL

How to write Hello World in Oracle SQL

Comments
1 min read
SQLite dot commands: read command is recursive?

SQLite dot commands: read command is recursive?

1
Comments
2 min read
SQL LIKE Operator: What It Is, How It Works, and Best Practices
Cover image for SQL LIKE Operator: What It Is, How It Works, and Best Practices

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

Comments
2 min read
Indexing, Hashing & Query Optimization in SQL

Indexing, Hashing & Query Optimization in SQL

2
Comments
2 min read
Transactions, Deadlocks & Log Based Recovery in SQL

Transactions, Deadlocks & Log Based Recovery in SQL

2
Comments
2 min read
Understanding Subqueries in SQL and Building JSON Directly in PostgreSQL
Cover image for Understanding Subqueries in SQL and Building JSON Directly in PostgreSQL

Understanding Subqueries in SQL and Building JSON Directly in PostgreSQL

Comments
5 min read
Understanding ACID Properties in SQL Transactions
Cover image for Understanding ACID Properties in SQL Transactions

Understanding ACID Properties in SQL Transactions

3
Comments
2 min read
SQL Rewriting vs. Indexing: How AI-Powered Structural Optimization Achieves 20x Scalability Gains
Cover image for SQL Rewriting vs. Indexing: How AI-Powered Structural Optimization Achieves 20x Scalability Gains

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

1
Comments 1
14 min read
🚀 Indexing, Hashing & Query Optimization in SQL (Tutorial Example on Students Table)
Cover image for 🚀 Indexing, Hashing & Query Optimization in SQL (Tutorial Example on Students Table)

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

Comments
2 min read
Demystifying Normalization in RDBMS: From 1NF to 3NF
Cover image for Demystifying Normalization in RDBMS: From 1NF to 3NF

Demystifying Normalization in RDBMS: From 1NF to 3NF

3
Comments
5 min read
Indexing, Hashing, and Query
Cover image for Indexing, Hashing, and Query

Indexing, Hashing, and Query

1
Comments
1 min read
SQLite dot commands: read file or standard output

SQLite dot commands: read file or standard output

1
Comments
3 min read
Fuzzy String Matching in PostgreSQL with pg_trgm (Trigram Search Tutorial)

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

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?

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

Comments
1 min read
NORMALIZATION
Cover image for NORMALIZATION

NORMALIZATION

1
Comments
3 min read
From Kafka to Clean Tables: Building a Confluent Snowflake Pipeline with Streams & Tasks
Cover image for From Kafka to Clean Tables: Building a Confluent Snowflake Pipeline with Streams & Tasks

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

3
Comments 1
10 min read
SQLStorm & CogniSQL: An AI-Augmented SQL Dataset(202508)
Cover image for SQLStorm & CogniSQL: An AI-Augmented SQL Dataset(202508)

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

Comments
4 min read
SQL Server Performance Optimization: Window Functions to Double Your Query Efficiency!
Cover image for SQL Server Performance Optimization: Window Functions to Double Your Query Efficiency!

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

Comments
4 min read
SQLite functions: Generate Series Examples

SQLite functions: Generate Series Examples

Comments
2 min read
Beyond Functional: Writing Professional and Performant SQL Queries
Cover image for Beyond Functional: Writing Professional and Performant SQL Queries

Beyond Functional: Writing Professional and Performant SQL Queries

3
Comments
2 min read
The Ultimate Guide to SQL Joins and Subqueries Explained
Cover image for The Ultimate Guide to SQL Joins and Subqueries Explained

The Ultimate Guide to SQL Joins and Subqueries Explained

11
Comments
7 min read
An Introduction to Commonly Used PL/SQL Data Types

An Introduction to Commonly Used PL/SQL Data Types

1
Comments
4 min read
SQLite functions: generate series

SQLite functions: generate series

Comments
4 min read
loading...