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 Magic: Automating Tasks with Cursor and Trigger ✨

🏦 Database Magic: Automating Tasks with Cursor and Trigger ✨

Comments
3 min read
Database Normalization: From 1NF to 3NF

Database Normalization: From 1NF to 3NF

Comments
2 min read
Cursor +Trigger

Cursor +Trigger

Comments
2 min read
Auto-Generate Snowflake Semantic Views with AI - A Developer's Fast-Track to Cortex Analyst

Auto-Generate Snowflake Semantic Views with AI - A Developer's Fast-Track to Cortex Analyst

1
Comments
11 min read
How I helped Revamp an Organization's Online Presence

How I helped Revamp an Organization's Online Presence

Comments
2 min read
Transactions, Deadlocks & Log Based Recovery

Transactions, Deadlocks & Log Based Recovery

Comments
1 min read
Cursor + Trigger

Cursor + Trigger

1
Comments
2 min read
💾Ensuring Database Stability: Transactions, Deadlocks & Log-Based Recovery

💾Ensuring Database Stability: Transactions, Deadlocks & Log-Based Recovery

Comments
3 min read
Database Normalization — Step-by-Step from 1NF to 3NF

Database Normalization — Step-by-Step from 1NF to 3NF

Comments
3 min read
Understanding ACID Properties in SQL with Practical Examples

Understanding ACID Properties in SQL with Practical Examples

Comments
2 min read
Understanding ACID Properties in SQL with Practical Examples

Understanding ACID Properties in SQL with Practical Examples

Comments
2 min read
Database Normalization — Step-by-Step from 1NF to 3NF

Database Normalization — Step-by-Step from 1NF to 3NF

Comments
3 min read
Boosting SQL Performance: Indexing & Query Optimization Using a Students Table

Boosting SQL Performance: Indexing & Query Optimization Using a Students Table

Comments
3 min read
Cursor + Trigger

Cursor + Trigger

Comments
1 min read
The Unbreakable Contract: Mastering Transactions, Deadlocks, and Database Recovery

The Unbreakable Contract: Mastering Transactions, Deadlocks, and Database Recovery

Comments
3 min read
The Backbone of Database Reliability: Exploring ACID in Action with SQL Transactions

The Backbone of Database Reliability: Exploring ACID in Action with SQL Transactions

Comments
3 min read
Mastering Database Normalization with Oracle Live SQL: A Practical Guide

Mastering Database Normalization with Oracle Live SQL: A Practical Guide

Comments
4 min read
What Is Row-Level Locking?

What Is Row-Level Locking?

Comments
2 min read
SQL Commands Guide

SQL Commands Guide

Comments 1
4 min read
Indexing, Hashing & Query Optimization

Indexing, Hashing & Query Optimization

1
Comments
2 min read
Database System Internals — Transactions, Deadlocks, Recovery & Indexing Explained with SQL Examples

Database System Internals — Transactions, Deadlocks, Recovery & Indexing Explained with SQL Examples

1
Comments 1
3 min read
EXPLORING NORMALIZATION

EXPLORING NORMALIZATION

Comments
2 min read
SQL Cursor & AFTER INSERT Trigger — Step-by-Step Guide with Example

SQL Cursor & AFTER INSERT Trigger — Step-by-Step Guide with Example

Comments
2 min read
Database Automation Power-Up: Cursors and Triggers in Under 5 Minutes

Database Automation Power-Up: Cursors and Triggers in Under 5 Minutes

Comments
2 min read
NORMALISATION

NORMALISATION

1
Comments
2 min read
loading...