Forem

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.
Part 1: MySQL 8.0 Optimizer Enhancements - SQL Query Optimization Deep Dive
Cover image for Part 1: MySQL 8.0 Optimizer Enhancements - SQL Query Optimization Deep Dive

Part 1: MySQL 8.0 Optimizer Enhancements - SQL Query Optimization Deep Dive

Comments
12 min read
Database Security Patterns for Web Applications
Cover image for Database Security Patterns for Web Applications

Database Security Patterns for Web Applications

Comments
2 min read
🚀 Database Optimization: Proven Techniques to Speed Up Your Queries
Cover image for 🚀 Database Optimization: Proven Techniques to Speed Up Your Queries

🚀 Database Optimization: Proven Techniques to Speed Up Your Queries

Comments
3 min read
Are SQL vs NoSQL Databases different? : Key Differences Every Developer Should Know

Are SQL vs NoSQL Databases different? : Key Differences Every Developer Should Know

Comments
1 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
Cover image for 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
Cover image for 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
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
COLLEGE STUDENT & COURSE MANAGEMENT SYSTEM

COLLEGE STUDENT & COURSE MANAGEMENT SYSTEM

1
Comments
2 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)
Cover image for 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
Cover image for 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
Cover image for 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”
Cover image for 👉 “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
MySQL Labs: Change Defaults, Add Constraints, Encrypt Passwords & Optimize Indexes
Cover image for MySQL Labs: Change Defaults, Add Constraints, Encrypt Passwords & Optimize Indexes

MySQL Labs: Change Defaults, Add Constraints, Encrypt Passwords & Optimize Indexes

Comments
2 min read
Filtering and Retrieving in SQL

Filtering and Retrieving in SQL

1
Comments 2
3 min read
Converting CSV to PDF HTML JSON & SQL
Cover image for Converting CSV to PDF HTML JSON & SQL

Converting CSV to PDF HTML JSON & SQL

Comments
7 min read
Oracle SQL Plan Management - 23ai features backported to 19.22

Oracle SQL Plan Management - 23ai features backported to 19.22

Comments
4 min read
Simplifying SQL Date Data Types with Practical Tips
Cover image for Simplifying SQL Date Data Types with Practical Tips

Simplifying SQL Date Data Types with Practical Tips

Comments
1 min read
Sagas vs ACID Transactions: Ensuring Reliability in Distributed Architectures
Cover image for Sagas vs ACID Transactions: Ensuring Reliability in Distributed Architectures

Sagas vs ACID Transactions: Ensuring Reliability in Distributed Architectures

1
Comments
11 min read
OWOX Data Marts - Free Open-Source Self-Service Analytics Platform
Cover image for OWOX Data Marts - Free Open-Source Self-Service Analytics Platform

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

Comments
1 min read
loading...