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 Delete Duplicate Data from a MySQL Database
javafullstackdev profile

How to Delete Duplicate Data from a MySQL Database

#database #sql #java #tutorial
Comments
4 min read
List of the best Google Dorks in 2024 for finding SQL injection vulnerabilities and other security issues:
trixsec profile

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

#sql #security #google #cybersecurity
14
Comments 1
1 min read
Common Table Expression (CTE) in PLSQL | Part 1
mrcaption49 profile

Common Table Expression (CTE) in PLSQL | Part 1

#sql #database #oracle #backend
5
Comments
6 min read
Understanding and Configuring Oracle Access Control Lists (ACLs) for Email Sending Using UTL_MAIL
Cover image for Understanding and Configuring Oracle Access Control Lists (ACLs) for Email Sending Using UTL_MAIL
leandro_nnz profile

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

#oracle #database #tutorial #sql
28
Comments
7 min read
SQLMap Cheat Sheet: A Quick Guide for Automated SQL Injection
trixsec profile

SQLMap Cheat Sheet: A Quick Guide for Automated SQL Injection

#sql #python #cybersecurity #devops
8
Comments
3 min read
Boosting PostgreSQL Performance: Optimising Queries with the != Operator
Cover image for Boosting PostgreSQL Performance: Optimising Queries with the != Operator
sasikumart profile

Boosting PostgreSQL Performance: Optimising Queries with the != Operator

#database #postgres #sql #performance
4
Comments
8 min read
How to create a table with SQL code?
Cover image for How to create a table with SQL code?
jing_li profile

How to create a table with SQL code?

#sql #database #ai #opensource
3
Comments
6 min read
Scenario 2: Mastering Backfilling for New dB Columns – Update Like a Pro!
Cover image for Scenario 2: Mastering Backfilling for New dB Columns – Update Like a Pro!
chidioguejiofor profile

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

#sql #typescript #backenddevelopment #performance
1
Comments
4 min read
How to Downsample Your Data Efficiently
dolphindb profile

How to Downsample Your Data Efficiently

#database #dolphindb #quant #sql
Comments
2 min read
Scenario 1: When You Need to Update Multiple Rows with Different Values – The Smart Way!
Cover image for Scenario 1: When You Need to Update Multiple Rows with Different Values – The Smart Way!
chidioguejiofor profile

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

#sql #typescript #backenddevelopment #performance
13
Comments 3
3 min read
Turbocharge Your App: Slash DB Calls with Raw SQL Magic!
Cover image for Turbocharge Your App: Slash DB Calls with Raw SQL Magic!
chidioguejiofor profile

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

#sql #typescript #performance #sequelize
4
Comments
2 min read
Transaction Control Language TCL - COMMIT, ROLLBACK, and SAVEPOINT
mrcaption49 profile

Transaction Control Language TCL - COMMIT, ROLLBACK, and SAVEPOINT

#sql #plsql #database #backend
4
Comments
3 min read
CASE | DECODE | IF ELSE - Conditional Logic in PLSQL
mrcaption49 profile

CASE | DECODE | IF ELSE - Conditional Logic in PLSQL

#sql #plsql #backend #database
1
Comments
2 min read
Understanding Recursive Queries in PostgreSQL: A Process Hierarchy Example
Cover image for Understanding Recursive Queries in PostgreSQL: A Process Hierarchy Example
dm8ry profile

Understanding Recursive Queries in PostgreSQL: A Process Hierarchy Example

#postgres #database #howto #sql
Comments
3 min read
Logical Processing order of a SQL query
mrcaption49 profile

Logical Processing order of a SQL query

#sql #plsql #backend #database
9
Comments 2
4 min read
PL/SQL Cursors
mrcaption49 profile

PL/SQL Cursors

#sql #backend #database #fullstack
2
Comments 2
4 min read
DbVisualizer 24.2: A Complete Review
Cover image for DbVisualizer 24.2: A Complete Review
antozanini profile

DbVisualizer 24.2: A Complete Review

#news #sql #database #productivity
10
Comments
11 min read
PL/SQL Triggers
mrcaption49 profile

PL/SQL Triggers

#sql #plsql #backend #database
1
Comments
3 min read
Deleting Duplicate Data from MySQL
nikhilxd profile

Deleting Duplicate Data from MySQL

#database #sql #programming #tutorial
1
Comments
3 min read
Different ways of working with SQL Databases in Go
Cover image for Different ways of working with SQL Databases in Go
der_gopher profile

Different ways of working with SQL Databases in Go

#go #sql #database
2
Comments
9 min read
PLSQL Top 10 Interview Questions
mrcaption49 profile

PLSQL Top 10 Interview Questions

#plsql #sql #backend #fullstack
2
Comments
4 min read
How data is replicated in slave nodes in SQL databases
Cover image for How data is replicated in slave nodes in SQL databases
ankitmalikg profile

How data is replicated in slave nodes in SQL databases

#sql #database #systemdesign #architecture
Comments
3 min read
How I used ChatGPT o1 and Claude for generating a SQL RBAC report and was surprised by the results
juanstoppa profile

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

#chatgpt #claude #rbac #sql
Comments
9 min read
Join the Party: A Comprehensive Guide to SQL Joins with Examples
asim_khan_cbe65e41bcbbc65 profile

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

#javascript #sql #database #sqlserver
1
Comments
4 min read
NoSQL vs SQL Which one you should use ?
Cover image for NoSQL vs SQL Which one you should use ?
yashrajxdev profile

NoSQL vs SQL Which one you should use ?

#database #sql #programming #beginners
7
Comments
3 min read
loading...