DDL, DML, DCL & TCL statements in SQL (Database basics)

[@SQLwithManoj]

Check this playlist for all videos on DBMS & Database basics: ruclips.net/p/PLU9JMEzjCv176mRCXCCijrA5Jl6c9ihMM !!!

[@anjalikayasth3277]

you are right sir ,but khi khi galat mention h, mene bi website pr hi dekha h

[@jagtarmahal4311]

Sir please share your constant number

[@raoshehroz3823]

thank you sir .

[@farmersons8310]

Yes sir you are right 😍😍

[@imtiaz3114]

0:54 => DDL - Data Definition Language
- CREATE
- ALTER
- DROP
- TRUNCATE TABLE
2:42 => DML - Data Manipulation Language
- SELECT
- INSERT
- UPDATE
- DELETE
- BULK INSERT
- MERGE
5:20 => DCL - Data Control Language
- GRANT
- REVOKE
- EXECUTE AS
- REVERT
7:15 => TCL - Transaction Control Language
- BEGIN TRANSACTION
- COMMIT TRANSACTION
- ROLLBACK TRANSACTION
- SAVE TRANSACTION

[@diyanadiya4905]

Thanks

[@rahulsolanki2004]

Sir, I am from Mexico, currently living in india, your explanation is very good lot of love from mexico....

[@jeffreydrhodes]

Why leave a thumbs down? This video was great!!!

[@habenetsay9448]

I am from ethiopia.thank you for best explanation.

[@marwahassan6119]

I'm from Iraq. Thank u sir for this explaning

[@ezradongijena1772]

helpful actually gng to write my exam in an hour's time..

[@sarikabiwalkar4037]

Nice and easy to understand explanation.

[@sharmiladevi3240]

Thank u Sir🤝

[@tinamclaughlin1991]

You are knowledgeable and explain plainly so I can understand. I want to drive into this! Thanks Manoj!

[@vipnirala]

Worth watching

[@saralamuneender]

Thank you sir

[@bigtechmindset]

Thanks for sharing!

[@ankitsharma5654]

very helpful video

[@alexschmidt4371]

Manoj: "You can drop the views".
RUclips: "If you say so"

[@kss2066]

wonderful class

[@mrigendrapratapsingh7176]

Nice explanation...

[@yadwendraray9522]

Good express

[@Charly77ify]

Ive suscribed, very useful the tutorial, thank you Manoj!

[@santoshitarkewadje1564]

Ty sir..

[@adz9010]

I am from dubai thank you sir f

[@mahanthwarpujaa3762]

thanks sir this is easy to understand everyone

[@eldhoseroy6751]

Helpfull

[@duesalbladesinger7900]

Thank you for your explanations.

[@AkashAkash-jq4kn]

very nice sir

[@nipunsachinda]

much helpfull

[@vit6723]

Thank you manoj from ph

[@wajoofun1181]

great sir G.................????

[@prasannakumarkethi9418]

Nice

[@MomenRashad]

thx ^...^

[@suriya_619]

I am hear for my sem exam🤗😋

[@santoshitarkewadje1564]

Same here 😀

[@kotharavi2516]

Thanks sir

[@kavibritto]

nyc explanation

[@saddaramsubbareddy2949]

It was osmmmmmmm explanation Sir! Thank you Sir......for ur best and detail explanation

[@harishchirati2311]

Thank you sirits good

[@math260879]

make another video please to explain how to use those demonstrated sql statements.

[@math260879]

With sql server or Mysql for ex

[@renukateli60]

nice

[@krishnasagarapusanthoshi8106]

will you please give a detailed information about TCL with examples

[@amitsirauthorandmentormath18]

good

[@samchinedu2635]

Nice one why is truncate And delete different language but does the same function

[@artforpiece]

wonderful !

[@love-sb2zm]

Rakhitha Dassanayake thax

[@kirankumar-fw7wf]

sir explain some examples plzz we know theory but can't understand it so from example we can understand

[@SQLwithManoj]

Sure Kiran, as soon as I get time, will post a video here. Please subscribe and click on the Bell button so that you will get updates from here.

[@sandip5346]

manoj

[@sanjaypranesh7221]

voice is like gvm

[@hemlatalalwani5978]

sir everyone knows theory . explain with same example

[@SQLwithManoj]

Sure Hemlala for your comments, will post new videos with examples :)
Hope you've subscribed !!!

[@Rackerintraining]

Dude, it's an overview and it's free!!!! A little appreciation for the man's generosity and work. There is over 30 videos in this playlist alone, I'm sure there will be plenty of hands on examples

[@anmolshobhitshukla9305]

I read somewhere that select keyword is used in Data query language. So what is right?

[@dvrmurthy001]

SQL for which Database??
Is this for Oracle/DB2 or SQL server??

[@SQLwithManoj]

It's mainly for SQL Server, but all these concepts and most basic queries works for all databases.

[@dvrmurthy001]

@@SQLwithManoj
Thank You Manoj.
Actually, I am an Oracle DBA with more than 10 Years of experience.
Now I am going work as a DB2 DBA also.
Therefore, I need to learn SQL for DB2..
Could you please suggest SQL for DB2 DATABASE.

[@shayari_junction_6824]

in a transaction either all the SQL statement be committed or all rolled back
sir please described that statement .

[@ManojPandeyManub22]

