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.
TIL: joining with LIKE

TIL: joining with LIKE

2
Comments
1 min read
Understanding and Using Window Functions in SQL

Understanding and Using Window Functions in SQL

Comments
1 min read
Preventing SQL Injection (SQLi) in Symfony: Best Practices with Examples

Preventing SQL Injection (SQLi) in Symfony: Best Practices with Examples

Comments
3 min read
Top 🐘👀 Postgres Monitoring Tools 🧰 and Best Practices in 2024 🔝

Top 🐘👀 Postgres Monitoring Tools 🧰 and Best Practices in 2024 🔝

5
Comments
4 min read
Essential SQL Database Security Practices to Protect Your Data

Essential SQL Database Security Practices to Protect Your Data

Comments
4 min read
These 10+ comparisons cover entire SQL concepts, Is it?

These 10+ comparisons cover entire SQL concepts, Is it?

Comments
6 min read
Advanced Paradigms in Data Ingestion: Integrating Big Data Ecosystems with Linux, SQL

Advanced Paradigms in Data Ingestion: Integrating Big Data Ecosystems with Linux, SQL

Comments
3 min read
SQL Server: Usare l'Istruzione LIKE all'Interno di una WHERE

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

Comments
3 min read
SQL Indexes

SQL Indexes

Comments
3 min read
Split a Huge CSV File into Multiple Smaller CSV Files #eg69

Split a Huge CSV File into Multiple Smaller CSV Files #eg69

8
Comments 1
1 min read
My journey learning Apache Spark

My journey learning Apache Spark

Comments
2 min read
Introduction to DBMS

Introduction to DBMS

Comments
4 min read
SQL "SELECT INTO" vs "INSERT INTO SELECT" statements.

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

Comments
1 min read
How Pipe Syntax Fix SQL Design Problems

How Pipe Syntax Fix SQL Design Problems

Comments
5 min read
Procedure vs Function | PLSQL

Procedure vs Function | PLSQL

1
Comments
2 min read
I'm looking for a FullStack Software Developer Role

I'm looking for a FullStack Software Developer Role

Comments
2 min read
To Delete a record without using the DELETE | INSERT | UPDATE

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

Comments
2 min read
Why Doesn't Postgres Use My Index

Why Doesn't Postgres Use My Index

Comments
16 min read
Data Hunter Game

Data Hunter Game

1
Comments 2
3 min read
How to Query CSV Files with SQLite

How to Query CSV Files with SQLite

Comments
8 min read
What Are Stored Procedures?

What Are Stored Procedures?

Comments
8 min read
Populating a Vertica Database with Random Data

Populating a Vertica Database with Random Data

Comments
4 min read
Normalization | 1 NF

Normalization | 1 NF

7
Comments
1 min read
LuxDevHQ (Lux Academy and Data Science East Africa) Training Program in AI, Data Science, Analytics, and Data Engineering

LuxDevHQ (Lux Academy and Data Science East Africa) Training Program in AI, Data Science, Analytics, and Data Engineering

16
Comments
2 min read
Relational vs. Document Databases: Key Differences, Use Cases, and Performance

Relational vs. Document Databases: Key Differences, Use Cases, and Performance

Comments
3 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

Comments
3 min read
Best Practices for Alembic and SQLAlchemy

Best Practices for Alembic and SQLAlchemy

Comments 1
5 min read
How to Secure Web Applications: Top Security Practices

How to Secure Web Applications: Top Security Practices

Comments
3 min read
Indexes Under The Hood

Indexes Under The Hood

1
Comments
14 min read
How to Optimize SQL Queries for Better Database Performance?

How to Optimize SQL Queries for Better Database Performance?

1
Comments 1
5 min read
SQL Data Exploration for BoardGameGeek datasets

SQL Data Exploration for BoardGameGeek datasets

Comments
5 min read
SQL Queries Execution Order

SQL Queries Execution Order

Comments
3 min read
Simplifying SQL View Management in Laravel Migrations

Simplifying SQL View Management in Laravel Migrations

1
Comments
3 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

11
Comments
3 min read
Mastering SQL Optimization: A Beginner’s Guide to Faster and More Efficient Queries

Mastering SQL Optimization: A Beginner’s Guide to Faster and More Efficient Queries

Comments
3 min read
Materialized View in SQL

Materialized View in SQL

Comments
5 min read
Pragma Autonomous Transaction in Oracle PL/SQL | Complete Overview

Pragma Autonomous Transaction in Oracle PL/SQL | Complete Overview

8
Comments
4 min read
SQL vs. NoSQL: Key Differences, Use Cases, and Choosing the Right Database for Your Project

SQL vs. NoSQL: Key Differences, Use Cases, and Choosing the Right Database for Your Project

Comments
5 min read
B-tree index in ORACLE SQL

B-tree index in ORACLE SQL

Comments
2 min read
Concurrency Issues in SQL and Distributed Systems

Concurrency Issues in SQL and Distributed Systems

Comments
25 min read
Getting members according to primary key values #eg63

Getting members according to primary key values #eg63

9
Comments
1 min read
Difference Between Varray and Nested Table in PLSQL

Difference Between Varray and Nested Table in PLSQL

1
Comments
2 min read
Sequence in SQL | PART 2

Sequence in SQL | PART 2

Comments
3 min read
Understanding SQL Queries: A Beginner’s Guide pt1

Understanding SQL Queries: A Beginner’s Guide pt1

Comments
4 min read
Partitioning in Oracle SQL

Partitioning in Oracle SQL

Comments
2 min read
B-Tree Index and Bitmap Index in ORACLE SQL

B-Tree Index and Bitmap Index in ORACLE SQL

Comments
2 min read
Criando um Simulador de Banco de Dados em Rust: Parsing, Compilação e Execução de Consultas SQL

Criando um Simulador de Banco de Dados em Rust: Parsing, Compilação e Execução de Consultas SQL

Comments
3 min read
SQL 101: Introduction to Structured Query Language

SQL 101: Introduction to Structured Query Language

1
Comments
3 min read
CPU SIMULATOR

CPU SIMULATOR

1
Comments 4
1 min read
SQL Query Compilation

SQL Query Compilation

Comments
1 min read
Handling Data in SQL: Signed vs. Unsigned Types

Handling Data in SQL: Signed vs. Unsigned Types

Comments
1 min read
Use Transactions When Manually Accessing SQL Databases

Use Transactions When Manually Accessing SQL Databases

Comments
3 min read
Query Optimization in PL/SQL

Query Optimization in PL/SQL

1
Comments
4 min read
View with Join Condition in SQL

View with Join Condition in SQL

Comments
2 min read
My first CLI.

My first CLI.

Comments
3 min read
SQL-92 in TPC Benchmarks: Are They Still Relevant?

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

7
Comments
10 min read
Troubleshooting PostgreSQL Low Free Memory

Troubleshooting PostgreSQL Low Free Memory

Comments
11 min read
SQL ain't that Scary

SQL ain't that Scary

Comments
11 min read
Demystifying SQLMap: A Practical Guide to Web and SQL Injection Testing

Demystifying SQLMap: A Practical Guide to Web and SQL Injection Testing

Comments
2 min read
Named Calling Notations in PLSQL

Named Calling Notations in PLSQL

Comments
2 min read
loading...