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

Dec 1 '24

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

#sql #security #cybersecurity #mariadb

4 min read

Nicola Iantomasi

Oct 27 '24

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

#sql #sqlserver #database

3 min read

Trix Cyrus

Nov 30 '24

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

#sql #security #cybersecurity #mariadb

4 min read

Pau

Oct 27 '24

Introduction to DBMS

#beginners #tutorial #database #sql

4 min read

Nov 29 '24

INSTEAD OF Trigger | Oracle SQL

#oracle #data #database #sql

3 min read

Trix Cyrus

Nov 29 '24

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

#sql #mariadb #python #cybersecurity

4 min read

Danwycliff Ndwiga

Oct 30 '24

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

#sql #database #data #dataengineering

1 min read

TrailBase

Nov 28 '24

TrailBase: Fast & Open FireBase Alternative

#firebase #sql #rust #programming

6 min read

Nov 28 '24

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

#sql #sqlserver #legacy #database

6 min read

Roxana Maria Haidiner

Nov 27 '24

ERD Diagrams | MySQL Database Management and Docs

#database #management #design #sql

6 min read

Nov 20 '24

5 Essential SQL Skills Learned from a Decade of Experience

#sqlserver #sql #beginners

4 min read

Nov 27 '24

ACID Properties in Databases: What Happens Without Them?

#database #data #dataengineering #sql

6 min read

Open Source SPL

Nov 27 '24

SQL: Multi field mixed deduplication followed by numbering #eg81

#sql #development #devdiscuss #github

2 min read

Nov 27 '24

Working with PostgreSQL Date and Time Functions

#database #postgres #analytics #sql

3 min read

Ayra Jett for Bytebase

Nov 26 '24

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

#api #gitops #sql #database

6 min read

Adam Furmanek for Metis

Oct 23 '24

Why Doesn't Postgres Use My Index

#sql #database #postgres

16 min read

Nov 26 '24

Packages in Oracle SQL | Package specification | Package body

#sql #database #webdev #beginners

1 min read

Nov 26 '24

SUBSTR function in Oracle

#webdev #sql #oracle #data

1 min read

Nov 26 '24

17 Practical Examples of the CREATE TABLE Statement

#oracle #sql

1 min read

Rafael Avelar Campos

Nov 25 '24

Ensuring Data Integrity in Financial Transactions: The PostgreSQL Transaction Solution

#node #postgres #sql #fintech

4 min read

Peter

Oct 22 '24

How to Query CSV Files with SQLite

#database #sqlite #csv #sql

8 min read

Jing for Chat2DB

Oct 22 '24

What Are Stored Procedures?

#database #sql #mysql

8 min read

Nov 25 '24

Statement Level Trigger vs Row Level Trigger

#sql #webdev #database #devops

2 min read

Nov 25 '24

The Amazing SQL Recursive Queries

#sql #recursive #awesome

3 min read

Aditi Bindal for NodeShift

Nov 24 '24

How to Install PostgreSQL on Ubuntu 22.04 LTS

#postgres #database #sql #webdev

10 min read

loading...