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.
SQL Injection: A Deep Dive into a Persistent Vulnerability

SQL Injection: A Deep Dive into a Persistent Vulnerability

Comments
4 min read
Using SQL for data analysis seems to be a false proposition

Using SQL for data analysis seems to be a false proposition

9
Comments 7
6 min read
Demystifying Relational Algebra in DBMS: Operators Explained (with SQL Examples)

Demystifying Relational Algebra in DBMS: Operators Explained (with SQL Examples)

Comments
6 min read
Count Date Ranges per Year — From SQL to SPL #23
Cover image for Count Date Ranges per Year — From SQL to SPL #23

Count Date Ranges per Year — From SQL to SPL #23

8
Comments 1
2 min read
Python is a very powerful tool for Data Analysts.

Python is a very powerful tool for Data Analysts.

5
Comments
1 min read
Como Conectar ao DuckDB com C++
Cover image for Como Conectar ao DuckDB com C++

Como Conectar ao DuckDB com C++

2
Comments
4 min read
How to Connect to DuckDB with C++
Cover image for How to Connect to DuckDB with C++

How to Connect to DuckDB with C++

1
Comments
3 min read
🗃️ What Is SQL Manipulation? (And Why It’s Like Talking to a Super-Organized Assistant)

🗃️ What Is SQL Manipulation? (And Why It’s Like Talking to a Super-Organized Assistant)

Comments 1
3 min read
DBMS MAKAUT MCQs

DBMS MAKAUT MCQs

2
Comments
20 min read
FAQs in WBUT DBMS exam

FAQs in WBUT DBMS exam

Comments
4 min read
My Journey with ASP.NET Core & SQL Server: Lessons Learned
Cover image for My Journey with ASP.NET Core & SQL Server: Lessons Learned

My Journey with ASP.NET Core & SQL Server: Lessons Learned

Comments
1 min read
Database Management Systems: A Visual Guide
Cover image for Database Management Systems: A Visual Guide

Database Management Systems: A Visual Guide

2
Comments
12 min read
Parallel Query Processing - (System-wide and Query-based)

Parallel Query Processing - (System-wide and Query-based)

Comments
6 min read
DBMS

DBMS

Comments
1 min read
SQL DDL Commands Explained: Structuring Your Database
Cover image for SQL DDL Commands Explained: Structuring Your Database

SQL DDL Commands Explained: Structuring Your Database

Comments
2 min read
Beginner's Guide to ADO.NET: Connection, Command & Dataset Explained

Beginner's Guide to ADO.NET: Connection, Command & Dataset Explained

Comments
1 min read
Hands-On WrenAI Review: Text-to-SQL Powered by RAG

Hands-On WrenAI Review: Text-to-SQL Powered by RAG

Comments
3 min read
Building a RAG System with Firebase Functions, OpenAI, and Pinecone
Cover image for Building a RAG System with Firebase Functions, OpenAI, and Pinecone

Building a RAG System with Firebase Functions, OpenAI, and Pinecone

3
Comments
3 min read
Navigating MariaDB on HTB’s ‘Sequel’ Box to Retrieve the Flag

Navigating MariaDB on HTB’s ‘Sequel’ Box to Retrieve the Flag

Comments
1 min read
How to install Maven (Apache Maven) on Windows 11?
Cover image for How to install Maven (Apache Maven) on Windows 11?

How to install Maven (Apache Maven) on Windows 11?

2
Comments
2 min read
Why T-SQL’s Most Misunderstood Keyword Is Actually It's Safest

Why T-SQL’s Most Misunderstood Keyword Is Actually It's Safest

Comments 2
27 min read
I am Learning SQL(mysql) in 2025.

I am Learning SQL(mysql) in 2025.

4
Comments 2
1 min read
SQL vs. NoSQL | Schema Design Differences Explained Visually
Cover image for SQL vs. NoSQL | Schema Design Differences Explained Visually

SQL vs. NoSQL | Schema Design Differences Explained Visually

13
Comments 2
5 min read
PostgreSQL 🐘 Hosting Options in 2025: Pricing Comparison 💸⚖️
Cover image for PostgreSQL 🐘 Hosting Options in 2025: Pricing Comparison 💸⚖️

PostgreSQL 🐘 Hosting Options in 2025: Pricing Comparison 💸⚖️

5
Comments
5 min read
Summarize Row Counts by Dynamic Columns into JSON — From SQL to SPL #22
Cover image for Summarize Row Counts by Dynamic Columns into JSON — From SQL to SPL #22

Summarize Row Counts by Dynamic Columns into JSON — From SQL to SPL #22

6
Comments 1
2 min read
loading...