Friday, August 14, 2026
Home DBMS

DBMS

Serializable schedule in DBMS transaction processing

In a database management system (DBMS), a serializable schedule is a way of executing concurrent transactions in a way that produces the...

Assertion in SQL

An assertion in SQL is a named statement that specifies a requirement that must be true for the database's contents. The assertion...

SET operations in SQL

Set operations combines the results of two independent SQL queries. There are three set operations in SQL  1.Union 2. Intersect

Masters in Data Science(MDS) Program at Tribhuvan University

TU's MDS program not only provides you with a high-quality education but also positions you to tap into the vast opportunities in Nepal and beyond. With the growing adoption of data-driven decision-making in various industries, the demand for skilled data scientists is on the rise, both locally and internationally. Moreover, studying in Nepal can be a unique experience, offering the chance to explore a rich cultural heritage while gaining cutting-edge data science expertise. So, if you have a passion for data and a desire to shape the future of technology and business in Nepal, pursuing an MDS degree at Tribhuvan University could be one of the best decisions you'll ever make.

Transaction Control in DBMS – An introduction with examples

The process known as transaction control enables you to govern how transactions affect your database. It enables you to either roll back the changes made during a transaction in the event of an error or commit the changes made during a transaction to the database.

ACID Properties of Transaction – Atomicity, Consistency, Isolation, Durability

Transactions in a database management system (DBMS) include a number of characteristics that guarantee the consistency and integrity of the database.

Essential Skills to Excel as a Power BI Developer: Beyond DAX and Power Query

As a Power BI developer, your expertise goes beyond formulas and queries; it extends into the realm of data modeling and database management. Let's explore these crucial skills that can propel your career to new heights.

Normalization basics that every DBMS student must know.

Normalization is a process that is used to reduce the redundancy and dependency in a database. It is the process of organizing...

View in SQL

A virtual table called a SQL view is produced as a result of a SELECT command. It doesn't save any data on...

Things to care about when designing a good database system

There are several things to consider when designing a good database system: Data modeling: A good database design begins...

Structured Query Language: DDL, DML, TCL, DCL, DQL

SQL (Structured Query Language) is a programming language used to manage and manipulate data stored in relational databases. It is a standard...

Trigger in SQL

An automatic execution of a defined block of SQL code known as a trigger occurs in reaction to specific events, such as...

Most Read

Why Linux Won the Infrastructure War? Lessons from Linus Torvalds

In 1991, 21-year-old Linus Torvalds announced a "hobby" operating system. Today, Linux powers supercomputers, cloud servers, and Android. Explore his journey, the open-source economy, and the lessons for modern developers.

What Is Vibe Coding? A Complete Beginner’s Guide to Building Software and Web Pages With AI

A few years ago, building a website meant sitting down with a programming book, picking a language, and slowly working through syntax...

What is Answer Engine Optimization (AEO)? Getting Ready for AI Powered Search and Agentic Era Digital Marketing

Search is changing faster than it has in the last two decades. For years, businesses focused on ranking their websites on search...

The Plain Text Web: Why llms.txt Is Becoming the New Site Standard

The web built today is heavy. Between client-side JavaScript, cookie banners, tracker scripts, and responsive CSS grids, a typical webpage carries megabytes...