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-92 in TPC Benchmarks: Are They Still Relevant?
franckpachot profile

SQL-92 in TPC Benchmarks: Are They Still Relevant?

#postgres #sql #database #benchmark
7
Comments
10 min read
What Is a NoSQL Database and When Should You Use It?
jing_li profile
Jing for Chat2DB

What Is a NoSQL Database and When Should You Use It?

#database #sql #nosql #mysql
7
Comments 4
6 min read
Indexes in SQL | Clustered and Non Clustered Index
mrcaption49 profile

Indexes in SQL | Clustered and Non Clustered Index

#sql #fullstack #backend #database
5
Comments
2 min read
Podman - Create A FHIR-Server & SQL Server
vuelancer profile

Podman - Create A FHIR-Server & SQL Server

#webdev #beginners #sql #api
10
Comments
2 min read
Pragma Autonomous Transaction in Oracle PL/SQL | Complete Overview
mrcaption49 profile

Pragma Autonomous Transaction in Oracle PL/SQL | Complete Overview

#sql #fullstack #backend #programming
6
Comments
4 min read
Procedure vs Function | PLSQL
mrcaption49 profile

Procedure vs Function | PLSQL

#sql #devops #database #oracle
1
Comments
2 min read
Mastering Databases: From Optimizing Queries to Distributed Systems — Hoài Nhớ
hoainhoblogdev profile

Mastering Databases: From Optimizing Queries to Distributed Systems — Hoài Nhớ

#database #sql #nosql #databasedesign
18
Comments 8
4 min read
Normalisation | 2 NF
mrcaption49 profile

Normalisation | 2 NF

#sql #database #oracle #fullstack
5
Comments
2 min read
Normalization | 1 NF
mrcaption49 profile

Normalization | 1 NF

#sql #database #oracle #fullstack
5
Comments
1 min read
To Delete a record without using the DELETE | INSERT | UPDATE
mrcaption49 profile

To Delete a record without using the DELETE | INSERT | UPDATE

#sql #webdev #beginners #programming
Comments
2 min read
Convert CSV Data into Multilevel JSON #eg56
esproc_spl profile
Judy

Convert CSV Data into Multilevel JSON #eg56

#sql #json #csv #esproc
8
Comments
1 min read
SQL Injection: Types, Examples & Prevention Cheat Sheet
pynt profile

SQL Injection: Types, Examples & Prevention Cheat Sheet

#sql #security #api #pynt
Comments
1 min read
Data Analyst Checklist
justdetermined profile

Data Analyst Checklist

#sql #tableau #python #dataanalyst
11
Comments 1
1 min read
SQL in Minutes: Your Ultimate SQL Cheat Sheet
justdetermined profile

SQL in Minutes: Your Ultimate SQL Cheat Sheet

#sql #database #sqlserver #mariadb
2
Comments
1 min read
SQL INJECTION AND ITS TYPES.
mahimabhardwaj profile

SQL INJECTION AND ITS TYPES.

#sql #sqlinjection #cybersecurity #database
4
Comments
3 min read
😻🦾 Top 5 Text2SQL AI Tools in 2024 🤖🔁
yiran_jing_d932aa8bc72a83 profile

😻🦾 Top 5 Text2SQL AI Tools in 2024 🤖🔁

#ai #database #sql #productivity
26
Comments 1
2 min read
Interval Partitioning in Oracle SQL
mrcaption49 profile

Interval Partitioning in Oracle SQL

#sql #oracle #beginners #programming
5
Comments
2 min read
Relational Database
rajondey profile

Relational Database

#relationaldatabase #sql
Comments
2 min read
PostgreSQL Insights: Understanding MVCC in Transactions
wilson_evan_1efa5910f8855 profile

PostgreSQL Insights: Understanding MVCC in Transactions

#programming #sql #database #sqlserver
Comments
3 min read
Joins in SQL
mrcaption49 profile

Joins in SQL

#sql #backend #beginners #tutorial
9
Comments
2 min read
System Design: SQL vs NoSQL databases and what distinguishes them.
sirius93 profile