For ex: below we are binding 3 inserts in a single transaction by providing BEGIN-COMMIT block:
BEGIN TRAN
insert row 1
insert row 2
insert row 3
COMMIT TRAN
... here if 2nd insert fails, the 1st insert will also rollback and 3rd insert won't happen.
But if you don't apply BEGIN-COMMIT block, all 3 inserts will behave as 3 independent transactions.
Hope this helps :)

[@sonamnandal8257]

sir ..what is the difference between alter command and update command?

[@ManojPandeyManub22]

ALTER command is used to change the TABLE schema, like add/remove a column, thus its DDL.
UPDATE command is used to change the value of row/column in a table, thus its DML.

[@sonamnandal8257]

thank u sir .. well explained

[@manojk.v]

Are you b c a student

[@AMJADALI-lj3yo]

What is the difference between MySQL T SQL and No SQL and pl SQL ?????

[@SQLwithManoj]

check here: sqlwithmanoj.com/2015/05/03/what-is-sql-plsql-t-sql-and-difference-between-them/

[@vela8909]

From American College

[@sarojbehera8495]

sir explain with project

[@SQLwithManoj]

sure, I'm planning to create a separate video on each of these, please stay tuned.

[@krasimirarsov9992]

Damn, I hate the Indian pronunciation and i usually click away, but this a very good explanation of the SQL language. Thank you!

[@SQLwithManoj]

thanks Krasimir !!!

[@jaysanghavi8248]

You hate ? Does anyone give a damn!😂

[@tarunchauhan794]

Sir everyone knows this all function so plz explain example

[@jamaicalajot5360]

sir is that the 4 syntactical veriance of SQL??

[@ramrackzz7773]

sir, please explain any project

[@Subho1919]

May be you missed "Save Point" in TCL statement list.

[@KuliJens]

It's there.

[@adarilokesh7196]

plz send ...mechanical engineering link ..all subjects....

[@jetendrajha7055]

How to alter and update table

[@aneeszaide9270]

Why like command is case sensitive

[@SQLwithManoj]

SQL commands are no case sensitive, its your data that is, which is defined by using collation settings while creating table/columns.

[@ajrkhan258]

what is the DRL

[@Sentaur-qd8im]

Why didn't you tell us about data selection, query language DQL?... DQL - it includes only one SELECT command.

[@sasiprakash888]

Voice is low

[@anjalikayasth3277]

tcl me revoke and grant aata h, aapne ulta bol diya check kro sir

[@SQLwithManoj]

GRANK & REVOKE fall under DCL, not TCL, check here: en.wikipedia.org/wiki/Data_control_language

[@zebenebekele2118]

10Q

[@vikrambehera7195]

What is data querry language (dql) sir?

[@vikrambehera7195]

You haven't described in your video

[@Nk_Pandey]

Select is dql not dml stammt.data query language

[@SQLwithManoj]

for correct info check here: www.w3schools.in/mysql/ddl-dml-dcl/

[@aneeszaide9270]

Plz anyone tell me on thing
If the IN commands have 1 lakh values then what will do ..????

[@SQLwithManoj]

As your SELECT statement within IN() clause is returning 1 lack rows, you should try converting it to EXISTS() clause of JOIN, should work better.

[@mynameissaipratyush]

Manoj Engineer

[@jennig.8537]

+10 lince :'v

[@DevRaj-fk6xx]

Select -DQL

[@SQLwithManoj]

DQL (Data Query Lang) or DRL (Data Retrival Lang) is a subset of DML, and there is no official reference of these subtypes. Officially SELECT stmt is a DML, check here: docs.microsoft.com/en-us/sql/t-sql/queries/queries

[@poojawaghmare5563]

sir usko samjakar batiye hindi me

[@SQLwithManoj]

Pooja, sorry will have to record another video for Hindi. I've put this in simple english, please slow the speed of video from RUclips bar.

[@RajatSeth6911]

Where is DQL

[@SQLwithManoj]

DQL as such is nothing, but the SELECT statement, and you can consider it as part of DML itself.

[@RajatSeth6911]

Fine sir

[@keshavgupta8361]

Sound is very low

[@SQLwithManoj]

sorry Keshav for that. Plz try to increase volume from your system tray.

[@nakulgunjiyal4876]

DCL is dharchual not data control Language ok

[@SQLwithManoj]

what's dharchual ?

[@saivygandhi9660]

give some examples.. don't repeat the theory sir

[@SQLwithManoj]

sure, plz wait for my next video on this. Subscribe and you will get an email.

[@KingDriftOriginals]

Bro speak it as S Q L NOT sequel

[@firasal-mahrouqi1059]

It's commonly referred to as sequel by nearly everyone.

[@KingDriftOriginals]

@@firasal-mahrouqi1059 may bee

[@Getaneh188]

@@KingDriftOriginals you can call it both ways.

[@KingDriftOriginals]

Nope

[@Getaneh188]

@@KingDriftOriginals Google it man

[@flashx2630]

Bhai koi Hind ku nahi bolta hai

[@SQLwithManoj]

ok, will create some videos in Hindi :)

[@BossManTee]

Marry me

[@pavi_thra_gowda]

haha..mechanical student spotted

[@soumadykumaran7149]

🤢

[@AkshayAjith-nc8zw]

Thank you sir

[@harshdeepsingh9737]

very nice sir

[@balajiks6123]

Thanks you sir

[@vanaja1498]

Thank you sir