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 vs NoSQL: The Ultimate Interview Guide to Choosing the Right Database (Simple Checklist Included)
Cover image for SQL vs NoSQL: The Ultimate Interview Guide to Choosing the Right Database (Simple Checklist Included)

SQL vs NoSQL: The Ultimate Interview Guide to Choosing the Right Database (Simple Checklist Included)

2
Comments
4 min read
Mandatory Profile in Oracle Database

Mandatory Profile in Oracle Database

Comments
3 min read
Week 4 SQL Injection Audit Challenge

Week 4 SQL Injection Audit Challenge

Comments
27 min read
[Simple SNS Project] Step 4. Search Implementation & Logging Strategy

[Simple SNS Project] Step 4. Search Implementation & Logging Strategy

Comments
1 min read
I Built a PostgreSQL User Analytics System — Here’s What I Learned About Real SQL
Cover image for I Built a PostgreSQL User Analytics System — Here’s What I Learned About Real SQL

I Built a PostgreSQL User Analytics System — Here’s What I Learned About Real SQL

25
Comments 1
3 min read
SQL Pattern Matching As A Beginner (LIKE, ILIKE, IN, BETWEEN)
Cover image for SQL Pattern Matching As A Beginner (LIKE, ILIKE, IN, BETWEEN)

SQL Pattern Matching As A Beginner (LIKE, ILIKE, IN, BETWEEN)

20
Comments
3 min read
Best SQL Courses with Certificates for 2026

Best SQL Courses with Certificates for 2026

1
Comments
7 min read
Learning SQL Subqueries as a Beginner: What Made Sense and What Didn’t
Cover image for Learning SQL Subqueries as a Beginner: What Made Sense and What Didn’t

Learning SQL Subqueries as a Beginner: What Made Sense and What Didn’t

25
Comments
3 min read
Deploy: Cenário: Azure App Service + Github + SQL Server
Cover image for Deploy: Cenário: Azure App Service + Github + SQL Server

Deploy: Cenário: Azure App Service + Github + SQL Server

Comments
5 min read
SQL: Doing GROUP BY in CsvPath
Cover image for SQL: Doing GROUP BY in CsvPath

SQL: Doing GROUP BY in CsvPath

Comments
5 min read
SQL WHERE Clause: I Thought I Knew It… Until It Asked Me About LIKE 😭
Cover image for SQL WHERE Clause: I Thought I Knew It… Until It Asked Me About LIKE 😭

SQL WHERE Clause: I Thought I Knew It… Until It Asked Me About LIKE 😭

4
Comments
3 min read
Practicing SQL with Real Data: INSERT, WHERE, ORDER BY, and GROUP BY
Cover image for Practicing SQL with Real Data: INSERT, WHERE, ORDER BY, and GROUP BY

Practicing SQL with Real Data: INSERT, WHERE, ORDER BY, and GROUP BY

25
Comments
3 min read
Craft and Control Resource Pools on MSSQL
Cover image for Craft and Control Resource Pools on MSSQL

Craft and Control Resource Pools on MSSQL

Comments
3 min read
Subquery to GROUP JOIN — A Method for Merging Multiple Subqueries

Subquery to GROUP JOIN — A Method for Merging Multiple Subqueries

Comments 1
5 min read
Learning SQL in Practice: LeetCode Challenges and Setting Up PostgreSQL
Cover image for Learning SQL in Practice: LeetCode Challenges and Setting Up PostgreSQL

Learning SQL in Practice: LeetCode Challenges and Setting Up PostgreSQL

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