SQL JOIN tutorial 2024: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, join more than 2 tables

[@codelucky]

You always look happy and make such valuable video tuts. 💐

[@coupleracademy]

LucKie thank you!

[@justinrocky6645]

kzbin.info/www/bejne/o3qyl5Wdft-efck

[@mohamed.montaser]

can you make a video on how to create the database and tables on PostgreSQL

[@coupleracademy]

Mohamed Montaser that’s the plan for our next video. Thank you for sharing the idea!

[@mohamed.montaser]

@@coupleracademy i will be eagerly waiting, is there an option to upload CSV files in pg-admin? like what you did with SQLite

[@coupleracademy]

Yes, there is. First, you have to create a table in pg-admin (create a server, a new database, and automatically you will get schema called “public”, open it and create a table). It should have the same field names and the same order as you have in your csv (be super careful here - there has to be a 100% match in terms of letter case, symbols, etc.). Once done, right click on the new table -> Import/Export. Choose import, file format .csv and carefully choose the delimiter used in your csv. If everything matches, the data will get uploaded to this table.

[@coupleracademy]

Mohamed, here is a video tutorial on how to setup postgreSQL from scratch: kzbin.info/www/bejne/en7PZpmpmJ2Dic0

[@justinrocky6645]

kzbin.info/www/bejne/o3qyl5Wdft-efck

[@hasanmahmud988]

nice.video

[@saadshalgheen7059]

V 💐🔴🔴 good

[@proskillscenter9589]

great

[@pankajkharade6936]

👍🏻👍🏻👍🏻👍🏻👍🏻