System Design: SQL vs NoSQL databases and what distinguishes them.

#systemdesign #database #mongodb #sql
Comments
2 min read
How data is replicated in salve nodes in SQL databases
ankitmalikg profile

How data is replicated in salve nodes in SQL databases

#sql #database #systemdesign #architecture
Comments
3 min read
Relational Databases vs. NoSQL
rajondey profile

Relational Databases vs. NoSQL

#relationaldatabases #sql #nosql
Comments
2 min read
Need Suggestions
coolguy_96_77e8876259d19a profile

Need Suggestions

#cloudcomputing #sql #career
Comments
1 min read
Capítulo 2 - Modelos de Datos y Lenguajes de Consulta
pabloar profile

Capítulo 2 - Modelos de Datos y Lenguajes de Consulta

#data #sql #nosql #dataengineering
2
Comments
7 min read
Enhance Your SQL Skills: 'Project - Modify Primary Key of Countrylanguage Table'
labby profile
Labby for LabEx

Enhance Your SQL Skills: 'Project - Modify Primary Key of Countrylanguage Table'

#labex #sql #mysql #programming
Comments
3 min read
Unlocking speed: the power of indexing in database performance
prahladyeri profile

Unlocking speed: the power of indexing in database performance

#webdev #database #mysql #sql
3
Comments
4 min read
Indexing for a Scalable Serialization Isolation Level
franckpachot profile

Indexing for a Scalable Serialization Isolation Level

#sql #yugabytedb #postgres #database
3
Comments 2
5 min read
How to Use Unique Key Constraints in Database Tables
j700abe profile

How to Use Unique Key Constraints in Database Tables

#sql #softwareengineering #database #sqlserver
Comments
2 min read
Upsert a row in a DB that doesn't use primary keys or unique constraints
tylerlwsmith profile

Upsert a row in a DB that doesn't use primary keys or unique constraints

#mysql #sql
4
Comments
3 min read
Access IRIS database with ODBC or JDBC using Python
intersystemsdev profile

Access IRIS database with ODBC or JDBC using Python

#database #python #sql #documentation
1
Comments
5 min read
SQL Cheatsheet: A Handy Reference for SQL Commands with Examples
jagroop2001 profile

SQL Cheatsheet: A Handy Reference for SQL Commands with Examples

#webdev #database #programming #sql
35
Comments 8
3 min read
ACID properties in SQL
mrcaption49 profile

ACID properties in SQL

#sql #backend #fullstack #webdev
5
Comments
1 min read
Unlock the Power of Stored Procedures and Cursors: A Project-Based Course on Database Retrieval
labby profile
Labby for LabEx

Unlock the Power of Stored Procedures and Cursors: A Project-Based Course on Database Retrieval

#labex #sql #mysql #programming
Comments
2 min read
How to Use Common Table Expressions (CTEs) to Avoid N+1 Queries in Hierarchical Data
naveed profile

How to Use Common Table Expressions (CTEs) to Avoid N+1 Queries in Hierarchical Data

#performance #postgres #sql #database
1
Comments
5 min read
The Ultimate Database Tools for Collaborative Team Design in 2025
roxana_haidiner profile

The Ultimate Database Tools for Collaborative Team Design in 2025

#database #git #sql #management
2
Comments 2
5 min read
Choose the Best Database Management Tool for PostgreSQL in 2025
roxana_haidiner profile

Choose the Best Database Management Tool for PostgreSQL in 2025

#database #postgres #sql #design
2
Comments 1
12 min read
Structured vs. Unstructured Databases: The Ultimate Guide to Understanding the Key Differences
abhinowww profile

Structured vs. Unstructured Databases: The Ultimate Guide to Understanding the Key Differences

#database #coding #sql #learning
2
Comments
3 min read
Functional indices for lightning-fast queries on many-to-many relationship tables
intersystemsdev profile

Functional indices for lightning-fast queries on many-to-many relationship tables

#indexing #sql #beginners #programming
Comments
15 min read
AS Keyword in SQL Server
amr-saafan profile

AS Keyword in SQL Server

