SQL Tutorial 5: DDL (Data Definition Language) Commands

[@woodworksgeek]

Pavan = God of Free Education

[@irfandy4hmad]

Shortcut key :
CTRL + ENTER : Execute the current line
CTRL + SHIFT + ENTER : Execute all line

[@baxtables]

thanks bro

[@sourabhdesai4254]

THANKS MAN!

[@sumitgoyal385]

EXCELLENT FOR FIRST TIME CRYSTAL CLEAR DIFFERENCE BETWEEN DROP,DELETE AND TRUNCATE EXCELLENT VIDEO

[@shameemahamad2617]

very nice series of videos for anyone to get good understanding of SQL.

[@sdetpavan]

Thanks

[@basanagoudabiradar8669]

Understandable knowledge for DDL ....👍sir

[@sdetpavan]

Thanks

[@dilliprasad5675]

When i started watching your vedios compleately my brain getting knowledge from this tutorials . any ways thank you very much sir i personally recomended this chanel for 50 members .🙏🙏🙏🙏🙏🙏🙏

[@sdetpavan]

Glad to hear that

[@BhanupriyaSD-w3r]

🎉thanks for this valuable cource

[@sdetpavan]

My pleasure

[@VaraMARVELleader]

Even it is lengthy more informative, thanks for your kind time do videos like this...

[@sdetpavan]

Welcome

[@VaraMARVELleader]

Really Your Presentation is Awesome to listen.

[@sdetpavan]

Thanks

[@allmyfans9782]

Super sir...,,your Explanation....

[@sdetpavan]

Thanks

[@santoshkumar-to7lb]

such a great video and great human being your. thanks for uploading and sharing this information. god bless

[@sdetpavan]

My pleasure

[@twinkleyadav2272]

hello sir
This SQL playlist is superb but i want to know if this is only for testers or there is something different topics for SQL for campus preparation

[@Nikhil-qi4oz]

is this playlist is useful for BigData?

[@reshma1375]

Tnk u sir very informative 👍🏻

[@sdetpavan]

Welcome

[@Eng-Mohamed-Ahmed]

thanks sir you helped more

[@sdetpavan]

It's my pleasure

[@abhinavgarg1988]

I am feeling so lucky to have a teacher like you. Thank you so much for making this informative video ☺️🙏

[@sdetpavan]

Glad to hear that

[@bharathenishetty1550]

Great explanation

[@sdetpavan]

Thanks

[@ukshahrukh]

how to add HR database with all tables?

[@saranyachandrabos3541]

Thank you so much

[@sdetpavan]

Most welcome!

[@Aunestly]

At 14:23 Wondering how you would modify the data type by type if you wanted to change it from a varchar to a integer instead of the size of the data type.

[@shubhamsinha9037]

Hello Sir, your video is so good.
One thing i want to tell that update and delete videos for DML is not there.

[@suhananadaf5993]

Sir, will you provide the dataset so that we can practise

[@romanyakymets738]

Thank you very much!

[@sdetpavan]

welcome

[@DineshKumar-ml2tm]

your videos are really awesome sir, Can anyone tell me in which part the UPDATE CONCEPT is there?

[@NeverStopLearning56]

DML

[@keshavbhagat8318]

Very Very Thank You Sir 🙏

[@sdetpavan]

Most welcome

[@mahamoodulhasanmd4078]

unable to find session on DML.
Kindly share the video of DML

[@muhammadjunaidmajeed1211]

Excellent!

[@dilipkumarp7533]

Thanks sir

[@sdetpavan]

Welcome

[@Imana23]

how do i import the employer datebase to my database? can anybody help?

[@sonamjangbusherpa8018]

thankyou sir

[@sdetpavan]

Welcome

[@nbkmpat]

How to add new values in newly created column

[@villagecookingwithak9724]

Insert

[@Sam-vv1gu]

Using update query bro

[@vishalkoundal5008]

