Skip to content

DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Trix Cyrus

Sep 26 '24

List of the best Google Dorks in 2024 for finding SQL injection vulnerabilities and other security issues:

#sql #security #google #cybersecurity

1 min read

Sep 26 '24

Common Table Expression (CTE) in PLSQL | Part 1

#sql #database #oracle #backend

6 min read

Leandro Nuñez for Digital Pollution

Sep 25 '24

Understanding and Configuring Oracle Access Control Lists (ACLs) for Email Sending Using UTL_MAIL

#oracle #database #tutorial #sql

7 min read

Trix Cyrus

Sep 26 '24

SQLMap Cheat Sheet: A Quick Guide for Automated SQL Injection

#sql #python #cybersecurity #devops

3 min read

Sep 25 '24

Boosting PostgreSQL Performance: Optimising Queries with the != Operator

#database #postgres #sql #performance

8 min read

Jing for Chat2DB

Sep 25 '24

How to create a table with SQL code?

#sql #database #ai #opensource

6 min read

Chidiebere Ogujeiofor

Sep 25 '24

Scenario 2: Mastering Backfilling for New dB Columns – Update Like a Pro!

#sql #typescript #backenddevelopment #performance

4 min read

DolphinDB

Aug 22 '24

How to Downsample Your Data Efficiently

#database #dolphindb #quant #sql

2 min read

Chidiebere Ogujeiofor

Sep 24 '24

Scenario 1: When You Need to Update Multiple Rows with Different Values – The Smart Way!

#sql #typescript #backenddevelopment #performance

3 min read

Chidiebere Ogujeiofor

Sep 24 '24

Turbocharge Your App: Slash DB Calls with Raw SQL Magic!

#sql #typescript #performance #sequelize

2 min read

Sep 24 '24

Transaction Control Language TCL - COMMIT, ROLLBACK, and SAVEPOINT

#sql #plsql #database #backend

3 min read

Sep 24 '24

CASE | DECODE | IF ELSE - Conditional Logic in PLSQL

#sql #plsql #backend #database

2 min read

Dmitry Romanoff

Aug 25 '24

Understanding Recursive Queries in PostgreSQL: A Process Hierarchy Example

#postgres #database #howto #sql

3 min read

Sep 23 '24

Logical Processing order of a SQL query

#sql #plsql #backend #database

4 min read

Sep 23 '24

PL/SQL Cursors

#sql #backend #database #fullstack

4 min read

Antonello Zanini

Sep 23 '24

DbVisualizer 24.2: A Complete Review

#news #sql #database #productivity

11 min read

Sep 23 '24

PL/SQL Triggers

#sql #plsql #backend #database

3 min read

Nikhil Soman Sahu

Sep 23 '24

Deleting Duplicate Data from MySQL

#database #sql #programming #tutorial

3 min read

Sep 23 '24

Different ways of working with SQL Databases in Go

#go #sql #database

9 min read

Sep 22 '24

PLSQL Top 10 Interview Questions

#plsql #sql #backend #fullstack

4 min read

Sep 22 '24

How data is replicated in slave nodes in SQL databases

#sql #database #systemdesign #architecture

3 min read

Sep 22 '24

How I used ChatGPT o1 and Claude for generating a SQL RBAC report and was surprised by the results

#chatgpt #claude #rbac #sql

9 min read

Asim khan

Sep 22 '24

Join the Party: A Comprehensive Guide to SQL Joins with Examples

#javascript #sql #database #sqlserver

4 min read

Yashraj

Sep 21 '24

NoSQL vs SQL Which one you should use ?

#database #sql #programming #beginners

3 min read

Jean-Yves Pellé

Sep 1 '24

Deploy a lightweight BI solution with your first dashboard in 5 steps

#dashboard #reporting #sql #businessintelligence

2 min read

loading...