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 📢

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:

➖➖➖➖➖➖➖➖➖➖➖➖➖

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:

➖➖➖➖➖➖➖➖➖➖➖➖➖

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!

[RishabhMishraOfficial]

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

[AyushiJayant]

In the era of selfish people who want others to struggle finding right sources, you are a boon for learners . Keep it up sir big thanks, after juggling among various free sources, finally all doubts cleared in a single video

[_gauravpatel]

Thank you! If anyone says s/he wants to lean sql, I'll recommend this video!! Great.

[niranjangupta]

Rishabh bhai apne bhi itna help nahi karte, jitna aap kiye ho abhi tak thankyou.

[ur_niraj]

i am working👨‍💻 as data analyst in tigeranalytics... nice to see people like u sharing knowledge to youngster

[nidhis]

yaar rishabh thank you so much, , bhaut simple aur jldi khtm krne wale courses banaye h ..kam se kam 3 saal se mujhe aisa teacher nai mil rha tha .. now i can finally learn sql

[BotherPrabhakar]

Hey Rishabh, your teaching style awesome, thanks a lot for that.
Here is order of execution in SQL > SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT

[IamMiteshParmar]

Hey Rishabh, I am from a non IT background. I am halfway and really enjoying the way you taught and designed this. Keep up the good work going.

[mdumar]

Thank You Sir ji
Me interview me ye apka video padh kr gya tha or me select ho gya.
Thank you so much.

[IskconGlobalMovement]

@30:09 It was a good exercise. Here are my findings on ALTER command in SQL:
ALTER TABLE customer
ADD COLUMN gender char;

ALTER TABLE customer
RENAME COLUMN city TO location;

***To change datatype using ALTER COLUMN***

ALTER TABLE customer
ALTER COLUMN age SMALLINT;

**Set Default value in column email***

ALTER TABLE customer
ALTER COLUMN email SET DEFAULT 'Unknown';

**REMOVING DEFAULT VALUE FROM COLUMN email**

ALTER TABLE customer
ALTER COLUMN email DROP DEFAULT;

[mostlyankita]

Just completed full SQL Course✅.
Must say one of the best course series I have come across. Its really helpful and u have made the learning so easy to understand. Keep up the good work Man !!! 😀

[NeenaKhaira]

I like how effectively everything was described in Hindi. Despite the fact that everyone can speak and comprehend English, studying in your mother tongue is more relatable. I want to thank you for sharing your expertise with me since it motivated me to become a data analyst.

[jafarullahansari]

00:02 Learn SQL from basics to advanced topics in this comprehensive course.
01:44 Introduction to SQL and its applications
05:13 DCL (Data Control Language) in SQL
06:51 Benefits of using Excel as a database
10:23 Understanding the concept of data types in SQL.
12:04 Different data types in SQL
15:51 SQL Tutorial for Beginners | Full SQL Course In Hindi. Learn about creating tables in a database.
17:26 Creating a table in SQL involves using the 'CREATE TABLE' command followed by the table name and column information.
21:09 Learn how to create a table and query its data
23:18 Learn how to define table columns and insert values in SQL
27:28 SQL Tutorial for Beginners | Full SQL Course In Hindi
29:28 Adding and dropping columns in SQL tables
34:12 Introduction to SQL conditions and operators
36:05 Handling multiple conditions in SQL
40:35 Importing and exporting data in SQL
42:40 There are two types of functions in SQL, system defined functions and user defined functions.
46:18 Concatenating strings in SQL using the CONCAT function.
48:38 Introduction to aggregate functions in SQL.
52:42 Using aggregate functions in SQL
54:42 GROUP BY statement is used with aggregate functions to group data based on specified columns.
58:18 Grouping data by customer ID helps identify the customer with the highest transaction.
1:00:55 Applying the HAVING clause in SQL
1:05:30 The time stamp in SQL contains date and time information.
1:07:07 Storing data in a database and performing functions with time and date
1:11:32 This video covers the complete basics of joins in SQL.
1:13:18 Combining two tables using SQL JOIN
1:16:46 Inner join combines common elements between two tables.
1:18:35 Inner join is used to combine two tables based on a common column.
1:23:05 Explaining left join and its output
1:24:44 Left join in SQL
1:28:50 SQL Full Join returns all the records when there is no match in both tables
1:30:50 Understanding the different types of joins in SQL
1:34:35 Find the name of the respective Manager for H of D Employees
1:36:14 The video discusses joining tables and using unions in SQL.
1:40:33 Subqueries are used to create complex queries and perform operations within a query.
1:42:45 Exploring SQL queries to find the average amount in a table
1:46:50 Using comparison and logical operators in SQL queries
1:48:48 Using join operators in SQL for common data retrieval.
1:53:34 Window functions in SQL can be used to create a window of data within a table.
1:55:06 Window functions in SQL
1:58:13 Ranking function is useful for analyzing data and creating rankings.
1:59:42 The video explains how to use window functions and partition data in SQL
2:03:06 Understanding aggregate functions and window functions in SQL
2:04:40 Understanding the rank function in SQL
2:07:55 Understanding SQL ranking function
2:09:39 Window functions include 'order by' and give the desired values based on conditions.
2:12:49 The video discusses the concept of lead and lag in SQL
2:14:26 Understanding the case statement in SQL
2:17:38 Using the case statement to categorize products based on their values.
2:19:14 Understanding the case statement in SQL
2:22:42 The video covers common table expressions in SQL
2:24:15 Temporary tables in SQL
2:28:10 Using subqueries in SQL to retrieve specific data
2:29:45 Joining tables to get data from multiple tables
2:33:40 Practicing and solving more problems helps in earning more
Crafted by jafrullah

[rahuldande]

Sir smjhane ka trika acha lga apko step by step smj agya thank asi video n mili kabhi YouTube pe pehle

[rjgaming]

I wanted to learn excel, SQL, coding. I have watched your excel full tutorial video and practiced one day. Trust me, i have learned exactly what you have shown in ur Excel tutorial video in a day. And now I'm watching ur SQL video and it's my first day. But i feel, it's a little bit hard. Coz i have to replay some parts 3, 4 times. But i hope, i will learn it quickly. Thank you for your free informative tutorial videos😊😊😊❤❤❤

[CP_Masters]

Started many sql courses but never completed until I found this. Kudos Rishabh Subscribed..!

[prernajain]

hello, i just started watching ur SQL tutorial for beginners as I am non-IT professional so this video is helping me to understand the topic in a very simplest way .Thank you so much for helping beginners.
Order of execution - FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY, LIMIT

[rupayadav]

I think after watching your video, struggles for students are gone in SQL. Amazing explanation. Thank you so much for covering all topic so smoothly.

[themihirmathurofficial]

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

[Soothing]

i have watched so many SQL tutorial till now in Hindi and English both but the way you explain was fabulous man even small non tech child can understand this . Really you are helping many students and Non-IT Professional, keep making Such a good content. 😇