SQL Testing
Introduction To RDMS
DataBase
DBMS Vs RDBMS
SQL Tutorials
SQL DataTypes
SQL Operators
SQL Statements
DDL (Data Definition Language)
SQL-Create Table
SQL-Alter Table
SQL-Drop Table
SQL-Truncate Table
DML (Data Manipulation Language)
SQL-Select Statement
SQL-Insert Statement
SQL-Update Statement
SQL-Delete Statement
SQL Constraints
SQL-Not Null Constraint
SQL-Unique Constraint
SQL-Primary Key Constraint
SQL-Foreign Key Constraint
SQL-Check Constraint
SQL Special Operators
SQL-IN Operator
SQL-LIKE Operator
SQL-BETWEEN Operator
SQL Sorting (Order By)
SQL Group By
SQL Aggregate Function
SQL Having
SQL Joins
SQL-Cross Join
SQL-Inner Join
SQL-Left Outer Join
SQL-RIGHT Outer Join
SQL-Self Join
SQL SubQueries
ISQL-Independent Sub Queries
SQL-Correlated Sub Queries
SQL Views
SQL Index
DataBase
DBMS Vs RDBMS
SQL Tutorials
SQL DataTypes
SQL Operators
SQL Statements
DDL (Data Definition Language)
SQL-Create Table
SQL-Alter Table
SQL-Drop Table
SQL-Truncate Table
DML (Data Manipulation Language)
SQL-Select Statement
SQL-Insert Statement
SQL-Update Statement
SQL-Delete Statement
SQL Constraints
SQL-Not Null Constraint
SQL-Unique Constraint
SQL-Primary Key Constraint
SQL-Foreign Key Constraint
SQL-Check Constraint
SQL Special Operators
SQL-IN Operator
SQL-LIKE Operator
SQL-BETWEEN Operator
SQL Sorting (Order By)
SQL Group By
SQL Aggregate Function
SQL Having
SQL Joins
SQL-Cross Join
SQL-Inner Join
SQL-Left Outer Join
SQL-RIGHT Outer Join
SQL-Self Join
SQL SubQueries
ISQL-Independent Sub Queries
SQL-Correlated Sub Queries
SQL Views
SQL Index
What is RDBMS?
- The standard for relational database management systems (RDBMS)
- A database management system that manages data as a collection of tables in which all relationships are represented by common values in related tables.
- Data in RDBMS is stored and sorted in the form of rows, columns (also called tuples and attribute in the DBMS language).
Difference between DBMS and RDBMS
DBMS | RDBMS |
Data stored as a file. | Data is stored in the form of tables. |
DBMS supports a single user. | RDBMS supports multiple users. |
Data stores either in either a navigational or hierarchical form. | RDBMS uses tabular structures to store data, headers are the column names and the rows contains values. |
The database does not support normalisation. | It supports the normalisation and joining of tables. |
Does not support a distributed database. | Supports a distributed database. |
Does not support client-server architecture. | Support client-server architecture. |
No relationship between the data value | Data relationship with the help of foreign keys |
Low software and hardware | High software and specialised DB hardware |
DBMS was not made to handle a huge amount of data. | RDBMS can actually handle a very high amount of data. |
Lack of security in the DBMS model of storing data, | More security of the data stored as several log files created |
Example-XML,file system, etc. | Example- MYSQL, Oracle, SQL Server, etc |