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.
Day 3 of SQL Series || Basic Commands

Day 3 of SQL Series || Basic Commands

6
Comments
3 min read
End Of Series: SQL Injection Detect & Defend

End Of Series: SQL Injection Detect & Defend

5
Comments 1
1 min read
Part 9: SQL Injection Series - Building Honeypots for Real-Time Detection

Part 9: SQL Injection Series - Building Honeypots for Real-Time Detection

5
Comments
3 min read
Just-in-Time Database Access

Just-in-Time Database Access

5
Comments
2 min read
Part 6: SQL Injection Series: Case Studies and Lessons Learned

Part 6: SQL Injection Series: Case Studies and Lessons Learned

8
Comments
4 min read
Part 5: SQL Injection Series: Future Trends and Emerging Challenges

Part 5: SQL Injection Series: Future Trends and Emerging Challenges

5
Comments
4 min read
SQL 101 | Summary of Most Used SQL Syntax for Data Analysis

SQL 101 | Summary of Most Used SQL Syntax for Data Analysis

1
Comments
2 min read
Part 8: SQL Injection Series - Advanced Prevention Techniques and Real-World Applications

Part 8: SQL Injection Series - Advanced Prevention Techniques and Real-World Applications

6
Comments
2 min read
These 10+ comparisons cover entire SQL concepts, Is it?

These 10+ comparisons cover entire SQL concepts, Is it?

Comments
6 min read
Part 4: SQL Injection Series: Real-World Scenarios Deep Dive

Part 4: SQL Injection Series: Real-World Scenarios Deep Dive

5
Comments
4 min read
SQL Server: Usare l'Istruzione LIKE all'Interno di una WHERE

SQL Server: Usare l'Istruzione LIKE all'Interno di una WHERE

Comments
3 min read
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
Introduction to DBMS

Introduction to DBMS

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-1)[Must Read]

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

6
Comments
4 min read
SQL "SELECT INTO" vs "INSERT INTO SELECT" statements.

SQL "SELECT INTO" vs "INSERT INTO SELECT" statements.

Comments
1 min read
How Pipe Syntax Fix SQL Design Problems

How Pipe Syntax Fix SQL Design Problems

Comments
5 min read
TrailBase: Fast & Open FireBase Alternative

TrailBase: Fast & Open FireBase Alternative

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

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

Improve Your MySQL Database Design and Management with DbSchema

12
Comments 2
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
Packages in Oracle SQL | Package specification | Package body

Packages in Oracle SQL | Package specification | Package body

Comments
1 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
loading...