Home / DBMS

DBMS

SQL Recovery

Transaction recovery The database management system allows as a method to manage the data tables and it’s related information. Adata table set of records in a tables format. A transaction a programming unit whose execution may no change the container of the database, the transaction is executed as a single unit and help …

Read More »

SQL Security

Security in sql

Control consideration The database is shared between multiple users so need to secure the data to unauthorized user full stop the database is controlled with a different technique to protect the information and provide required data to the database security includes in the policy to protect data provide processing control …

Read More »

SQL Basics

SQL SQL is a structured query language. It is a non-procedure language that allows built-in function and command for controlling the database and its data. It provides built-in syntax to define the express for controlling the database. The application of database like SQL server Oracle, my SQL etc support this language to generate …

Read More »