Breaking News

DBMS

What is Database Keys in DBMS?

Database Keys Keys are very important part of Relational database. They are used to establish and identify relation between tables. They also ensure that each record within a table can be uniquely identified by combination …

Read More »

Normalization of Database

Normalization of Database Database Normalisation is a technique of organizing the data in the database. Normalization is a systematic approach of decomposing tables to eliminate data redundancy and undesirable characteristics like Insertion, Update and Deletion …

Read More »

What Is Structure Query Language(SQL) ?

Introduction to SQL Structure Query Language(SQL) is a programming language used for storing and managing data in RDBMS. SQL was the first commercial language introduced for E.F Codd’s Relational model. Today almost all RDBMS(MySql, Oracle, …

Read More »

create command

create command create is a DDL command used to create a table or a database. Creating a Database To create a database in RDBMS, create command is uses. Following is the Syntax, create database database-name; …

Read More »

alter command

alter command alter command is used for alteration of table structures. There are various uses of alter command, such as, to add a column to existing table to rename any existing column to change datatype …

Read More »

Data Manipulation Language (DML)

DML command Data Manipulation Language (DML) statements are used for managing data in database. DML commands are not auto-committed. It means changes made by DML command are not permanent to database, it can be rolled …

Read More »

All Transaction Control Language(TCL) commands

TCL command Transaction Control Language(TCL) commands are used to manage transactions in database.These are used to manage the changes made by DML statements. It also allows statements to be grouped together into logical transactions. Commit …

Read More »

All Data Control Language(DCL) Command

Data Control Language(DCL) is used to control privilege in Database. To perform any operation in the database, such as for creating tables, sequences or views we need privileges. Privileges are of two types, System : …

Read More »

WHERE clause

Where clause is used to specify condition while retriving data from table. Where clause is used mostly withSelect, Update and Delete query. If condititon specified by where clause is true then only the result from …

Read More »