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.
Getting Started with SQL: A Guide for Data Analysts
tiffkaranja profile

Getting Started with SQL: A Guide for Data Analysts

#dataanalytics #datascience #sql #tutorial
Comments 1
2 min read
Olake (Lakehouse)
sandarbh_bajpai profile

Olake (Lakehouse)

#devrel #database #opensource #sql
Comments
2 min read
Apresentação do Repositório Dotnet Templates
ortizdavid profile

Apresentação do Repositório Dotnet Templates

#csharp #dotnet #sql #api
Comments
2 min read
Features I Wish MySQL Had but Postgres 🐘 Already Has 😻
op3ratordec profile

Features I Wish MySQL Had but Postgres 🐘 Already Has 😻

#postgres #mysql #sql #database
5
Comments 2
5 min read
ORM vs ODM: What's the Difference and When to Use Them?
himanshudevgupta profile

ORM vs ODM: What's the Difference and When to Use Them?

#programming #sql #mongodb #tutorial
7
Comments
1 min read
Top 5 Alternative Data Career Paths (And How to Learn Each for Free)
destinovaailabs profile

Top 5 Alternative Data Career Paths (And How to Learn Each for Free)

#datascience #ai #sql #mysql
Comments 2
4 min read
Backup (and restore) an Sql database inside a docker container.
arvinyorro profile

Backup (and restore) an Sql database inside a docker container.

#docker #sql #cli #terminal
Comments
1 min read
10 SQL Anti-Patterns You Must Avoid in Production
cristiansifuentes profile

10 SQL Anti-Patterns You Must Avoid in Production

#sql #database #performance #advancedsql
2
Comments
2 min read
SQL Join Dark Arts: Anti Joins, Semi Joins, and Beyond
cristiansifuentes profile

SQL Join Dark Arts: Anti Joins, Semi Joins, and Beyond

#sql #database
Comments
2 min read
Think in Sets: Writing High-Performance SQL the Declarative Way
cristiansifuentes profile

Think in Sets: Writing High-Performance SQL the Declarative Way

#sql #database #postgres #sqlserver
Comments
2 min read
Transforming Rows to Columns and Back: SQL PIVOT/UNPIVOT Techniques
cristiansifuentes profile

Transforming Rows to Columns and Back: SQL PIVOT/UNPIVOT Techniques

#sql #database #dataengineering #analytics
1
Comments
2 min read
Working with JSON in PostgreSQL, MySQL & SQL Server
cristiansifuentes profile

Working with JSON in PostgreSQL, MySQL & SQL Server

#sql #database #json #datamodeling
1
Comments
2 min read
Querying the Past: Temporal Tables in SQL Server and PostgreSQL
cristiansifuentes profile

Querying the Past: Temporal Tables in SQL Server and PostgreSQL

#sql #database #sqlserver #postgres
2
Comments
2 min read
Materialized Views in SQL: Supercharging Read Performance
cristiansifuentes profile

Materialized Views in SQL: Supercharging Read Performance

#sql #database #dataengineering #backend
Comments
2 min read
Behind the Scenes: Reading SQL Execution Plans Like a Pro
cristiansifuentes profile

Behind the Scenes: Reading SQL Execution Plans Like a Pro

#sql #database #backend #indexing
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.