Advantage of SQL

SQL Cursors As we have discussed SQL Cursors in SQL tutorial of tutoraspire so you can go through the concepts again to…

SQL Trigger As we have discussed SQL Trigger in SQL tutorial of tutoraspire so you can go through the concepts again to…

DBMS Tutorial DBMS Tutorial provides basic and advanced concepts of Database. Our DBMS Tutorial is designed for beginners and professionals both. Database…

Types of Databases There are various types of databases used for storing different varieties of data: 1) Centralized Database It is the…

Recovery with Concurrent Transaction Whenever more than one transaction is being executed, then the interleaved of logs occur. During recovery, it would…

SQL Index Indexes are special lookup tables. It is used to retrieve data from the database very fast. An Index is used…

Three schema Architecture The three schema architecture is also called ANSI/SPARC architecture or three-level architecture. This framework is used to describe the…

Reduction of ER diagram to Table The database can be represented using the notations, and these notations can be reduced to a…

SQL INSERT Statement The SQL INSERT statement is used to insert a single or multiple data in a table. In SQL, You…

Timestamp Ordering Protocol The Timestamp Ordering Protocol is used to order the transactions based on their Timestamps. The order of transaction is…