I must confess that you're the best tutor i have ever come across on this platform your tutorials have guild me through my journey of becoming a dev engineer....Thank you
For what you did around the 19:04 mark in the video, I used this command with a couple of subqueries and it worked (in case you couldn't remember Dave Grohl's emp_no or hire_date from the other table): INSERT INTO titles (emp_no, title, from_date) VALUES( (SELECT emp_no FROM employees WHERE first_name = 'Dave' AND last_name = 'Grohl'), 'Rock Star', (SELECT hire_date FROM employees WHERE first_name = 'Dave' AND last_name = 'Grohl') )
Well done Dave, just a few notes from a beginner point of view (I'm not but pretending): If I am new to SQL/Databases I might not be able to follow your instruction as I wouldn't know how tables are structured (rows, columns, primary key, …), so a short intro on tables would be helpful (I think), Also, I found it not so easy for new comers to understand the JOIN clause without an illustration of the two joined tables where one can visually locate the two joined columns (with the relationship in between), the tables aliases and how we can use this relation to extract needed data from both sides of the relationship/tables. Waiting for the PHP integration video
Good notes Ahmad. Students all learn differently. I always hope (and encourage) exploration on their own as well. I know there is always room for improvement though, and I appreciate your notes and perspective. My motto is "Strive for progress, not perfection". It keeps me productive! :)
@@DaveGrayTeachesCode I love teaching and I've taught quite a few of students/friends, my comments are mostly written based on what I've experienced with them. I had a small discussion with my brother about different education systems and how they affect the students' learning experience and we concluded that letting students do their own researches is better for them in the long run my main purpose for me to subscribe to your channel (and some others) was to know more about teaching methods and techniques. So, Thanks a lot for the clarification and sorry if you get annoyed with me
Both are useful. LAMP has powered the web for years. I prefer Node because I like JS, but either tool can be used to create what is needed. Also, each part of the stack can be different. For example, I frequently use Node with SQL at work. 🚀
Hey brother thank you , I just had one problem with it ,when I tried to run the code its throwing me an error saying "no database selected " what could be the reason ?
You deserve more views brother. As always, great tutorial!
Thank you!
I was just thinking about MySQL the other night and now here you are with a crash course, thank you.
You're welcome. I'll start integrating it with PHP and Node JS in upcoming tutorials.
I must confess that you're the best tutor i have ever come across on this platform
your tutorials have guild me through my journey of becoming a dev engineer....Thank you
You're very welcome! 🙏💯
For what you did around the 19:04 mark in the video, I used this command with a couple of subqueries and it worked (in case you couldn't remember Dave Grohl's emp_no or hire_date from the other table):
INSERT INTO titles (emp_no, title, from_date)
VALUES(
(SELECT emp_no FROM employees WHERE first_name = 'Dave' AND last_name = 'Grohl'), 'Rock Star',
(SELECT hire_date FROM employees WHERE first_name = 'Dave' AND last_name = 'Grohl')
)
Nested queries! Good job exploring options and expanding on the tutorial info.
Mr Gray you are an awesome instructor, Greetings from Buenos Aires, Argentina!
Thank you! And hello to Argentina! 👋
Well done Dave,
just a few notes from a beginner point of view (I'm not but pretending):
If I am new to SQL/Databases I might not be able to follow your instruction as I wouldn't know how tables are structured (rows, columns, primary key, …), so a short intro on tables would be helpful (I think),
Also, I found it not so easy for new comers to understand the JOIN clause without an illustration of the two joined tables where one can visually locate the two joined columns (with the relationship in between), the tables aliases and how we can use this relation to extract needed data from both sides of the relationship/tables.
Waiting for the PHP integration video
Good notes Ahmad. Students all learn differently. I always hope (and encourage) exploration on their own as well. I know there is always room for improvement though, and I appreciate your notes and perspective. My motto is "Strive for progress, not perfection". It keeps me productive! :)
@@DaveGrayTeachesCode I love teaching and I've taught quite a few of students/friends,
my comments are mostly written based on what I've experienced with them.
I had a small discussion with my brother about different education systems and how they affect the students' learning experience and we concluded that letting students do their own researches is better for them in the long run
my main purpose for me to subscribe to your channel (and some others) was to know more about teaching methods and techniques.
So, Thanks a lot for the clarification and sorry if you get annoyed with me
Not annoyed at all Ahmad 🙂 I appreciate your notes and feedback. Thank you! Always working towards improvement 🙏💯
best video on mysql crud operations i wacth, each step details explained perfect as always by Dave Gray.
Thank you again, Basilis! 💯
Incredible content
Thanks Dave
You're welcome!
Awesome as always. Thanks
Thanks!
:D thanks, prof. Dave!
God bless!
You're welcome! 💯
You're amazing and my hero
Thank you for the kind words!
What are your thoughts about the LAMP VS Node stack?
Both are useful. LAMP has powered the web for years. I prefer Node because I like JS, but either tool can be used to create what is needed. Also, each part of the stack can be different. For example, I frequently use Node with SQL at work. 🚀
Hey brother thank you , I just had one problem with it ,when I tried to run the code its throwing me an error saying "no database selected " what could be the reason ?
You need to select the database that you are querying.
I never knew you did php
A little bit. Considering another short series for building a REST API with PHP and SQL.
Thanks a Lot, this is very Helpful! i gave you Like and Subcribe
Thank you!