SQL Commands | DDL DML TCL Commands | SQL Datatypes | In Hindi
HTML-код
- Опубликовано: 19 окт 2020
- SQL Commands | DDL DML TCL Commands | SQL Datatypes | In Hindi | Tutorial#03
in this playlist, I am going to start Structured Query Language (SQL). SQL is one of the best database software which is broadly used. It is mainly the syllabus part of 11/12/BCA/BTech student and I have designed this in such a way that it is specially designed for 11/12/BCA/BTech student. In this video, I have explained the different types of MySQL commands as well as SQL datatypes. SQL has different types of commands which is broadly categorized into DDL, DML and DCL/TCL.
Telegram Channel: t.me/codeituplearners
Facebook Group: / 21673. .
Instagram: t.me/codeitupyt
Facebook Group: groups/21673...
Facebook Page: / codeitup-104310264625489
Website: codeitup.in
Join this channel to get access to perks:
/ @codeitup
Link to Previous Video: • How to Install MySQL o...
Link to next video: • SQL Constraints | Prim...
Tags Used:
sql commands
ddl dml tcl commands
sql datatypes
sql commands
ddl
dml
dcl
constraints
all types of sql commands
rdbms
dbms sql
oracle
mysql
database basics
ddl commands create table
ddl commands in dbms
data definition language in sql
data definition language tutorial
data definition language in dbms tutorial
sql commands in dbms
#codeitup
#sql
#cbse
@CBSE
@CBSE INDIA
@Unacademy CBSE Science 11 & 12
@CBSE Udaan XI
@Ncert Solutions CBSE ncerthelp.com
I have exam 4 days later. And I got all the things you taught on topic SOL as well as on PYTHON. THANK YOU SIR🙂🙂
You are a teacher with supreme qualities🌻
😊
Great stuff, brilliant. loved it. you explained it so smoothly like a hot knife just gets into butter. Love from Scotland. Sir Anand keep an eye on my comments at least I can do to admire you.
😊
Sir Good Explanation ..I was able to understand it easily.. Thank You 🙏Sir 🙏...For Such a Class.. 👍 I have just started learning SQL
Thanks a lot Nayan, keep learning!
Thanks sir you are the best teacher of ip.
Anand sir Anand aa gaya
We again on your channel it's time for term 2
😊
Ho gaya bhai sab term 2 ka syllabus?
Amazing...!!!! You really doing a great job nd ur teaching method is awsm..thank you so much for amazing explanation nd concepts🙏
Most welcome Kanchan, keep learning!
You are the best teacher i have ever seen❤❤
😊🙏
cap
bade dino ke baad laga h ki koi acha teacher mila h
Excellent Sir👍
Awesome
No words
Thanks Nishith😊
Thank you so much sir😇🙏🏻
Jai Mata Saraswati ji🙏🏻🙏🏻🙏🏻🙏🏻
🙂🙏
Sir please make a full course of DBMS
Really sir this playlist is helping a lot
Thanks for the SQL playlist
Please add more vedios
Sure I will dear !
# Amazing Explanation Sir I think u forgot to tell the D/B char and varchar in video ..Plss tell once
You are best guruji 🙏💕
Thanks Rahul!
Congratulations sir for 106k+
Thanks😊
great sir
Thanks!
10:11 , sir char or varchar mein ky difference hoga????
Char meeh sirf abcd likh sakte hai lekin varchar meeh 123... And abcd likh sakte hai jese address we have house no ward no building name area name
Mere se bhi char aur varchar k diffrence pucha gya tha viva m...acha hua maine ye video viva se pehle dekh liya tha thanks to u❤️
😊👍
Difference bata skti ho?
Bata do pls help ho jaayegi
Sir needed SQL tutorials... Thax for the initiative sir.....
Welcome Sakshi !
Ha
Sir your way of teaching is awesome thank u sir for these concepts
Most welcome Nikhil !
Sir plz practice ke liye imp ques bhi daal Dena
Congo sir for another 1k
Following me😀
@@codeitup yeah 😁
Very well sir
Thanks Badal!
thankyou very much
Most welcome😊
char and varchar difference ????
Sir wo konsa command kis liye use hote hein wo 11th ya 12th book mein hai
sir, can u plz provide us notes of class 12 ip.....?
Sir is lecture mai video mai कुछ मिस हुआ है last मैं data type का use कैसे किया vo नही दिखा।
Sir ye pdfs jitne bhi h uploaded vo deleted crse ko htakar h ??
Sir, please make a full course of DBMS 🙏🏻🙏🏻
Yes sir please make a full course of DBMS 🙂
Sure allow me some time.
@@codeitup Okey ,thank you sir ❤️. I am following you since 2020 ,your contents are really amazing 😍. I had learnt python basics from your playlist that had helped me score good in my exam . Thank you sir for that. I am eagerly waiting for your DBMS course (I have in this semester) because I think you can make me understand topics better than other channels. Thank you again for awesome easy explanation ❤️🤩
😊
Sir, your way of guide for student is wonderful.
Thanks a lot Sofia!
thanks for your efforts. You are the best
❤️❤️❤️❤️❤️❤️❤️thanks
😊
In Collage i Didn't Understand What Is SQL and everything but In sir Video is double Awesome Thanks U sir make it up.
And make More Video On it
Hmare schl teacher se to acha smjhaya sir ne
😊
Sir class 10 it ka bhi vedio upload kijye
Thank you for such good lessons sir😊😊.
Did you also taught constraints in this video?
In the last video, I have taught the constraints.
Sir aapne char aur varchar mae diffence toh bataya hi nahi bas yahi bole ki important hai..toh bata toh do😐
ruclips.net/video/k0_9IIeg-_M/видео.html
Great sir ..nicely explained
Thanks for liking Suresh!
Sach mai sir ....
App hai to hum hai...
Or, aap sb se mai hu PKG 😊
Bahut ache se samjhaya aapne, acha laga dekhke.
sir , in questions ka ans bata dijiye plzzz -
source code kya hota ha ?
Oop"s ka concept bata dijiye?
Dynamic ka matlab?
Interpreted Ka matlab?
Set as default ka matlab?
By default ka matlab?
files extract karna, ka matlab?
Peripheral devices kya hote ha?
Hello Himanshu, aapne kaafi sare questions puche hai. Comment me itne sare question ka jawab dena possible nahi hota. But sirf islie ki you don't feel bad I am replying:
Source Code - The code that we write is called source code.
OOPS - Object oriented Programming (see this video for details: ruclips.net/video/kiLWaEiObgw/видео.html )
Dynamic - Anything that happens during runtime is dynamic.
Set as default - It is a value which is used when no value is passed.
By Default - There are many tasks that is done by computer without the consent of use, this is called by default.
File Extract - Jab hum files ki size ko kam karne ke lie use compress karte hai to fir se un files ko use karne ke lir hame pahle un files of extract karna hota hai.
Peripheral Devices - The different devices which are used with the computer system is called pheripheral devices.
@@codeitup thanku so much sir ji
Sir manipulate ko operate krna bol skte h...
Mai python v apke video se padh rha hu or mysql v start kr diya hu ...u r awsm sir
That's good dear, keep learning!
Sir difference nhi btaya apna char ans vchar m
Sir, DCL and TCL are both different types of command in MySQL .
DCL performs the task like - Grant, Revoke
Where as TCL performs the task like - Commit, Rollback
Yes, There are few more things under the TCL commands - Save point , Set , Transaction. There is another command called DQL (Data Query Language) , "Select" is the DQL command.
Best explanation of sql 👌🏻
Thanks Divya!
The way of your teaching is very nice.
Thanks a lot Pratyush!
sir can you provide me notes of 12 ip please
Sir dekh kar bura lagta h log aap jaise talented teacher ko aage nhi badhate h lekin mujhe aap par bharosa h ki aapka channel jald hi 5 to 10 lakh subscriber ho jayenge
I am happy ki mere pas aap jaise students hai jo mujhe itna pyar aur respect dete hai. Mere lie yahi bahut hai. God bless you.
Ya ...Faiyaz. .This is just a start
Are char aur varchar mei difference toh bataiye sirr
East or beat ...
Anand sir is best...
Ha ha... Thanks a ton dear 😊
Great sir ji
Thanks a ton Akash!
🙏 sir aapke Charan kaha h 🥺💜 thanks a lot 🙏💜💜
Most welcome🙂
Notes bhi milenge
Sir please SQL Book name batao. #Ask
Char and varchar me diffrence??
Is this playlist good for ip?
@@tanish4824 idk about syllabus of ip but if it has sql then yeah, its a good playlist
what is the mean of query
Question h bhai😂😂
😜😜😜😜
☺
Thanks sir
You're welcome Faizal!
Sir school ke notes chodd ke aap ke notes kar rha hu
😊👍
sir u did not tell the difference between char and varchar
nice video sir ......
Thanks deepanshu!
Sir aapne char aur varchar me difference toh bataya hi nhii
Bhai Playlist main dekh,de rakha hai
@@ketanmeena5133 bhai maine sql ki saari videos dekh li prr mujhe nhi mila agar aapko mile toh video ki link bhej dena plzz
Upgrade yo goofy ahh mic and book se karna hota toh video kyo dekhte