Thank you Rishabh, Due to this query i can insert into values in table but won't be able to update value used your written query but unable to update.. Actually my table is different from yours so for insert i used 👇 INSERT INTO student VALUES (1, 'sam','Delhi', 90), (2, 'Ram','Bangalore', 11), (3, 'Pam','Mumbai', 60), (4, 'Sam','Pune', 10); Please suggest! !
@@tannuyadav8742 i also faced the same problem, but then i figure it out the solution although my approach is not too good but it will resolve the issue..here rishabh sir can insert multiple values using only one single statement but we can use the insert statement every time when we have to enter values in our column e.g: INSERT INTO customer (1, 'sam', 26, 'Delhi', 9008); INSERT INTO customer (2, 'Ram', 19, 'Bangalore', 20000); INSERT INTO customer (3, 'Pam', 31, 'Mumbai', 10000)
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
Really awesome video, thanks to help all students and professionals...God bless you 🎇 After completing this full video, is there any other topics remains for concepts in SQL
bro can a fresher get into tiger? i am preparing right now. can you tell me what types of question should I focused and more? also should I start python or only focus on sql
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 !!! 😀
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.
Hey It's really true I myself saw this video and now able to know what actually SQL is Btw please can you suggest me that one imp skill to be a data analyst I am also preparing for the same ❤😊
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
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. 😇
Hello Rishab... You are amazing soul. From you itself I learned PowerBI and now able to creat really interesting visualising dashboards... Now from your SQL course am gaining confidence... I completed this course yeah i know need to work on projects but you have anazing skills to make it possible to trust ourself to step one step ahead towards my dream of data analyst..... Thankyou so much Rishab.... Am so grateful to you... Thankyou for helping all of us and spoting light for all aspirants switching from nonIT to IT Grateful to you 😊🙏🙏🙏🙏🙏🙏☺️
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
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
Hi Rishabh, I have checked lots of material in UA-cam for SQL but this one of the best channel i have found. really appreciate your effort ,simplicity and dedication. Keep it bro 👍👍
Thank you so much for this course sir. This is a blessing for all the beginners out there. I am absolutely sure that after completion of this course, everyone will have decent knowledge of SQL.
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😊😊😊❤❤❤
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
Hi Rishabh, I feel privileged to UA-cam now to have recommended me your video. I am a non IT professional willing to learn and change my vertical, and your videos by far are the best value addition to my learning library. Thank you! Simplified and easy learning that, too, in vernacular language.
@@mahakgarg3152there are not really any difference between them. Both are database management softwares used for create, manipulate and store the data
One of the best course series i have ever seen. So clearly and neatly explained and organised with definition, syntax and example practise most important with the pdf document can be kept as notes. Thanks for the video it helped me a lot to understand and follow SQL.
ust 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 !!! 😀
Rishabh you have made very crisp, point to point an awesome video. You are contributing alot to my data analyst journey. Thanks. Make such video on Power Bi and Python too if possible. regards.
Shukriya rishab thanks a lot... you rock... tum bahot zabardast insaan ho. World needs people like u. Sab sey achi baat yeh hai k tumne yeh videos hindi mey banayi hai !
One thing i noticed that while using ALTER TABLE command to add column, we must add data type otherwise error will occur; ALTER TABLE customer ADD COLUMN address varchar(100);
Hello Rishabh, I'm a non-IT professional who has just begun learning SQL, and your videos and explanations have been extremely helpful. I'm making a comment in the middle of your videos. Thanks for your hard work :)
Hello Rishabh, This is the first time when I'm learning SQL and it's been complete delightful learning experience. Thank you for sharing all the knowledge with so candid way, it actually helps to learn more. Please be the same person/teacher you are bcoz you're Awesome :) Keep helping and stay blessed always :) Wishing you all the success and all the good wishes...!!! Quick Assignment 1: Order of Execution: SELECT, FROM, LIMIT, GROUP BY, HAVING, ORDER BY.
Hello Rishabh, I recently progressed for Google's Data Analytics Apprentice role and your videos helped me on the way a lot. They boosted my confidence and helped my understanding of Data Analytics better. Just wanted to thank you for your efforts !!!
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.
Ever since I joined your journey at the humble mark of 700 subscribers, witnessing your growth has filled my heart with boundless joy. 🥳🥳The knowledge I have gained through your captivating videos has enriched my life beyond measure, leaving an indelible mark of gratitude and appreciation.👍
You're great Sir! For your amazing way of learning . Your teaching concepts are very smooth and easy to understand for beginners. You are always be in our hearts for your kind services. Thank You.
Great content. Thank you. Suggesting this content to People across domains. People who are preparing for government jobs should learn the free skills from UA-cam and try to keep themselves busy. Skills acquired in the process can help them sustain in the long run if things didn't turn in favour.
I am unable to write properly Select query with full syntax but this course is helpful, I am working as SAP ABAP consultant , ABAP is basically SQL Queries to fetch data from the database dictionary.
today morning 7 am i was so stressed with job switch and morning i saw ur first video of roadmap to DS. I did this course with money and no placement... regretted.. today i have started with your guidance again with 100 days challenge to again revise everything and get new job...thanks and ur amazing already subscribed
Rishabh Bhai, you deserve so much love, respect n blessings for sharing knowledge. Your quality of explanation is second to none. 👏👏 Someone from non IT background like me is enjoys your videos so much. Keep up the great work.
@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;
OMG......Rishabh, your channel has the full potential of reaching at least 1 million subscribers very soon, Keep the good work ON. You made it so much easy and understandable for even non-IT background individuals. Please make such video on POWER BI as well
Rishabh Bhai you're the ideal explanation of how a human should be = "Humble and Kind". And people might've ignored this line but I ain't i.e "Khud se pucho ki shuru kyu kiya tha, career mei kuch bada karna hai" . Thanks for helping us all.
Salute hai ...aise teacher ko ...kash itna gyaan engineering colleges mai dete toh india kaha se kaha pohoch jata...really so help full for begineers who are learning from scratch that too (full practical)... Aise teachers ko bharat ratna milna chahiye ..they are the real heroes of the society to serve the youth that too for free...keep it up sir aur bhi ache beneficial videos lekar aye for data analysts freshers to become experts one day 💐💯😇💞☺️
To remember SQL sequence here is a simple mantra. Just remember the following sentence "Some French Waiters Grow Health Oranges", now remember the first letter of each word of the sentence. S = Select, F = From , W = Where, G = Group By, H = Having , O = Order by. Hope it helps.
Greate video, Honestly Just pure content 💯No faltu ki baate Thank you Rishabh bhai🔥👌 Thank you for providing Notes. Request : Please bring One Single video on SQL question For interviews.
Hello Rishabh, I am Rohit from non IT background who has just started learning SQL, the way you taught is really awesome. It would be great if you can provide an input in one small query that "from where did you copy the data which you paste in table query"? at video time 21.17 although I have learnt the same way through right click on table then click on create the table
Hi Rishabh, I have checked lots of material in UA-cam for SQL but this one of the best channel i have found. really appreciate your effort ,simplicity and dedication. Keep it bro 👍👍 Love from bangladesh
Hi Rishabh, Thank you so much for the video. I had scrolled a lot of videos but your video tuned up in a perfect manner with me because of your teaching and explaining style. thanks a lot for this. even by paying on Udemy or anywhere, can get this quality content.
Such a appreciating work done by you sir... We are very thankful to you for providing the better quality of source of education to enhance the skills... 🙌
I absolutely love how you have the course setup like a PowerPoint. Do you have an English version so that I can understand when you explain a bit on each slide? Thanks 😊
@@nandini0328 then learn Hindi cuz English is the Anglo white Christian missionary colonizers' language whereas Hindi is indigenous to India than english so it's better if y'all (South Indians ) must learn Hindi , speakin' out one of the indigenous product of Bharat is way much better than speakin' out in a language (english) which is foreign to Bharat/Indic civilization
In SQL, the order of execution for a typical query follows these steps: 1. FROM: The query retrieves data from the specified tables or views. 2. WHERE: Conditions are applied to filter the rows based on specified criteria. 3. GROUP BY: The result set is grouped into subsets based on the specified columns. 4. HAVING: Conditions are applied to filter the groups based on specified criteria. 5. SELECT: The columns to be included in the result set are selected. 6. ORDER BY: The result set is sorted based on the specified column(s). 7. LIMIT: The number of rows in the result set is limited.
@@sarthakjaiswal4724 exactly brooo everyone here in the comment section is just commenting the order same as in question but order by pehle ayega ki select ?
First of all Thank you Rishabh Sir, you are giving free content on youtube its helpfull for me .when i watched your videos my confidence build too much.lots of love ❤❤❤❤❤❤
Assignment 1 SEQUENCE -1)SELECT 2)FROM 3)WHERE (It comes with Select) 4)GROUP BY 5)HAVING- (It comes with Group by and always placed after the GROUP BY clause) 6)OREDER BY 7)LIMIT
Thank you bro, for putting in so much of efforts and making SQL topic easy... this is only time was I was able to completely understand all SQL pointers mentioned. God Bless you bhai :) 👏🙌
In SQL, the order of execution for a typical query follows these steps: 1. FROM: The query retrieves data from the specified tables or views. 2. WHERE: Conditions are applied to filter the rows based on specified criteria. 3. GROUP BY: The result set is grouped into subsets based on the specified columns. 4. HAVING: Conditions are applied to filter the groups based on specified criteria. 5. SELECT: The columns to be included in the result set are selected. 6. ORDER BY: The result set is sorted based on the specified column(s). 7. LIMIT: The number of rows in the result set is limited.
How to Clone an SQL Table: Step-by-Step Guide Welcome to our SQL tutorial series! In this video, we’ll walk you through the process of cloning an SQL table. Whether you need to copy a table's structure, data, or both, we’ve got you covered with detailed instructions for MySQL, PostgreSQL, and SQL Server. #AnalyticsBattle #ExcelVsPowerBI#SQL #DatabaseManagement #WiFiLearning #TechSkills #DataManagement#DataAnalysis #TechSkills #WiFiLearning #CareerGrowth #DataAnalytics#DataDistribution #WiFilearning #KnowledgeSharing #DigitalTransformation#DataScience #DataAnalysis #CareerPaths #WiFiLearning #TechEducation#Polymorphism #JavaSkills #OOP #WiFiLearning #TechAdvantage#DAX #DataAnalytics #WiFiLearning #TechSkills #ExcelTips#CareerBoost#WiFiLearning #ExcelMastery #ProductivityBoost #DataAnalytics #WiFiLearning 👇👇 ua-cam.com/users/shortstr2Zvp8-qto?feature=shared 📧 Stay Connected: • www.wifilearning.com • info@wifilearning.com • Facebook - facebook.com/wifilearning0 • Instagram - instagram.com/wifi_learning/ • Linkedin - www.linkedin.com/company/7956803/admin/feed/posts/ Thank you for watching, and happy learning!
You are a good teacher .You taught SQL in the easiest way. I am from non tech background but i learnt very well from your video . Thank you so much sir😊🙏
Server’s are not connected ! So you can only see those data which is in server that you are operating ! If a server can be accessible by another server then it’s a security bug which call ! Business logic and error or cross site scripting (xxs) !
Rishabh Sir, you are awesome. You make learning sth difficult so easy! I'm learning SQL for the first time and before coming across your video I was very apprehensive about the topic! Thank you for enriching us learners by sharing knowledge in such an honest way :)
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
Thank you Rishabh,
Due to this query i can insert into values in table but won't be able to update value used your written query but unable to update..
Actually my table is different from yours so for insert i used 👇
INSERT INTO student
VALUES
(1, 'sam','Delhi', 90),
(2, 'Ram','Bangalore', 11),
(3, 'Pam','Mumbai', 60),
(4, 'Sam','Pune', 10);
Please suggest! !
I am facing the same issue
@@tannuyadav8742 i also faced the same problem, but then i figure it out the solution although my approach is not too good but it will resolve the issue..here rishabh sir can insert multiple values using only one single statement but we can use the insert statement every time when we have to enter values in our column e.g:
INSERT INTO customer
(1, 'sam', 26, 'Delhi', 9008);
INSERT INTO customer
(2, 'Ram', 19, 'Bangalore', 20000);
INSERT INTO customer
(3, 'Pam', 31, 'Mumbai', 10000)
@@AbdullahJan-vy3es i am facing issues in updating values ...
@@tannuyadav8742 You have missed writing the column names after student. Try writing that and then run.
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
Glad you liked it ✅️ keep learning n keep growing 🚀
@@RishabhMishraOfficialSir I m belong to non tech background can I join data science?
Really awesome video, thanks to help all students and professionals...God bless you 🎇
After completing this full video, is there any other topics remains for concepts in SQL
@@RishabhMishraOfficial really love you sir
You said it right bro era of selfish people....
Hats off to Rishabh Sir! 🌹💐
i am working👨💻 as data analyst in tigeranalytics... nice to see people like u sharing knowledge to youngster
bro can a fresher get into tiger? i am preparing right now. can you tell me what types of question should I focused and more? also should I start python or only focus on sql
Can you tell me which skills are required to get a job to become data analyst ?
Can u pls tell me is it easy data science course for fresher or intellipaat is good for placement prgorm?
Thank you! If anyone says s/he wants to lean sql, I'll recommend this video!! Great.
Ye jo video h hum MySQL pr bhi Sikh skte h kya
Rishabh bhai apne bhi itna help nahi karte , jitna aap kiye ho abhi tak thankyou.
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.
use chatgpt
non IT ka h toh yahan kya kaddu lene aaya h
@@darthvader875 Nahi be tera family business nahi badhane aaya. Knock another door for your kaddu
@@IamMiteshParmar nice reply bro
Good.. But how can I see front end.. Please guide me.. How can I add values in front end...
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 !!! 😀
Glad you liked ✅️
Hi ankita, where can i practice Sql for free. Please help.... Congrats for completing SQL. Keep going..
@@rajatbarik6981go for leetcode that's the best platform to practice
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.
Glad you liked the content ✅️
Exactly
Hey
It's really true
I myself saw this video and now able to know what actually SQL is
Btw please can you suggest me that one imp skill to be a data analyst
I am also preparing for the same ❤😊
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
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. 😇
Thanks and welcome 🙌, glad you liked it ✨️
@@RishabhMishraOfficial Is this course sufficient for data analyst
@@RishabhMishraOfficialsir ye video me sql pura course completed hain ya eska part 2 upload sir karege kripa bataye
Hello Rishab...
You are amazing soul.
From you itself I learned PowerBI and now able to creat really interesting visualising dashboards... Now from your SQL course am gaining confidence... I completed this course yeah i know need to work on projects but you have anazing skills to make it possible to trust ourself to step one step ahead towards my dream of data analyst..... Thankyou so much Rishab.... Am so grateful to you...
Thankyou for helping all of us and spoting light for all aspirants switching from nonIT to IT
Grateful to you 😊🙏🙏🙏🙏🙏🙏☺️
Glad it was helpful ✅️ keep learning n keep growing 🚀
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
Glad you liked it ✅️
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
Glad it was helpful ✅️
Hi Rishabh,
I have checked lots of material in UA-cam for SQL but this one of the best channel i have found. really appreciate your effort ,simplicity and dedication. Keep it bro 👍👍
Thanks, glad you liked it ✅️
Thank you so much for this course sir. This is a blessing for all the beginners out there. I am absolutely sure that after completion of this course, everyone will have decent knowledge of SQL.
Glad you liked n keep learning n keep growing 🚀
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.
Glad it helped! ✅️
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😊😊😊❤❤❤
Did you get the job?
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
Glad it was helpful!
select sabse pehle ayega brother
Hi Rishabh,
I feel privileged to UA-cam now to have recommended me your video.
I am a non IT professional willing to learn and change my vertical, and your videos by far are the best value addition to my learning library. Thank you!
Simplified and easy learning that, too, in vernacular language.
Difference between MySQL and PostgreSQL,?
Best of luck 👍
@@RishabhMishraOfficial can you please share pdf file
@@mahakgarg3152there are not really any difference between them. Both are database management softwares used for create, manipulate and store the data
Hi Rishab bhai, thanks for spreading knowledge. Here is the quick assignment of 01: Select | from | where | group by | having | order by | limit
I would say I really appreciate the 2:34:44 hours long free tutorial! People like you make it possible for me to learn for free.
One of the best course series i have ever seen. So clearly and neatly explained and organised with definition, syntax and example practise most important with the pdf document can be kept as notes.
Thanks for the video it helped me a lot to understand and follow SQL.
I'm glad it was helpful! 🙂
The best SQL video in UA-cam that I have ever seen. Your explanation make SQL very easy. I really appreciate your hard work. Thanku Mr. Rishabh😊
Glad it was helpful! ✅️
Really sir apki video dekhkar bilkul bhi dar nahi laga SQL se ❤🎉 it's amazing and your explanation is very nice
Thanks sir😊
ust 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 !!! 😀
Glad you liked it ✅️ n awesome you completed it.. keep learning n keep growing 🚀
Rishabh you have made very crisp, point to point an awesome video. You are contributing alot to my data analyst journey. Thanks. Make such video on Power Bi and Python too if possible. regards.
Glad you liked it ✨️ n noted ✅️
Thank You Sir ji
Me interview me ye apka video padh kr gya tha or me select ho gya.
Thank you so much.
Shukriya rishab thanks a lot... you rock... tum bahot zabardast insaan ho. World needs people like u. Sab sey achi baat yeh hai k tumne yeh videos hindi mey banayi hai !
Glad you liked it ✅️
One thing i noticed that while using ALTER TABLE command to add column, we must add data type otherwise error will occur;
ALTER TABLE customer
ADD COLUMN address varchar(100);
Hello Rishabh, I'm a non-IT professional who has just begun learning SQL, and your videos and explanations have been extremely helpful. I'm making a comment in the middle of your videos. Thanks for your hard work :)
Thanks n i m glad that it was helpful ✅️
hey, have you completed sql ? how much time does it took ?
Started many sql courses but never completed until I found this. Kudos Rishabh Subscribed..!
Glad it was helpful ✅️ n welcome aboard 🚀
Thank you so much for this course sir, You are great ❤❤❤lots of love....keep posting such videos for data analyst ❤
Glad you liked ✅️
Hello Rishabh,
This is the first time when I'm learning SQL and it's been complete delightful learning experience. Thank you for sharing all the knowledge with so candid way, it actually helps to learn more. Please be the same person/teacher you are bcoz you're Awesome :) Keep helping and stay blessed always :)
Wishing you all the success and all the good wishes...!!!
Quick Assignment 1:
Order of Execution: SELECT, FROM, LIMIT, GROUP BY, HAVING, ORDER BY.
Glad you liked 👍
Order of execution is: from where group by having select order by limit
@@RishabhMishraOfficial Thank you Rishabh :)
@@RishabhMishraOfficial but select come first na?
@@unfiltered_anshika coming first is not executing first from clause executes first
Why select is coming after.not on first in select table? Can you please clarify
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.
Glad it's helpful ✅️
Hello Rishabh,
I recently progressed for Google's Data Analytics Apprentice role and your videos helped me on the way a lot. They boosted my confidence and helped my understanding of Data Analytics better.
Just wanted to thank you for your efforts !!!
Excellent 👍
Nice explanation....Thank you for such content..I must say most underrated tutor..keep going sir
Thats So nice of you 🙌
i am so lucky i got you as my teacher
thank you so much sir
Glad you liked the content ✅️
Alhamdullilh.....thanks my friend 🎉❤
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.
Glad you liked the content ✅️, all the very best for your future endeavors ✨️
Ever since I joined your journey at the humble mark of 700 subscribers, witnessing your growth has filled my heart with boundless joy. 🥳🥳The knowledge I have gained through your captivating videos has enriched my life beyond measure, leaving an indelible mark of gratitude and appreciation.👍
Glad you liked the content n it's helpful 🚀
You're great Sir! For your amazing way of learning . Your teaching concepts are very smooth and easy to understand for beginners. You are always be in our hearts for your kind services. Thank You.
Glad it was helpful ✅️
Its really helpfull. I completemy 1st year in 2 hours.aand i like your *phir ye bhadak jayega*.😊
Keep learning n keep growing 🚀
bhai abhi sirf 10 min hi howye video dekhty howye....bro i salute. what a clearity of explanation. Salute your effort bro. Best work !
Glad you liked it ✅️
Great content. Thank you.
Suggesting this content to People across domains.
People who are preparing for government jobs should learn the free skills from UA-cam and try to keep themselves busy.
Skills acquired in the process can help them sustain in the long run if things didn't turn in favour.
Great suggestion! 👍
Oder of execution in SQL : FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY, LIMIT
What about "Offset"?
I am unable to write properly Select query with full syntax but this course is helpful, I am working as SAP ABAP consultant , ABAP is basically SQL Queries to fetch data from the database dictionary.
This is the only series I've watched all the way through. Thank you! ❤ I hope you leave a comment, please.
Glad you liked ✅️ keep learning n keep growing 🚀
today morning 7 am i was so stressed with job switch and morning i saw ur first video of roadmap to DS. I did this course with money and no placement... regretted..
today i have started with your guidance again with 100 days challenge to again revise everything and get new job...thanks and ur amazing already subscribed
Glad it was helpful ✅️ and all the very best brother 👍
@@RishabhMishraOfficial Thank you..and I will refer to your videos.
hey, have you completed sql ? how much time does it took ?
Rishabh Bhai, you deserve so much love, respect n blessings for sharing knowledge. Your quality of explanation is second to none. 👏👏 Someone from non IT background like me is enjoys your videos so much. Keep up the great work.
Glad you liked it ✨️ and all the very best brother 👍
@@RishabhMishraOfficial dear bhaiya is this video of sql 2.5 hour video is enough for data analyst . plz lrt me know.
Hii sir i am graduate but not well in English and also not it background so how to certifide in sql and power bi and also how to get dream job
🖐
@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;
thank you so much rishabh bhaiyya
thanku
Glad you liked ✅️
OMG......Rishabh, your channel has the full potential of reaching at least 1 million subscribers very soon, Keep the good work ON. You made it so much easy and understandable for even non-IT background individuals. Please make such video on POWER BI as well
Really appreciable so much of clearance for SQL ..Good for beginners. Thanks for providing such videos youtube as well as sir 🎉
Glad you liked it ✨️
The concept of giving notes and making things easy so that we can devote more time in learning rather than making notes was best 👍🏻👍🏻
Glad you liked ✅️
select > from > group by> having > where > order by > limit
Rishabh Bhai you're the ideal explanation of how a human should be = "Humble and Kind". And people might've ignored this line but I ain't i.e "Khud se pucho ki shuru kyu kiya tha, career mei kuch bada karna hai" . Thanks for helping us all.
Awesome 👌 Keep learning n keep growing 🚀
1) SELECT
2) FROM
3) WHERE - AND
4) GROUP BY
5) HAVING CLAUSE - AND
7) ORDER BY
8) LIMIT
Thanks
Is this answer 100% correct?
have you cross-checked it?
@@aryankhatri1545 yes its correct, as it is answer hai jo video mei sequence diya hai.
this is wrong order of execution. The correct order is: From, where, group by, having, select, order by, limit
@@sanyarastogi9205 aap SQL ya DBMS nhi IT field hi chd do
Last one was Epic "Congratulations you Completed Course Successful" 😅🎉
Glad you liked it ✅️ n congratulations on completing the course 👏
@@RishabhMishraOfficial Thank you So Much❣️
Salute hai ...aise teacher ko ...kash itna gyaan engineering colleges mai dete toh india kaha se kaha pohoch jata...really so help full for begineers who are learning from scratch that too (full practical)... Aise teachers ko bharat ratna milna chahiye ..they are the real heroes of the society to serve the youth that too for free...keep it up sir aur bhi ache beneficial videos lekar aye for data analysts freshers to become experts one day 💐💯😇💞☺️
Glad you liked ✅️
Keep learning n keep growing 🚀
Hello sir I am from Pakistan I learned sql from your videos I benefited a lot your explanation style is very awesome
To remember SQL sequence here is a simple mantra. Just remember the following sentence
"Some French Waiters Grow Health Oranges",
now remember the first letter of each word of the sentence.
S = Select, F = From , W = Where, G = Group By, H = Having , O = Order by.
Hope it helps.
Thank you sir
Because of your cours I got my first job
( Special your join functions diagram )
Where did you got the job bro
Sir app kya sikhate ho main fan ban gaya apka. 1st video maine apka power bi dekha tha
Glad you liked ✅️
Greate video, Honestly Just pure content 💯No faltu ki baate
Thank you Rishabh bhai🔥👌 Thank you for providing Notes.
Request : Please bring One Single video on SQL question For interviews.
Coming this Saturday , watch it n let me know your thoughts in comment 👍
@@RishabhMishraOfficial Thank you bhai 🤩🙏
Hello Rishabh, I am Rohit from non IT background who has just started learning SQL, the way you taught is really awesome. It would be great if you can provide an input in one small query that "from where did you copy the data which you paste in table query"? at video time 21.17
although I have learnt the same way through right click on table then click on create the table
Aage kya krne vaale ho bhai
hey, have you completed sql ? how much time does it took ?
Hi Rishabh,
I have checked lots of material in UA-cam for SQL but this one of the best channel i have found. really appreciate your effort ,simplicity and dedication. Keep it bro 👍👍 Love from bangladesh
Glad you liked it ✅️
I found the right recording on right time....really helped me a lot...thanks sir🙏
Glad you liked
One of the best SQL course ❤️
Sir.what is the freshers salary of python Full stack developer....
Hi Rishabh, Thank you so much for the video. I had scrolled a lot of videos but your video tuned up in a perfect manner with me because of your teaching and explaining style. thanks a lot for this. even by paying on Udemy or anywhere, can get this quality content.
Glad it helped ✅️
Keep learning n keep growing 🚀
Really appreciate your effort
Glad it was helpful ✅️
Really a great mentor. Hats off to you, Sir. Rishabh Mishra.
Glad you liked it ✅️
Your teaching ability is on a next level❤
Glad you liked it 👍
Such a appreciating work done by you sir... We are very thankful to you for providing the better quality of source of education to enhance the skills... 🙌
Glad you liked it ✅️
your teaching is very understandable. thanks for that.
I absolutely love how you have the course setup like a PowerPoint. Do you have an English version so that I can understand when you explain a bit on each slide? Thanks 😊
No, sorry.. currently i make videos in Hindi language but yess in future will start a English channel if there will be demand 👍
@@RishabhMishraOfficialWe want videos in English too.
@@nandini0328 then learn Hindi cuz English is the Anglo white Christian missionary colonizers' language whereas Hindi is indigenous to India than english so it's better if y'all (South Indians ) must learn Hindi , speakin' out one of the indigenous product of Bharat is way much better than speakin' out in a language (english) which is foreign to Bharat/Indic civilization
@@nandini0328 then prefer Hindi anytime, you didn't understand anythin' what I meant
1) SELECT
2) FROM
3) WHERE
4) GROUP BY
5) HAVING
7) ORDER BY
8) LIMIT
I think limit will come before order by
@@disharighosh4859 no limit will come at last
@@disharighosh4859limit at last so we can limit according to requirement of rows
sql was always scary for me. thanks for the video. i absorbed 90% at once and it made me interested in sql aswell
Glad I could help! ✅️
Keep learning n keep growing 🚀
very helpful session🤩🤩loved that cleared all the concepts😇thanksssss...
Glad it was helpful ✅️
Wow, your content is so easy and useful, thanks a lot man, Thank you 🤩
Glad you liked it ✨️
Assignment 1:
Order of execution in SQL is
SELECT, FROM ,WHERE, GROUP BY, HAVING, ORDER BY, LIMIT
In SQL, the order of execution for a typical query follows these steps:
1. FROM: The query retrieves data from the specified tables or views.
2. WHERE: Conditions are applied to filter the rows based on specified criteria.
3. GROUP BY: The result set is grouped into subsets based on the specified columns.
4. HAVING: Conditions are applied to filter the groups based on specified criteria.
5. SELECT: The columns to be included in the result set are selected.
6. ORDER BY: The result set is sorted based on the specified column(s).
7. LIMIT: The number of rows in the result set is limited.
@@sarthakjaiswal4724 exactly brooo everyone here in the comment section is just commenting the order same as in question but order by pehle ayega ki select ?
@@adityashekharsingh2669 select will come before order by
@@sanyarastogi9205 yup
So comprehensive even for Dummies to learn SQL. Thank you Brother!😄
Glad it was helpful! ✅️
Awesome video..any layman can understand the SQL the way you are explaining. Thank you so much for this video!!
Glad it helped! ✅️
Thanks for this informative session mate.. Really appreciate it.. 🙏👍
Glad it was helpful! ✨️
First of all Thank you Rishabh Sir,
you are giving free content on youtube its helpfull for me .when i watched your videos my confidence build too much.lots of love ❤❤❤❤❤❤
Very good explanation and simple language
Glad you liked ✅️
HOW CAN SOMEONE BE SUCH AN AMAZING CREATOR IN THE ERA WHERE EVERYONE IS BEHIND SELLING THEIR COURSES??
Glad you liked the content ✅️
Bhaiya ek solid sql project wala video mil jaaye toh maza aa jayega 🙂
Okayy noted ✅️
Assignment 1
SEQUENCE -1)SELECT
2)FROM
3)WHERE (It comes with Select)
4)GROUP BY
5)HAVING- (It comes with Group by and always placed after the GROUP BY clause)
6)OREDER BY
7)LIMIT
Sorry it's incorrect, pls check sql interview questions playlist for correct answer n detailed explanation
I think it's correct
just following your Business analyst roadmap. Now After Excel i am hear to learn SQL 🔥
Happy to hear that! 😊 keep learning n keep growing ✅️
Thankyou Rishabh , You have explained SQL in the easiest way possible. 5 /5 Rating for this tutor.
Glad you liked it ✅️
Thank you bro, for putting in so much of efforts and making SQL topic easy... this is only time was I was able to completely understand all SQL pointers mentioned. God Bless you bhai :)
👏🙌
hey, have you completed sql ? how much time does it took ?
1:05:11 assignment 1 ,the correct sequence is select, from , where , group by, having, order by , limit
In SQL, the order of execution for a typical query follows these steps:
1. FROM: The query retrieves data from the specified tables or views.
2. WHERE: Conditions are applied to filter the rows based on specified criteria.
3. GROUP BY: The result set is grouped into subsets based on the specified columns.
4. HAVING: Conditions are applied to filter the groups based on specified criteria.
5. SELECT: The columns to be included in the result set are selected.
6. ORDER BY: The result set is sorted based on the specified column(s).
7. LIMIT: The number of rows in the result set is limited.
How to Clone an SQL Table: Step-by-Step Guide
Welcome to our SQL tutorial series! In this video, we’ll walk you through the process of cloning an SQL table. Whether you need to copy a table's structure, data, or both, we’ve got you covered with detailed instructions for MySQL, PostgreSQL, and SQL Server.
#AnalyticsBattle #ExcelVsPowerBI#SQL #DatabaseManagement #WiFiLearning #TechSkills #DataManagement#DataAnalysis #TechSkills #WiFiLearning #CareerGrowth #DataAnalytics#DataDistribution #WiFilearning #KnowledgeSharing #DigitalTransformation#DataScience #DataAnalysis #CareerPaths #WiFiLearning #TechEducation#Polymorphism #JavaSkills #OOP #WiFiLearning #TechAdvantage#DAX #DataAnalytics #WiFiLearning #TechSkills #ExcelTips#CareerBoost#WiFiLearning #ExcelMastery #ProductivityBoost #DataAnalytics #WiFiLearning
👇👇
ua-cam.com/users/shortstr2Zvp8-qto?feature=shared
📧 Stay Connected:
• www.wifilearning.com • info@wifilearning.com •
Facebook - facebook.com/wifilearning0 •
Instagram - instagram.com/wifi_learning/ •
Linkedin - www.linkedin.com/company/7956803/admin/feed/posts/
Thank you for watching, and happy learning!
You are a good teacher .You taught SQL in the easiest way. I am from non tech background but i learnt very well from your video . Thank you so much sir😊🙏
Please help me to get data from one SQL server view to another SQL server and data will update automatically
Server’s are not connected ! So you can only see those data which is in server that you are operating ! If a server can be accessible by another server then it’s a security bug which call ! Business logic and error or cross site scripting (xxs) !
Rishabh Sir, you are awesome. You make learning sth difficult so easy! I'm learning SQL for the first time and before coming across your video I was very apprehensive about the topic! Thank you for enriching us learners by sharing knowledge in such an honest way :)
Glad it was helpful ✅️
@@RishabhMishraOfficialis the above lecture about 2 hours is sufficient for becoming a data analytics.
Order of execution in SQL is SELECT, FROM , WHERE, LIMIT, GROUP BY , HAVING , ORDER BY
finally completed with exercise thanks sir for your valuable content.
Awesome 👌
This is enough for data analyst??
Sir is this SQL course enough for data analyst role?plz reply
Yess absolutely 💯 after this course just practice sql interview questions
FROM, WHERE , GROUP BY , SELECT , HAVING , ORDER BY , LIMIT
It's Query function