select * from SQL Page 120 - DEV Community

Skip to content

DEV Community

Allowed

Posts about learning SQL
Posts about tips, tricks, problems, and answers
Posts about news or commentary of the field
Posts about specific tooling or frameworks

Think what would someone wanting to learn more about SQL want to see.

Not Allowed

Articles that mention SQL in passing
Articles that break the terms of use

SQL is the language of data, has been for nearly 50 years now!

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Apr 3

left join an effective satellite without duplicating rows (use a cte)

#datavault #sql #effectivesatellite #leftjoin

3 min read

Matty Stratton for Tiger Data (Creators of TimescaleDB)

Mar 18

How Do PostgreSQL Indices Work, Anyways?

#postgres #database #sql #performance

6 min read

Mar 21

Building a SQL Tokenizer and Formatter From Scratch — Supporting 6 Dialects

#sql #webdev #typescript #javascript

5 min read

Mar 13

Connecting power bi to SQL databases locally and through cloud service.

#sql #database #productivity #beginners

5 min read

Feb 17

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

#database #performance #sql #sre

6 min read

Mar 2

Adding NOT NULL Constraints to Existing PostgreSQL Columns Safely

#postgres #database #sql #backend

5 min read

Santhoshi Mary A

Mar 22

Number Guessing Game

#database #python #sql #tutorial

2 min read

Abdelrahman Adnan

Feb 16

# Module 4 Summary - Analytics Engineering with dbt

#analytics #dataengineering #sql #tutorial

2 min read

Abdelrahman Adnan

Feb 16

Part 3: Testing, Documentation & Deployment 🚀

#analytics #dataengineering #sql #tutorial

5 min read

Feb 16

Solving MSSQL's 2100 Parameter Limit: From IN Clause to Cursor-Based Pagination

#backend #database #sql #typescript

4 min read

catatsuy

Mar 15

Why I, as Someone Who Likes MySQL, Now Want to Recommend PostgreSQL

#mysql #postgres #database #sql

13 min read

Beverline Otiende

Mar 22

Advanced SQL for Data Analytics: Advanced Techniques Every Data Analyst Should Know

#sql #database #datascience

14 min read

Mar 17

Partitioning PotgreSQL Database

#sql #postgres #architecture #performance

4 min read

Teymur Bayramov

Feb 19

How to implement “CreatedAt” and “UpdatedAt” timestamps in Entity Framework Core?

#csharp #sql #database #dotnet

7 min read

Mar 21

Snowflake vs Redshift vs BigQuery: Which One Should You Use?

#sql #beginners #snowflake #dataengineering

4 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.