SQL Tutorial for Beginners | Full SQL Course In Hindi

Anyone facing issue in Inserting or updating values in CHAPTER-04, please use below query:

👉 Customer Table
🔖 Create table

CREATE TABLE customer
(
CustID int PRIMARY KEY,
CustName varchar(50) NOT NULL,
Age int NOT NULL,
City char(50),
Salary numeric );

🔖 Insert values in table

INSERT INTO customer (CustID, CustName, Age, City, Salary)
VALUES
(1, 'sam', 26, 'Delhi', 9008),
(2, 'Ram', 19, 'Bangalore', 11000),
(3, 'Pam', 31, 'Mumbai', 6060),
(4, 'Sam', 42, 'Pune', 10000);

🔖 Update values in table

UPDATE customer
SET CustName = 'Xam' , Age = 32
WHERE CustID = 4

QA 1.
SELECT
FROM
WHERE
GROUP BY
HAVING
ORDER BY
LIMIT

This is really a great explanation❤❤ I am from non it background and you explain it very well so that everyone can understand it

Quick Assignment 1:-
Order of execution with example:-

select mode, count(amount) as total
from payment
where amount >= 100
group by mode
having count(mode) >=2
order by total desc
limit 5

Very helpful

Thanks bhai for this video😊

Sir when we are creating tables directly its not accepting length scale and prescion 😢

Select roll no from class
Where roll no >5
Limit 10
Group by roll no
Having roll no> =5
Order by Asc

Thank you for the video i just completed studying and will download pdf to practice

Bro..business analyst me kaun sa sql krna chahiye..uska koi course me help kro

Thank you so much sir for this video. It really helped me a lot.❤

Helpful❤

why we are sepcifically using this sql insted of oracle,mysql etc

sir pdf kaha se download kare

Thanks sir for your support

Thanks for the explain of SQL.. it's very helpful for everyone.. can you please share this pdf which you are explaining.

Thanks a lot for SQL. PLEASE TEACH Tableau in the same way.

Hi bhai you are fantastic man

SELECT mode,SUM(amount) AS total
FROM payment
WHERE mode='Credit Card' OR mode ='Cash'
GROUP BY mode
HAVING SUM(amount)>420

output:
mode total
Cash 440

content acha ha but smjhany ka way acha nai ha,bhut zayada breaks lety hu ap bhai.

Sir is this much SQL knowledge enough for data analysis??

Thank you so much brother

HI SIR HOW ARE YOU, I JUST COMPLETED SQL FULL LECTURE VIDEO, THANK YOU SO MUCH FOR THIS VIDEO SIR IT HELPS A LOT AND COVERS ALL IMPORTANT TOPIC WHICH IS REQUIRED BUT I HAVE ONE DOUBT ABOUT SIR, I JUST WANT TO KNOW WHEN I WRITE QUARY ON POST-SQL SOME TIME I GET ERROR AND ALSO GET INFORMATION AS SYNTAX ERROR, BUT I TRY TO WRITE CORRECTLY BUT ITS ALWAYS INCORRECT PLEASE TELL ME SIR HOW CAN I WRITE AND CORRECT QUARY WITHOUT ERROR FREE SIR PLEASE DO NEEDFUL FOR ME SIR,.......

Thanks

Mr Mishra doing God's work.

Sir used in aggregate function in window total me value h same code same table create I am but output is different in total box .

Sir kon sa editior use kiya apne

Hi Sir, I am Ankush When I imported my file I got the ERROR: invalid byte sequence for encoding "UTF8": 0x00
CONTEXT: COPY customers, line 1. How can I resolve this Issue

Very Very Useful and Easy to learn tutorial.. Thank you Rishabh 😊

thanks for I have completed it

Select * from ...
Where...
Group by....
Having....
Order by....
Limit.....

i dont know why sql didn't working in my laptop that show fill up ur password etc again and again

It would be helpful if you make vedios in English 😊

Can we use same command on mac terminal using percona

❤❤very good sir plz make one more pdf with video of postgresql

Please teach python also which we needed most for data science advance level only thank you in advance

Do you have any video having MS SQl project with dashboard on Power BI? Please guide

Assignment1 Ans From , Where , Group By , Having, Select , Order By , Limit

which compiler are u used here??

Select, from, limit, where, group by, having, order by

Where I can find the pdf?

constraint ka jo bole apne k school mai roll no. blank nhi hone chia or hua toh wo data usko lega he nhi wo error through kar dega or data ko system mai feed he nhi karega es type ki error se bachhne k lia constraints ka use karty hai . But use he karty hai na constraints k es type ka error throgh kar sky mujhe confusing laga or wrong bhi?

i am using mac and not able to import the csv file via any of the methods , tried both query method and manual import method
msg
ERROR: could not open file "documents:\customer.csv" for reading: No such file or directory
HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as psql's \copy.

SQL state: 58P01
can you help as there is no division in the harddrive section as present in windows and even after copying exact links i am not able to get the file imported

How to compare to tables?

Functions kaam nahi kr rhe hai kaafi Sare MS Sql mai