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.
Explaining self-join in SQL

Explaining self-join in SQL

Comments
1 min read
Handling Dates and Times in Oracle Database

Handling Dates and Times in Oracle Database

1
Comments
3 min read
Calculate based on the records within the group and fill the result into the first record:From SQL to SPL #4

Calculate based on the records within the group and fill the result into the first record:From SQL to SPL #4

5
Comments
3 min read
Uses of Snowflake Schema

Uses of Snowflake Schema

Comments
3 min read
Why Successful Companies Don't Have DBAs

Why Successful Companies Don't Have DBAs

Comments
4 min read
Like IDE for SparkSQL: Support Pycharm! SparkSQLHelper v2025.1.1 released

Like IDE for SparkSQL: Support Pycharm! SparkSQLHelper v2025.1.1 released

Comments
1 min read
Introduction to SQL

Introduction to SQL

Comments
3 min read
Rails Self-Join Tables - Parent-Child Magic

Rails Self-Join Tables - Parent-Child Magic

Comments
3 min read
SQL Injection - In Just 5 Minutes!

SQL Injection - In Just 5 Minutes!

Comments
3 min read
Find logged Microsoft SQL Server Messages

Find logged Microsoft SQL Server Messages

Comments
1 min read
Front-End to Full-Stack Journey Part 3: Server Proxies, React and Progress

Front-End to Full-Stack Journey Part 3: Server Proxies, React and Progress

Comments
4 min read
SQL 101 | Chapter 3: Mastering Data Retrieval with SELECT Statements

SQL 101 | Chapter 3: Mastering Data Retrieval with SELECT Statements

Comments
7 min read
Observability 2.0 - The Best Thing Since Sliced Bread

Observability 2.0 - The Best Thing Since Sliced Bread

Comments
4 min read
SQL Transactions - COMMIT, ROLLBACK, and Savepoints with Python

SQL Transactions - COMMIT, ROLLBACK, and Savepoints with Python

Comments
2 min read
Explaining Relation and Data Independence in SQL

Explaining Relation and Data Independence in SQL

Comments
2 min read
A Quick Guide to SQL Data Modification Commands with Examples

A Quick Guide to SQL Data Modification Commands with Examples

1
Comments
3 min read
Search for the closest matching record within the group:From SQL to SPL

Search for the closest matching record within the group:From SQL to SPL

7
Comments
2 min read
Mastering SAP SD: Streamlining Sales and Distribution

Mastering SAP SD: Streamlining Sales and Distribution

Comments
1 min read
SQL VS NoSQL

SQL VS NoSQL

Comments
2 min read
Understanding Views in Databases: A Complete Guide 🧠💡

Understanding Views in Databases: A Complete Guide 🧠💡

2
Comments
5 min read
This Is Probably the Most Perfect Programming for Solving SQL Data Analysis Pain Points

This Is Probably the Most Perfect Programming for Solving SQL Data Analysis Pain Points

6
Comments
7 min read
Subqueries

Subqueries

Comments
1 min read
Transactions and ACID Properties

Transactions and ACID Properties

Comments
3 min read
Calculate monthly account balance and fill in missing dates:From SQL to SPL

Calculate monthly account balance and fill in missing dates:From SQL to SPL

6
Comments
2 min read
How And Why The Developer-First Approach Is Changing The Observability Landscape

How And Why The Developer-First Approach Is Changing The Observability Landscape

Comments
11 min read
loading...