Introduction to PostgreSQL Tutorial - Part 2

[@DatabaseStar]

Get my free PostgreSQL Cheat Sheet to help you remember commands and keywords when reading and writing SQL here: www.databasestar.com/postgres-cheat-sheet/

[@pemtashi1]

Thank you so much! Your videos have proven to be incredibly helpful. Please more content, perhaps focusing on slightly more advanced SQL queries or more intricate query techniques.

[@DatabaseStar]

Thanks! I'm glad they are helpful. Sure, I'll create more videos on advanced topics.

[@TheDoomCompany]

Your presentation is really great. Straightforward, good pace!

[@DatabaseStar]

Thanks, glad you like it!

[@vnagaravi]

Im not good at but
I think you need to add double quotes when you want to use upper case letters in column or table names if you use upper case without double quotes postgres will consider that as lower case

[@DatabaseStar]

Yeah that's right, if you mention a table as upper case or lower case, postgres will consider it lower case. If you want it to be kept as upper case you need to surround it in quotes.
This is the functionality in other SQL vendors as well.
However, I don't use quotes around table names as I don't think it matters what case the table name is created in. Both SELECT FROM customer and SELECT FROM CUSTOMER will work.

[@anwarshaik5132]

How are getting those suggestions for autofill?

[@DatabaseStar]

These suggestions happen when pgAdmin recognises that there are objects, such as tables and columns, that exist on the database.

[@kostiantynkarzhanov9216]

Awesome tutorial! Thank you so much! 💛

[@DatabaseStar]

Thanks!

[@stackbind4728]

Awesome bro. waiting for part-3.

[@DatabaseStar]

Thanks!

[@jeffrey6124]

Great! videos as always ... can you have these videos on a play list ... I'm having a hard time finding the next video for part 2 or it's not yet uploaded 😁 many thanks! 🥰

[@DatabaseStar]

Thanks! They are already on a playlist - Introduction to PostgreSQL. There are only 2 videos at the moment (this one is number 2) and I'm working on the next videos.

[@oguzturkyilmaz543]

Thank you

[@DatabaseStar]

You're welcome

[@yugasaimanikanta139]

Bro plz keep the full lechtures daily

[@DatabaseStar]

I aim to publish a new video every 1-2 weeks.

[@yugasaimanikanta139]

Waiting for part-3

[@DatabaseStar]

Good to hear! It's in the works.

[@kehindefagbohungbe]

Thank you

[@DatabaseStar]

You're welcome

[@DatabaseStar]

You’re welcome!

[@englui]

Me 🏃‍♂️ to unsubscribe all Database tutors I've subscribed before i found this channel

[@DatabaseStar]

Hahah thanks!

[@ginikadaily]

part 3 please

[@DatabaseStar]

Sure, it's coming in a few weeks!

[@Edward-qx9lb]

🌹 'Promo sm'

[@DatabaseStar]

Thanks, I think!