Skip to content

Tag Archives: DBMS-SQL

Introduction : A transaction is a series of object operations that must be done in an ACID-compliant manner. Atomicity – The transaction is completed entirely or not… Read More
Structured Query Language or SQL is a standard database language that is used to create, maintain and retrieve the data from relational databases like MySQL,… Read More
What is ‘Identity Column’ ? Identity column of a table is a column whose value increases automatically. A user generally cannot insert a value into… Read More
Fragmentation is a process of dividing the whole or full database into various subtables or sub relations so that data can be stored in different… Read More
Query processing in a distributed database management system requires the transmission of data between the computers in a network. A distribution strategy for a query… Read More
1. Database management system (DBMS) :Database management system (DBMS) is a software that manage or organize the data in a database. We can arrange the… Read More
1. CHAR :The char data type is used to store the character values. It is a fixed-length data type i.e once initialized we cannot change… Read More
Magic tables are the temporary logical tables that are created by the SQL server whenever there are insertion or deletion or update( D.M.L)  operations. The… Read More
A SQL login is another credential that allows you to access SQL Server. When you log on to Windows or even your e-mail account, for… Read More
Queries in SQL :A query will either be an invitation for data results from your info or for action on the info, or each. a… Read More
JOINS :Joins in SQL are used to combine rows from multiple tables on a specific condition, which is a relation between the columns of two… Read More
In this article, we will discuss the overview of DDL commands and will understand DDL commands like create, alter, truncate, drop. We will cover each… Read More
In this article, we will discuss the overview of transaction, deadlock and will focus on update conflicts with the concurrent update and understand with the… Read More
Overview :Structured Query Language or SQL is a standard Database language that is used to create, maintain and retrieve the data from relational databases like… Read More
Fuzzy Search :A technique of finding the strings that match a pattern approximately (rather than exactly). Users / Reviewers often capture names inaccurately. Typing mistake… Read More

Start Your Coding Journey Now!