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.
How to Detect and Defend Against SQL Injection Attacks - Part 3[Must Read]

How to Detect and Defend Against SQL Injection Attacks - Part 3[Must Read]

5
Comments
4 min read
INSTEAD OF Trigger | Oracle SQL

INSTEAD OF Trigger | Oracle SQL

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

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

5
Comments
4 min read
Advancing Data Access with Text to SQL Technology

Advancing Data Access with Text to SQL Technology

Comments
5 min read
TrailBase: Fast & Open FireBase Alternative

TrailBase: Fast & Open FireBase Alternative

Comments
6 min read
LIBRARY MANAGEMENT SYSTEM USING JAVA AND SQL

LIBRARY MANAGEMENT SYSTEM USING JAVA AND SQL

Comments
1 min read
Working with PostgreSQL Date and Time Functions

Working with PostgreSQL Date and Time Functions

Comments
3 min read
Things Platform Engineers Lack When Dealing With Databases

Things Platform Engineers Lack When Dealing With Databases

Comments
3 min read
SUBSTR function in Oracle

SUBSTR function in Oracle

5
Comments
1 min read
Packages in Oracle SQL | Package specification | Package body

Packages in Oracle SQL | Package specification | Package body

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

17 Practical Examples of the CREATE TABLE Statement

2
Comments
1 min read
Crossing the Line before the Finish Line. Also the line before that.

Crossing the Line before the Finish Line. Also the line before that.

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

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

5
Comments
6 min read
The Amazing SQL Recursive Queries

The Amazing SQL Recursive Queries

Comments
3 min read
How to Detect and Defend Against SQL Injection Attacks(Part-1)[Must Read]

How to Detect and Defend Against SQL Injection Attacks(Part-1)[Must Read]

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

AI-Driven SQL Query Optimization and Big Data Integration

Comments
3 min read
The Power of OUTER APPLY: A SQL Weapon to Expand Legacy Database

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

6
Comments 1
6 min read
A Comparison of Top Private and Browser Based SQL on CSV Tools

A Comparison of Top Private and Browser Based SQL on CSV Tools

Comments
3 min read
🇩🇪 Datenmanipulation und Abfragen mit SQL

🇩🇪 Datenmanipulation und Abfragen mit SQL

Comments
8 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
ACID Properties in Databases: What Happens Without Them?