DEV Community

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.
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
College Student & Course Management System
Cover image for College Student & Course Management System

College Student & Course Management System

3
Comments
3 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
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
Introduction to MongoDB and NoSQL — Day 1

Introduction to MongoDB and NoSQL — Day 1

8
Comments 4
2 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
How to Always Write Optimized Queries in Amazon Redshift - Complete Guide
Cover image for How to Always Write Optimized Queries in Amazon Redshift - Complete Guide

How to Always Write Optimized Queries in Amazon Redshift - Complete Guide

Comments
7 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
Vectors in AI: A Bridge Between Code and Business
Cover image for Vectors in AI: A Bridge Between Code and Business

Vectors in AI: A Bridge Between Code and Business

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
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

10
Comments
5 min read
You Can't Trust COUNT and SUM: Scalable Data Validation with Merkle Trees
Cover image for You Can't Trust COUNT and SUM: Scalable Data Validation with Merkle Trees

You Can't Trust COUNT and SUM: Scalable Data Validation with Merkle Trees

2
Comments 1
8 min read
SQL vs MYSQL difference
Cover image for SQL vs MYSQL difference

SQL vs MYSQL difference

Comments
1 min read
SQL with Real Life Example Explained - 2025

SQL with Real Life Example Explained - 2025

Comments 1
1 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
Using CASE to Sort ENUM Values in MySQL

Using CASE to Sort ENUM Values in MySQL

1
Comments
2 min read
Do you know what a distributed database is?

Do you know what a distributed database is?

Comments
2 min read
Cursor in Database Management System (DBMS): Types, Properties, and Examples

Cursor in Database Management System (DBMS): Types, Properties, and Examples

4
Comments
6 min read
loading...