Easy SQL Notes

Relational Database Management System  (RDBMS) A relational Database is a way of organizing data in rows and columns. The structure used to store data in row and column format is known as a table. A relational database and the software required for handling the database will together form an RDBMS.  It allows you to create, read, update, and delete (CRUD operations) data on a database. In mathematics, 'a relation' is defined as a set of tuples that have the same attributes. The table is a name we commonly use to represent a relation . It has a set of tuples(rows) and the same attributes(columns) From the above discussion, we can understand that RDBMS is nothing but a collection of tables that store interrelated data   +   a set of programs to access and manipulate that data. Some of the commonly used RDBMS packages are MySQL, PostgreSQL, Oracle Database, Microsoft SQL Server, IBM Db2, MariaDB.0 What are the different types of database users? What do a database a...

Describing what a Database is or  What is a database  As ordinary computer users, we may be accustomed to saving data in simple files like text files in notepad, spreadsheets like Microsoft Excel, etc. When it comes to a single user, spreadsheets are excellent. We can use them to execute basic operations like integrating data from different sheets or even creating appropriate reports and dashboards. As long as the data volume is manageable and limited, this is alright. Otherwise, we must use what we refer to as databases, which are simply software applications made to store massive amounts of information in a highly structured manner. Note : Unofficially wherever we store data can be called a database; however computer science people generally call the software application, which is specifically built to handle data, a database.  I would like to stick on to the word "Database Management Systems/DBMS" when we refer to such applications 😀 A Database Management System in s...