Saturday, July 25, 2026
Home DBMS

DBMS

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.

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.

Assertion in SQL – Basic

In SQL, an assertion is a statement that ensures that certain conditions are always enforced in the database no matter what. Same as...

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

What is Microsoft Open Database Connection(ODBC)

languages that can use ODBC include Python, PHP, COBOL, and Perl etc.

Joins in SQL

With SQL, there are various JOIN types that let you combine data from different tables. Below is a quick summary of the...

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...

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...

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...

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...

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...

Two Tier vs Three Tier Database Management System Architecture

DBMS Architecture helps in design, development, implementation, and maintenance of a database to great extent.

Most Read

How to setup DNS Records in Cloudflare – Guide for Website Owners

Whether you're launching your first website, connecting a custom email address, or moving your domain to a new hosting provider, you've probably...

DeepSeek AI: The Open-Source AI Disruptor Shaking Up the Tech World

DeepSeek AI is revolutionizing the artificial intelligence landscape with its open-source, cost-effective, and highly customizable model. Built on cutting-edge transformer architecture and fine-tuned using reinforcement learning with human feedback (RLHF), DeepSeek delivers human-like text generation and accurate responses. Its efficient training techniques reduce computational costs by up to 40%, while its foundation on open-source frameworks like PyTorch and TensorFlow ensures seamless integration for developers. Whether you're a startup, a developer, or a large enterprise, DeepSeek offers unparalleled transparency, affordability, and performance, making it a game-changer in the world of AI. Discover why DeepSeek is outshining competitors like ChatGPT and Google Gemini in this comprehensive guide.

Useful Python Libraries for Data Science & ML Enthusiasts

Hi there, DataSagar here! If you're as passionate about data science as I am, then you know how overwhelming it can be...

Nepal Government allowing IT Companies to Invest Abroad

In a landmark decision that signals Nepal’s intent to embrace globalization and technological advancement, the government has now allowed Nepali IT companies...