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.
Why I Built an "Awesome List" for Data Analysis (And How It Can Help You)
pavelgrigoryev profile

Why I Built an "Awesome List" for Data Analysis (And How It Can Help You)

#datascience #beginners #sql #python
5
Comments
2 min read
Building SW: Lessons from the Backend
ryansgi profile

Building SW: Lessons from the Backend

#go #opensource #webdev #sql
4
Comments
8 min read
Automating Old Partition Cleanup in Oracle with PL/SQL
mrcaption49 profile

Automating Old Partition Cleanup in Oracle with PL/SQL

#automation #database #sql
6
Comments
3 min read
Enterprise Software Vendors: Drive Compliance & Customer Insights with MindsDB Knowledge Bases + Hybrid Search
mindsdbteam profile

Enterprise Software Vendors: Drive Compliance & Customer Insights with MindsDB Knowledge Bases + Hybrid Search

#ai #sql #knowledgebase #tutorial
Comments
12 min read
👉 “Top 5 SQL Query Patterns Every Developer Should Know for Interviews”
fullstackprepdev_sda_d43a profile

👉 “Top 5 SQL Query Patterns Every Developer Should Know for Interviews”

#webdev #programming #sql #interview
Comments
1 min read
Combine Two JSON Collections with Nested Arrays: MongoDB and PostgreSQL Aggregations
franckpachot profile

Combine Two JSON Collections with Nested Arrays: MongoDB and PostgreSQL Aggregations

#mongodb #postgres #sql #json
Comments
8 min read
👉 “SQL Joins Explained Like You’re 5 (Interview-Friendly Guide)”
fullstackprepdev profile

👉 “SQL Joins Explained Like You’re 5 (Interview-Friendly Guide)”

#webdev #programming #sql #developer
Comments
1 min read
Filtering and Retrieving in SQL
koustav profile

Filtering and Retrieving in SQL

#sql #mysql #database #tutorial
1
Comments 2
3 min read
SQL Rewriting vs. Indexing: How AI-Powered Structural Optimization Achieves 20x Scalability Gains
rebooter_s profile

SQL Rewriting vs. Indexing: How AI-Powered Structural Optimization Achieves 20x Scalability Gains

#sql #mysql #performance #ai
1
Comments 1
14 min read
Converting CSV to PDF HTML JSON & SQL
danish profile

Converting CSV to PDF HTML JSON & SQL

#json #pdf #sql #csv
Comments
7 min read
Oracle SQL Plan Management - 23ai features backported to 19.22
abhilash8 profile

Oracle SQL Plan Management - 23ai features backported to 19.22

#sql #oracle #tuning #oci
Comments
4 min read
Simplifying SQL Date Data Types with Practical Tips
dbvismarketing profile

Simplifying SQL Date Data Types with Practical Tips

#sql #mysql #oracle #postgressql
Comments
1 min read
Sagas vs ACID Transactions: Ensuring Reliability in Distributed Architectures
andrey_s profile

Sagas vs ACID Transactions: Ensuring Reliability in Distributed Architectures

#sql #dataengineering #database #analytics
1
Comments
11 min read
OWOX Data Marts - Free Open-Source Self-Service Analytics Platform
owoxbi profile

OWOX Data Marts - Free Open-Source Self-Service Analytics Platform

#data #analytics #sql #opensource
Comments
1 min read
Zero Downtime Migrations: Shadow Table Strategy Explained
zeedu_dev profile

Zero Downtime Migrations: Shadow Table Strategy Explained

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