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
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
1
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
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
r_a_dev profile

Ensuring Data Integrity in Financial Transactions: The PostgreSQL Transaction Solution

#node #postgres #sql #fintech
8
Comments
4 min read
Statement Level Trigger vs Row Level Trigger
mrcaption49 profile

Statement Level Trigger vs Row Level Trigger

#sql #webdev #database #devops
5
Comments
2 min read
How to Install PostgreSQL on Ubuntu 22.04 LTS
aditi_b profile

How to Install PostgreSQL on Ubuntu 22.04 LTS

#postgres #database #sql #webdev
3
Comments
10 min read
True Alphanumeric / natural sorting in MySQL - why is the answer always recursion?
grahamthedev profile

True Alphanumeric / natural sorting in MySQL - why is the answer always recursion?

#mysql #sql #webdev #programming
35
Comments 7
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.