oracle interview question - What is SQL, What are the types of SQL statements

-----------------------------------------------------------------------------------------------------------

SQL stands for Structured query language,
In simpler terms it’s the way to communicate with the database, what I mean by communication here is , any instruction we want to give to database would be through SQL.

So, these instructions are nothing but commands or statements in SQL.

For instance, if you want to store some new data into database, then you need to use "INSERT" statement. similarly if you want to remove some data, then you need to use "DELETE" statement.

Depends on the functionality of these instructions or statements, the SQL statements are broadly classified into five sub categories, or five SUB SQL languages as given below,

DDL ( Data Definition Language )
DML ( Data manipulation Language )
DCL ( Data Control language )
TCL ( Transaction Control Language )
DRL ( Data Retrieval Language )

These language are classified based on the core functionality they perform, Given below commands for each language.

DDL – CREATE, ALTER, DROP, TRUNCATE
DML – INSERT, UPDATE, DELETE
DCL – GRANT, REVOKE
TCL – COMMIT, ROLLBACK, SAVEPOINT
DRL – SELECT

[vivektarab]

Start

0:31 - What is SQL

1:43 - What do you mean by communicating a Database

2:29 - There are Types of Sql

3:24 - DDL

4:40 - Truncate

4:59 - DML

5:36 - DCL

6:16 - TCL

6:49 - DRL

7:53 - Some More Languages

1:19 - Some queries Examples

2:44 - Using Distinct Keyword

2:54 - With Unique Keyword

3:11 - Using Group by

4:11 - Using Union

5:19 - Union with Nulls

6:13 - Using Intersect Operator

6:35 - Using Minus Operator

7:11 - Using Row_Number ()

7:55 - Using Rank or DenseRank

8:31 - Two more ways - One is Using RowID - Using Subquery

8:53 - Using RowID with Corelated Subquery

9:11 - Recap all these Queries

[DebakinandanMaharana]

Hello sir, mera ajj computer practical exam me bahut kharab hua agar mene pehele se hi apki ye video dekhlihoti to ajj ye Nehi hota 😔😔😔

[vivektarab]

0:30 - What is SQL

1:43 - What do you mean by communicating a Database

2:39 - There are Types of Sql

3:24 - DDL

4:40 - Truncate

4:59 - DML

5:36 - DCL

6:16 - TCL

6:49 - DRL

7:53 - Some More Languages

[kanchanadevi]

Practical eg for session control and system control plz

[hc]

I /we've always taught in schools and old oracle videos/tutorials/books that Select is part of DML statements. DRL/DQL is new for me. But in official oracle website, I can't found DRL/DQL definition or they made a page/topic about this..

[bharathipandian]

Siva, so tcl is applicable only for Dm statements?

[viswanathans]

Very Very Useful videos !!! Thanks for your videos

[harshmittal]

very nice video its information is precise and accurate

[kalpeshpatil]

Can you please make a video on regular expression and type of regular expression with small example in easy way to get it understand.
It will be very thankful, if you make video on this.
Thanks in advance cheers.

[avitpatil]

SIR, BUT DRL isn't an official term commonly recognized like DDL, DML, DCL, and TCL CORRECT ?

[andrewpullins]

If I could make a suggestion. I think it would be better if these videos were titled [what I will learn], Oracle interview questions. So for example this video should be called "What are the types of SQL Statements, Oracle Interview Questions" this way when I am reading the title of the video on YouTube the most important aspect of the video can be understood right away and that is what will I learn from watching this video.

[sunithasunitha]

Hii sir good evening, sir I want to some clarification what about the data query language this have four statements how to use in real life

[shaikrasheed]

I have one doubt sir!! Is sql compiled or interpreted??
Is plsql anonymous blocks are precompiled or compiled??

[royaljd]

The way of ur explaining is very good, but ur voice is some low can't hear properly bro.

[kishorekumar]

Hi Siva, to Rename any table we will use RENAME command, under which category it will come ? Along with ALTER we can use RENAME, So categorie RENAME command ?

[kishorekishan]

I have a query
"Can we delete duplicate rows in the table by using primary key?"

[majedaarmaddy]

please provide an example of merge statement, i have been asked questions on merge twice

[devilsgaming]

Sir I want learn PL/SQL from beginning is there any recorded videos so that I can buy

[kondareddy]

Hi Siva, Good evening. Could please post a video on basic, regularly used Unix commands by an Oracle SQL, plsql developer.
2. Also on the tools used by a SQL or PLSQL developer.

[srjjsr]

I'm unable to remember in my mind.while giving interview I'm unable fetch from my mind