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

Подписаться 14 тыс.

Просмотров 83 тыс.

50% 1

Welcome guys! I'm CA and in this video I'll explain in detail the Data Definition Language (DDL) and the different commands in DDL which are CREATE, ALTER, DROP, RENAME and TRUNCATE. Watch this video till end and let's get started!
NOTE:- I'LL EXPLAIN THE PROCESS OF CREATING A TABLE AND A DATABASE IN DETAIL AFTER THE COMPLETION OF THEORETICAL CONCEPT OF SQL, SO DON'T WORRY ABOUT IT AND JUST FOCUS ON THE THEORY FOR NOW.!!
Important links:-
Install MySQL :- • How to Install the lat...
Previous Video (#1. Basic Concepts):- • 1. Basic concept of SQ...
Next Video (#3. SQL Data Types) :- • 3. What are SQL Data T...

Опубликовано:

19 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии

@bighitintern1628 2 года назад

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 2 года назад

Thank you so much!🙂❤

@chngdexter2008 5 месяцев назад

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

@EverythingComputerized 4 месяца назад

Thanks buddy😄

@kamarulidzadbinabdaziz4945 3 года назад

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

@EverythingComputerized 3 года назад

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. ❣

@studiousartre9635 Год назад

You are a lifesaver for my 11th standard IP journey.

@EverythingComputerized Год назад

😇❤️

@rohan5618 2 года назад

Your explanation is perfect for me ♥️

@EverythingComputerized 2 года назад

Happy to know that❤

@sherisaikumar7047 2 года назад

U r really better than my lecturer ❤️

@EverythingComputerized 2 года назад

😅thank you!

@malwalsabino519 Год назад

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

@EverythingComputerized Год назад

Thank you 😊

@alifiyasayyed51 3 года назад

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

@EverythingComputerized 3 года назад

🙌🙌😀❤

@Somayssc57 3 года назад

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

@EverythingComputerized 3 года назад

🙂🙌

@codewithwaqas5862 2 года назад

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

@EverythingComputerized 2 года назад

Thank you brother!

@hyperphenomenal4360 2 года назад

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

@EverythingComputerized 2 года назад

Yea sure! I'll surely plan on that!

@johnanih56 2 года назад

Excellent delivery!

@EverythingComputerized 2 года назад

Thanks man!

@NikhilKumar-xq9tz 4 года назад

Mast hai content aur information keep it up👌🏻

@EverythingComputerized 4 года назад

Thanks bhai😊😊

@learntolead6250 3 года назад

Thank you so much!! Hanastly understandable

@EverythingComputerized 3 года назад

❤

@25_madargisoumyachandrayya81 2 года назад

THIS VIDEO SAVED ME , THANKS ALOT : )

@EverythingComputerized 2 года назад

😄❤

@abdulfaridbaisulrahuman3640 Год назад

Nice teaching I like you

@EverythingComputerized Год назад

Thankyou!

@kartheekkartheek8212 2 года назад

Well explanation brother ☺️ tq

@EverythingComputerized 2 года назад

😄❤

@allaboutit-4023 2 года назад

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

@EverythingComputerized 2 года назад

Thank you!😊

@chetnakumari8277 Год назад

best video....thanku so much sir

@EverythingComputerized Год назад

😃🙂

@varunmainkar1067 Год назад

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

@EverythingComputerized Год назад

😃♥️

@balakrishnabi7450 2 года назад

your flow is excellent bro....

@EverythingComputerized 2 года назад

Thanks for compliment buddy❤

@virajpatil7121 3 года назад

Sir you teaching us very well thanks sir

@EverythingComputerized 3 года назад

Thank you so much for the compliment 😊💗

@sudeshnasart3019 10 месяцев назад

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

@thorodinson6625 2 года назад

This is really awesome.

@EverythingComputerized 2 года назад

Thanks😃

@KiranDevi-en1xe 3 года назад

Thank u sir it's help me a lot

@EverythingComputerized 3 года назад

🙂❤

@umaghayathrii1759 Год назад

Thank you sir☺

@EverythingComputerized Год назад

😇

@sujatakshetri2871 2 года назад

Thank you so much sir ☺️🤩

@EverythingComputerized 2 года назад

Most welcome!

@vidyasagar4049 3 года назад

Superb explanation bro

@EverythingComputerized 3 года назад

Thanks bro🤟

@jamseerpv460 4 года назад

Clear thank you 🙏💕

@EverythingComputerized 4 года назад

Most welcome buddy🤗❤

@amittandulkar Год назад

Thank you bro♥️

@EverythingComputerized Год назад

😇

@sharlynfarrahdsouza3072 3 года назад

Thank you😁

@EverythingComputerized 3 года назад

Welcome😁

@SinvulaSaboi 3 месяца назад

10/10

@Rekha-gl6db 2 года назад

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 2 года назад

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 3 года назад

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

@EverythingComputerized 3 года назад

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 3 года назад

Thanx u very much🔥🔥

@EverythingComputerized 3 года назад

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

@siddhkaps9952 4 года назад

you should give the syntax notes after video

@EverythingComputerized 4 года назад

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 4 года назад

@@EverythingComputerized thank you bro and you explained very nicely

@EverythingComputerized 4 года назад

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

@BTsArmy-bj3mv 2 года назад

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

@EverythingComputerized 2 года назад

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 2 года назад

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

@EverythingComputerized 2 года назад

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

@rraju9888 2 года назад

How to add column before another column ????

@EverythingComputerized 2 года назад

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 2 года назад

@@EverythingComputerized thank you so much♥️

@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