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.
The Power of OUTER APPLY: A SQL Weapon to Expand Legacy Database

The Power of OUTER APPLY: A SQL Weapon to Expand Legacy Database

7
Comments 1
6 min read
Improve Your MySQL Database Design and Management with DbSchema

Improve Your MySQL Database Design and Management with DbSchema

8
Comments 1
6 min read
ACID Properties in Databases: What Happens Without Them?

ACID Properties in Databases: What Happens Without Them?

5
Comments
6 min read
Working with PostgreSQL Date and Time Functions

Working with PostgreSQL Date and Time Functions

Comments
3 min read
I'm looking for a FullStack Software Developer Role

I'm looking for a FullStack Software Developer Role

Comments
2 min read
SUBSTR function in Oracle

SUBSTR function in Oracle

5
Comments
1 min read
🗂️ Master SQL Review with GUI 🎛️, GitOps 🖇️ and API 🔌

🗂️ Master SQL Review with GUI 🎛️, GitOps 🖇️ and API 🔌

10
Comments
6 min read
Why Doesn't Postgres Use My Index

Why Doesn't Postgres Use My Index

Comments
16 min read
17 Practical Examples of the CREATE TABLE Statement

17 Practical Examples of the CREATE TABLE Statement

2
Comments
1 min read
What else can Stream&Kotlin evolve into?

What else can Stream&Kotlin evolve into?

6
Comments
6 min read
Ensuring Data Integrity in Financial Transactions: The PostgreSQL Transaction Solution

Ensuring Data Integrity in Financial Transactions: The PostgreSQL Transaction Solution

7
Comments
4 min read
How to Query CSV Files with SQLite

How to Query CSV Files with SQLite

Comments
8 min read
Statement Level Trigger vs Row Level Trigger

Statement Level Trigger vs Row Level Trigger

9
Comments
2 min read
What Are Stored Procedures?

What Are Stored Procedures?

Comments
8 min read
The Amazing SQL Recursive Queries

The Amazing SQL Recursive Queries

Comments
3 min read
AI-Driven SQL Query Optimization and Big Data Integration

AI-Driven SQL Query Optimization and Big Data Integration

Comments
3 min read
Day 2 of SQL Series || Basic Commands

Day 2 of SQL Series || Basic Commands

9
Comments
3 min read
True Alphanumeric / natural sorting in MySQL - why is the answer always recursion?

True Alphanumeric / natural sorting in MySQL - why is the answer always recursion?

33
Comments 5
4 min read
TrailBase: Building an App with UI, Admin Dash and Vector Search in ~100 Lines

TrailBase: Building an App with UI, Admin Dash and Vector Search in ~100 Lines

Comments
6 min read
Online SQL Editors: Exploring Window Functions in MySQL and Their Practical Applications

Online SQL Editors: Exploring Window Functions in MySQL and Their Practical Applications

Comments
4 min read
Populating a Vertica Database with Random Data

Populating a Vertica Database with Random Data

Comments
4 min read
Exploring Microsoft SQL Server: Powering Enterprise Data Management

Exploring Microsoft SQL Server: Powering Enterprise Data Management

Comments
10 min read
Best Practices for Using GROUP BY in MySQL for Converting Vertical Data to JSON

Best Practices for Using GROUP BY in MySQL for Converting Vertical Data to JSON

Comments
5 min read
Alphanumeric / Natural sort in MySQL - 30 years and we still can't do this? 😤

Alphanumeric / Natural sort in MySQL - 30 years and we still can't do this? 😤

31
Comments 8
13 min read
lowCalAlt_update1

lowCalAlt_update1

Comments
1 min read
Day 1 SQL Series || Introduction to SQL

Day 1 SQL Series || Introduction to SQL

16
Comments 1
3 min read
Automating API endpoint testing with Spin

Automating API endpoint testing with Spin

1
Comments
5 min read
Relational vs. Document Databases: Key Differences, Use Cases, and Performance

Relational vs. Document Databases: Key Differences, Use Cases, and Performance

Comments
3 min read
How to connect and query multiple databases with a single REST API

How to connect and query multiple databases with a single REST API

Comments
3 min read
Зоопарк Hibernate: N+1 запросов или как накормить жадного бегемота

Зоопарк Hibernate: N+1 запросов или как накормить жадного бегемота

1
Comments
2 min read
Factory Design Pattern - Creational Design Pattern

Factory Design Pattern - Creational Design Pattern

Comments
3 min read
Building a Secure, Scalable Learning Platform with RBAC Features 🎓🔒📚

Building a Secure, Scalable Learning Platform with RBAC Features 🎓🔒📚

