Database Management

Flask and Django both are Web Framework in python. Before comparing Flask and Django we need to understand few other terms which will make our understanding very clear. Library VS framework Library is less complex whereas framework is complex in nature. You can control when you are importing any method or function from any module […]
RDBMS: RDBMS means a Relational database management system. It is based on the relational model, which depicts a straight forward way of representing data in tables which is intuitive. In RDBMS each row of a table is a record with a unique ID called a key. MySQL, ORACLE database, PostgreSQL, IBM Db2 are common examples […]
What is Stored Procedure It is a code of SQL that can be used many times based on our requirements during managing data. In programming when you need to execute certain SQL queries multiple times, instead of calling them you can write a stored procedure that can be executed as and when required. Why we […]
Purpose: Join is the most important concept in SQL. Join is used for getting data from two or more tables however it is observed that people do not understand the right concept of the join and they end up using the wrong join method which might result in the wrong dataset. Use of Join: A […]