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.
Online Voting System in my facing challenges.....
abineshrajendiran profile

Online Voting System in my facing challenges.....

#beginners #java #sql #jdbc
1
Comments
2 min read
How to Pass the Amazon SQL Interview (A Practical Guide)
rahmanfrr profile
Rahman

How to Pass the Amazon SQL Interview (A Practical Guide)

#sql #dataengineering #career #interview
Comments
4 min read
Advanced SQL: Mastering CTEs and Window Functions
rahmanfrr profile
Rahman

Advanced SQL: Mastering CTEs and Window Functions

#sql #database #programming #tutorial
Comments
3 min read
What actually happens in a database index (and why half of them do nothing)
vladut02 profile
VLAD

What actually happens in a database index (and why half of them do nothing)

#database #sql #postgres #performance
2
Comments 1
4 min read
Open-source tool: Practical experience in converting large quantities of SQL code syntax : 'PIVOT' function rewrite (Case 1)
zgl20053779 profile

Open-source tool: Practical experience in converting large quantities of SQL code syntax : 'PIVOT' function rewrite (Case 1)

#automation #database #opensource #sql
Comments
5 min read
The hardest label in our dataset is the one where nothing happened
inve_money_e95961f8489d28 profile

The hardest label in our dataset is the one where nothing happened

#datascience #dataengineering #analytics #sql
Comments
14 min read
We Replaced 3 Microservices With One Postgres Table
infoinlet1 profile

We Replaced 3 Microservices With One Postgres Table

#postgres #architecture #backend #sql
6
Comments
7 min read
How to Solve a Month-over-Month Churn SQL Interview Question
rahmanfrr profile
Rahman

How to Solve a Month-over-Month Churn SQL Interview Question

#sql #dataengineering #interviewprep #amazon
Comments
4 min read
Open-source tool: Simple example of syntax conversion for batch SQL code: 'ORACLE START WITH CONNECT' syntax conversion
zgl20053779 profile

Open-source tool: Simple example of syntax conversion for batch SQL code: 'ORACLE START WITH CONNECT' syntax conversion

#automation #database #opensource #sql
1
Comments 1
2 min read
Recursive CTEs, explained from first principles
sophiemwangi profile

Recursive CTEs, explained from first principles

#sql #cte #dataengineering #datascience
3
Comments 2
5 min read
The Transactional Outbox Pattern: Dual-Write Consistency in Distributed Systems
amasen profile

The Transactional Outbox Pattern: Dual-Write Consistency in Distributed Systems

#sql #postgres #distributedsystems #architecture
Comments
3 min read
SQL DATEDIFF Internals: Why 2 Seconds Can Equal 1 Full Day (Boundary Traps)
arpitmbangre profile

SQL DATEDIFF Internals: Why 2 Seconds Can Equal 1 Full Day (Boundary Traps)

#sql #database #dataengineering #beginners
Comments
2 min read
Don't put an LLM in charge of your production database
aniketsoni profile

Don't put an LLM in charge of your production database

#sql #llm #data #platform
Comments
5 min read
How to return top-N from each group with GROUP_CONCAT()
sanikolaev profile

How to return top-N from each group with GROUP_CONCAT()

#database #sql #opensource #tutorial
Comments
6 min read
Three ways your dashboard can be correct and still lie
sprettball profile

Three ways your dashboard can be correct and still lie

#data #sql #webdev #analytics
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.