Author Archives: Sumit Thakur - Page 5
Explain Data Control Language (DCL) with Examples in DBMS
Explain Data Control Language (DCL) with Examples in DBMS: A Data Control Language (DCL) can be defined as a computer language that is used for controlling privilege in the database.…
Data Definition language (DDL ) in DBMS with Examples
Data Definition language(DDL) in DBMS with Examples: Data Definition Language can be defined as a standard for commands through which data structures are defined. It is a computer language that…
What is SQL, its Applications, Advantages and Disadvantages?
SQL fully abbreviated as Structured Query Language can be defined as a domain-specific language used to manage the relational databases and performs different operations on the data stored in them.…
B-TREE Indexing in DBMS: Why we use B-Tree
B-TREE Indexing in DBMS With PDF: Before we proceed to B-tree indexing lets understand what index means. An Index can be simply defined as an optional structure associated with a…
Explain DBMS Transactions
Explain DBMS Transactions: Transaction management is a very interesting and important concept in DBMS as it is related to our daily life. We withdraw the amount, deposit the cash, also…
DBMS – RELATIONAL ALGEBRA
DBMS - RELATIONAL ALGEBRA : Algebra - As we know is a formal structure that contains sets and operations, with operations being performed on those sets. Relational algebra can be…
26 Advantages of Data Mining
26 Advantages of Data Mining: The data can be found through various digital tools from different sources to get raw data from digital and physical world. There are lots of…
How does Data Mining works
How does data mining works: Data mining engine is essential part of data mining system that consist several functional modules like association, correlation analysis, luster analysis, knowledge discovery, characterization, evolution…
Joins in DBMS and Types (Inner, Outer, Theta, Equi, Left, Right)
Joins are the foundation in SQL. The JOIN operation is essentially used to combine related tuples from two or more relations into a single type. In simple words, it is…
CONCURRENCY CONTROL In DBMS
CONCURRENCY CONTROL In DBMS PDF: In the multi-user system, we all know that multiple transactions run in parallel, thus trying to access the same data and suppose if one transaction…