Naveens K articles - 8 total
CRUD OPERATIONS IN MONGODB
INTRODUCTION MongoDB is one of the most popular NoSQL databases, widely used for its...
Indexing, Hashing & Query Optimization in SQL
Intro When working with large databases, retrieving data efficiently becomes a big...
Transactions, Deadlocks & Log Based Recovery in SQL
Intro In this blog, let’s explore three very important database concepts: Transactions,...
Understanding ACID Properties in SQL Transactions
Intro When working with databases, data integrity is everything. Imagine transferring...
Understanding Cursors & Triggers in DBMS
Introduction Databases are the backbone of almost every software application today. From...
Demystifying Normalization in RDBMS: From 1NF to 3NF
Hi everyone! I’m really excited to share my learnings in RDBMS through this blog. As someone who is...
College Student and Course Management System using SQL (Oracle)
Introduction This is a simple, basic SQL project that demonstrates how to design and...
College Student and Course Management System using SQL (Oracle)
Introduction This is a simple, basic SQL project that demonstrates how to design and...