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.
Rails Self-Join Tables - Parent-Child Magic

Rails Self-Join Tables - Parent-Child Magic

Comments
3 min read
MariaDB to PostgreSQL: Lessons & Challenges

MariaDB to PostgreSQL: Lessons & Challenges

3
Comments
6 min read
Database Design Principles - Normalization and Denormalization

Database Design Principles - Normalization and Denormalization

Comments
3 min read
Como Alterar o Nome do Seu SQL Server

Como Alterar o Nome do Seu SQL Server

Comments
1 min read
OLTP Explained: Speed, Integrity, and High Availability in Databases

OLTP Explained: Speed, Integrity, and High Availability in Databases

3
Comments 3
2 min read
SQL Injection - In Just 5 Minutes!

SQL Injection - In Just 5 Minutes!

Comments
3 min read
Find logged Microsoft SQL Server Messages

Find logged Microsoft SQL Server Messages

Comments
1 min read
PostgreSql Tasks - Case study:2

PostgreSql Tasks - Case study:2

1
Comments
2 min read
How to Import/Export CSV file in pgAdmin

How to Import/Export CSV file in pgAdmin

Comments
3 min read
SQL Coding

SQL Coding

Comments 1
3 min read
Why Developers Are Ditching SQL Pain Points with Open-Source SPL

Why Developers Are Ditching SQL Pain Points with Open-Source SPL

6
Comments
7 min read
Mastering `SelectMany` in EF Core: SQL Equivalents and Best Practices

Mastering `SelectMany` in EF Core: SQL Equivalents and Best Practices

4
Comments
3 min read
SQL 101 | Chapter 8: Using Subqueries for Improved Modularity and Dynamic Calculations

SQL 101 | Chapter 8: Using Subqueries for Improved Modularity and Dynamic Calculations

3
Comments
3 min read
Как выбрать язык программирования для бекенда

Как выбрать язык программирования для бекенда

1
Comments
1 min read
JSON: A Technical Overview

JSON: A Technical Overview

1
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.