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.
Acid Properties in SQL

Acid Properties in SQL

1
Comments
2 min read
Exploring PL/SQL Collection Methods: DELETE, TRIM, and Their Best Practices

Exploring PL/SQL Collection Methods: DELETE, TRIM, and Their Best Practices

2
Comments
2 min read
Transactions , Deadlocks & Log Based Recovery in SQL

Transactions , Deadlocks & Log Based Recovery in SQL

1
Comments
2 min read
Cursor + Trigger

Cursor + Trigger

Comments
2 min read
How to Scale Analytics When You’re Tracking Billions of Events Without Exploding Cost

How to Scale Analytics When You’re Tracking Billions of Events Without Exploding Cost

Comments
3 min read
Explain the difference between subquery,CTE and stored procedures

Explain the difference between subquery,CTE and stored procedures

Comments
1 min read
Transforming Tableau Performance: How Optimized Data Logic Cut Dashboard Load Time by 98.9%

Transforming Tableau Performance: How Optimized Data Logic Cut Dashboard Load Time by 98.9%

5
Comments
8 min read
How Generative AI Is Turning Natural Language Into SQL—And Changing Data Work

How Generative AI Is Turning Natural Language Into SQL—And Changing Data Work

Comments
4 min read
Learning SQL: The Language Behind Your Data

Learning SQL: The Language Behind Your Data

Comments
3 min read
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
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
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
TypedSql: Turning the C# Type System into a High-Performance SQL Query Engine

TypedSql: Turning the C# Type System into a High-Performance SQL Query Engine

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

Fixing SQL Injection Vulnerabilities to Strengthen Security

Comments 2
10 min read
Demystifying Normalization in RDBMS: From 1NF to 3NF

Demystifying Normalization in RDBMS: From 1NF to 3NF

Comments
5 min read
Understanding the Difference Between Subquery, CTE, and Stored Procedure

Understanding the Difference Between Subquery, CTE, and Stored Procedure

Comments
3 min read
🚀 Understanding Indexing in Oracle (B-Tree, B+ Tree, Hash Cluster) Indexes are one of the most important concepts in databases.

🚀 Understanding Indexing in Oracle (B-Tree, B+ Tree, Hash Cluster) Indexes are one of the most important concepts in databases.

Comments
3 min read
💾 ACID Properties

💾 ACID Properties

Comments
2 min read
📝 Understanding Transactions, Deadlocks & Log-Based Recovery in SQL 💾

📝 Understanding Transactions, Deadlocks & Log-Based Recovery in SQL 💾

1
Comments
2 min read
loading...