SQL Tutorial

SQL is a standard Query language for storing, manipulating and retrieving data in databases.

SQL provides statements for a variety of tasks, including:
-Querying data
-Inserting, updating, and deleting rows in a table
-Creating, replacing, altering, and dropping objects
-Controlling access to the database and its objects
-Guaranteeing database consistency and integrity

Our SQL tutorial will teach you how to use SQL in: Oracle database systems.

SQL Statements: 

Data Manipulation Language (DML):
Fetching data from a database, add new rows, changes existing rows, delete an unwanted row from tables in the databases, respectively. known as Data Manipulation languages (DML)
Statements:
SELECT
INSERT
UPDATE
DELETE
MERGE
Data Definition Language (DDL):
Sets up, changes and removes data structures from tables, known as
data definition languages (DDL)
Statements:
CREATE
ALTER
DROP
RENAME
TRUNCATE
COMMENT

Data Control Language (DCL):
Provides or removes access rights to Oracle Database
Statements :
GRANT
REVOKE

Data Transaction Control (DTC) :
Manages the changes made by DML Statements. Changes to the data can be grouped together into logical transactions.
Statements:
COMMIT
ROLLBACK
SAVEPOINT

Leave a Reply

Your email address will not be published. Required fields are marked *