Intro to DBMS
--------------
Data Base Management System : Every Website has two parts front end and backend. Front end is something from where user enters or input the data and backend is something where that inputted data is stored.
Now there arw two ways of saving the data in the backend.
1. Unsorted Way : .xml
2. Sorted Way : DBMS
SQL : Structured Query Language: Its a intermediater between front end and back end from where user enters the data and retrieve for the same.
DDL : Data Definition Language : Its a part of SQL which deals in only creating platform on which the future data is going to be saved.
DML : Data Manupulation Langauge : it holds the responsibility of all the saving editing and deleting of the data which is already in the database platform created by DDL.
SQL Basics
----------
1. Insert Query : USed to add something in the database
2. Update Query : Used to Update the database
3. Delete Query : Used to delete the content of the table.
4. Drop Query : USed to Drop the entire table from the database with content.
Order By Cluase : This clause is used to sort the database either in ase or des.
Union Select : Used to execute more than two queries at the same in the database.
--------------
Data Base Management System : Every Website has two parts front end and backend. Front end is something from where user enters or input the data and backend is something where that inputted data is stored.
Now there arw two ways of saving the data in the backend.
1. Unsorted Way : .xml
2. Sorted Way : DBMS
SQL : Structured Query Language: Its a intermediater between front end and back end from where user enters the data and retrieve for the same.
DDL : Data Definition Language : Its a part of SQL which deals in only creating platform on which the future data is going to be saved.
DML : Data Manupulation Langauge : it holds the responsibility of all the saving editing and deleting of the data which is already in the database platform created by DDL.
SQL Basics
----------
1. Insert Query : USed to add something in the database
2. Update Query : Used to Update the database
3. Delete Query : Used to delete the content of the table.
4. Drop Query : USed to Drop the entire table from the database with content.
Order By Cluase : This clause is used to sort the database either in ase or des.
Union Select : Used to execute more than two queries at the same in the database.
No comments:
Post a Comment