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.
Upsert a row in a DB that doesn't use primary keys or unique constraints

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

3
Comments
3 min read
Access IRIS database with ODBC or JDBC using Python

Access IRIS database with ODBC or JDBC using Python

1
Comments
5 min read
Unlock the Power of Stored Procedures and Cursors: A Project-Based Course on Database Retrieval

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

Comments
2 min read
ACID properties in SQL

ACID properties in SQL

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

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

1
Comments
5 min read
How to connect and query multiple databases with a single REST API

How to connect and query multiple databases with a single REST API

2
Comments
3 min read
Choose the Best Database Management Tool for PostgreSQL in 2025

Choose the Best Database Management Tool for PostgreSQL in 2025

10
Comments 4
12 min read
The Ultimate Database Tools with Git in 2025

The Ultimate Database Tools with Git in 2025

12
Comments 4
5 min read
Structured vs. Unstructured Databases: The Ultimate Guide to Understanding the Key Differences

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

2
Comments
3 min read
Functional indices for lightning-fast queries on many-to-many relationship tables

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

Comments
15 min read
Simplifying SQL View Management in Laravel Migrations

Simplifying SQL View Management in Laravel Migrations

1
Comments
3 min read
Fastest way to count in sql

Fastest way to count in sql

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

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

12
Comments 2
3 min read
Dive into the World of SQL: Comprehensive Programming Resources for Beginners and Experts

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

Comments
3 min read
Optimizing SQL Queries

Optimizing SQL Queries

2
Comments
5 min read
Associative Arrays in PL/SQL

Associative Arrays in PL/SQL

6
Comments
3 min read
SQL and Database Design: A Detailed Exploration - Week Seven

SQL and Database Design: A Detailed Exploration - Week Seven

Comments
5 min read
Employee Management System Using SQL

Employee Management System Using SQL

17
Comments
4 min read
Core PHP CRUD Operations: A Beginner's Tutorial

Core PHP CRUD Operations: A Beginner's Tutorial

11
Comments 1
4 min read
VARRAY in PLSQL Functions | LIMIT | COUNT | EXTEND

VARRAY in PLSQL Functions | LIMIT | COUNT | EXTEND

5
Comments
2 min read
Difference Between Varray and Nested Table in PLSQL

Difference Between Varray and Nested Table in PLSQL

2
Comments
2 min read
This Single-Line Command Reduced Our Database Object Management Efforts

This Single-Line Command Reduced Our Database Object Management Efforts

Comments
5 min read
Self Join in SQL | Best Explanation with Examples

Self Join in SQL | Best Explanation with Examples

6
Comments
5 min read
Materialized Views in SQL | Best Explanation

Materialized Views in SQL | Best Explanation

6
Comments
3 min read
RAISE_APPLICATION_ERROR and PRAGMA EXCEPTION_INIT in PLSQL EXCEPT HANDLING

RAISE_APPLICATION_ERROR and PRAGMA EXCEPTION_INIT in PLSQL EXCEPT HANDLING

7
Comments 1
3 min read
loading...