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 DATABASE
Cover image for SQL DATABASE

SQL DATABASE

Comments
1 min read
SQL Tricks: Generate Calendar Table

SQL Tricks: Generate Calendar Table

Comments
5 min read
Cracking the Code: Your First Steps with SQL! 💻

Cracking the Code: Your First Steps with SQL! 💻

Comments
4 min read
The "Expressive" protocol

The "Expressive" protocol

1
Comments
3 min read
How to Duplicate Rows in MySQL

How to Duplicate Rows in MySQL

Comments
2 min read
SQL CASE Statements: The Order Matters!

SQL CASE Statements: The Order Matters!

Comments
2 min read
Some Example SQL

Some Example SQL

Comments
6 min read
College Student and Course Management System
Cover image for College Student and Course Management System

College Student and Course Management System

Comments
3 min read
PostgreSQL UUID: Bulk insert with UUIDv7 vs UUIDv4
Cover image for PostgreSQL UUID: Bulk insert with UUIDv7 vs UUIDv4

PostgreSQL UUID: Bulk insert with UUIDv7 vs UUIDv4

3
Comments 1
10 min read
Laravel SQL Injection Prevention: Best Practices to Secure Your PHP Applications
Cover image for Laravel SQL Injection Prevention: Best Practices to Secure Your PHP Applications

Laravel SQL Injection Prevention: Best Practices to Secure Your PHP Applications

Comments
1 min read
Data Science vs Business Analytics

Data Science vs Business Analytics

Comments
1 min read
SQL CASE Statement Explained with Real-World Examples
Cover image for SQL CASE Statement Explained with Real-World Examples

SQL CASE Statement Explained with Real-World Examples

Comments
1 min read
How to Generate Database Documentation (HTML5, PDF, Markdown)
Cover image for How to Generate Database Documentation (HTML5, PDF, Markdown)

How to Generate Database Documentation (HTML5, PDF, Markdown)

7
Comments
3 min read
Diving into RDBMS & Data Integrity

Diving into RDBMS & Data Integrity

1
Comments
10 min read
Hi Devs, I'm Rohit – Writing Git & SQL for Beginners”

Hi Devs, I'm Rohit – Writing Git & SQL for Beginners”

Comments
1 min read
SQL vs. NoSQL: Will the Wrong Data Store Destroy your Transaction Records?
Cover image for SQL vs. NoSQL: Will the Wrong Data Store Destroy your Transaction Records?

SQL vs. NoSQL: Will the Wrong Data Store Destroy your Transaction Records?

11
Comments
8 min read
Visualizing Recursive SQL Queries: A Step-by-Step Walkthrough

Visualizing Recursive SQL Queries: A Step-by-Step Walkthrough

Comments
4 min read
🌳💨 Tree queries slowing you down?

🌳💨 Tree queries slowing you down?

Comments
1 min read
The Ultimate SQL Tutorial: Learn to Query Like a Pro
Cover image for The Ultimate SQL Tutorial: Learn to Query Like a Pro

The Ultimate SQL Tutorial: Learn to Query Like a Pro

Comments
4 min read
Querying a Nested Array with `elemMatch` in Amazon DocumentDB

Querying a Nested Array with `elemMatch` in Amazon DocumentDB

Comments
3 min read
Advanced SQL Part 1: Window Functions Explained with Precision

Advanced SQL Part 1: Window Functions Explained with Precision

Comments
4 min read
SQL Indexing: Your Database's Secret Weapon for Speed 🚀

SQL Indexing: Your Database's Secret Weapon for Speed 🚀

Comments
4 min read
SQL Learning...

SQL Learning...

1
Comments 2
1 min read
Building a Data Career: The Skills That Truly Matter
Cover image for Building a Data Career: The Skills That Truly Matter

Building a Data Career: The Skills That Truly Matter

5
Comments
5 min read
SQL REPLACE Function: Quick Guide with Real Examples
Cover image for SQL REPLACE Function: Quick Guide with Real Examples

SQL REPLACE Function: Quick Guide with Real Examples

Comments
2 min read
loading...