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.
Databricks SQL Essentials - Array Data Type
rueedlinger profile

Databricks SQL Essentials - Array Data Type

#database #dataengineering #sql #tutorial
Comments
6 min read
ForgeSQL: one diagram, real SQL, real Docker
thiago_rosadasilva_0688 profile

ForgeSQL: one diagram, real SQL, real Docker

#showdev #database #docker #sql
Comments
1 min read
Star Schema vs. Snowflake Schema: When to Use Each
alexmercedcoder profile

Star Schema vs. Snowflake Schema: When to Use Each

#architecture #database #dataengineering #sql
Comments
4 min read
SQLite as a Vector Database — Yes, Really
zrcic profile
Zrcic

SQLite as a Vector Database — Yes, Really

#ai #database #rag #sql
1
Comments
7 min read
🚀 SQL Joins and Window Functions Explained (With Real Examples for Data Analysts)
githinji_victormaina_627 profile

🚀 SQL Joins and Window Functions Explained (With Real Examples for Data Analysts)

#sql #database #datascience #beginners
2
Comments 1
3 min read
Introducing the (experimental!) Stainless SQL SDK generator
cjav_dev profile

Introducing the (experimental!) Stainless SQL SDK generator

#sql #webdev #openai #database
Comments
6 min read
The Ultimate Guide to Databricks Data Engineer Associate Exam: Everything You Need to Know
datatechbridge profile

The Ultimate Guide to Databricks Data Engineer Associate Exam: Everything You Need to Know

#dataengineering #learning #sql #tutorial
1
Comments
40 min read
COALESCE in SQL: the “Don’t Let NULL Win” Function You’ll Use Everywhere
baldwin_apps profile

COALESCE in SQL: the “Don’t Let NULL Win” Function You’ll Use Everywhere

#sql #database #programming #dataengineering
Comments
2 min read
SQL Joins and Window Functions: The Difference Between Combining Data and Analyzing It
wangeci_ndovu profile

SQL Joins and Window Functions: The Difference Between Combining Data and Analyzing It

#beginners #database #sql #tutorial
1
Comments
3 min read
Real world considerations: MS-SQL vs PostgreSQL vs MySQL
marko_mgi_b8a9b2bc90838b profile

Real world considerations: MS-SQL vs PostgreSQL vs MySQL

#sql #mysql #postgres
2
Comments
12 min read
PostgreSQL global statistics on partitionned table require a manual ANALYZE
franckpachot profile

PostgreSQL global statistics on partitionned table require a manual ANALYZE

#postgres #sql #database #partitioning
6
Comments
8 min read
Zero-Downtime Schema Changes in SQL Server: The Reality Behind “Just Run the Migration”
sonia_bobrik_1939cdddd79d profile

Zero-Downtime Schema Changes in SQL Server: The Reality Behind “Just Run the Migration”

#database #performance #sql #sre
Comments
6 min read
Why SQL Makes You Stand Ahead of Most Candidates
tanushreep profile

Why SQL Makes You Stand Ahead of Most Candidates

#sql #analytics #database #datascience
Comments
2 min read
Adding NOT NULL Constraints to Existing PostgreSQL Columns Safely
mickelsamuel profile

Adding NOT NULL Constraints to Existing PostgreSQL Columns Safely

#postgres #database #sql #backend
3
Comments
5 min read
Part 2: dbt Project Structure & Building Models 📁
abdelrahman_adnan profile

Part 2: dbt Project Structure & Building Models 📁

#data #dataengineering #sql #tutorial
Comments
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.