DAY - 10

What is RDBMS?

A database is an organized collection of data stored in a computer system and usually controlled by a database management system (DBMS). The data in common databases is modeled in tables, making querying and processing efficient.

RDBMS stands for Relational Database Management Systems. It is a program that allows us to create, delete, and update a relational database. A Relational Database is a database system that stores and retrieves data in a tabular format organized in the form of rows and columns. It is a smaller subset of DBMS which was designed by E.F Codd in the 1970s. The major DBMSs like SQL, My-SQL, and ORACLE are all based on the principles of relational DBMS.

STEP 1 : Create a database.

STEP 2 : Display the databases.

STEP 3 : Select the database to be used.

STEP 4 : Create a table and give the values.

STEP 5 : Insert the extra values to the table.

STEP 6 : Select all the values from the table.

STEP 7 : Insert more values to the table.

STEP 8 : Select particular sections from the table.

STEP 9 : Select particular sections from the table within a limit.

STEP 10 : Arrange the selected values in ascending or descending order.

STEP 11 : Select the values from table using keyword where.

The value selected is from the country name you have given and % symbol denotes the remaining of the value which starts from the letter given before the % symbol.