Dear Rishabh sir, I just wanted to drop you a quick note to say a massive thank you for your awesome SQL tutorials! Seriously, your explanations are so clear and easy to follow. It’s like a breath of fresh air compared to my school teacher who makes everything sound super complicated. Tomorrow, we have an exam on this stuff, and thanks to you, I feel way more confident going into it. Your videos have been a lifesaver! Keep doing what you're doing, man. You’re making a real difference for us learners out here! 💪🚀 Thanks again!
Bhai.. please ek small si request hai aapse.. Jo bhi aapne SQL mein poora padhaya hai.. uski ye PPT ya Notes.. ek jagah pe available kra do.. It'll be really helpful..😌❤️❤️
@@RishabhMishraOfficial Why am I getting this error "ERROR: column "id" of relation "customer" does not exist LINE 2: (ID,Name,Age,City,Salary)" where my column names are all correct?
things which seems to be difficult is explained very well in a easy way by you. thankyou so much for these type of videos sir. we learn a lot of things from your videos. I have joined a physical coaching but your way of teaching is far better than them.
A video of SQL querry for fetching database from server and Fetching all table name with records from database would be great If we don't have gui to do that we must have knowledge of the Querry I guess.
first of all yes its really easy to understand the way you are teaching but just go through the error too like it we will not use " or ' we may face that error because with mistake people may understand better thanks
I have a query, why use *varchar for name* but *char for city* Both can be variance character as City can be same or different for both and length is also variable
Hi What is advantage in making tables in sqp? We can make tables in excel very easily....can u give example where we want to make table in sql and not in excel...
i have one ask..when we create table thru query then name was only "customer" but when we create it directly then name was "public.cust" whereas you mentioned table name only "cust"
Hello Rishabh, I am using SSMS. I cannot import csv file data by using copy function in SSMS. How can I import csv file data with help of query? Please help me...
Sir while creating columns u dint click "not null" for address and salary....if there are null values then while cleaning the data will have issue and have to delete the null values or replace it with mean, median, or mode.....its a doubt im watching ur video for first time
What's diff. btw "char" and "char[]" ? like this there are so many data type has same Ques. Is there any option that input data type NAME Column char(15), in this column maximum 15 characters are added as NAME.. Same Age Column int(2) by input length myself...
Kya hum esa nhi kr skte hain ki custname m length k lie data type m character krna chahie tb fir hum length daal skte hain vrna int s nhi daal skte length
Hi, thank you for such wonderful video but I have a doubt apne jab query tool open kia to usme cust id varchar and all copy paste jo kia tha voh kaha se kia ya fr voh data apne kudh likhi thi? 4:28
hi, you said for paste, but where from I should copy. i did not understand please make a video point to point, what should copy, paste, back remember point. please
Rishab bhai .. can I use the queries in postgressin ms sql? are they similar? actually mere job mein ms sql required hai .. kya main aaoka video dekh ke seekh sakta hoon?
Hi, when I am following your action on my computer @ step when you said under table querytool-choose testdb/postgres@ mine information is not same as you. I need help. Thanks
Hi Sir, pls mujhe guide kariye , kya postgreSQL seekhne ke baad kisi bhi SQL pe kaam kar sakte hain kya? like mySQL or on Oracle , simple question kya sabhi SQL ke syntax same hote Hain? pls guide 🙏🙏
mysql, oracle and postgresql are RDBMS and all of these used SQL as a language. RDBMS means "Relational DataBase Management System ". hope you get an answer to your question. Rishab bhai might be busy so I just put an answer.
Sir I am getting the query as SELECT * FROM public.cust ORDER BY custid ASC LIMIT 100 while yours on the screen as SELECT * FROM public.cust LIMIT 100 I followed your exact same steps sir in postgresql latest version, please tell me where am i doing it wrong?
Rishabh bro, getting error at 1:09 while trying to insert the data in the table. I tried to create other table as well, and getting error for ID only. Used your commented query only to create the table ERROR: column "custid" of relation "customer" does not exist LINE 1: INSERT INTO customer (CustID, CustName, Age, City, Salary)
Dear Rishabh sir,
I just wanted to drop you a quick note to say a massive thank you for your awesome SQL tutorials! Seriously, your explanations are so clear and easy to follow. It’s like a breath of fresh air compared to my school teacher who makes everything sound super complicated. Tomorrow, we have an exam on this stuff, and thanks to you, I feel way more confident going into it. Your videos have been a lifesaver! Keep doing what you're doing, man. You’re making a real difference for us learners out here! 💪🚀
Thanks again!
SQL itni aasani se aapne padha Diya.
Thank you bhaiya
Glad you liked it ✅️
ABHI TAK KA SABSE BADIYA SQL TRAINING VIDEO
Glad you liked ✅️
Bhai.. please ek small si request hai aapse.. Jo bhi aapne SQL mein poora padhaya hai.. uski ye PPT ya Notes.. ek jagah pe available kra do.. It'll be really helpful..😌❤️❤️
Yes,link is there. pls check the video description
@@RishabhMishraOfficial ok.. thanks bhaiya
@@divyanshumishra5993 bhai mujhe to notes nhi mila
@divyanshumishra5993 Bhai link mili ho to bta de
@@RishabhMishraOfficialbhai notes ki link hi nhi dikha rahi...plzz guide
By watching these practicals, it's very easy for us to understand step by step. Thanks for the video. 🙂
Thank you :)
Can u please tell me is there is maths need to learn sql
Your teaching style is practically based, Thank you, sir
Glad to hear that ✨️
@@RishabhMishraOfficial Why am I getting this error "ERROR: column "id" of relation "customer" does not exist
LINE 2: (ID,Name,Age,City,Salary)" where my column names are all correct?
things which seems to be difficult is explained very well in a easy way by you. thankyou so much for these type of videos sir. we learn a lot of things from your videos. I have joined a physical coaching but your way of teaching is far better than them.
Glad you liked it ✅️
A video of SQL querry for fetching database from server and
Fetching all table name with records from database would be great
If we don't have gui to do that we must have knowledge of the Querry I guess.
Thank you!
After following & learning from your videos get a positivity of moving a head in learnings
watched this part. thanks for explaining it step by step. I am enjoying this tutorial
Thank you :)
first of all yes its really easy to understand the way you are teaching but just go through the error too like it we will not use " or ' we may face that error because with mistake people may understand better
thanks
Glad you liked ✅️ n noted ✅️
Great video, Just one
Question: When should we choose int datatype and numeric datatype?
The most commonly used numeric data types are INT and FLOAT .
The INT for whole numbers, while the FLOAT for decimal numbers.
your video is helpful sir
Glad you liked ✅️
Explained in an easy manner, Thank You.
Glad it was helpful! 👍
Quite easy to learn...thank you brother
Glad you liked ✅️
Dear Sir:
Kindly define what is the difference between "varchar" and "Char".
Thanks
You are life saver bhaiya ❤
to the point, nice explanation.
Glad it was helpful! ✅️
I have a query,
why use *varchar for name*
but *char for city*
Both can be variance character as City can be same or different for both and length is also variable
Yess you can do that 👍
Bhai aap great ho
Glad you liked it ✅️
Quality teaching 👏 👌 thank you 😊
Awesome way of teaching 👍👍👍👍👍👍
Glad you liked it ✨️
Hi
What is advantage in making tables in sqp? We can make tables in excel very easily....can u give example where we want to make table in sql and not in excel...
Great question, i have answer this question in detail please watch my first SQL video- What is SQL
thank u dear🥰 it is really good for me😊
Glad you liked ✅️
Great..!! Thanks sir for sharing this type of video.
thank u so much for these videos. its so helpful.
Glad you like them! 👍
Great job bhaiya .... thanks for this series....♥️♥️
Glad, you liked it! :)
Bro, is this playlist enough to appear for data domain interviews?
This is enough just to understand basics n topics but along with this solve interview questions n make projects
Thank you Bro ❤
thankyou sir
Glad you liked ✅️
Shukriya sir or achy sy agy waly topic bi clear kr Dyn
Quality content! ✨
Hi Rishabh please make correction while inserting value in classroom column INSERT INTO classroom
(rollno, name, house, grade)
VALUES
(1, ‘Sam’, ‘Akash’, ‘B’),
(2, ‘Ram’, ‘Agni’, ‘A’),
(3, ‘Shyam’, ‘Jal’, ’B’),
(4, ‘Sundar’, ‘Agni’, ’A’),
(5, ‘Ram’, ‘Yayu’, ‘B’);
instade of the above one please use below one
INSERT INTO classroom
(rollno, name, house, grade)
VALUES
(1, 'Sam', 'Akash','B'),
(2, 'Ram', 'Agni', 'A'),
(3, 'Shyam', 'Jal', 'B'),
(4, 'Sundar', 'Agni', 'A'),
(5, 'Ram', 'Yayu', 'B');
INSERT 0 5
Query returned successfully in 239 msec.
Yess it's updated in the pinned comment, thanks for sharing
very essential video
Glad you liked it 👍
hey you should have mentioned that last statement of the table must be ending without a comma so that query could not have a syntax error
Thank you so much
Glad you liked ✅️
Thank you sir 💐
Glad you liked ✅️
Very nice sir ..
How to show all databases and how to show all tables with query
For ms sql,
SELECT * FROM information_schema.tables;
Postgre sql
psql -d database_name -U user -W
\dt
\dt+
Hello Sir, Can you please use SQLite or SSMS software instead of this? It will be really helpful. Thanks.
Exactly what we have to do in this table
Sir, u r awesome. thanks for the video.
Easy way to learn sql
Thank you :)
Thankyou rishabh
Glad you liked ✅️
Waiting for the next part.
Hi Abhishek, coming soon!
thank you dost
Glad you liked it ✅️
Each and every video is well explained 🫶💯
Thnk uhhh so much 😊
Very well explained
Glad it was helpful! ✅️
Hi can you please make video on how to create database and schemas in my sql. It will be greate helpful for me.
Noted ✅️
Sir can you explain in 04:30 from where did you copy and paste the query? didn't understand that
Awesome video thanks
i have one ask..when we create table thru query then name was only "customer" but when we create it directly then name was "public.cust" whereas you mentioned table name only "cust"
Can i get some project to work on that for a pratice purpose
Yess, you can get free projects on Kaggle website
please provide the playlist of software development training and Manula testing training .............0 Lavel to Advance lavel
thanks bhaiya
Sir from where did you copy the query? You pasted it at 4:30
Hello Rishabh, I am using SSMS. I cannot import csv file data by using copy function in SSMS. How can I import csv file data with help of query?
Please help me...
Also when we write name , do we have to use " " this all the time?
Yess, it's a part of syntax for strings (characters)
I made this table in MySQL WorkBench but for there is numeric option for salary.....
Sir more examples
Tab aur acche se samaj mai aaygya
Okayy noted ✅️
Very clear, thank u
Glad it was helpful! ✅️
1.Why salary and address is not given NOT NULL constraint.
2. Difference between integer and numeric data type
Thanks for valueable video. I have downloaded postgre sql17 and also created table but table is not showing on psadmin4. pls reply
Install 16 version
Thanks
Super explanation🎉🥳💐
Practice ke liye kaun sa software (free) use karna chahiye hame
Postgre sql, mysql or ms sql server
@@RishabhMishraOfficial kya ye sabhi software offline hai
Sir while creating columns u dint click "not null" for address and salary....if there are null values then while cleaning the data will have issue and have to delete the null values or replace it with mean, median, or mode.....its a doubt im watching ur video for first time
Yes that depends on database you want to create. As a customer, sometimes people don't want to share those details
Hey, can you please make a video on Celonis process mining.
In entire youtube I could not find any playlist in Hindi language for Celonis PQL and EMS
thx from nepal
Sir, how we unlock the character, here in these we had cx name as 1 character. How do we modify?
What's diff. btw "char" and "char[]" ? like this there are so many data type has same Ques.
Is there any option that input data type NAME Column char(15), in this column maximum 15 characters are added as NAME..
Same Age Column int(2) by input length myself...
How to delete the the database which we have created after we have saved it.. Example testdb
If you're using Postgre sql, then just right-click on the database n delete it
Or use
DROP DATABASE testdb
Rishabh bhaiya apne ko sql me pdhaya ye kafi hai ya or v pdhna hoga ?
Yess after this you just need to practice interview questions n for that you can follow my playlist- sql interview questions and answers
Kya hum esa nhi kr skte hain ki custname m length k lie data type m character krna chahie tb fir hum length daal skte hain vrna int s nhi daal skte length
char me length wala me kon sa wala code use karenge
Bhai ek video bna do ge ki MySQL laptop me kase download kre mujhe nhi aa raha😢😢😢 please 🥺🥺🥺❤️🥺❤️❤️❤️❤️
Hi, thank you for such wonderful video but I have a doubt
apne jab query tool open kia to usme cust id varchar and all copy paste jo kia tha voh kaha se kia ya fr voh data apne kudh likhi thi? 4:28
It's from notes, link in first video of this series
Sir int data type main size Dena hota hai na?
Sir postres me bhi btado
hi, you said for paste, but where from I should copy. i did not understand please make a video point to point, what should copy, paste, back remember point. please
It's in the notes, link in first video of this series
Bhaiya link nahi mil rhi ppt ki plz give us the PPT it's really helpful fof us plz teel us how to download it
Rishab bhai .. can I use the queries in postgressin ms sql? are they similar? actually mere job mein ms sql required hai .. kya main aaoka video dekh ke seekh sakta hoon?
Anyone knows better sql tool which will have less option than this??
Sir python with automation ka kya scope h aage
I think most of the automation work will be taken care by machine leaning and AI
Hi, when I am following your action on my computer @ step when you said under table querytool-choose testdb/postgres@ mine information is not same as you. I need help. Thanks
Hope you’re using Postgre sql, n still facing any issue pls let me know in comments or can ping me on Instagram
Hi Sir,
pls mujhe guide kariye , kya postgreSQL seekhne ke baad kisi bhi SQL pe kaam kar sakte hain kya? like mySQL or on Oracle ,
simple question kya sabhi SQL ke syntax same hote Hain?
pls guide 🙏🙏
mysql, oracle and postgresql are RDBMS and all of these used SQL as a language. RDBMS means "Relational DataBase Management System ". hope you get an answer to your question. Rishab bhai might be busy so I just put an answer.
Can we do SQL in MS excess?
Sir I am getting the query as
SELECT * FROM public.cust
ORDER BY custid ASC LIMIT 100
while yours on the screen as
SELECT * FROM public.cust
LIMIT 100
I followed your exact same steps sir in postgresql latest version, please tell me where am i doing it wrong?
It's same only difference is sorting of data
sir
, what is difference between char and varchar
good one!!
what is the difference between int and numeric in the case of datatype
i think both are same
Brother can we practice this with mysql?
Yes absolutely 💯
agar salary mein numeric ki jagah int likha kyn nai, int bhi chal jata hai na?
in postgre16 it dose not accept the syntax when we write int8 the query does exicute sucessfully
Kindly provide the practice data set
Yes it's there, pls check the description first video of this sql tutorial series
@@RishabhMishraOfficial Thank you dear.God bless you
Rishabh bro, getting error at 1:09 while trying to insert the data in the table.
I tried to create other table as well, and getting error for ID only.
Used your commented query only to create the table
ERROR: column "custid" of relation "customer" does not exist
LINE 1: INSERT INTO customer (CustID, CustName, Age, City, Salary)
Hi Rishabh, hi, I try to sql query but same problem.
Why have you used DROP TABLE command at last ?
Sir we want advance thing for sql database
Okayy noted ✅️
Not being able to add length to custname while doing practically whereas at the same time added length to address. What could be the problem ??