Introduction to PostgreSQL Tutorial

Introduction to PostgreSQL Tutorial - Part 3

Рет қаралды 8,817

Күн бұрын

Пікірлер: 42

@TheNisiu 3 ай бұрын

Your tutorials are the BEST I've found on KZbin 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!

@DatabaseStar 2 ай бұрын

Thanks, I'm glad you like the tutorials and find them useful! Are there any topics in SQL or databases you're struggling with (and that I could make a video on)?

@TheNisiu 2 ай бұрын

@@DatabaseStar yes, thank you for asking!! A really simple issue I'm,, having issues uploading a csv file that may have too many columns to enter manually. Will you show me how? 😊

@DatabaseStar 2 ай бұрын

Sure, I can make a video on that. What do you mean by "too many columns to enter manually"? Generally, you use your SQL editor to find an "import data" menu item, select the CSV, and proceed through the wizard to import the file.

@TheNisiu 2 ай бұрын

@@DatabaseStar right! I've been having trouble with it for some reason. I'm sure it's something I'm missing.

@ugonmaajie2240 Жыл бұрын

Thank you so much, can't wait for more videos. You are indeed the best SQL tutor 😊

@DatabaseStar Жыл бұрын

Thanks, I'm glad you liked it!

@t0khyo Жыл бұрын

Best DB channel on KZbin Thanks for this great tutorial! Waiting for the next one🏋‍♂

@DatabaseStar Жыл бұрын

Thanks, I'm glad youn like it!

@t0khyo Жыл бұрын

@@DatabaseStar I just have a one note about the sound it is so low I hope u raise the volume in the video editor.

@t0khyo Жыл бұрын

@@DatabaseStar If you're working with only PowerPoint, I'd be delighted to assist you with this straightforward task at no cost.

@BM-zb9lz 7 ай бұрын

Thank you for your lessons with wonderful voice. Looking forward to part 4

@DatabaseStar 7 ай бұрын

Thanks!

@georgepistikoudis Жыл бұрын

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 :)

@DatabaseStar Жыл бұрын

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.

@Crystal-Fox 10 ай бұрын

amazing videos , very simple explanation and was easy to grasp the concepts . can you please continue the series as soon as possible , thank you .

@DatabaseStar 9 ай бұрын

Thanks! Yes I will be continuing the series soon.

@itsAnkitGupta Жыл бұрын

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!

@DatabaseStar Жыл бұрын

Thanks! Sure, I plan on adding more videos to this PostgreSQL series to teach more about it.

@iebeda Ай бұрын

Hi! Beautiful course, I really appreciate your lessons. But I have a question - in the last part of this video, where you updated the data in column "in_stock" from 'Yes' to a number(about 7:30), why didn't you use single quotes on both sides('10' instead of 10)? After the quary for changing the column type returned an error, "in_stock" should've stayed VARCHAR type. Did postgres change the numbers you entered to VARCHAR automatically? Thanks!

@DatabaseStar Ай бұрын

Thanks! The reason I didn't use single quotes around the number 10 is because when we update or insert number values, we don't need to add single quotes. Using a value of 10 (without the quotes) instead of '10' (with the quotes) is recommended.

@frantzp1718 10 ай бұрын

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!

@DatabaseStar 10 ай бұрын

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.

@mohammadfaiz5237 5 ай бұрын

Is there any Part 4, Thank you for your great explanation

@DatabaseStar 5 ай бұрын

Thanks! Yeah part 4 is coming soon

@mohammadfaiz5237 5 ай бұрын

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.

@DatabaseStar 5 ай бұрын

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.

@lucassuhl6905 9 ай бұрын

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

@DatabaseStar 9 ай бұрын

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.

@Praween.222. Жыл бұрын

how can I start fresh work in PostgreSQL. Like if I do some practics and then I have to switch to my project work

@DatabaseStar Жыл бұрын

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.

@Praween.222. Жыл бұрын

@@DatabaseStar thanks buddy ☺ and please upload the next part