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.
Hackerrank - SQL - Revising the Select Query II
mrpunkdasilva profile

Hackerrank - SQL - Revising the Select Query II

#sql #learning #beginners #hackerrank
1
Comments
1 min read
Building a Sales Analytics Dashboard on Azure PostgreSQL + Azure Data Studio
cli_tayo profile

Building a Sales Analytics Dashboard on Azure PostgreSQL + Azure Data Studio

#postgressql #sql #azure #database
2
Comments
3 min read
Mastering Automation: 5 Real-World n8n Workflow Examples (With Step-by-Step Guides)
grantwatsondev profile

Mastering Automation: 5 Real-World n8n Workflow Examples (With Step-by-Step Guides)

#sql #programming
3
Comments
4 min read
đŸ§± OLTP vs OLAP: When Transaction Meets Analytics
qvfagundes profile

đŸ§± OLTP vs OLAP: When Transaction Meets Analytics

#datafoundation #dataengineering #ai #sql
2
Comments
2 min read
Sequences in MongoDB
franckpachot profile

Sequences in MongoDB

#mongodb #database #sequence #sql
Comments
4 min read
SQL Server 2025 - What’s New and How to Visualize the Schema
roxana_haidiner profile

SQL Server 2025 - What’s New and How to Visualize the Schema

#sqlserver #database #sql #dataengineering
14
Comments 1
7 min read
Learn SQL Fast: A Step-by-Step Tutorial for Beginners
pythontutorial profile

Learn SQL Fast: A Step-by-Step Tutorial for Beginners

#sql #sqltutorial
Comments
3 min read
Database Design Errors to Avoid & How To Fix Them
roxana_haidiner profile

Database Design Errors to Avoid & How To Fix Them

#database #sql #mysql #dataengineering
11
Comments 1
5 min read
Remember to set the frequency for replication to Litestream!
lucianghinda profile

Remember to set the frequency for replication to Litestream!

#ruby #sqlite #sql #backup
3
Comments 2
1 min read
Top Free ER Diagram Tools for PostgreSQL in 2025
roxana_haidiner profile

Top Free ER Diagram Tools for PostgreSQL in 2025

#postgres #postgressql #sql #database
11
Comments 1
7 min read
Filtering Out Rows Using LEFT JOIN: A Clean Alternative to NOT IN
drorata profile

Filtering Out Rows Using LEFT JOIN: A Clean Alternative to NOT IN

#sql #sqlpatterns #analytics #tutorial
1
Comments
3 min read
đŸ§© When to Use NoSQL and SQL?
sajidurshajib profile

đŸ§© When to Use NoSQL and SQL?

#sql #nosql #database #systemdesign
5
Comments
2 min read
Hackerrank - SQL - Average Population of Each Continent
mrpunkdasilva profile

Hackerrank - SQL - Average Population of Each Continent

#programming #sql #devchallenge #hackerrank
6
Comments
2 min read
SQL Server Stored Procedure Design for Flexible Record Lookup
seanmdrew profile

SQL Server Stored Procedure Design for Flexible Record Lookup

#sql
2
Comments 4
5 min read
Django ORM: consultas complexas pt.2
mts-lucas profile

Django ORM: consultas complexas pt.2

#django #python #backend #sql
1
Comments
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.