Comments
6 min read
How to Secure Web Applications: Top Security Practices

How to Secure Web Applications: Top Security Practices

Comments
3 min read
Indexes Under The Hood

Indexes Under The Hood

1
Comments
14 min read
SQL Data Exploration for BoardGameGeek datasets

SQL Data Exploration for BoardGameGeek datasets

Comments
5 min read
Part 10: SQL Injection Series - The Psychology of Attackers and SQL Injection in Larger Attack Strategies

Part 10: SQL Injection Series - The Psychology of Attackers and SQL Injection in Larger Attack Strategies

6
Comments 1
3 min read
The Prisma ORM: A Brief Overview and Introduction

The Prisma ORM: A Brief Overview and Introduction

4
Comments
9 min read
SQL Queries Execution Order

SQL Queries Execution Order

Comments
3 min read
When and Why to Use JSON Columns in SQL Databases

When and Why to Use JSON Columns in SQL Databases

1
Comments
3 min read
Part 7: SQL Injection Series: Advanced SQL Injection Techniques

Part 7: SQL Injection Series: Advanced SQL Injection Techniques

5
Comments 1
4 min read
Working of SQL*Loader

Working of SQL*Loader

5
Comments
2 min read
Simplifying SQL View Management in Laravel Migrations

Simplifying SQL View Management in Laravel Migrations

1
Comments
3 min read
Top 20+ Full-stack Projects For Beginners in C#, ASP.NET , .NET CORE

Top 20+ Full-stack Projects For Beginners in C#, ASP.NET , .NET CORE

6
Comments
3 min read
Mastering SQL Optimization: A Beginner’s Guide to Faster and More Efficient Queries

Mastering SQL Optimization: A Beginner’s Guide to Faster and More Efficient Queries

Comments
3 min read
ChartDB: New Functionalities Unlocked! 🎉

ChartDB: New Functionalities Unlocked! 🎉

12
Comments
2 min read
How to Detect and Defend Against SQL Injection Attacks - Part 2

How to Detect and Defend Against SQL Injection Attacks - Part 2

7
Comments 1
4 min read
Using ON DUPLICATE KEY UPDATE and NOT EXISTS in MySQL

Using ON DUPLICATE KEY UPDATE and NOT EXISTS in MySQL

2
Comments
1 min read
🚀 Go-ing Full-Stack: Building Dynamic Web Apps with Go 🐹, PostgreSQL 🐘, Docker 🐳, and HTTP Servers 🌐

🚀 Go-ing Full-Stack: Building Dynamic Web Apps with Go 🐹, PostgreSQL 🐘, Docker 🐳, and HTTP Servers 🌐

33
Comments 2
6 min read
My Data Analyst Interview Journey and What I Learned

My Data Analyst Interview Journey and What I Learned

2
Comments
4 min read
Understanding Batch SQL Injection: A Real-World Threat to Data Security

Understanding Batch SQL Injection: A Real-World Threat to Data Security

Comments
5 min read
Connecting SQL Databases to the Cloud: PostgreSQL, MySQL, SQLite, and Cloud Integration Explained

Connecting SQL Databases to the Cloud: PostgreSQL, MySQL, SQLite, and Cloud Integration Explained

Comments 1
7 min read
Technical Interview Questions - Part 4 - Git + SQL vs noSQL

Technical Interview Questions - Part 4 - Git + SQL vs noSQL

3
Comments
3 min read
Access Controls for Users and Roles in SQL

Access Controls for Users and Roles in SQL

Comments
6 min read
On-Demand Refresh | Materialized Views (Mviews) in ORACLE SQL

On-Demand Refresh | Materialized Views (Mviews) in ORACLE SQL

5
Comments
3 min read
Entendo a ordem de execução de uma query SQL

Entendo a ordem de execução de uma query SQL

1
Comments
2 min read
SQL for Data Validation: Implementing Business Rules and Constraints

SQL for Data Validation: Implementing Business Rules and Constraints

1
Comments
5 min read
TIL: joining with LIKE

TIL: joining with LIKE

2
Comments
1 min read
Postgres can do that? No surprise Postgres is everywhere

Postgres can do that? No surprise Postgres is everywhere

1
Comments
9 min read
SQL vs. NoSQL: Key Differences, Use Cases, and Choosing the Right Database for Your Project

SQL vs. NoSQL: Key Differences, Use Cases, and Choosing the Right Database for Your Project

Comments
5 min read
UUID 🪪 or Auto Increment Integer / Serial ⚙️ as the Database Primary Key?

UUID 🪪 or Auto Increment Integer / Serial ⚙️ as the Database Primary Key?

10
Comments
3 min read
loading...