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.
DATABASE NORMALIZATION IN SQL - 1NF,2NF AND 3NF EXPLAINED (STUDENT - COURSE CASE STUDY

DATABASE NORMALIZATION IN SQL - 1NF,2NF AND 3NF EXPLAINED (STUDENT - COURSE CASE STUDY

Comments
3 min read
Data Security in SQL: Encryption, Roles, and Permissions

Data Security in SQL: Encryption, Roles, and Permissions

Comments
2 min read
DB2 Pract (Packages, subqueries)

DB2 Pract (Packages, subqueries)

Comments
7 min read
How simultaneously swapping unique IDs in Postgres

How simultaneously swapping unique IDs in Postgres

4
Comments
2 min read
SeaORM 2.0: New Entity Format

SeaORM 2.0: New Entity Format

1
Comments
9 min read
Apache Ignite 3.1.0 is now available

Apache Ignite 3.1.0 is now available

Comments
2 min read
Why AI Analytics Tools Are Solving the Wrong Problem

Why AI Analytics Tools Are Solving the Wrong Problem

5
Comments 1
7 min read
cursor

cursor

Comments
3 min read
The Deterministic Problem with Probabilistic AI Analytics

The Deterministic Problem with Probabilistic AI Analytics

Comments
7 min read
DevPill 6 - SQLC: how to scaffold your database code

DevPill 6 - SQLC: how to scaffold your database code

Comments
1 min read
Devpill 4 - Database migrations with Migrate

Devpill 4 - Database migrations with Migrate

Comments 1
1 min read
Fixing SQL Injection Vulnerabilities to Strengthen Security

Fixing SQL Injection Vulnerabilities to Strengthen Security

Comments 2
10 min read
Generating Table Schema from AWS Glue Table

Generating Table Schema from AWS Glue Table

2
Comments
1 min read
How to Learn SQL for Data Analysis in 2026: A Free Learning Path

How to Learn SQL for Data Analysis in 2026: A Free Learning Path

2
Comments
2 min read
Learning .NET from Beginner to Advanced Level's

Learning .NET from Beginner to Advanced Level's

40
Comments 2
22 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.