Functions in SQL are the executable blocks that are created and stored in the database. The functions can be invoked from the SQL statements whenever required. Though SQL has some inbuilt functions but the developers can write their own user-defined functions. The functions in SQL are similar to the procedures in SQL that we have discussed earlier. But both of them share … [Read more...] about Functions in SQL
Triggers in SQL
Triggers in SQL are the programs that are executed automatically when a certain condition is met. The trigger can even be used to maintain the integrity of data. The triggers are created and stored in the database and then it is the responsibility of the database system to get the trigger executed whenever a certain condition is met. In this section ahead we will discuss the … [Read more...] about Triggers in SQL
Procedures in SQL
Procedures in SQL are the small subprograms or executable named blocks that can be created and saved in the database. These procedures can be invoked and executed whenever required. It is similar to functions or methods in other programming languages such as C, C++ and Java, etc. In the section ahead, we will discuss the procedure in-depth such as how it is defined, how it … [Read more...] about Procedures in SQL
Views in SQL
Views are virtual tables whose tuples or records do not physically exist in the database. Instead, the tuples of this virtual relation or virtual table are computed spontaneously when the user executes the query associated with the view. The database stores the query associated with the view so that the user does not have to write the query again and again. In the section … [Read more...] about Views in SQL
Classification of Database Management System
Classification of database management system is based on various parameters such as the kind of data model used to construct the DBMS, the number of users that will be using the database system, the way in which the database is distributed. In the section ahead, we will be discussing all the criteria on which the database system can be classified. Classification of Database … [Read more...] about Classification of Database Management System