2. What is Data Definition Language? Use of CREATE, ALTER, DROP, RENAME and TRUNCATE Commands.

[@bighitintern1628]

I will recommend ur channel to my other mates. Damn ur explanation is so clear and precise that too in a short period of time. Really ur efforts means a lot ❣️

[@EverythingComputerized]

Thank you so much!🙂❤

[@kawaii_hk]

Your presentation is so clear and easy to understand. Thank you for the EXTRA study material I needed for class. EXTRA GOOD.

[@EverythingComputerized]

You're very welcome!

[@chngdexter2008]

As a newbie to SQL and coding, this is the best and clearest video I have ever watched so far. Thanks!

[@EverythingComputerized]

Thanks buddy😄

[@kamarulidzadbinabdaziz4945]

hi im from malaysia.U explain better than my lecturer.I can understand DDL now.Thankyou so much brooo!

[@EverythingComputerized]

Glad to hear that buddy! Wish you all the best!

[@georgeriser2352]

THIS IS EXACTLY WHAT I NEEDED FOR ME TO GET A HOLD OF DATABASE BASICS. ❣

[@sherisaikumar7047]

U r really better than my lecturer ❤️

[@EverythingComputerized]

😅thank you!

[@rohan5618]

Your explanation is perfect for me ♥️

[@EverythingComputerized]

Happy to know that❤

[@malwalsabino519]

Very clear explanation and easy to understand. This tutorial helped me alot. Big like

[@EverythingComputerized]

Thank you 😊

[@johnanih56]

Excellent delivery!

[@EverythingComputerized]

Thanks man!

[@varunmainkar1067]

Best explanatory videos.. Thank you so much!! :)

[@EverythingComputerized]

😃♥️

[@25_madargisoumyachandrayya81]

THIS VIDEO SAVED ME , THANKS ALOT : )

[@EverythingComputerized]

😄❤

[@Somayssc57]

Explanation is imagine sir.👍👍👍👌👌👌👌

[@EverythingComputerized]

🙂🙌

[@NikhilKumar-xq9tz]

Mast hai content aur information keep it up👌🏻

[@EverythingComputerized]

Thanks bhai😊😊

[@alifiyasayyed51]

Thank you very much sir this video is very helpful for me🙂 nd your explanation is very best👍 I can understand DDL now.

[@EverythingComputerized]

🙌🙌😀❤

[@codewithwaqas5862]

Your channel name is so amazing and also your teaching methods thanks

[@EverythingComputerized]

Thank you brother!

[@hyperphenomenal4360]

extraordinary teaching, keep going, make tutorials on java and c programming also

[@EverythingComputerized]

Yea sure! I'll surely plan on that!

[@chetnakumari8277]

best video....thanku so much sir

[@EverythingComputerized]

😃🙂

[@balakrishnabi7450]

your flow is excellent bro....

[@EverythingComputerized]

Thanks for compliment buddy❤

[@virajpatil7121]

Sir you teaching us very well thanks sir

[@EverythingComputerized]

Thank you so much for the compliment 😊💗

[@kartheekkartheek8212]

Well explanation brother ☺️ tq

[@EverythingComputerized]

😄❤

[@sudeshnasart3019]

Thank you thank you so much.....😢

[@learntolead6250]

Thank you so much!! Hanastly understandable

[@EverythingComputerized]

❤

[@abdulfaridbaisulrahuman3640]

Nice teaching I like you

[@EverythingComputerized]

Thankyou!

[@thorodinson6625]

This is really awesome.

[@EverythingComputerized]

Thanks😃

[@amittandulkar]

Thank you bro♥️

[@EverythingComputerized]

😇

[@sujatakshetri2871]

Thank you so much sir ☺️🤩

[@EverythingComputerized]

Most welcome!

[@vidyasagar4049]

Superb explanation bro

[@EverythingComputerized]

Thanks bro🤟

[@allaboutit-4023]

Your explanation is awesome... Subscribed ur channel with a lot of love and thnx🥰

[@EverythingComputerized]

Thank you!😊

[@umaghayathrii1759]

Thank you sir☺

[@EverythingComputerized]

😇

[@KiranDevi-en1xe]

Thank u sir it's help me a lot

[@EverythingComputerized]

🙂❤

[@jamseerpv460]

Clear thank you 🙏💕

[@EverythingComputerized]

Most welcome buddy🤗❤

[@sharlynfarrahdsouza3072]

Thank you😁

[@EverythingComputerized]

Welcome😁

[@Rekha-gl6db]

in my sql application we can create database in a large volume .sql is dbms and query language where we can do crud operations am i correct?

[@EverythingComputerized]

Dbms is the application that is used to do CRUD operations on databases.. sql is just a query language.. u can think it of as a way to use dbms..

[@abdheshkumar249]

Retrieve all the records from table plz bata dijiye kaise command likhe ge plz 😥😥😥

[@EverythingComputerized]

Watch my latest vdo... its on DQL and SELECT Command.. you can also have a look at DML vdo.. I have given a brief there, but I have explained your doubts in complete detail in my latest vdo on DQL.. Hope you are helped🙂

[@abdheshkumar249]

Thanx u very much🔥🔥

[@EverythingComputerized]

U r most welcome🙂 And all the best for your exams if you are giving one.🙋‍♂️

[@sonal008]

Drop and Delete are different??

[@EverythingComputerized]

The DELETE command deletes one or more existing records from the table in the database. The DROP Command drops the complete table from the database. Source: scaler.com

[@rraju9888]

How to add column before another column ????

[@EverythingComputerized]

In MySQL there's no method for BEFORE a column. But the same behaviour can be achieved by adding AFTER a column. To add a column_2 just after column_1: ALTER TABLE table_name ADD COLUMN column_2 VARCHAR(30) AFTER column_1; To add a column_1 at first in the table: ALTER TABLE table_name ADD column_1 VARCHAR(30) FIRST; Note: u can change VARCHAR to any data type of your choice! So be flexible in modifying the above syntaxes.

[@rraju9888]

@@EverythingComputerized thank you so much♥️

[@BTsArmy-bj3mv]

Sir can you make a program so that we can understand how syntax works

[@EverythingComputerized]

I've already shown the practical implementation after the theory part in all the videos. For more detailed concept, follow the SQL playlist on my channel. For SQL programming part, follow up the *Problem solving* videos on the playlist.

[@BTsArmy-bj3mv]

@@EverythingComputerized so sorry for this comment and you are really good mentor can you make videos on python

[@EverythingComputerized]

No need to be sorry buddy! I'm planning on it.. it will be uploaded soon!

[@SinvulaSaboi]

10/10

[@siddhkaps9952]

you should give the syntax notes after video

[@EverythingComputerized]

I made this tutorial keeping school students in mind, so i assumed that viewers has a book. If you are facing problems, I'll try to include the best notes for the concerned video. Thanks for your feedback!

[@siddhkaps9952]

@@EverythingComputerized thank you bro and you explained very nicely

[@EverythingComputerized]

Nice to hear that my efforts are fruitful! Thank you so much for support❤❤