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.
Oracle Database - Compare Execution Plans

Oracle Database - Compare Execution Plans

9
Comments
5 min read
How to Replace a Null with the Corresponding Value in the Previous Record

How to Replace a Null with the Corresponding Value in the Previous Record

11
Comments 1
1 min read
Move Fast and “Branch” Things

Move Fast and “Branch” Things

2
Comments
8 min read
Exploring Enhanced Switch in Java

Exploring Enhanced Switch in Java

4
Comments 2
2 min read
Optimising Database Performance: The Pitfalls of ‘SELECT * FROM’ Queries

Optimising Database Performance: The Pitfalls of ‘SELECT * FROM’ Queries

Comments
4 min read
Getting Started with SQL Transactions in PostgreSQL

Getting Started with SQL Transactions in PostgreSQL

Comments
4 min read
Como normalizar banco de dados?

Como normalizar banco de dados?

9
Comments
2 min read
A Clever Way To Implement Pessimistic Locking in EF Core

A Clever Way To Implement Pessimistic Locking in EF Core

1
Comments
5 min read
How to Calculate Median on Values That Have Corresponding Quantities

How to Calculate Median on Values That Have Corresponding Quantities

10
Comments
2 min read
Easy no-code REST API for your databases

Easy no-code REST API for your databases

12
Comments 4
3 min read
Passing The DataCamp SQL Associate Certificate

Passing The DataCamp SQL Associate Certificate

34
Comments 3
2 min read
Unveiling the Power of Database-Side Rendering: Elevating Web Development Standards

Unveiling the Power of Database-Side Rendering: Elevating Web Development Standards

Comments
2 min read
Understanding SQL vs. NoSQL Databases: A Beginner's Guide

Understanding SQL vs. NoSQL Databases: A Beginner's Guide

3
Comments
2 min read
Building a Mermaid.js Gantt Chart in a FileMaker Web Viewer

Building a Mermaid.js Gantt Chart in a FileMaker Web Viewer

Comments
5 min read
Using SQL to discover problem dates in your data

Using SQL to discover problem dates in your data

Comments
10 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.