hello sir u mentioned that how to add new column in the table GRADE .....But when I am trying to populate the column .....the query will next execute please help me ........Is it the correct query to update the record of new added column....you also mentioned the same but not run the query ......I am trying to execute but it will run ......
Update table Student set grade='A' where s_id=1;

[@sreejx]

hi Vishal do not use table keyword after update.

[@akkhileshv4323]

@@sreejx 😂

[@revathylakshminarasimhan1141]

Can you please explain how truncate and drop works when autocommit is set to 0?

[@Ajaykumar-hd7dt]

sir while I am deleting data using delete command I am unable to rollback the data as I am using autocommit=0 but it is not effecting could you please help me in this.

[@AbdulHannan-dg6dl]

use this command to insert values.
select all these commands together to commit changes and then follow the same process. I solved my problem through this process.
INSERT INTO STUDENT VALUES (101,'DAVID');
INSERT INTO STUDENT VALUES (102,'SMITH');
INSERT INTO STUDENT VALUES (103,'SCOTT');
COMMIT;
SET SQL_SAFE_UPDATES=0;
SELECT * FROM STUDENT;
DELETE FROM STUDENT;
ROLLBACK;

[@divyaram1237]

that’s really great thank you

[@lalithala4040]

Hi sir i created a table . i got 2 warnings like integer display width is deprecated and will be remove in future release.
and In table values not displayed. please help me on this.

[@akulavenkatesh1587]

problem with integer size

[@divyaram1237]

Still If you face same problem don’t give any number in “INT “

[@chandradeepkumar2038]

Hi sir, How I will get Hr table for practice

[@supriyapawar8417]

Thank you !!

[@sdetpavan]

Welcome

[@akshatan4520]

Just a question for alter command
Add command works with or without () around LastName. but it does not work the same way to Modify?. is there any specific reason.
ALTER table student ADD COLUMN (LastName varchar(10));
ALTER table student ADD COLUMN LastName varchar(10);
ALTER table student MODIFY COLUMN LastName varchar(15); -------->Works
ALTER table student MODIFY COLUMN (LastName varchar(10)); --------> Doesnot work

[@jainhimanshu439]

sir HR ka ye database hmare pas bhi a jaye same . hmare work bench m. to hm ye commands execute kr ke dekh lenge. please help in this.

[@lordkrishna2775]

God bless...

[@sdetpavan]

My pleasure

[@anushasandy]

SIR ANY NOTES AVABLE FOR THIS SERIES?

[@sdetpavan]

www.pavantestingtools.com/p/sql-tutorials.html

[@anushasandy]

@@sdetpavan Thank you sir

[@pegahmoeini1350]

Can you provide the PowerPoint, please?

[@amarnadhreddy9746]

I want your sql ppt sir where can i get it

[@AnilSharma-co6iw]

hello sir ..can you plz share SQL notes?that's really a big help for me.

[@meghashreebhat7596]

ROLLBACK command is not working I tried enabling autocommit =0 and sql safe updates =0 . Still it cannot be rollback. Please help me

[@bharathenishetty1550]

might be you are doing some wrong operatiosn orderwise carefully, do the operations , it will work.

[@retbao]

@@bharathenishetty1550 i faced the same issue. 1-query to check table 2- delete.. 3- rollback 4- query again ==> data is gone

[@payalpatel-ft1df]

DESCRIBE command don't work in bdeaver .. Can anyone please help which command we can use in bdeaver to view table

[@nhjosi8929]

sir i want to start my career in testing please help me please share testing tutorial link

[@chandradeepkumar2038]

while watching video parallelly i want to practice

[@lokeshp1929]

Can anyone help me to get that hr database?

[@lokeshp1929]

That given link doesn't have that database

[@rajivraushan1387]

ALTER TABLE STUDENT CHANGE COLUMN SNAME STUNAME VARCHAR(20);

[@woodworksgeek]

THANK YOU!

[@r.sankaranrajasimhan630]

23:20

[@TimothyPolly]

3318 Witting Dale

[@er.nikhilmehta8367]

Sir in video many times the screen is not visible.

[@amolvijay309]

Kuch bhi🙄