Beginner SQL
This is the beginner guide to SQL
Now let's not learn the conventional way we were used to be. Assume I have an almirah or a closet so what are the actions I can perform with this system I can put something in the system, I can take something out of the system and change something in the system. I can remove something from the system. So let's understand the above steps in terms of SQL which is a structured query language for the Database.
- we can retrieve data from a database like taking clothes from almirah or closet.
- we can insert records in a database just like putting some clothes in an almirah.
3.we can update the records from the database.
4. we can create new stored procedures in a database.
major commands are SELECT,UPDATE,DELETE,INSERT,WHERE
don’t worry you dont have to memorize any of this consider this as a playing with the new system.
RDBMS: Relational Database Management System:-
Those databases in which we can use SQL to query some operations are under RDBMS such as DB2, Oracle, MySQL, MS SQL.
Data inside the RDBMS is stored in the form of tables.
The table is just a box in which we can put something. So to organize our data we will use tables, so assume we have the table for storing marks of all the students in our class so for that w have the name and respective marks. In this case, the name will be one column and marks will be another column and data will be put in each row.
