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.
"Table 'test.p' doesn't exist" — Understanding SQL Aliases and Default JOIN Behavior
dean_lee profile

"Table 'test.p' doesn't exist" — Understanding SQL Aliases and Default JOIN Behavior

#database #sql #leetcode #beginners
Comments
2 min read
How Databricks Genie Turns Plain English Into SQL Code
lucy1 profile
Lucy

How Databricks Genie Turns Plain English Into SQL Code

#databricks #dataengineering #sql #ai
5
Comments
11 min read
SQL Views Explained: Write Once, Query Forever
vivekdraxlr profile

SQL Views Explained: Write Once, Query Forever

#sql #database #postgres #beginners
Comments 1
6 min read
CVE-2026-21643: FortiClient EMS Critical SQL Injection — Actively Exploited, No Credentials Required
yuznumara profile

CVE-2026-21643: FortiClient EMS Critical SQL Injection — Actively Exploited, No Credentials Required

#news #cybersecurity #infosec #sql
Comments
2 min read
I Analyzed 10 Million Records in 47 Seconds Using Python + DuckDB (No Spark, No Cloud)
dattasable profile

I Analyzed 10 Million Records in 47 Seconds Using Python + DuckDB (No Spark, No Cloud)

#sql #python #dataengineering #tutorial
3
Comments 2
3 min read
Stop Using Subqueries: 3 Advanced SQL CTE Patterns That Saved My Production Database
dattasable profile

Stop Using Subqueries: 3 Advanced SQL CTE Patterns That Saved My Production Database

#sql #database #dataengineering #programming
Comments 1
3 min read
MySQL InnoDB Locking: The Silent Killer Behind Database Crashes
sriramrajendran profile

MySQL InnoDB Locking: The Silent Killer Behind Database Crashes

#mysql #database #sql #opensource
Comments 1
24 min read
CTEs vs Subqueries in SQL: Which One Should You Use?
neha_christina_1ac8651819 profile

CTEs vs Subqueries in SQL: Which One Should You Use?

#sql #dataengineering #beginners #programming
Comments
3 min read
PetStore: Pure Java for UI and Safe SQL Mapping
pponec profile

PetStore: Pure Java for UI and Safe SQL Mapping

#showdev #java #sql #ui
Comments
3 min read
SQL String Functions: Clean, Transform, and Tame Messy Data Like a Pro
vivekdraxlr profile

SQL String Functions: Clean, Transform, and Tame Messy Data Like a Pro

#sql #database #postgres #dataengineering
Comments
6 min read
How to Optimize BigQuery Costs (Real Techniques That Work)
amaranarun profile

How to Optimize BigQuery Costs (Real Techniques That Work)

#bigquery #dataengineering #googlecloud #sql
1
Comments
9 min read
Data modelling in Power BI: Joins, Relationships, and Schemas Explained.
hadijja_musekwa_3ba940a91 profile

Data modelling in Power BI: Joins, Relationships, and Schemas Explained.

#beginners #database #microsoft #sql
Comments
2 min read
SQL Injection Explained: How Hackers Bypass Login Forms (and How to Stop Them)
sanjayghosh profile

SQL Injection Explained: How Hackers Bypass Login Forms (and How to Stop Them)

#security #cybersecurity #webdev #sql
1
Comments
3 min read
Leveling up: Adding SQLite Persistence to my Rust Guessing Game
uc_yussy profile
Yussy

Leveling up: Adding SQLite Persistence to my Rust Guessing Game

#rust #sql
Comments
1 min read
AdventureWorks Is Dead. Here's a 42-Table Business Dataset That Actually Balances.
mindweavetech profile

AdventureWorks Is Dead. Here's a 42-Table Business Dataset That Actually Balances.

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