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.
A Windows Service is Down. Now What?
prateek_srivastava_6a5661 profile

A Windows Service is Down. Now What?

#devops #microsoft #sql #sre
Comments
6 min read
PostgreSQL psql: Schema Navigation Quick Reference
amelye_chatila_717552aace profile

PostgreSQL psql: Schema Navigation Quick Reference

#sql #database #postgres #devtips
Comments
1 min read
How I Built Memory for a Local AI Companion Without Sending Chats to a Server
lukasz_141142 profile

How I Built Memory for a Local AI Companion Without Sending Chats to a Server

#ai #rust #sql #buildinpublic
Comments
5 min read
Bringing Relational SQL Databases to the P2P World
ozymandiasthegreat profile

Bringing Relational SQL Databases to the P2P World

#architecture #database #software #sql
Comments
3 min read
A SQL interview is a translation test, not a syntax test
fourleaf profile

A SQL interview is a translation test, not a syntax test

#sql #career #interview #database
Comments
6 min read
Where to Get a Sample Database to Practice SQL (And How to Check It Loaded)
michaelnocito profile

Where to Get a Sample Database to Practice SQL (And How to Check It Loaded)

#sql #database #tutorial #beginners
Comments
13 min read
How to Practice SQL Online With Nothing Installed (And Where Your Data Goes)
michaelnocito profile

How to Practice SQL Online With Nothing Installed (And Where Your Data Goes)

#sql #database #tutorial #beginners
Comments
11 min read
Customer Segmentation in SQL With CASE WHEN
michaelnocito profile

Customer Segmentation in SQL With CASE WHEN

#sql #database #tutorial #beginners
Comments
14 min read
SQL Comment Syntax by Database: MySQL, PostgreSQL, SQL Server, SQLite, Oracle
michaelnocito profile

SQL Comment Syntax by Database: MySQL, PostgreSQL, SQL Server, SQLite, Oracle

#sql #database #tutorial #beginners
Comments
5 min read
NULL in SQL: Why = NULL Finds Nothing and What to Write Instead
michaelnocito profile

NULL in SQL: Why = NULL Finds Nothing and What to Write Instead

#sql #database #tutorial #beginners
Comments
14 min read
Month-over-Month Growth in SQL: LAG, the Growth Formula, and the Traps
michaelnocito profile

Month-over-Month Growth in SQL: LAG, the Growth Formula, and the Traps

#sql #database #tutorial #beginners
Comments
15 min read
How to Find Duplicate Rows in SQL (and Decide What Counts as One)
michaelnocito profile

How to Find Duplicate Rows in SQL (and Decide What Counts as One)

#sql #database #tutorial #beginners
Comments
15 min read
Which SQL Database Should You Install?
michaelnocito profile

Which SQL Database Should You Install?

#sql #database #tutorial #beginners
Comments
6 min read
COMMENT ON TABLE: How to Store a Table Description in the Database Itself
michaelnocito profile

COMMENT ON TABLE: How to Store a Table Description in the Database Itself

#sql #database #tutorial #beginners
Comments
6 min read
Why I Stopped Rushing to Machine Learning and Started with SQL Instead!
shreyas_s_cf15e23eb1cbcbc profile

Why I Stopped Rushing to Machine Learning and Started with SQL Instead!

#datascience #learning #machinelearning #sql
1
Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.