#sql #sqlserver #database
Comments
5 min read
Scenario 2: Mastering Backfilling for New dB Columns – Update Like a Pro!
chidioguejiofor profile

Scenario 2: Mastering Backfilling for New dB Columns – Update Like a Pro!

#sql #typescript #backenddevelopment #performance
Comments
4 min read
Fastest way to count in sql
volland profile

Fastest way to count in sql

#sql
Comments
1 min read
How to pass an Array of Structs in Bigquery's parameterized queries
matthieucham profile

How to pass an Array of Structs in Bigquery's parameterized queries

#bigquery #python #googlecloud #sql
8
Comments
3 min read
Dive into the World of SQL: Comprehensive Programming Resources for Beginners and Experts
getvm profile

Dive into the World of SQL: Comprehensive Programming Resources for Beginners and Experts

#getvm #sql #programming #tutorials
Comments
3 min read
DJ Databass
saradomincroft profile

DJ Databass

#react #flask #python #sql
Comments
4 min read
Associative Arrays in PL/SQL
mrcaption49 profile

Associative Arrays in PL/SQL

#webdev #javascript #sql #beginners
5
Comments
3 min read
Optimizing SQL Queries
mrpercival profile

Optimizing SQL Queries

#mysql #sql #mariadb
2
Comments
5 min read
SQL and Database Design: A Detailed Exploration - Week Seven
shubham_murti profile

SQL and Database Design: A Detailed Exploration - Week Seven

#aws #cloud #learning #sql
Comments
5 min read
VARRAY in PLSQL Functions | LIMIT | COUNT | EXTEND
mrcaption49 profile

VARRAY in PLSQL Functions | LIMIT | COUNT | EXTEND

#sql #database #oracle #fullstack
5
Comments
2 min read
Core PHP CRUD Operations: A Beginner's Tutorial
prahladyeri profile

Core PHP CRUD Operations: A Beginner's Tutorial

#php #database #sql
9
Comments
4 min read
Difference Between Varray and Nested Table in PLSQL
mrcaption49 profile

Difference Between Varray and Nested Table in PLSQL

#discuss #webdev #sql #database
1
Comments
2 min read
Join the Party: A Comprehensive Guide to SQL Joins with Examples
asim_khan_cbe65e41bcbbc65 profile

Join the Party: A Comprehensive Guide to SQL Joins with Examples

#javascript #sql #database #sqlserver
1
Comments
4 min read
Materialized Views in SQL | Best Explanation
mrcaption49 profile

Materialized Views in SQL | Best Explanation

#sql #data #webdev #database
8
Comments
3 min read
Self Join in SQL | Best Explanation with Examples
mrcaption49 profile

Self Join in SQL | Best Explanation with Examples

#sql #fullstack #devops #javascript
6
Comments
5 min read
This Single-Line Command Reduced Our Database Object Management Efforts
sushmitha_b_06c9646d9a20a profile

This Single-Line Command Reduced Our Database Object Management Efforts

#sql #database #custom
Comments
5 min read
Difference between GROUP BY and DISTINCT in SQL
mrcaption49 profile

Difference between GROUP BY and DISTINCT in SQL

#sql #database #oracle #fullstack
1
Comments
1 min read
RAISE_APPLICATION_ERROR and PRAGMA EXCEPTION_INIT in PLSQL EXCEPT HANDLING
mrcaption49 profile

RAISE_APPLICATION_ERROR and PRAGMA EXCEPTION_INIT in PLSQL EXCEPT HANDLING

#beginners #sql #oracle #fullstack
6
Comments
3 min read
Materialized View in SQL
mrcaption49 profile

Materialized View in SQL

#sql #data #database #fullstack
Comments
5 min read
How to Use the SQL Server ANY Keyword for Flexible Querying
amr-saafan profile

How to Use the SQL Server ANY Keyword for Flexible Querying

#sql #sqlserver #database
Comments
5 min read
Aggregate function & Windows functions
mrcaption49 profile

Aggregate function & Windows functions

#sql #database #oracle #fullstack
1
Comments
2 min read
loading...