SQL Tutorial for Beginners | Full SQL Course In Hindi
HTML-код
- Опубликовано: 9 июл 2024
- 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: bit.ly/3rbqpkB
👍 Subscribe for more SQL tutorials like this: bit.ly/3Fc7Gc6
👉 GitHub link (all files): 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: / rishabhnmishra
LinkedIn: / rishabhnmishra
Twitter: / 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: • Data Analyst- Skills, ...
Excel Course: • Excel for Beginners | ...
➖➖➖➖➖➖➖➖➖➖➖➖➖
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!
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.
Thank you! If anyone says s/he wants to lean sql, I'll recommend this video!! Great.
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! 🌹💐
Rishabh bhai apne bhi itna help nahi karte , jitna aap kiye ho abhi tak thankyou.
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?
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
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😊😊😊❤❤❤
Hi Rishab bhai, thanks for spreading knowledge. Here is the quick assignment of 01: Select | from | where | group by | having | order by | limit
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! ✅️
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 🚀
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 🚀
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 ❤😊
Hi Rishabh,
I feel privileged to RUclips 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
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...
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 ✅️
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.
Hi Rishabh,
I have checked lots of material in RUclips 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 ✅️
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
Really sir apki video dekhkar bilkul bhi dar nahi laga SQL se ❤🎉 it's amazing and your explanation is very nice
Thanks sir😊
select > from > group by> having > where > order by > limit
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
The best SQL video in RUclips that I have ever seen. Your explanation make SQL very easy. I really appreciate your hard work. Thanku Mr. Rishabh😊
Glad it was helpful! ✅️
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! 🙂
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 🚀
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 ✅️
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 ✅️
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 🚀
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 ✅️
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.
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
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 ?
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 ✅️
Hi Rishabh,
I have checked lots of material in RUclips 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 ✅️
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);
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
🖐
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 🚀
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 ✅️
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
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 ✨️
A BIG thanx to you Rishab for helping me understand SQL topics in a very easy-to-understand way. I had attended many classes previously but none of the classes were close to what you have taught. Thank you so much...God bless you!!!
Glad you liked ✅️
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 👍
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 ?
Nice explanation....Thank you for such content..I must say most underrated tutor..keep going sir
Thats So nice of you 🙌
Boss , finally my first content that i was able to complete in a whole decade . Thankful to your simplicity . Looking forward to a one on one session or a quick call, please let me know , if it can be a google meet , zoom or skyp call , it would be really really helpful
Hi Rishabh. you are amazing. Your style is understandable. keep it up
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 ✅️
Great content. Thank you.
Suggesting this content to People across domains.
People who are preparing for government jobs should learn the free skills from RUclips 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! 👍
Awesome video..any layman can understand the SQL the way you are explaining. Thank you so much for this video!!
Glad it helped! ✅️
Started many sql courses but never completed until I found this. Kudos Rishabh Subscribed..!
Glad it was helpful ✅️ n welcome aboard 🚀
One of the best SQL course ❤️
Sir.what is the freshers salary of python Full stack developer....
Thanks for this informative session mate.. Really appreciate it.. 🙏👍
Glad it was helpful! ✨️
Fantastic explanation Rishabh, I am new to SQL and went from Chapter 1-3..Your explanation is very crisp and easy to understand. Keep it up. I have subscribed to channel
Glad you liked ✅️
Welcome aboard 🚀
Best lecture on SQL.. Sir, You make concepts easy to understand with good and easy examples.Thank you very much sir💐🙌
Wow, your content is so easy and useful, thanks a lot man, Thank you 🤩
Glad you liked it ✨️
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 🚀
You made SQL easier Rishabh... Hats off to You 🙌✌ U hv Great teaching skills.. Keep Going Brother 😎 Wishing you all the very very Best 👏👏
Glad it was helpful ✅️
Hello Rishab,
This is by far the best video I found on SQL with simple and detailed explanation although I didn't quite get some of the advance topics discussed in the end like window functions and CTEs. I guess I have to work on them. Thank you very much for sharing your knowledge and I really appreciate for contribution for people of Non IT and aspiring data analyst. Keep up the wonderful work.
Your teaching ability is on a next level❤
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 ✅️
Perfect video for beginners Thank you
I really appreciate ur effort...first time I was able to complete such a lengthy technical video..with proper understanding..keep it up..we will keep on supporting u for such valuable content.
That's awesome 👌 Keep learning n keep growing 🚀
Also, complete the sql interview questions playlist from this channel
i am so lucky i got you as my teacher
thank you so much sir
Glad you liked the content ✅️
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 🤩🙏
Fantastic tutorial , I watched it once and now watching it again after installation and will be practicing now. I hope you do good and would like to thank you for the fantastic working
Glad it was helpful! ✅️
Thank you so much the complete course sir.. every good explanation.
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 ?
Hello sir I am from Pakistan I learned sql from your videos I benefited a lot your explanation style is very awesome
Thank You Sir ji
Me interview me ye apka video padh kr gya tha or me select ho gya.
Thank you so much.
Very Very Useful and Easy to learn tutorial.. Thank you Rishabh 😊
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
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 ?
I really thanking you for providing such a informative series. I Completed my Series in 2 weeks by gaining lots of knowledge of Sql. Thankyou so much keep it up👍
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 🚀
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.
Oder of execution in SQL : FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY, LIMIT
What about "Offset"?
Alhamdullilh.....thanks my friend 🎉❤
Wonderfull father of SQL Thanks a lot
Last one was Epic "Congratulations you Completed Course Successful" 😅🎉
Glad you liked it ✅️ n congratulations on completing the course 👏
@@RishabhMishraOfficial Thank you So Much❣️
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 ❤❤❤❤❤❤
@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 for being an exceptional instructor and for sharing your knowledge with such enthusiasm.
Glad you liked it ✅️
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
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
Really a great mentor. Hats off to you, Sir. Rishabh Mishra.
Glad you liked it ✅️
Thanks Rishabh for explaining everything in single video, it's really helpful..😊😊
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
Bhaiya ek solid sql project wala video mil jaaye toh maza aa jayega 🙂
Okayy noted ✅️
Really clever explanation and no unnecessary verbiage! Respect! + subscription
Glad you liked it ✅️ welcome aboard 🚀
select > from > where > limit > group by > having
can limit be at the end?
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
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) !
Thank you so much for this one brother, perfect one to revise all the important concepts of SQL with practical examples :)
Glad it was helpful! ✅️
So comprehensive even for Dummies to learn SQL. Thank you Brother!😄
Glad it was helpful! ✅️
bro what's the maximum pay for a fresh Data Analyst can get as of now?? who has completed all 5 syllabus (python, SQL, statistics, excel and power bi) ♦️♦️ let's assume the student has thoroughly completed everything
Avg starting salary for Data Analyst will be around 7-9 LPA (easily)- this is minimum
@@RishabhMishraOfficial can u name some companies please 🙏🙏🙏
Python and power BI from which platform you've done.
Assignment:
EXECUTION FLOW IN SQL
1.FROM
2.WHERE
3.GROUP BY
4.HAVING
5.SELECT
6.ORDER BY
7.LIMIT
I think SELECT should come first let me know Rishabh if I am wrong
@@user-pz3pd5yh8i
1 FROM Tables are joined to get the base data.
2 WHERE The base data is filtered.
3 GROUP BY The filtered base data is grouped.
4 HAVING The grouped base data is filtered.
5 SELECT The final data is returned.
6 ORDER BY The final data is sorted.
7 LIMIT The returned data is limited to row count.
Rishab thank you. Completed the SQL tutorial. Great job. Better than many paid 12hrs Udemy courses. Requests for future videos -
1. Create a similar 2:30 hr video for Machine Learning in Data analytics.
2. 2-hour video for basics of stats asked in Data analytics interview.
3. More advanced level python projects in data analytics using Machine learning.
4. 1-2 hr video on guesstimates asked in Data analytics/business analytics interviews.
Yess these videos are in pipeline 🚀
Thanks a lot brother , literally helped me understand SQL so well . Please keep providing your videos on other data science skills .
Glad you liked ✅️
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
Hi Rishabh Bhaiya,
Thank you so much for this amazing course. Initially, I was scared of SQL, but this course made it easy! Now, I'm able to solve the SQL problems confidently.
Glad it helped ✅️