Category Archives: SQL

Metadata in DBMS – Overview and Types

Metadata in DBMS is the data (details/schema) of any other data. It can also be defined as data about data. The word ‘Meta’ is the prefix that is generally the technical term for self-referential. In other words, we can say that Metadata is the summarized data for the contextual data. For example, consider the index… Read More »

Category: SQL

MongoDB vs SQLite – Difference between MongoDB and SQLite

In this article, you will learn about difference between MongoDB and SQLite. MongoDB MongoDB first version was released in 2009. It is the most reliable database used with Node.JS application. Its structure of saving the data is different because it stores data in a document which is like JSON. It uses the most popular document… Read More »

Joining Three or More Tables in SQL

Here you will learn about joining three tables in sql with example. Let us consider three tables Employee, Department and Project. We will see the complete example wherein these 3 tables are joined to produce a result: Table Employee This table records the Id of the Employee which is the primary key, the name of… Read More »

Category: SQL

Joins in SQL – Inner, Outer, Left and Right Join

Here you will get detailed information about joins in SQL. Join is a very basic concept in SQL which can be confusing at times. The joins are used when we need to find out the solution to a query involving the attributes of more than one table which have at least one attribute in common.… Read More »

Category: SQL

Difference between Primary Key and Foreign Key

A “key” is one of the most basic and important concepts of the Database Management System (DBMS); the keys helps us work easily with the records and the tables in our database by providing us with the ease of accessing and retrieving the data from the table. A primary key is the first key to… Read More »

Category: SQL

Difference Between MySQL and ORACLE

Here you will get to know about difference between mysql and oracle database. Both MySQL and Oracle are popular relational database management software developed by Oracle Corporation. MySQL: Its name is combination of words “My” and “SQL”, where “My” is name of daughter of co-founder Michael Widenius. And SQL full form is Structured Query Language.… Read More »

Category: SQL

Advantages and Disadvantages of DBMS

In this article you will know about advantages and disadvantages of DBMS. Database management system is an efficient way to create, manage and update databases and also is a prolific replacement of the old file systems which were earlier used to store and retrieve records. The DBMS facilitates the users to work with large amount… Read More »

Category: SQL

Difference between File System and DBMS

Here you will learn about difference between File System and DBMS in tabular form. File Management System, better known as File System is the most ancient and still the most popular way to keep your data files organised on your drives. On the other hand, when it comes to security and appropriate management of data… Read More »

Category: SQL