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.
Chat2DB: Data Analysis Without Writing SQL Code

Chat2DB: Data Analysis Without Writing SQL Code

2
Comments
4 min read
🗄️🚀 SQL vs NoSQL: Viability and Comparison

🗄️🚀 SQL vs NoSQL: Viability and Comparison

12
Comments 4
2 min read
Comprehensive SQL Project: Mastering Database Manipulation

Comprehensive SQL Project: Mastering Database Manipulation

Comments
3 min read
Cleaning up personal expense data with SQL

Cleaning up personal expense data with SQL

2
Comments 1
19 min read
CURSOR in PLSQL | Best Explanation

CURSOR in PLSQL | Best Explanation

7
Comments 1
3 min read
Use Natural Language to Query Your Database with Chat2DB

Use Natural Language to Query Your Database with Chat2DB

5
Comments 1
5 min read
Relational Database

Relational Database

1
Comments
2 min read
SQL, in each group modify the null value of a specified column as its neighboring value #eg43

SQL, in each group modify the null value of a specified column as its neighboring value #eg43

7
Comments
1 min read
Relational Databases vs. NoSQL

Relational Databases vs. NoSQL

Comments
2 min read
Configuring a Connection Pool

Configuring a Connection Pool

Comments
7 min read
Mastering Built-in Functions in Oracle SQL

Mastering Built-in Functions in Oracle SQL

Comments
3 min read
Comprehensive Analysis of Attack Events with SafeLine WAF

Comprehensive Analysis of Attack Events with SafeLine WAF

8
Comments
2 min read
SQL JOIN.

SQL JOIN.

3
Comments
5 min read
The Journey from Edgar F. Codd to Modern SQL: How Relational Databases Changed the World

The Journey from Edgar F. Codd to Modern SQL: How Relational Databases Changed the World

5
Comments 1
5 min read
I deleted our database after 72 hours of no sleep.

I deleted our database after 72 hours of no sleep.

Comments
1 min read
AI Productivity Tips 1 - SQL Companion Bot with Gemini 1.5 Pro

AI Productivity Tips 1 - SQL Companion Bot with Gemini 1.5 Pro

Comments
2 min read
Understanding Your Data: The Essentials of Exploratory Data Analysis

Understanding Your Data: The Essentials of Exploratory Data Analysis

Comments
3 min read
Securing PHP Applications Against SQL Injection Attacks

Securing PHP Applications Against SQL Injection Attacks

Comments 4
3 min read
Navigating Open Source Software: All Your Questions Answered

Navigating Open Source Software: All Your Questions Answered

Comments
7 min read
SQL, extract unique values of JSON format field from each group #eg42

SQL, extract unique values of JSON format field from each group #eg42

6
Comments
2 min read
Libraries for writing raw SQL safely

Libraries for writing raw SQL safely

2
Comments
8 min read
AS Keyword in SQL Server

AS Keyword in SQL Server

Comments
5 min read
50x Faster Window Functions? PawSQL's Index Magic Revealed

50x Faster Window Functions? PawSQL's Index Magic Revealed

Comments
3 min read
Enhancing Laravel Models with a Case-Insensitive Searchable Trait

Enhancing Laravel Models with a Case-Insensitive Searchable Trait

1
Comments
3 min read
🗂️ Understanding SQL Relationships: A Beginner's Guide

🗂️ Understanding SQL Relationships: A Beginner's Guide

1
Comments
3 min read
loading...