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.
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
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
SQL CASE Statements: The Order Matters!
drorata profile

SQL CASE Statements: The Order Matters!

#sql #database #dataengineering #python
Comments 1
2 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
HANDLING THE SAFE UPDATE MODE IN MYSQL
elimuigo profile

HANDLING THE SAFE UPDATE MODE IN MYSQL

#mysql #sql #sqlserver #database
Comments
1 min read
Count Distinct within Intervals in Order — From SQL to SPL #38
judith677 profile

Count Distinct within Intervals in Order — From SQL to SPL #38

#programming #sql #database #esprocspl
6
Comments 2
2 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
SQL Commands
shreyans_padmani profile

SQL Commands

#sql #dataanalytics #database #sqlcommands
Comments
2 min read
From Redundancy to Reusability: A Better Way to Manage Shared Records in Relational Databases
galisetty_priyatham_c1a49 profile

From Redundancy to Reusability: A Better Way to Manage Shared Records in Relational Databases

#datamodeling #sql
Comments 1
1 min read
Hackerrank - SQL - Occupations
mrpunkdasilva profile

Hackerrank - SQL - Occupations

#sql #learning #programming #hackerrank
Comments
2 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.