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.
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
Hackerrank - SQL - Occupations
mrpunkdasilva profile

Hackerrank - SQL - Occupations

#sql #learning #programming #hackerrank
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
🧩 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 - Higher Than 75 Marks
mrpunkdasilva profile

Hackerrank - SQL - Higher Than 75 Marks

#sql #beginners #hackerrank #learning
Comments
2 min read
Unlock Database Perfection: 15 Essential Resources for SQL Normalization Mastery
vaib profile

Unlock Database Perfection: 15 Essential Resources for SQL Normalization Mastery

#database #sql #normalization #dbms
2
Comments
5 min read
Hackerrank - SQL - Japanese Cities' Names
mrpunkdasilva profile

Hackerrank - SQL - Japanese Cities' Names

#sql #beginners #hackerrank #learning
Comments
1 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
How I Analyzed Retail Sales Data Using SQL
akansrodger profile

How I Analyzed Retail Sales Data Using SQL

#sql #postgres #portfolio #learning
Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.