What is SQL? Uses of SQL

Поделиться
HTML-код
  • Опубликовано: 20 фев 2024
  • Structured Query Language
    Uses of SQL
    Data definition: It is used to define the structure and organization of the stored data and the relationships among the stored data items.
    Data retrieval: SQL can also be used for data retrieval.
    Data manipulation: If the user wants to add new data, remove data, or modifying in existing data then SQL provides this facility also.
    Access control: SQL can be used to restrict a user’s ability to retrieve, add, and modify data, protecting stored data against unauthorized access.
    Data sharing: SQL is used to coordinate data sharing by concurrent users, ensuring that changes made by one user do not inadvertently wipe out changes made at nearly the same time by another user.
    A ‘;’ is used to end SQL statements.
    Statements may be split across lines, but keywords may not.
    Identifiers, operator names, and literals are separated by one or more spaces or other delimiters.
    A comma (,) separates parameters without a clause.
    A space separates a clause.
    Reserved words cannot be used as identifiers unless enclosed with double quotes.
    Identifiers can contain up to 30 characters.
    Identifiers must start with an alphabetic character.
    Characters and date literals must be enclosed within single quotes.
    Numeric literals can be represented by simple values.
    Comments may be enclosed between /* and */ symbols and maybe multi-line.

Комментарии •