SQL Tutorial for Beginners | Full SQL Course In Hindi
SQL Tutorial for Beginners – Learn complete SQL from basics to advance in one video.
This course is for beginners (with zero knowledge in sql) and through this course we’ll be learning various topics including sql basics in hindi, data types, database structure, basic CRUD operations, functions, operators, aggregation, nested queries, joins, cte and much more.
📢ALL csv files and queries are in PDF 📢
⭐ Download SQL PDF document used in this course: https://bit.ly/3rbqpkB
👍 Subscribe for more SQL tutorials like this: https://bit.ly/3Fc7Gc6
👉 GitHub link (all files): https://bit.ly/3Y7SRPr
Getting bored- “Khud se pucho ki shuru kyu kiya tha, career mei kuch bada karna hai” ?
➖➖➖➖➖➖➖➖➖➖➖➖➖
Want to connect with me? Check out these links:
Instagram: https://www.instagram.com/rishabhnmishra/
LinkedIn: https://www.linkedin.com/in/rishabhnmishra/
Twitter: https://twitter.com/rishabhnmishra
➖➖➖➖➖➖➖➖➖➖➖➖➖
Timestamps:
00:00 SQL Course Intro
01:13 Introduction to SQL
08:26 Data Types, Primary-Foreign Keys & Constraints
16:50 Create Table In SQL & Create Database
25:35 INSERT UPDATE, DELETE & ALTER Table
31:40 SELECT Statement & WHERE Clause
38:50 How To Import Excel File (CSV) to SQL
42:16 Functions in SQL and String Functions
49:47 Aggregate Functions
54:46 Group By and Having clause
1:05:21 Time Stamp, Date Time and Extract Function
1:12:22 JOINS in SQL, Types and Syntax
1:33:06 SELF JOIN, UNION & UNION ALL
1:41:25 Sub Query in SQL
1:53:04 Window Function
2:14:25 Case Statement/Expression
2:23:18 CTE-Common Table Expression
2:33:53 SQL Course Outro
➖➖➖➖➖➖➖➖➖➖➖➖➖
Other Useful Videos:
Data Analyst Roadmap, Skills and Jobs: https://www.youtube.com/playlist?list=PLdOKnrf8EcP1JMcD6PhDsUq8YyC0zMZCM
Excel Course: https://www.youtube.com/playlist?list=PLdOKnrf8EcP1Y1XRUVSUc0g-WfeiBigbd
➖➖➖➖➖➖➖➖➖➖➖➖➖
Hope you liked this SQL for beginners course and learned SQL completely from basic to advance. As a next step you can practice more sql queries, interview questions and answers and follow my roadmap to learn SQL 🙂
See You Soon, until then Bye-Bye!
by Rishabh Mishra
linux foundation
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
Why don’t you share the topic “Triggers “?????
2:09:04 bro mere sql me to sbki rank same aa rhi h sequence ki tarah
Brother
I want to give u a suggestion..
If u r making such type of videos for beginners,
then u must show how to download and install the apps or whatever u r using.
For example -( in this video) u haven't showed how to install and download postgresql
best videos for learning, keep posting..
Pdf is not opening
SIR payment_date ke liye hum konsa type dete hai,int8,numeric,varchar
SELECT
FROM
WHERE
GROUP BY
HAVING
ORDER BY
LIMIT
1st assignment 😍🥰☺
Keywords kya use krre hoo aap..???
Rishabh bhaiya me aapko bata nahi sakta but ye video poora 10 baar dekha mn nhi bhara abhi bhi 10 se jyada ik baar me add aaye isme tab bhi khusi ho rhi hai . Aapke video se hi mujhe aaj lead position per job mili hai thank you ❤😊
Rishav bhaiya facing this issue while importing of csv files.
Sir which book is correct for SQL?
Surprisingly for the first time I have completed 2 hours 35 mins of complete video thanks for making this video informative and interesting I never got bored throughout this video thank you so much for making this video for us ❤
Thank you so much for this course sir, You are great ❤❤❤lots of love….keep posting such videos for data analyst ❤
At 21:16 where did you paste that query from?
Thank you so much sir 🙏
Ese hi ek python ka bhi chahiye please sir.
FROM
WHERE
ORDER BY
GROUP BY
HAVING
SELECT
LIMIT
How to download pdf
How to download pdf
HOW DO YOU REMEMBER ALL THIS THINGS IN SQL LIKE SOMETIMES THEY ASK IN INTERVIEW SOMETHING AND I AM LIKE COMLETE BLANK
This is the best resource ever exist.
SELECT, FROM , WHERE, GROUP BY, HAVING, ORDER BY, LIMIT
Hello Rishabh,
The way you teach is really nice.Now I have a clear view of all the concepts.Thank you so much
please provide the link of SQL
How to download SQL applications?
Select
From
Where
Group by
Limit
Select
From
Where
Group by
Limit
Beautiful
Thankyou 😊
thank you so much brother for providing such knowledge and helping people to get jobs and feeding their families.
Superb
Link to download sql pdf document not working….pls share some other alternative
Thank you so much Rishabh Sir for this video. Just because of your one single video I got clear idea in SQL and also thanks for Power BI video.
Great detailed video.
Hey sir pleased start the giving the certificate to us after completing this cousre t add in our resume
awesome course sir!!! thank you
view and triggers !!!!!
sir can we use xampp for database project of data science instead of pgAdmin?
I have a doubt in self join why T2.managerid = T1.empid why not vice versa works
Do you provide online data analyst classes, @Rishabh Mishra?
If yes, please give us information about it. I am really in need of this training.
SELECT
FROM
WHERE
GROUP BY
HAVING
ORDER BY
LIMIT
Great work Rishabh bhai people who struggle and pay humongous money for courses and don’t get this type of knowledge as well as there are people who are only PDF readers they only teach what is in the PDF and no such explanation but no offence to anyone the way you are teaching I think it’s awesome good explanation and PDF handy as document but I prepared notes on my own by listening to you. Thank 😎 smart engineer 💐
HI Rishabh this is yuvraj.
To be honest i am a person who consume content on youtube and i rarely do like and comment on videos but your videos always made my mind for like and comment. i have been following you for about a year and i have learned a lot of things from you. i have created some excel projects like store analysis and some other also in excel. by learning from your videos i have got a Job in MIS Domain and now i just strated learning SQL from your videos. and i believe one day i will definitely crack a data analyst job.
Thanks Rishabh bhaiya from the bottom of my heart.