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.
Top 8 Free Database Design Tools for 2025
Cover image for Top 8 Free Database Design Tools for 2025

Top 8 Free Database Design Tools for 2025

11
Comments 3
6 min read
SQL Admin Scripts: A Practical Toolkit for Managing Servers and Databases
Cover image for SQL Admin Scripts: A Practical Toolkit for Managing Servers and Databases

SQL Admin Scripts: A Practical Toolkit for Managing Servers and Databases

8
Comments
9 min read
Mastering SQLMap Tamper Scripts: The Ultimate Guide to Evading WAFs Like a Pro [Must Read Article]

Mastering SQLMap Tamper Scripts: The Ultimate Guide to Evading WAFs Like a Pro [Must Read Article]

7
Comments
3 min read
Transforming Nested JSON into Usable Data with SQL CROSS APPLY
Cover image for Transforming Nested JSON into Usable Data with SQL CROSS APPLY

Transforming Nested JSON into Usable Data with SQL CROSS APPLY

2
Comments
3 min read
Data Engineer as a Real-Time Algo Trader – Turning Pipelines into Profit (or at Least Trying)!
Cover image for Data Engineer as a Real-Time Algo Trader – Turning Pipelines into Profit (or at Least Trying)!

Data Engineer as a Real-Time Algo Trader – Turning Pipelines into Profit (or at Least Trying)!

2
Comments
13 min read
Simple SQL Statements Only Exist in Coursebooks and Training Courses

Simple SQL Statements Only Exist in Coursebooks and Training Courses

6
Comments
7 min read
How Sequences used in Oracle SQL without AUTO_INCREMENT Keyword

How Sequences used in Oracle SQL without AUTO_INCREMENT Keyword

Comments 1
1 min read
Day 5 of SQL Series || Operators , Wildcards and Aggregate Functions

Day 5 of SQL Series || Operators , Wildcards and Aggregate Functions

6
Comments
4 min read
PostgreSQL CSV Import and Export Guide

PostgreSQL CSV Import and Export Guide

1
Comments
1 min read
Understanding Transaction Isolation Levels in PostgreSQL

Understanding Transaction Isolation Levels in PostgreSQL

1
Comments 1
2 min read
Selecting the Right Database for the Job
Cover image for Selecting the Right Database for the Job

Selecting the Right Database for the Job

8
Comments 1
6 min read
Aurora DSQL: Create a Serverless Cluster and Connect with PostgreSQL Client
Cover image for Aurora DSQL: Create a Serverless Cluster and Connect with PostgreSQL Client

Aurora DSQL: Create a Serverless Cluster and Connect with PostgreSQL Client

11
Comments
5 min read
Mastering SQL: A Comprehensive Roadmap for Beginners (Part I)
Cover image for Mastering SQL: A Comprehensive Roadmap for Beginners (Part I)

Mastering SQL: A Comprehensive Roadmap for Beginners (Part I)

12
Comments 3
3 min read
Oracle Database Fragmentation - How to reorg Tables / Indexes

Oracle Database Fragmentation - How to reorg Tables / Indexes

18
Comments 2
3 min read
How to Manage Your SQL Server Database Effectively
Cover image for How to Manage Your SQL Server Database Effectively

How to Manage Your SQL Server Database Effectively

6
Comments 1
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.