Your tutorials are the BEST I've found on UA-cam so far. I REALLY appreciate how clearly you break things down. I'm finding professional coders don't like bothering with layman's terms. Unfortunately it's how some of us get over the initial hump. So thank you!
I request you to complete PostgreSQL tutorial (requesting you to please cover concepts that are required often in data science/engineering). Thanks for explaining everything so precise and clear!
I have studied your first three PostgreSQL videos and I find them great. I like the way you explain things and also the way you keep videos short. The only thing (not a great issue though) I think is the sound volume. The sound volume on my two laptops sound very low, its far better on my tv. Thank you for this postgre tutorial :)
Hello professor, was just curious if you knew when you would be posting a part 4 to your amazing PostgreSQL series? Very interested to learn how to combine tables and making unique indicators. I am sure you are a busy man but thank you for the 3 lessons you already published. I have learned a lot this weekend. Thank you!
Sir, i have 1 question. Does PostgreSQL has a capability to automatically update the table row once the incoming data is inserted to the PostgreSQL? For example, the incoming data come from a broker.
Do you mean, update a row in a table when another row is inserted? If so, then yes, it could be done with a trigger. Or you could write a stored procedure to do this.
Hello, love the videos, but need some help. I got an error that read "ERROR: invalid input syntax for type integer: "YES" when I try the USING in_stock:: INTEGER command. Would love any guidance on this! I use Postgres 15 by the way
Thanks! I think that means the value of YES cannot be used as an Integer. I've addressed this in the video, and the solution is to change the data to be an integer first, then run Alter Table.
You could create a new "database" on the server, and then use that database for any future work. You can create one by expanding the left panel, right click on Databases, and select Create New. You could alternatively create a new Schema which is like a collection of databases.
Your tutorials are the BEST I've found on UA-cam so far. I REALLY appreciate how clearly you break things down. I'm finding professional coders don't like bothering with layman's terms. Unfortunately it's how some of us get over the initial hump. So thank you!
Thank you so much, can't wait for more videos. You are indeed the best SQL tutor 😊
Thanks, I'm glad you liked it!
Best DB channel on UA-cam Thanks for this great tutorial! Waiting for the next one🏋♂
Thanks, I'm glad youn like it!
@@DatabaseStar I just have a one note about the sound it is so low I hope u raise the volume in the video editor.
@@DatabaseStar
If you're working with only PowerPoint, I'd be delighted to assist you with this straightforward task at no cost.
Thank you for your lessons with wonderful voice. Looking forward to part 4
Thanks!
I request you to complete PostgreSQL tutorial (requesting you to please cover concepts that are required often in data science/engineering). Thanks for explaining everything so precise and clear!
Thanks! Sure, I plan on adding more videos to this PostgreSQL series to teach more about it.
I have studied your first three PostgreSQL videos and I find them great. I like the way you explain things and also the way you keep videos short. The only thing (not a great issue though) I think is the sound volume. The sound volume on my two laptops sound very low, its far better on my tv. Thank you for this postgre tutorial :)
Thanks for the feedback1 I've tried to improve the volume of my recent videos but I'll focus on it for my future videos.
amazing videos , very simple explanation and was easy to grasp the concepts .
can you please continue the series as soon as possible , thank you .
Thanks! Yes I will be continuing the series soon.
Hello professor, was just curious if you knew when you would be posting a part 4 to your amazing PostgreSQL series? Very interested to learn how to combine tables and making unique indicators. I am sure you are a busy man but thank you for the 3 lessons you already published. I have learned a lot this weekend. Thank you!
Hi, I’d like to make the next few videos in this series, so they are coming soon, sometime in the next couple of months.
Is there any Part 4, Thank you for your great explanation
Thanks! Yeah part 4 is coming soon
Thank you, I'm waiting part 4
Thanks! It's coming soon.
Looking forward to part 4
Good to hear!
Sir, i have 1 question. Does PostgreSQL has a capability to automatically update the table row once the incoming data is inserted to the PostgreSQL? For example, the incoming data come from a broker.
Do you mean, update a row in a table when another row is inserted? If so, then yes, it could be done with a trigger. Or you could write a stored procedure to do this.
Hello, love the videos, but need some help. I got an error that read "ERROR: invalid input syntax for type integer: "YES" when I try the USING in_stock:: INTEGER command. Would love any guidance on this! I use Postgres 15 by the way
Thanks! I think that means the value of YES cannot be used as an Integer. I've addressed this in the video, and the solution is to change the data to be an integer first, then run Alter Table.
Thank you
You're welcome
how can I start fresh work in PostgreSQL. Like if I do some practics and then I have to switch to my project work
You could create a new "database" on the server, and then use that database for any future work. You can create one by expanding the left panel, right click on Databases, and select Create New.
You could alternatively create a new Schema which is like a collection of databases.
@@DatabaseStar thanks buddy ☺ and please upload the next part
Please I like your teaches
Thanks!
please upload next part.
Sure! I’ll be working on it soon to get it published.