What is Database ?
SQL Tutorial :Database Is Collection of Information or Collection of Organized data and Collection of multiple tables
A database contains one or more tables. Each table is identified by a name for Example Customers or Orders etc. and that Tables contain records in the form of Rows and Columns.
What is SQL ?
SQL Tutorial SQL Stands For Structured Query Language. SQL is a language that is used to Manipulate ,Extract and Manage relational databases and perform various operations on the data.
SQL is Used To Access and Manipulation of Database. SQL is used to communicate with a database.
What is RDBMS
RDBMS stands for Relational Database Management System.
RDBMS is a program used to maintain a relational database
RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.
SQL Tutorial –Types Of SQL Command
DDL – Data Definition Language.
DML – Data Manipulation Language.
DCL – Data Control Language.
TCL – Transaction Control Language
DQL – Data Query Language.
Let us see SQL Command in Details
DDL
CREATE: Create command is used to create the database or its objects (like table, index, function, views, store procedure, and triggers).
DROP: Drop command is used to delete objects from the database.
ALTER: Alter is used to alter the structure of the database.
TRUNCATE: Truncate is used to remove all records from a table, including all spaces allocated for the records are removed.
COMMENT: Comment is used to add comments to the data dictionary.
RENAME: Rename is used to rename an object existing in the database.
DML
INSERT : Insert is used to insert data into a table.
UPDATE: Update is used to update existing data within a table.
DELETE : Delete is used to delete records from a database table.
LOCK: LOCK is used for Table control concurrency.
CALL: It is used to Call a PL/SQL or JAVA subprogram.
EXPLAIN PLAN: It is used to describes the access path to data.
TCL
COMMIT: It Commits a Transaction.
ROLLBACK: It Rollbacks a transaction in case of any error occurs.
SAVEPOINT: It Sets a save point within a transaction.
SET TRANSACTION: It Specifies characteristics for the transaction.
DCL
GRANT: Grant command gives users access privileges to the database.
REVOKE: Revoke command withdraws the user’s access privileges given by using the GRANT command.
DQL
SELECT: Select Statement is used to retrieve data from the database.
SQL Commands in Details
https://govtyojnaa.in