Introduction to PostgreSQL Tutorial - Part 2

📝 Get my free SQL Cheat Sheets: www.databasestar.com/get-sql-...
🎓 Learn and become confident in SQL: databasestar.mykajabi.com/sql...
In part 2 of this Introduction to PostgreSQL tutorial series, you'll build on the basics you learned in part 1 by learning:
- How to view specific columns in your table
- How to view specific rows in your table
- Why text values are different to number values in your queries
- Updating data in a table
- Deleting data in a table
⏱ TIMESTAMPS:
00:00 - View some data
00:45 - Select individual columns
01:55 - Filter our results
02:54 - Fixing our error
05:00 - Updating data
07:21 - Deleting data
🔗 VIDEO LINKS:
Scripts from this video: github.com/bbrumm/databasesta...
Scripts from Part 1 to set up the table: github.com/bbrumm/databasesta...
Part 1 - • Introduction to Postgr...

[@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/

[@TheDoomCompany]

Your presentation is really great. Straightforward, good pace!

[@DatabaseStar]

Thanks, glad you like it!

[@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.

[@kostiantynkarzhanov9216]

Awesome tutorial! Thank you so much! 💛

[@DatabaseStar]

Thanks!

[@stackbind4728]

Awesome bro. waiting for part-3.

[@DatabaseStar]

Thanks!

[@kehindefagbohungbe]

Thank you

[@DatabaseStar]

You're welcome

[@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.

[@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.

[@yugasaimanikanta139]

Waiting for part-3

[@DatabaseStar]

Good to hear! It's in the works.

[@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.

[@yugasaimanikanta139]

Bro plz keep the full lechtures daily

[@DatabaseStar]

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

[@ginikadaily]

part 3 please

[@DatabaseStar]

Sure, it's coming in a few weeks!

[@englui]

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

[@DatabaseStar]

Hahah thanks!

[@Edward-qx9lb]

🌹 'Promo sm'

[@DatabaseStar]

Thanks, I think!

[@oguzturkyilmaz543]

Thank you

[@DatabaseStar]

You're welcome