Setup Postgres Database on Ubuntu VM - Execute SQL Scripts

Publié le: 31 octobre 2021
sur la chaîne: itversity

872

Let us understand how to execute SQL Scripts using psql. We will create new database and then run the scripts which are cloned from GitHub.
1. Clone the GitHub repository on to the host.
2. Copy the folder which contain scripts to itv_pg container under root folder /.
3. Make sure retail_db database and retail_user user are created.
4. Run the appropriate scripts to create tables as well as to insert data.
5. Validate that tables are created and data is inserted by running simple queries.

🔵Click below to get access to the course with one month lab access for "Data Engineering Essentials Hands-on - SQL, Python and Spark" -
👉🏼🔗https://www.udemy.com/course/data-eng...

▶️Link for complete playlist -    • Section 004 - Setting up Environment ...

=============================================
More top rated #DataEngineering Courses from #itversity 👇🏻
_____________________________________________________

🟢Data Engineering using AWS Analytics Services
👉🏼🔗https://www.udemy.com/course/data-eng...

🟢Data Engineering using Databricks features on AWS and Azure
👉🏼🔗https://www.udemy.com/course/data-eng...

🟢Data Engineering using Kafka and Spark Structured Streaming (NEW)
👉🏼🔗https://www.udemy.com/course/data-eng...

==============================================
For quick itversity updates, subscribe to our newsletter or follow us on social platforms.

Newsletter: http://notifyme.itversity.com
LinkedIn:   / itversity
Facebook:   / itversity
Twitter:   / itversity
Instagram:   / itversity
YouTube:    / itversityin

#Spark #Python #DataEngineeringEssentials #SQL #BigData

🟡Join this channel to get access to perks:
   / @itversity

Sur cette page du site, vous pouvez voir la vidéo en ligne Setup Postgres Database on Ubuntu VM - Execute SQL Scripts durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur itversity 31 octobre 2021, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 872 fois et il a aimé 6 téléspectateurs. Bon visionnage!

262