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.
SQL vs NoSQL: A Simple Guide to Picking the Right Database
danishrazabangash profile

SQL vs NoSQL: A Simple Guide to Picking the Right Database

#systemdesign #database #sql #mongodb
Comments
2 min read
Data Types and So much more
jomiedu profile

Data Types and So much more

#backend #database #sql
Comments
2 min read
Why Is My SQL Query Slow Only in Production? (The Parameter Sniffing Trap)
azhadsuhaimi profile

Why Is My SQL Query Slow Only in Production? (The Parameter Sniffing Trap)

#sql #database #performance
Comments 1
2 min read
How to compare two PostgreSQL schemas
eggletric profile

How to compare two PostgreSQL schemas

#postgres #database #sql #bash
1
Comments
6 min read
BUILDING GREENWOOD ACADEMY DATABASE USING POSTGRESQL
jedidah_ondiso_887753d76e profile

BUILDING GREENWOOD ACADEMY DATABASE USING POSTGRESQL

#backend #database #sql #tutorial
1
Comments
5 min read
How an Employee Hierarchy Helped Me Understand Recursive CTEs
saamiabbaskhan profile

How an Employee Hierarchy Helped Me Understand Recursive CTEs

#sql #database #algorithms #programming
6
Comments 1
13 min read
Solving the Division Problem in SQL and Relational Algebra Using Python Reasoning
ameer_abdullah_68d48c8496 profile

Solving the Division Problem in SQL and Relational Algebra Using Python Reasoning

#sql #datascience #software #saas
1
Comments
3 min read
SQLite vs PostgreSQL: Choosing the Right Database
qingluan profile
qing

SQLite vs PostgreSQL: Choosing the Right Database

#database #sql #tutorial #programming
Comments
5 min read
Databricks launches AI agent for legacy SQL migration
vpodk profile

Databricks launches AI agent for legacy SQL migration

#databricks #sql #ai #cloudmigration
3
Comments
4 min read
Your BigQuery bill is a query-shape problem. We cut one 72% in three weeks.
votiakov profile

Your BigQuery bill is a query-shape problem. We cut one 72% in three weeks.

#bigquery #gcp #dataengineering #sql
Comments 1
3 min read
I built a free, interactive SQL practice tool for data engineering interviews
harishdataengineer profile

I built a free, interactive SQL practice tool for data engineering interviews

#dataengineering #sql #webdev #interview
Comments 1
1 min read
What Has To Be True Before You Trust An AI Data Agent
paulcrinigan profile

What Has To Be True Before You Trust An AI Data Agent

#ai #data #sql #agents
2
Comments 2
3 min read
Postrges: Stop Fighting schema.sql — Export PostgreSQL into a Clean, Git-Friendly Project Structure
roman_shevel_a41af9e39d8a profile

Postrges: Stop Fighting schema.sql — Export PostgreSQL into a Clean, Git-Friendly Project Structure

#postgres #database #sql #devops
Comments 2
1 min read
SQL Execution Order Internals: Why WHERE Fails on Aliases but ORDER BY Succeeds
arpitmbangre profile

SQL Execution Order Internals: Why WHERE Fails on Aliases but ORDER BY Succeeds

#sql #database #dataengineering #backend
1
Comments 2
1 min read
Why SQL Is Still the Most Important Skill for Data Engineers
akonagalla28 profile

Why SQL Is Still the Most Important Skill for Data Engineers

#dataengineering #sql #python #programming
Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.