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

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

#sql #mariadb #python #cybersecurity
7
Comments
4 min read
SQL "SELECT INTO" vs "INSERT INTO SELECT" statements.
danwycliff profile

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

#sql #database #data #dataengineering
Comments
1 min read
TrailBase: Fast & Open FireBase Alternative
trailbase profile

TrailBase: Fast & Open FireBase Alternative

#firebase #sql #rust #programming
Comments
6 min read
The Power of OUTER APPLY: A SQL Weapon to Expand Legacy Database
auyeungdavid_2847435260 profile

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

#sql #sqlserver #legacy #database
7
Comments 1
6 min read
ERD Diagrams | MySQL Database Management and Docs
roxana_haidiner profile

ERD Diagrams | MySQL Database Management and Docs

#database #management #design #sql
12
Comments 2
6 min read
5 Essential SQL Skills Learned from a Decade of Experience
auyeungdavid_2847435260 profile

5 Essential SQL Skills Learned from a Decade of Experience

#sqlserver #sql #beginners
56
Comments 50
4 min read
ACID Properties in Databases: What Happens Without Them?
meqdad_dev profile

ACID Properties in Databases: What Happens Without Them?

#database #data #dataengineering #sql
5
Comments
6 min read
SQL: Multi field mixed deduplication followed by numbering #eg81
esproc_spl profile

SQL: Multi field mixed deduplication followed by numbering #eg81

#sql #development #devdiscuss #github
6
Comments
2 min read
Working with PostgreSQL Date and Time Functions
edvichuki profile

Working with PostgreSQL Date and Time Functions

#database #postgres #analytics #sql
Comments
3 min read
🗂️ Master SQL Review with GUI 🎛️, GitOps 🖇️ and API 🔌
op3ratordec profile

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

#api #gitops #sql #database
11
Comments
6 min read
Why Doesn't Postgres Use My Index
adammetis profile

Why Doesn't Postgres Use My Index

#sql #database #postgres
Comments
16 min read
SUBSTR function in Oracle
mrcaption49 profile

SUBSTR function in Oracle

#webdev #sql #oracle #data
5
Comments
1 min read
17 Practical Examples of the CREATE TABLE Statement
foxinfotech profile

17 Practical Examples of the CREATE TABLE Statement

#oracle #sql
2
Comments
1 min read
Ensuring Data Integrity in Financial Transactions: The PostgreSQL Transaction Solution
rafael_avelarcampos_e71c profile

Ensuring Data Integrity in Financial Transactions: The PostgreSQL Transaction Solution

#node #postgres #sql #fintech
8
Comments
4 min read
How to Query CSV Files with SQLite
peter5 profile

How to Query CSV Files with SQLite

#database #sqlite #csv #sql
Comments
8 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.