🔥Data Scientist Masters Program (Discount Code - YTBE15) - www.simplilearn.com/big-data-and-analytics/senior-data-scientist-masters-program-training?AA7i2GcTGwU&Comments&TH-cam 🔥IITK - Professional Certificate Course in Data Science (India Only) - www.simplilearn.com/iitk-professional-certificate-course-data-science?AA7i2GcTGwU&Comments&TH-cam 🔥Caltech Post Graduate Program in Data Science - www.simplilearn.com/post-graduate-program-data-science?AA7i2GcTGwU&Comments&TH-cam 🔥Brown University - Applied AI & Data Science - www.simplilearn.com/applied-ai-data-science-course?AA7i2GcTGwU&Comments&TH-cam
After checking 8 course finally landed here …..thanks to simplilearn team for 1. Explaining SQL really from scratch so here I would recommend to beginners to go with this course 2. A big thanks to team for not only this course but many more courses are free Keep doing good works ….lots of love & best wishes to the team
I love you Simplilearn team, you all have saved my life. I have DBMS exam tomorrow, my teacher couldn't taught me and others properly and I haven't understood. He interpreted us in English, even you've used the same language but your teaching skills is way more better. (Your new subscriber)
So much of extremely useful and valuable information just for free ! I am glad that I came across this channel and saw the video. I am also glad to say that I cleared my interview of a data analyst, and this course helped me a lot while answering SQL based questions. Thanks a lot and kuddos to the team for uploading this video. Just one request, I really wanted the whole dataset which was used in classic models.
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.
Free 8 hours video!!!😍 you guys are awesome and love. It's a great help for middle class people like us. We are few friends watching this video together and exploring other videos.❤️❤️❤️
We are glad you found our video helpful. Like and share our video with your peers and also do not forget to subscribe to our channel for not missing video updates. We will be coming up with more such videos. Cheers!
Thank you for the appreciation. You can check our videos related to various technologies and subscribe to our channel to stay updated with all the trending technologies.
Thank you for the appreciation. You can check our videos related to various technologies and subscribe to our channel to stay updated with all the trending technologies.
Thank you for the appreciation. You can check our videos related to various technologies and subscribe to our channel to stay updated with all the trending technologies.
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.
This is one of the best videos to learn sql from basic to advanced. Thank you so much sir , for givng us such a wonderful session. Sir, I request you one thing , can you tell me how can i get the data records and tables which you used in this video so we practice alot. thanks sir.💥💥💥💥💥
We are glad you found our video helpful. Like and share our video with your peers and also do not forget to subscribe to our channel for not missing video updates. We will be coming up with more such videos. Cheers!
Hey, thank you for appreciating our work. We are glad to have helped. Do check out our other tutorial videos and subscribe to us to stay connected. Cheers :)
Q. Find employee I'd,name from employee table who has lesser exp thn avg and lesser salary thn avg. For this why can't we use this query? Select emp_id,emp_name from employee where exp_in months
We are glad you found our video helpful. Like and share our video with your peers and also do not forget to subscribe to our channel for not missing video updates. We will be coming up with more such videos. Cheers!
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.
Your satisfaction is our top priority, and we're thrilled to hear that you had a positive learning experience with us! If you're interested in pursuing additional learning opportunities, we encourage you to take a look at certification courses in the description box.
Hi, I am stuck at 27:15. When I enter the command show databases, I can’t find the database with world in it. So I am unable to continue coz I ant have world to work with. Could you help me please. Thanks
1:29:00 Can you also have SELECT salary, dept, FROM TABLE_NAME WHERE salary >( SELECT avg(salary), dept FROM TABLE_NAME): Obviously, this is without group by and having. Is this also possible for selecting department that have average salary
Thank you for the appreciation. You can check our videos related to various technologies and subscribe to our channel to stay updated with all the trending technologies.
@@SimplilearnOfficial Thanks simplelearn. I all ready downloaded that files but in discretion data set orders, order dates.....etc table data set is not present.
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.
Thank you for the appreciation. You can check our videos related to various technologies and subscribe to our channel to stay updated with all the trending technologies.
Thank you for the appreciation. You can check our videos related to various technologies and subscribe to our channel to stay updated with all the trending technologies.
Tq sir for your explanation sir could you please tell me how to give identity property using stored procedure without giving identity property in table
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.
SQL video tutorial was very helpful and easy to learn. I downloaded it from google drive it has only the first one-hour data set. I need the entire dataset to practice. I'd greatly appreciate it if you can share the entire dataset in the 8 hours video. Thank you
@@SimplilearnOfficial I could see the dataset for only the first one-hour video in the google drive folder (Kennet Rajan K J). However, I am looking for the remaining datasets from the video time 1:15:00 onwards. This will be more helpful to practice. Thank you again for your kind reply.
In subquery section - for update and delete subquery why do we use different tables name in the sql statement. Delete from employees where age in ( select age from employees_b where age> 30); here employees and employees_b two tables used
1 hr:25 min :--- Instead of using ---> select c.product_id, sum((s.sell_price - c.cost_price)*s.quantity) as profit.... here instead if i use ---> s.product_id does it make any change. Because both are same id values. someone please answer this....
Apologies for the inconvenience, we cannot directly provide attachments or files like pre-written data sheets in Notepad. However, we can assist you by providing sample SQL queries or guiding you with specific SQL syntax if you need assistance in writing SQL statements.
1:43:38 I have run Select * from cricket ; 2 times and the names are repeating again also numbers are incrementing, how can i reverse it ? And i want that cricket_id till 5. Do help me plz.
Thank you for all your effort in creating this video, it's been very helpful My questions is why is there no 'od.' before 'quantityordered' and 'priceeach' ('quantityordered' and 'priceeach' are columns in table orderdetails) select o.ordernumber, o.status, p.productname, sum(quantityordered * priceeach) as revenue from orders as o inner join orderdetails as od on o.ordernumber = od.ordernumber inner join products as p on p.productcode = od.productcode group by ordernumber;
1:54:02 I get this error any one knows why "Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'classicmodels.p.productName' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 0.000 sec"
The course is amazing and a quick recap on everything, Is there any way you can provide the db file for the databases you use in the video so we can test similar things side by side
Data sets should have provided by Simplilearn to practice users along with the video for far better understanding & course would have lot worth than this
I ran the read_query code: def read_query(connection, query): cursor = connection.cursor() result = None try: cursor.execute(query) result = cursor.fetchall() return result except Error as err: print(f"Error: '{err}'") and then q1 code: #using select statement q1= """ select * from orders; """ #connect to database connection = create_db_connection ("localhost", "root", pw, db) results = read_query(connection, q1) for result in results: print(results) But the table attributes are not printing. Please point out mistakes, if any.
🔥Data Scientist Masters Program (Discount Code - YTBE15) - www.simplilearn.com/big-data-and-analytics/senior-data-scientist-masters-program-training?AA7i2GcTGwU&Comments&TH-cam
🔥IITK - Professional Certificate Course in Data Science (India Only) - www.simplilearn.com/iitk-professional-certificate-course-data-science?AA7i2GcTGwU&Comments&TH-cam
🔥Caltech Post Graduate Program in Data Science - www.simplilearn.com/post-graduate-program-data-science?AA7i2GcTGwU&Comments&TH-cam
🔥Brown University - Applied AI & Data Science - www.simplilearn.com/applied-ai-data-science-course?AA7i2GcTGwU&Comments&TH-cam
After checking 8 course finally landed here …..thanks to simplilearn team for
1. Explaining SQL really from scratch so here I would recommend to beginners to go with this course
2. A big thanks to team for not only this course but many more courses are free
Keep doing good works ….lots of love & best wishes to the team
Thank you for making us a part of your upskilling journey! Learning #CannotBeLockedDown
I love you Simplilearn team, you all have saved my life. I have DBMS exam tomorrow, my teacher couldn't taught me and others properly and I haven't understood. He interpreted us in English, even you've used the same language but your teaching skills is way more better. (Your new subscriber)
Thank you for making us a part of your upskilling journey! Learning #CannotBeLockedDown
Thank you for making this 8 hour course for free.
I appreciate all the efforts you took in making this course..!!
You're very welcome!
Nothing but respect for making this 8 hours video for free 🔥🔥🔥
Your support means a lot to us and it motivated us to create even better learning content and courses experience for you.
@@SimplilearnOfficial sir please provide the dataset containing tables used during joins of tables to practice along with you.
Really man🙌
BIG APPLAUSE FOR THE TEAM! GREAT EFFORT
I love how he explained things slow easy to follow, unlike other guys talks like 65 miles an hour.
I find it so easy following your video training. You offer detailed explanations and step-by-step tutorials. Thank you.
You're very welcome!
Where did you find the database that they worked?
Great Presentation.
Thank You,
Natasha
You are so welcome!
Excellent class and easy way to understand. Best video to learn from youtube. Thank you so much.
You're very welcome!
i give respect to you for creating an 8 hour long video. Must have taken long work. This taught me alot!. You just gained a new subscriber
Thank you so much : ) We are glad to be a part of your learning journey
Awesome video and it's very useful for beginners in SQL and Thank you for this free session...!!!!
Most welcome!
So much of extremely useful and valuable information just for free ! I am glad that I came across this channel and saw the video. I am also glad to say that I cleared my interview of a data analyst, and this course helped me a lot while answering SQL based questions. Thanks a lot and kuddos to the team for uploading this video. Just one request, I really wanted the whole dataset which was used in classic models.
We are glad that you have enjoyed your learning experience with us : )
Thank you simplilearn team, This video is helpful for beginners, easy to understand & covered all the concepts...
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.
Free 8 hours video!!!😍 you guys are awesome and love. It's a great help for middle class people like us. We are few friends watching this video together and exploring other videos.❤️❤️❤️
We are glad you found our video helpful. Like and share our video with your peers and also do not forget to subscribe to our channel for not missing video updates. We will be coming up with more such videos. Cheers!
The course is understandable and easy to learn. Thank you Simplilearn for this awesome course!
You're very welcome!
I just started. Is it for beginners?
Simplilearn is the best thing that ever happened to the students
Thank you for the appreciation. You can check our videos related to various technologies and subscribe to our channel to stay updated with all the trending technologies.
Great class.
Keep up the good work.
Thank You,
Natasha Samuel
You are welcome!
Thank you for sharing, I just finished a data analysis program, and want more experience! So this video help my memory come back :)
Glad it was helpful!
Did you get a job in data analyst
Yes plz I am also planing to build career in it need Guiadance plzzzzz
You taught sql completely thank u♥️
Happy to help!
thanks a lot for this vid it saved me ....
Glad it helped
Thanks a lot... Huge respect for u
Hope you enjoyed our video! We have a ton more videos like this on our channel. We hope you will join our community!
Thankx a lot sir ..really helpful this one...please upload like this pl/sql
Thank you for the appreciation. You can check our videos related to various technologies and subscribe to our channel to stay updated with all the trending technologies.
I already subscribe this good channel 🙏🙏
Thank you Sir 🙏🙏🙏🙏♥️♥️♥️
Most welcome
tq for your valuable information
Welcome
@@SimplilearnOfficial I want Salesforce marketing cloud full video
i love you. it's a very detail and awesome course. 8 hours do not feel so long
Thank you for the appreciation. You can check our videos related to various technologies and subscribe to our channel to stay updated with all the trending technologies.
I love you. Its a very detail and awesome course. 8 hourse do not feel sonlong ❤
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.
By bad i found this amazing tutorial video yesterday! Thank you so much ❤️
You're so welcome!
This is one of the best videos to learn sql from basic to advanced. Thank you so much sir , for givng us such a wonderful session.
Sir, I request you one thing , can you tell me how can i get the data records and tables which you used in this video so we practice alot.
thanks sir.💥💥💥💥💥
You are most welcome
amazing guys thanks alot
Hope you enjoyed our video! We have a ton more videos like this on our channel. We hope you will join our community!
Excellent work by Simpli learn ..❤️❤️
Thank you! Cheers!
This is an amazing course
We are glad you found our video helpful. Like and share our video with your peers and also do not forget to subscribe to our channel for not missing video updates. We will be coming up with more such videos. Cheers!
thank you sir ..
Most welcome
Awesome video. Thank you so much for your efforts and hardwork.
Hey, thank you for appreciating our work. We are glad to have helped. Do check out our other tutorial videos and subscribe to us to stay connected. Cheers :)
thanks for making this video
Our pleasure!
I liked this classes it is really helpfull
Hello thank you for watching our video .We are glad that we could help you in your learning !
its really very helpfull, thankyou
Glad it was helpful!
Thank you for the video tutorial. I'd greatly appreciate if you can share the datasets. I need the datasets to practice.
I send it to your sister
@@avgGamer662 please send it to me too brother
thank you man
You're welcome!
Thanks to provide this course
Happy to help!
Q. Find employee I'd,name from employee table who has lesser exp thn avg and lesser salary thn avg.
For this why can't we use this query?
Select emp_id,emp_name from employee where exp_in months
Thank you so much for this video .❤👍
Thank you! Cheers!
its easy to learn
We are glad you found our video helpful. Like and share our video with your peers and also do not forget to subscribe to our channel for not missing video updates. We will be coming up with more such videos. Cheers!
Thank you sir for this 8 hours SQL course😊
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.
Watching exactly after 1 year...:)
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
I wish you were my college's teacher.
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
Thank you so much for providing such an excellent content free of cost. Can you please provide the data set for practice?
Your satisfaction is our top priority, and we're thrilled to hear that you had a positive learning experience with us! If you're interested in pursuing additional learning opportunities, we encourage you to take a look at certification courses in the description box.
Hi, I am stuck at 27:15. When I enter the command show databases, I can’t find the database with world in it. So I am unable to continue coz I ant have world to work with. Could you help me please. Thanks
Yeah, the world database is created by me. You will see the default databases with the show databases command in MySql Workbench.
This is good but you should provide the data what you are using in the examples so that we can know that we are doing it correctly.
"Thank you for your review. We’ll strive to do better.
1:29:00
Can you also have
SELECT salary, dept,
FROM TABLE_NAME
WHERE salary >( SELECT avg(salary), dept FROM TABLE_NAME):
Obviously, this is without group by and having. Is this also possible for selecting department that have average salary
The query will throw an error. The inner query is not correct, while non-aggregation column should be present in the group by clause."
Remove dept from inner query
Very nice explanation
Thanks and welcome
Good job, Keep it up!
Thank you for the appreciation. You can check our videos related to various technologies and subscribe to our channel to stay updated with all the trending technologies.
Thanks Simplilearn for Providing this video but Please Provide the all datasets which are used in this full course
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@@SimplilearnOfficial Thanks simplelearn. I all ready downloaded that files but in discretion data set orders, order dates.....etc table data set is not present.
What a great video
Glad you enjoyed it
Straight forward to the point
Many thanks
Hope you enjoyed our video! We have a ton more videos like this on our channel. We hope you will join our community!
Hello Simplilearn.
Thank you so much for this video.
It would be greatly appreciated if I get the datasets.
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 can you please also send the datasets to the email: lemogangmon@gmail.com
Email address: angelomolara@hotmail.co.uk
Will you please send to this mail id also sireesha.7952@gmail.com
@Simplilearn please send me the data sets at-
indumonu787@gmail.com
wow.....i have gain the experties in mysql just in 8 days....than youtube for suggesting me this video....and thanks a lot to @simplilearn
55:17 when you inserted a table with students name??? please check your content bfore uploading.. this can create huge confusion
thank you for this masterpiece
.
You're welcome
Great..
Hope you enjoyed our video! We have a ton more videos like this on our channel. We hope you will join our community!
Awesome tutorial .
Thank you for the appreciation. You can check our videos related to various technologies and subscribe to our channel to stay updated with all the trending technologies.
great course, can you please share presentation used during course.
We don't have any pdf of this particular video. For slides, you can check out our slideshare profile: www.slideshare.net/Simplilearn"
1:35:39 to 4:01:31
Nice one
Thank you for the appreciation. You can check our videos related to various technologies and subscribe to our channel to stay updated with all the trending technologies.
Helping me a lot ....keep it up ...
Glad to hear that
dear team, kindly provide us the full data set for practice
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
Tq sir for your explanation sir could you please tell me how to give identity property using stored procedure without giving identity property in table
Your support means a lot to us and it motivated us to create even better learning content and courses experience for you.
@@SimplilearnOfficial sir please show solution to my query in video lecture
Just the video I was looking for.
Please how do I get the datasets?
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@SimplilearnOfficial
Please give us the data table used in this SQL not just the data codes that have been used.
Videos re very helpful... Can you please provide the dataset?
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
Kindly share datasets.
So, we can practice with your awesome video.
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
Great presentation. Can you share 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.
very usefull complete course for sql learner.could you please send me the datasets.
thank you
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
hi simplilearn , can you provide the dataset of employees table , it is not available in the provided dataset link.
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
7:33:07 Not Union But Unique
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
SQL video tutorial was very helpful and easy to learn. I downloaded it from google drive it has only the first one-hour data set. I need the entire dataset to practice. I'd greatly appreciate it if you can share the entire dataset in the 8 hours video. Thank you
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
@@SimplilearnOfficial I could see the dataset for only the first one-hour video in the google drive folder (Kennet Rajan K J). However, I am looking for the remaining datasets from the video time 1:15:00 onwards. This will be more helpful to practice. Thank you again for your kind reply.
@@SimplilearnOfficial Group by and having session 1:05:06 provide the datasets for practice
Will this course which is covered in this video help me to develop my skill of SQL which is required for the designation of Business Analyst?
In subquery section - for update and delete subquery why do we use different tables name in the sql statement.
Delete from employees where age in ( select age from employees_b where age> 30); here employees and employees_b two tables used
1 hr:25 min :--- Instead of using ---> select c.product_id, sum((s.sell_price - c.cost_price)*s.quantity) as profit.... here instead if i use ---> s.product_id does it make any change. Because both are same id values. someone please answer this....
can u provid us that pre writter data sheets in note pad if possible as it is very hectic to type each and every data
Apologies for the inconvenience, we cannot directly provide attachments or files like pre-written data sheets in Notepad. However, we can assist you by providing sample SQL queries or guiding you with specific SQL syntax if you need assistance in writing SQL statements.
1:43:38
I have run
Select * from cricket ; 2 times and the names are repeating again also numbers are incrementing, how can i reverse it ? And i want that cricket_id till 5. Do help me plz.
AttributeError: 'NoneType' object has no attribute 'cursor' @Simplilearn getting this error please help 4:14:39
Thank you for all your effort in creating this video, it's been very helpful
My questions is why is there no 'od.' before 'quantityordered' and 'priceeach' ('quantityordered' and 'priceeach' are columns in table orderdetails)
select o.ordernumber, o.status, p.productname,
sum(quantityordered * priceeach) as revenue
from orders as o inner join orderdetails as od on
o.ordernumber = od.ordernumber inner join products as p on
p.productcode = od.productcode
group by ordernumber;
an excellent video but there is no database WORLD present
We are glad that you have enjoyed your learning experience with us : )
1:54:02 I get this error any one knows why "Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'classicmodels.p.productName' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 0.000 sec"
1:11 where can i get the data set
How did you open command prompt at 22:37
The course is amazing and a quick recap on everything, Is there any way you can provide the db file for the databases you use in the video so we can test similar things side by side
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
Data sets should have provided by Simplilearn to practice users along with the video for far better understanding
& course would have lot worth than this
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
Can you please prove similar training for MSSQL. this will be great help.
Stick around as we have a tutorial on the same coming up soon.
@@SimplilearnOfficial thanks for the response. Will stay connect.
whats the difference between MSSQL and SQL ?
I am a beginner..do we need do install every time and do all process from 18 min to 23 min ? For everytime ? Please tell me
Just for one time
can i have dataset as you used in the examples for each topic
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
ooo nailed
Hope you enjoyed our video! We have a ton more videos like this on our channel. We hope you will join our community!
I have a doubt- how to find all the orderids of the customer who has given maximum orders. Table= Orders and columns= CustomerID, OrderID.
I ran the read_query code:
def read_query(connection, query):
cursor = connection.cursor()
result = None
try:
cursor.execute(query)
result = cursor.fetchall()
return result
except Error as err:
print(f"Error: '{err}'")
and then q1 code:
#using select statement
q1= """
select * from orders;
"""
#connect to database
connection = create_db_connection ("localhost", "root", pw, db)
results = read_query(connection, q1)
for result in results:
print(results)
But the table attributes are not printing. Please point out mistakes, if any.
23:41
What we need to do while having this error 1045 (28000) : Access denied for user 'root'@'localhost' (using password: YES)
for some reason I'm only pulling up 4 databases instead of 7 like yours when I type in show databases; Any suggestions?
Please help me get the Classic models data used in this video like 'Product', 'Productlines' etc.
i dont have the table for students do i have to create one too, check the link to the dataset and it seem some of the datasets is missing
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
thank you