Full form of SQL is Structured Query Language.
It is language that is created to manage the data. Data may be person name, person address, person full detail or it may be about any products. Data is a row material can be anything whatever you can think.
When data is represent in form of useful data known as Information.
Data need to get, add, update and delete means manage the data. SQL is a Language that use to manage the data.
There is a proper way to add, updated, delete and get the data & we have to followed all the stuff.
All data placed in one place so that we can mange known as database.
Suppose we are ask to create a databases to manage the employees in company "abccompany".
Following are the operators which is used in SQL
It is language that is created to manage the data. Data may be person name, person address, person full detail or it may be about any products. Data is a row material can be anything whatever you can think.
When data is represent in form of useful data known as Information.
Data need to get, add, update and delete means manage the data. SQL is a Language that use to manage the data.
There is a proper way to add, updated, delete and get the data & we have to followed all the stuff.
All data placed in one place so that we can mange known as database.
Suppose we are ask to create a databases to manage the employees in company "abccompany".
- Create a database name eg abccompany
- Create different tables like employees, emp_accounts, emp_leaves, emp_holidays etc.
- Place data according to table.
Following are the operators which is used in SQL
| Operator | Description |
| = | Equal |
| <> or != | Not equal |
| > | Greater than |
| < | Less than |
| >= | Greater than or equal |
| <= | Less than or equal |
| BETWEEN | Between an inclusive range |
| LIKE | Search for a pattern |
| IN | To specify multiple possible values for a column |
No comments:
Post a Comment