SQL Tutorial- Inroduction

Hello Everyone, Welcome to my first tutorial on SQL Basics:

This is how I learn while doing practice. It can be easy for you to understand. Hope you like this and the other post related to SQL. I will be using HR schema of Oracle Database in the coming pots.
Happy Learning 😇😇

It's all about data and the way to retrieve , insert, update , delete or do some other operations related data in or from the database. Now question comes what is Data.

DATA:

- Any fact related to an object

SQL:

- STRUCTURED QUERY LANGUAGE
 # Way to access or manage DATA in a relational database.

DRL:

- DATA RETRIEVAL LANG | DATA QUERY LANG
# SELECT

FUNCTIONALITIES OF A SELECT STATEMENT:
************************************
SELECTION => RECORDS OF CHOICE
PROJECTION =>COLUMNS OF CHOICE
JOIN => DATA FROM MULTIPLE TABLE

DML:

- DATA MANIPULATION LANG
# INSERT ,UPDATE,DELETE ,MERGE

TCL:

- TRANSACTION CONTROL LANG
 # COMMIT,ROLLBACK,SAVEPOINT

DDL:

- DATA DEFINITION  LANG
# CREATE ,ALTER,DROP,RENAME,TRUNCATE

DCL:
- DATA CONTROL LANG
# GRANT ,REVOKE


Will learn more in the next blog about DRL or say DQL (i.e. DATA RETRIEVAL LANG | DATA QUERY LANG)