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.
SQL 101 | Summary of Most Used SQL Syntax for Data Analysis
yujin profile

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

#tutorial #database #sql #ardenov
1
Comments
2 min read
Part 8: SQL Injection Series - Advanced Prevention Techniques and Real-World Applications
trixsec profile

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

#sql #sqlserver #security #cybersecurity
6
Comments
2 min read
The Justin Beiber database problem!
usmanzahidcode profile

The Justin Beiber database problem!

#database #sql #backend #performance
2
Comments
1 min read
Part 4: SQL Injection Series: Real-World Scenarios Deep Dive
trixsec profile

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

#sql #security #cybersecurity #mariadb
5
Comments
4 min read
SQL Server: Usare l'Istruzione LIKE all'Interno di una WHERE
nicola-iantomasi profile

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

#sql #sqlserver #database
Comments
3 min read
How to Detect and Defend Against SQL Injection Attacks - Part 3[Must Read]
trixsec profile

How to Detect and Defend Against SQL Injection Attacks - Part 3[Must Read]

#sql #security #cybersecurity #mariadb
5
Comments
4 min read
Introduction to DBMS
paulopnun profile

Introduction to DBMS

#beginners #tutorial #database #sql
Comments
4 min read
INSTEAD OF Trigger | Oracle SQL
mrcaption49 profile

INSTEAD OF Trigger | Oracle SQL

#oracle #data #database #sql
5
Comments
3 min read
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
Packages in Oracle SQL | Package specification | Package body
mrcaption49 profile

Packages in Oracle SQL | Package specification | Package body

#sql #database #webdev #beginners
Comments
1 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
What Are Stored Procedures?
jing_li profile

What Are Stored Procedures?

#database #sql #mysql
Comments
8 min read
loading...