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.
Learning SQL? Here is a Practical Guide to Read and Write SQL Queries.
okall_omondi profile

Learning SQL? Here is a Practical Guide to Read and Write SQL Queries.

#sql #programming #beginners #tutorial
Comments
6 min read
Ottoch - ask your database questions in you plain language, self-hosted....
santhosh_bhandari_aee9f66 profile

Ottoch - ask your database questions in you plain language, self-hosted....

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

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

#productivity #opensource #database #sql
Comments
6 min read
When SQL Has Nothing to Say: Understanding NULLs
rose_odiwuor profile

When SQL Has Nothing to Say: Understanding NULLs

#sql
Comments
3 min read
Merging Two Messy CSVs: The Key Problems Excel Formulas Hide From You
yuhehe profile

Merging Two Messy CSVs: The Key Problems Excel Formulas Hide From You

#webdev #datascience #sql #beginners
Comments 1
3 min read
Database Indexing That Actually Speeds Things Up
stackhorizon profile

Database Indexing That Actually Speeds Things Up

#database #sql #performance #postgres
Comments 1
3 min read
A DEEP DIVE INTO DDL'S AND DML'S
mysticg profile

A DEEP DIVE INTO DDL'S AND DML'S

#beginners #database #sql
Comments 1
3 min read
SQL for Beginners: Window Functions vs GROUP BY
mysticg profile

SQL for Beginners: Window Functions vs GROUP BY

#sql #ai #programming #productivity
2
Comments
4 min read
My SQL Learning Journey: The Sunrise Supermarket Project
nelly_gitonga profile

My SQL Learning Journey: The Sunrise Supermarket Project

#beginners #database #learning #sql
5
Comments
5 min read
I Replaced SQLite's C Driver with 800 Lines of Pure Python Stdlib: What the Docs Don't Tell You About Raw B-Trees, 9-Byte Varints, and 48-Bit Integers
sandman_sh profile

I Replaced SQLite's C Driver with 800 Lines of Pure Python Stdlib: What the Docs Don't Tell You About Raw B-Trees, 9-Byte Varints, and 48-Bit Integers

#python #sql
Comments 1
15 min read
Walking an Org Chart with One SQL Query
rahmanfrr profile
Rahman

Walking an Org Chart with One SQL Query

#sql #postgres #database #tutorial
Comments
1 min read
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 I built one open-source SQL workspace for five database engines
cccadet profile

How I built one open-source SQL workspace for five database engines

#opensource #sql #database #typescript
Comments 1
4 min read
A Nullable Column Cost Me Five Years of Branches
_66d02d0cc1ece7d1137c5f profile

A Nullable Column Cost Me Five Years of Branches

#sql #schema #postgres #nulls
Comments 2
4 min read
How I Recovered Deleted SQL Server Rows Without Ever Enabling CDC or Audit
caiderek profile

How I Recovered Deleted SQL Server Rows Without Ever Enabling CDC or Audit

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