SQL Advanced Tutorial | Advanced SQL Tutorial With Examples | SQL For Beginners | Simplilearn
HTML-код
- Опубликовано: 9 июл 2024
- 🔥 SQL Certification Course - www.simplilearn.com/sql?...
🔥Post Graduate Program In Data Analytics: www.simplilearn.com/pgp-data-...
🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): www.simplilearn.com/iitk-prof...
🔥Caltech Data Analytics Bootcamp(US Only): www.simplilearn.com/data-anal...
🔥Data Analyst Masters Program (Discount Code - YTBE15): l.linklyhq.com/l/1yhwh
This video on SQL Advanced Tutorial will help you learn the important advanced SQL queries for performing complex operations. Advanced SQL Tutorial With Examples will help you learn how to write subqueries and stored procedures. You will get an idea about triggers and views in SQL. Finally, we'll explore some of the important window functions in MySQL.
Following are the topics covered in this SQL for beginners video:
00:00:00 SQL Advanced Tutorial
00:11:19 Stored Procedures
00:28:05 Triggers in SQL
00:35:36 Views in SQL
00:44:25 Windows Functions in SQL
Dataset Link - drive.google.com/drive/folder...
✅Subscribe to our Channel to learn more about the top Technologies: bit.ly/2VT4WtH
⏩ Check out the SQL training videos: • SQL Tutorial Videos🔥[2...
#SQLAdvancedTutorial #SQLTutorial #SQLTutorialForBeginners #SQLCourse #SQLTraining #SQLForBeginners #SQLCourse #SQLTraining #Simplilearn
➡️ About Post Graduate Program In Data Analytics
This Data Analytics Program is ideal for all working professionals and prior programming knowledge is not required. It covers topics like data analysis, data visualization, regression techniques, and supervised learning in-depth via our applied learning model with live sessions by leading practitioners and industry projects.
✅ Key Features
- Post Graduate Program certificate and Alumni Association membership
- Exclusive hackathons and Ask me Anything sessions by IBM
- 8X higher live interaction in live online classes by industry experts
- Capstone from 3 domains and 14+ Data Analytics Projects with Industry datasets from Google PlayStore, Lyft, World Bank etc.
- Master Classes delivered by Purdue faculty and IBM experts
- Simplilearn's JobAssist helps you get noticed by top hiring companies
- Resume preparation and LinkedIn profile building
- 1:1 mock interview
- Career accelerator webinars
✅ Skills Covered
- Data Analytics
- Statistical Analysis using Excel
- Data Analysis Python and R
- Data Visualization Tableau and Power BI
- Linear and logistic regression modules
- Clustering using kmeans
- Supervised Learning
👉 Learn More at: www.simplilearn.com/pgp-data-...
🔥Caltech Data Analytics Bootcamp(US Only): www.simplilearn.com/data-anal...
🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688
🔥Post Graduate Program In Data Analytics: www.simplilearn.com/pgp-data-analytics-certification-training-course?SQlAdvancedTutorial-M-55BmjOuXY&Comments&
🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): www.simplilearn.com/iitk-professional-certificate-course-data-analytics?SQlAdvancedTutorial-M-55BmjOuXY&Comments&
🔥Caltech Data Analytics Bootcamp(US Only): www.simplilearn.com/data-analytics-bootcamp?SQlAdvancedTutorial-M-55BmjOuXY&Comments&
🔥Data Analyst Masters Program (Discount Code - YTBE15): www.simplilearn.com/data-analyst-masters-certification-training-course?SQlAdvancedTutorial-M-55BmjOuXY&Comments&
Superb tutorial, thanks for not wasting time and getting straight to the points.
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
Really appreciate the tutorial for making it short and simple,
Thank you for the wonderful video!🤞
Amazing video sir thankyou for this video
The video was amazing and on point. Thank you!
We're thrilled to have been a part of your learning experience, and we hope that you feel confident and prepared to take on new challenges in your field. If you're interested in further expanding your knowledge, check out our course offerings in the description box.
Very knowledgeable session and clear concept explanation !
Glad you liked it
this lesson is indeed teachible
It's a great lecture. Thank you! 🥰
You're most welcome!
Super vedio bro. First Time i am watching complete depts concept of advance sql query. I think this is my first advance sql vedio . tanks for giving for valuable wonderful vedio ,
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
Great materteral, thanks
Our pleasure!
Amazing content with superb explanation
Thanks a ton
Really helpful, Thanks
Glad it was helpful!
Thanks so much for the tutorial, learnt alot..
You're very welcome!
Very useful. Thank you very much!
Glad it was helpful!
Great Video Thank You!
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
simple easy to understand and well made .thank you
Glad it was helpful!
Thnk yousir u clear my douts
Our pleasure
Thanks for this Video. It would be nice if you added scripts to create the databases in the google drive link available in the description, as it only contains the dml syntax.
Please look into this to enable us to practice along with you.
Excellent explanation
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
Thanks & long live youtubers
Always welcome
Ready to learn
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
In 'partition by' example, it was total salary by department not the highest salary of some employee in that department.
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
Yeah you're correct, came to see if anyone commented this.
You are awesome!!! Please provide the db because the link is broken. Thanks!!
very informative
We are delighted to have been a part of your learning journey! If you want to continue honing your skills and keeping up-to-date with industry trends, check out our course offerings in the description box.
The video is very informative sir,the concepts are very clear ...thanks a lot!!! (P.S- please improve your typing accuracy :"))
Thank you for choosing us as your learning partner. We are thrilled to hear that you enjoyed your experience with us! If you are looking to expand your knowledge further, we invite you to explore our other courses in the description box.
can you please come with statistical query such us lead lag rank etc which are required for Data Analysis?
Hi, Simplilearn provides online training across the world. We would be happy to help you regarding this. Please visit us at www.simplilearn.com and drop us a query and we will get back to you! Thanks!
Hi!
Thank you so much for such a powerful and explanatory video.
Pls, how can I get the data set used for this tutorial?
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
Check out at 11:00 the query result should list price less than 100, however it is not, can you please review and confirm?
There's no dataset in the description.
all you've put is few commands that you are using in the video.
where's the dataset?
how am i supposed to practice it without dataset?
the first line in the txt file in the link is a select statement.
how am i going to run a select statement if i don't have the tables?
Nice video. Would be nicer if your workbench wasn't zoomed in 300%
We're thrilled to have been a part of your learning experience, and we hope that you feel confident and prepared to take on new challenges in your field. We thrive to improve with your suggestions. If you're interested in further expanding your knowledge, check out our course offerings in the description box.
Hi, could you please share the scripts for insert into table, for the tables which you are using in the database. It would be really helpful ,otherwise i have to create the tables manually.Also the file you have uploaded in description box, in that there is not insert into scripts.
Thanks for the notification. We will update the required script in the description as soon as possible.
very nice
Thanks
Thanks for such educating tutorial
Please send us the required dataset used in this tutorial
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
sir this total salary is highest salary or sum of the all employees salary working in same department please comment
Should have explained all the triggers with examples.
Hey ,We'll go into these implementations in detail in another video. Stay tuned!
Nice video! can I please get the dataset?
Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.
where can I find the dataset? I only see dml
Hi Simplilearn! Can you please send me the database in a ZIP or BAK file, used in this course??
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@@SimplilearnOfficial There is no such data set
Hello, nyc explanation can i get the dataset ?
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
Amazing content can I have the dataset used in this video
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
hi great tutorial, can you please send the database file, or share it in google drive
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
Sir could you please share the databases which you have used in this course.
Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.
@@SimplilearnOfficial ashitoshsingh46@gmail.com
@@SimplilearnOfficial harshagupta2608@gmail.com send to me too
Industry using advanced queries
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
Please share the database with the tables and relations created file
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
Sir can you please provide the database you have used in this view?
Thanks in Advance
Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.
nishantmotghare2013@gmail.com
@@SimplilearnOfficial shivangbelwariar1@gmail.com Can you please send all the files to this id too. Thank you
Hi may i please have the dataset as well Thank you!!
Hi can you please share dataset used in video
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
would you provide me files that i can practice.
Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.
@@SimplilearnOfficial i too need data set can you send me to this email madhubala164@gmail.com
Hi, Can you please provide the datasets over my email. Would like to keep my email hidden.
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@@SimplilearnOfficial Hi. There is no dataset in the link enclosed in the description. There is only a file with SQL code you perform on the video. Could you please share also Dataset to the Google Drive? Thank you in advance.
Hi, please give the data set link
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
could you share the database?
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
how can i find the dataset?
Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.
@@SimplilearnOfficial Hey can you please send the dataset to muzammildude@gmail.com?
Windows function is not completely clear
Thank you for bringing this to our attention. We’re sorry you had a bad experience. We’ll strive to do better
From where I can download the sql_iq database ???
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
Where is database files ?
Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.
@@SimplilearnOfficial shaikhhaya09@gmail.com
Please send me data set used in this tutorial
Keep my email hidden please
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
Why using MySQL while title is SQL 🙄🙄🙄
SQLS not SQL
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
OMG, this guy makes too many mistakes when he is typing. It is really distracting. Thanks for the work tho
Thank you for bringing this to our attention. We’re sorry you had a bad experience. We’ll strive to do better
would you provide me files that i can practice.
Hello, thanks for viewing our tutorial. It would be helpful if you will provide your email ID to us so that we can send the requested dataset promptly. On the off chance that you need your email ID to be kept hidden from others, we can do that too. Hope that helps.
@@SimplilearnOfficial please email me to cerol.dwen@gmail.com
Thank you
animeshbonny@gmail.com, thanks in advance.