Skip to content

Tag Archives: DBMS-SQL

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
Here we are going to see how we can compare the columns of two different tables in SQL. We will be taking a few examples… Read More
The purpose of this article is to make a simple program to Join two tables using Join and Where clause in SQL. Below is the… Read More
Here we will see how to add unique key constraint to a column(s) of a MS SQL Server’s database with the help of a SQL… 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
The aim of this article is to make a simple program to Join two tables using Join and Where clause using MySQL. Below is the… Read More