Define SQL and rules of SQL and structure of sql
Answers
SQL
- SQL stands for structured Query Language.
- It is used for storing and managing Data in a relational database system.
- It is a standard language for Relational database.
Some Rules under SQL.
- Structured Query language is not case - sensitive.
- Statements of SQL depends upon number of text lines.
- Using SQL all actions performed on database.
- SQL depends on relations between data.
Structure of SQL working Model
Note - Refer to the attachment for the diagram.
Define SQL
SQL stands for Structured Query Language. SQL is a non-procedrual language computer language, aimed to store, manipulate and query data stored in a relational database and also used to create interface between user and database.
SQL provides variety of tasks such as:
> Querying data
> Creating, replacing, altering and dropping tables.
> Inserting, updating and deleting rows in a table.
> Controlling access to the database.
> Guaranteeing database consistency and integrity.
Rules of SQL commands
i) SQL statements can be typed in lowercase or uppercase letter. SQL statements are not case sensitive.
ii) The statements can be typed in single line or multiple lines.
iii) A semicolon (;) is used to terminate the SQL statements.
iv) The statements may be distributed across the line but keywords cannot be.
v) A comma (,) is used to seperate parameters without a clause.
vi) Characters and date constrants or literals must be enclosed in single quotes ('A').
vii) A command can be typed either full or first four characters.
Diagram:- Refer to the attached diagram above.
please tommorow exam
https://brainly.in/question/33907416?utm_source=android&utm_medium=share&utm_campaign=question