Lec-124: CREATE Command (DDL) in SQL with Implementation on ORACLE

👉Subscribe to our new channel: / @varunainashots
► Structured Query Language (SQL)(Complete Playlist):
• Structured Query Langu...
Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
• Design and Analysis of...
►Computer Architecture (Complete Playlist):
• Computer Organization ...
► Theory of Computation
• TOC(Theory of Computat...
►Artificial Intelligence:
• Artificial Intelligenc...
►Computer Networks (Complete Playlist):
• Computer Networks (Com...
►Operating System:
• Operating System (Comp...
►Database Management System(Complete Playlist):
• DBMS (Database Managem...
►Discrete Mathematics:
• Discrete Mathematics
►Compiler Design:
• Compiler Design (Compl...
►Number System:
• Number system
►Cloud Computing & BIG Data:
• Cloud Computing & BIG ...
►Software Engineering:
• Software Engineering
►Data Structure:
• Data Structure
►Graph Theory:
• Graph Theory
►Programming in C:
• C Programming
►Digital Logic:
• Digital Logic (Complet...
---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
► Subscribe to us on TH-cam: / gatesmashers
►Subscribe to our new channel: / @varunainashots
► Like our page on Facebook: / gatesmashers
► Follow us on Instagram: / gate.smashers
► Follow us on Instagram: / varunainashots
► Follow us on Telegram: t.me/gatesmash...
► Follow us on Threads: www.threads.ne...
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:
Email us at: [e-mail]
#SQL#implementation#DDLCommands

[@nikhatparvin2778]

You are the best teacher I have ever found in online learning ....thank you so much for giving your best to us .......

[@ShubhamKumar-bn1do]

Your teaching style is engaging, and you have a remarkable ability to explain complex topics in a way that is easy to understand. Your enthusiasm for the subject matter is contagious, and it has truly inspired me to develop a deeper interest in the subject. Your patience, encouragement, and willingness to help your students succeed have made a significant difference in my learning journey.

[@GateSmashers]

Wow, thank you!

[@rohanchakraborty9997]

Sir this video is not included in your DBMS playlist. Please include it for the students who are following the playlist. Thank you for all your videos, Sir.

[@faiz_fictions]

Exactly

[@amrishmittal8014]

Rohan is there any other video related to sql which is not included in the playlist??

[@ankitmehta4133]

yes

[@togetherwithmri]

@@amrishmittal8014 Is there...?

[@itz_contender3091]

@@togetherwithmri aree bhai woh yes bolra hai mtlb ki woh sehmat hai ky bro

[@user-jm9nd7tg2b]

Sir, please include this video in your playlist by putting no. 51 part 2 if no. is the problem, (it would be extremely helpful for souls following ur playlist )
thank you so much for amazing content like this. U r one of the Greatest Teacher I ever came across on TH-cam. helping me clear my Engineering in a brighter way .😊😌🙌

[@sainisaab352]

Thanks sir with help of videos i am prepare full syllabus of me only in one day and obtain 38 marks out of 40.

[@GateSmashers]

Wow..God bless you..Thanks a lot Sapna

[@tharkaprasad4042]

Juth boltha hain bandar

[@itz_contender3091]

@@GateSmashers yeh bhi mera dost hai isko -38 mila hai

[@RajVeer-vlog8]

Great work, you do!
It would help in my upcoming interviews/tests

[@thepunekarvlogs]

Thank you so much sir...You are making videos on SQL ...🙏 I requested you for this earlier ...Thanks for taking the request into consideration..!

[@poonamdhadekar3861]

Tq very much sir Maine online course Liya hai ......thy didn't taught like how easy u are teaching tq very much sir 🙏

[@shalinimishra3805]

Thanks a lot sir....I've been watching ur videos since last 6 months..nd guess what..I've scored 9.2 cgpa in my university exams as well as preparing good for Gate 2021..Ur works are really appreciative...🙏🙏

[@GateSmashers]

Ohh wow..congrats..all the best for gate 21. Lots of blessings

[@shalinimishra3805]

Thanks again Sir

[@itz_contender3091]

@@GateSmashers woh jhut bolra hai aur aap sabasi dereho woh mera dostt hai gawar ko 6.1 mila hai

[@bhoomikaagrawal11diamond17]

thankyou you so much sir. This has really helped me in the pre-boards practical preparation.

[@manojthakur6745]

Thanks sir, your teaching style so easy, thanks a lot for your effort

[@mounimounika9438]

Thank you so much sir , the way u are explaining really awesome and I liked it. Moreover your videos helped me a lot for the interviews

[@maheshlal2061]

Sir jesa aap padte ho phle theory and then practical this is unique

[@maheshsawase367]

You are very very best teaching.I like it sir.

[@kapilalaghule]

Thank you so much ❤️ helpful rha

[@ZohaibRajpootFromSheikhupura]

Love from Pakistan 🇵🇰❤️
Good work sir 😊

[@ForgetThings]

Hi Please set all videos in Ascending order for find right video in right time. So we can easily Learn the things. I appreciate your efforts Thanks.

[@Spoorti123-r4w]

Thank u so much sir u explained very well n plz upload more videos for UGC net ke liye

[@user-nb9jb2sy4s]

Sir you thank-you so much ❤❤ itna good studies karne ke liye 🎉

[@AimNoor-xx7ek]

thank you sir ma phly bohat confuse thi ab smj aa gai

[@maheshsawase367]

I like it your teaching.u are best teacher

[@sajansekhu8785]

thnkk u so much sir ji...God bless u forever ji..🙏🙏🙏🙏🙏🙏

[@rounak3239]

Gurujee jabardast shandar zindabaad

[@lepakshirh7419]

Nice explanation sir keep teaching us tq so much for the lessons 🤝

[@imrohit2611]

Add this video in the playlist of DBMS.

[@sachinbhosale2736]

ReaLLY VERY uSEFULL video for begginers!!

[@i_ajeet_mathur]

Very Helpful Video Sir Thanku 🤗

[@mahesh3886]

Thank you sir, your videos are awesome. Its understandable with ur practical explanation...But I don't know hindi, please teach in english...

[@Omniscient_Cricket]

Demonstration on the software was like iceing on the cake 👍😂

[@anitasingh4537]

Good explanation

[@13shaunkijatt55]

Bhut achi v,.. h concept clear ho gya

[@snappyupdates]

Thanks sir it really helps me...🙏

[@faiz_fictions]

How many differences between mysql and Oracle in form of syntax???

[@GeerishaAcharya]

शुक्रिया सर जी..🙏🙏

[@mayuripopat2758]

Awesome videos

[@ripunjoysahariah9634]

This video is not in DBMS playlist .....Sir please include it soon . ....tq

[@Rohit_sharma_03787]

Sir ye video DBMS ki Playlist me daal dijiye please 🙏

[@akbarahmad5245]

thankyou so much sir for putting your efforts for us. please provide us the link for Oracle installation.

[@MandeepSingh-yn3mm]

Awesome explanation 👌👌

[@himanshujawharani7871]

Very nice explanation sir......

[@krishma94]

Hy Sir..
As soon as possible Codd rules pr bhi ek video bna dijiye Sir plzz.. bcz it's part of syllabus of NTA NET.

[@shivaclasses1683]

Ty sir
Plz make a video for TOC

[@susmitasengupta3362]

U r the best teacher ...

[@siddharttiwari4288]

Thank you so much sir. Please make a video on SQL queries. Please please please sir

[@madihajabeen8009]

Thanku sir....sir plz upload the solved Computer past paper 2019 of b.sc part 2 punjab university

[@lavanyadewangan9356]

Sir if i want to insert data in this table so either i writee these name ram , shyam..... In creat command synrax or use insert command...

[@akankshasingh4057]

Thankyou so much sir really thankyou thankyou thankyou so much

[@kunaljain2154]

Hi sir...agr mhuje table m kuch add krna ho to kaise krnge..means create krte waqt m kuch bhul gaya add krna .vo kaise krange.

[@anannyaray8963]

Sir what is the difference between varchar( ) and varchar2( )

[@ankitgoyal8556]

Please arrange the playlist in correct order sir and some important videos missing in this playlist

[@kritika6369]

Thanku sir in class 10 term 2 these commands are coming

[@BharadwajBhat]

sir please remove that subscribe button or make small it disturb a lot other than that u r awesome sir....'

[@sanjidasama8997]

Sir aap table creat karne vali video bnao na practical in sql Or kese keys define kre

[@priyankaarora6364]

Thanks sir for all videos

[@sagarmehla3781]

ADD this video in dbms playlist also

[@merlinjeyanthijames7219]

R u in Mumbai sir

[@malikakram7031]

Very nice video 🎉

[@-hLokesh]

Love u sir for grip on subject

[@meghajoshi1424]

Thankyou very helpful video

[@sanasiddiqui8896]

Hi Sir,thank you for wonderful explaination ,I am looking for pl/sql concept as well ( proceedures,triggers,cursor) ,do you have the session on these?

[@alimalick5495]

Yes, you can check DBMS playlist.

[@mohammedshaikh4986]

Thanks

[@gschargepoint5030]

YOU DESERVE MORE SALARY THAN OUR COMBINE COLLAGE TEACHERS SALALRY.......

[@yusraali2345]

Sir plz upload more videos for class 12th "i. P"

[@rajjoshi2719]

Sir agar hame id int ke baaad primary key use karte hai toh ?
or primary key ka kya kya use hai ?

[@chandnithakur4249]

Nice teaching sir🙏🙏😎😎

[@rutujaaher3592]

Thanku so much sir 😊

[@aishwaryavpkadam]

Please add this video in your SQL playlist.

[@krishanlanka7659]

can you do a video to display only some fields records from a SQL (table )database. after clicking a id or one field to go to full detail page (another page). thanks in PHP please use UNION key word to combine the table records.

[@vijaysonwane5377]

Hello bhai mujhe oracle ke all videos nahi mil rahe he apke channel .kya aap plz mujhe bataoge ki baki ke videos konse playlis me he

[@avadhutvarvatkar3512]

Sir ye video playlist main nhi hai

[@rahulchakrawarti3547]

I am using MySQL workbench

[@deepmudi541]

useful video for me

[@datascientistoflife8550]

Excellent Sir ....

[@abdulquadir6173]

Gate Ka questions BHI kraya kro Bhai sirf theory SE Pura concept nhi hota clear please relational algebra and SQL Ka previous years question gate

[@thekhanal5057]

please explain Entily Integrity and refrential integrity rules ASAP i have exams and i cant understand this ... before Wednesday ( 10th of dec 2019)

[@chandmiya7615]

I really appreciate you

[@uniqueart9260]

I really like ur videos but i want to start the sql from beginning but ur playlist is totally disturb.......will u help me????

[@79jayshree]

Sir will these be relevant to Microsoft sql as well since you mentioned that it's mostly applicable to Oracle?

[@-hLokesh]

Helping me alot

[@sgentertainment4452]

Thanks sir

[@utkarshjaiswal7224]

sir add this video in playlist

[@ritiksunilgautam9246]

Sir please upload a video on MySQL queries

[@zohaibbutt156]

Select E.Employee_id, E.Employee_name from Employee E, Department D where D.Department_id =10 and E.Salary > min(E.Salary) order by E.Employee_Id

[@zohaibbutt156]

Is this query will be Executed?

[@pratikawadhiya5157]

Bhaiya mujhe 'C00001' is type se data store krna hi but ye varchar se nhi ho rha or varchar2 m syntax error ho jata hai please iska koi solution batye.

[@GateSmashers]

Ho jayega varchar se..maine bahut baar kiya hai..C00001 ko single quotes me likhna aise insert into table values (‘C00001’);

[@hariomtiwari3994]

Sir isko SQL me bhi apply KR sakte hai

[@YogeshKumar-ct8od]

Sir this formed in row manner how to create in coloumn manner

[@shivatiwari1127]

Thnku sir 👍

[@digiliferandhawa4190]

Hi

[@nishamehta6219]

Its Attributes or fields

[@suchetabhatia4473]

Thanku sir

[@abhishekupadhyay7261]

Thank you sir ji

[@shivanidhole3671]

Sir please make videos on pl/sql

[@anu_Vlog43]

Thanks sir 👍🙏

[@sratnamanjari244]

Thank You Sir..

[@ujjwaljain9780]

sir pls add this video in sql playlist

[@mubashirabbas5647]

Thank you sir ❤️ sir ...sir plz ya bta dyn Oracle DB ko kysy install kry plz sir it's request

[@GateSmashers]

If you want to install oracle 11g then install it directly because its very simple. Just next next...But 12c installation needs little guidance. If you are doing simply practice on oracle then go with 11g its very simple to install

[@mubashirabbas5647]

@@GateSmashers ok sir thank you very much

[@036sadulla2]

Sir excellent. Sir ab phone me sql programe kar saktegi?
haito plz app ka name natao naa

[@mdshabbir8784]

10 g install hone k baad kisi system par sql load ho jata hai aur kisi system par help menu khul deta hai. R step batane lagta hai magar kaam nahii karta hai. Kiya solution kiya jaye. Plz guide.

[@KanhaiyaKumar-mt3xu]

can you suggest a book for sql (DBMS)

[@rkentertainment6967]

sir ek mera dout hai sir dbms learn kare ke baad kya kare
dbms me kis type job hota hai

[@nirojkhatiwada1015]

Where to use Not null