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 Security Patterns for Web Applications

Database Security Patterns for Web Applications

Comments
2 min read
SQLite dot commands: Output mode separator command

SQLite dot commands: Output mode separator command

2
Comments
2 min read
The main tasks of a Database Administrator (DBA) by 2025

The main tasks of a Database Administrator (DBA) by 2025

5
Comments
27 min read
SQLite dot commands: Output mode

SQLite dot commands: Output mode

2
Comments
9 min read
How to Migrate Your On-Premise Database to Google Cloud SQL? A Detailed Guide

How to Migrate Your On-Premise Database to Google Cloud SQL? A Detailed Guide

6
Comments
5 min read
COLLEGE STUDENT & COURSE MANAGEMENT SYSTEM

COLLEGE STUDENT & COURSE MANAGEMENT SYSTEM

1
Comments
2 min read
Associações polimórficas no Rails: como fazer, prós e contras

Associações polimórficas no Rails: como fazer, prós e contras

17
Comments 3
4 min read
Day 2: Data Analytics Progress📈

Day 2: Data Analytics Progress📈

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

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

5
Comments
2 min read
Building SW: Lessons from the Backend

Building SW: Lessons from the Backend

4
Comments
8 min read
Automating Old Partition Cleanup in Oracle with PL/SQL

Automating Old Partition Cleanup in Oracle with PL/SQL

6
Comments
3 min read
Enterprise Software Vendors: Drive Compliance & Customer Insights with MindsDB Knowledge Bases + Hybrid Search

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

Comments
12 min read
👉 “Top 5 SQL Query Patterns Every Developer Should Know for Interviews”

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

Comments
1 min read
Combine Two JSON Collections with Nested Arrays: MongoDB and PostgreSQL Aggregations

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

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

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

Comments
1 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.