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.
Oracle 23ai — Applying Grid Infrastructure Patches via GUI(Zero-Downtime)

Oracle 23ai — Applying Grid Infrastructure Patches via GUI(Zero-Downtime)

Comments
4 min read
Understanding Query Cost in SQL

Understanding Query Cost in SQL

1
Comments
7 min read
Learn SQL Fast: A Step-by-Step Tutorial for Beginners

Learn SQL Fast: A Step-by-Step Tutorial for Beginners

Comments
3 min read
HANDLING THE SAFE UPDATE MODE IN MYSQL

HANDLING THE SAFE UPDATE MODE IN MYSQL

Comments
1 min read
PostgreSQL Practical Labs: Error Handling, Advanced Data Types & Kali Linux Setup

PostgreSQL Practical Labs: Error Handling, Advanced Data Types & Kali Linux Setup

Comments
3 min read
Count Distinct within Intervals in Order — From SQL to SPL #38

Count Distinct within Intervals in Order — From SQL to SPL #38

6
Comments 2
2 min read
From Redundancy to Reusability: A Better Way to Manage Shared Records in Relational Databases

From Redundancy to Reusability: A Better Way to Manage Shared Records in Relational Databases

Comments 1
1 min read
đź§Ş Exploiting Blind SQL Injection by Triggering Time Delays

đź§Ş Exploiting Blind SQL Injection by Triggering Time Delays

Comments 1
3 min read
MySQL Tutorial: A Complete Guide to Mastering Database Management

MySQL Tutorial: A Complete Guide to Mastering Database Management

1
Comments
3 min read
Unlock Database Perfection: 15 Essential Resources for SQL Normalization Mastery

Unlock Database Perfection: 15 Essential Resources for SQL Normalization Mastery

2
Comments
5 min read
30-DAY CHALLENGE LEARNING SQL

30-DAY CHALLENGE LEARNING SQL

1
Comments
1 min read
Building a Robust SQLite Query Builder in TypeScript: Lessons from an Arabic Dictionary App

Building a Robust SQLite Query Builder in TypeScript: Lessons from an Arabic Dictionary App

Comments
4 min read
💡 Java Streams vs SQL – When to Use Which and Why

💡 Java Streams vs SQL – When to Use Which and Why

1
Comments
2 min read
Introducing gq-to-sql: Convert Graph-Style URL Queries into SQL

Introducing gq-to-sql: Convert Graph-Style URL Queries into SQL

4
Comments 3
1 min read
Safeguarding Your PostgreSQL Data: A Practical Guide to pg_dump and pg_restore

Safeguarding Your PostgreSQL Data: A Practical Guide to pg_dump and pg_restore

Comments
5 min read
Mastering Foreign Keys in MySQL: A Comprehensive Guide

Mastering Foreign Keys in MySQL: A Comprehensive Guide

Comments
6 min read
Beginner’s Guide to SQL Server Stored Procedures

Beginner’s Guide to SQL Server Stored Procedures

2
Comments
5 min read
[Share] SQL - A Quick Intro

[Share] SQL - A Quick Intro

Comments
8 min read
How to Drop Tables in MySQL Using dbForge Studio: A Simple Guide for Safer Table Management

How to Drop Tables in MySQL Using dbForge Studio: A Simple Guide for Safer Table Management

Comments
2 min read
Enhancing SQL INSERT INTO Performance: Tips and Tools

Enhancing SQL INSERT INTO Performance: Tips and Tools

Comments
2 min read
MySQL Database: Hands-On Labs for Multi-Table Operations & Sales Data Analysis

MySQL Database: Hands-On Labs for Multi-Table Operations & Sales Data Analysis

Comments
2 min read
"The API Is Slow, Fix It!" – What I Learned About `EXPLAIN` and Indexing

"The API Is Slow, Fix It!" – What I Learned About `EXPLAIN` and Indexing

Comments
2 min read
đź”· Top 20+ .NET & OOPs Interview Questions (Easy Guide for Freshers)

đź”· Top 20+ .NET & OOPs Interview Questions (Easy Guide for Freshers)

3
Comments
3 min read
Query YAML Like a Database — Why I Built YamlQL (And How It Works)

Query YAML Like a Database — Why I Built YamlQL (And How It Works)

2
Comments
4 min read
Beginner’s Guide to Designing a Relational Database Schema

Beginner’s Guide to Designing a Relational Database Schema

13
Comments 5
4 min read
loading...