Database Management System | Lecture 2 | Basic SQL Queries (operations on tables) | The Sudoers Clu

DBMS stands for Database Management System. We can break it like this DBMS = Database + Management System. Database is a collection of data and Management System is a set of programs to store and retrieve those data. Based on this we can define DBMS like this: DBMS is a collection of inter-related data and set of programs to store & access those data in an easy and effective manner.

A database management system (DBMS) refers to the technology for creating and managing databases. DBMS is a software tool to organise (create, retrieve, update, and manage) data in a database.

This video covers some of the basic SQL Queries to perform basic operations on tables.

Topics Covered;
1. How to Create a table
2. How to insert data into a table
3. How to display a table data, display data conditionally
3. How to update data in a table
4. How to delete data in a tale
5. How to alter a table (add, drop, modify, rename)

1. Create a database
CREATE DATABASE {database_name};

2. Use a database
USE {database_name};

3. Create a table
CREATE TABLE {table_name}({column_1} {column_1_Data_Type}, {column_2} {column_2_Data_Type});

4. Insert a data(row) in a table
INSERT INTO {table_name} VALUES({value_of_column_1}, {value_of_column_2});

5. Display a table data
SELECT * from {table_name};

5. Delete data (row) in a table
DELETE FROM {table_name} WHERE {column_name}={column_value};

6. Update table data
UPDATE {table_name} SET {column_name}={new_column_value} WHERE {column_name}={old_column_value};

7. Add new column in a table
ALTER TABLE {table_name} add {column_name} {column_data_type};

8. Remove column from a table
ALTER TABLE {table_name} drop {column_name};

9. Change data type of a column
ALTER TABLE {table_name} MODIFY {column_name} {new_column_data_type};

10. Rename a column.
ALTER TABLE {table_name} RENAME COLUMN {old_column_name} TO {new_column_name};

----~----

website - https://thesudoersclub.github.io

The Sudoers Club | Projects -
Masterkey - https://thesudoersclub.github.io/projects/masterkey
LocalServer - https://github.com/TheSudoersClub/LocalServer

#thesudoersclub #database #dbms #sql