Connection to Dedicated PostgresQL Database-4 - Example of running queries against your own PostgresSQL database

4 - Example of running queries against your own PostgresSQL database

Video Transcription

Video Summary

This final tutorial demonstrates how to query a dedicated PostgreSQL database using provided connection details through pgAdmin. The presenter shows connecting to the database, opening the query tool, and running basic queries like selecting course data and performing joins. The tutorial emphasizes that users have read-only access to two databases: one with full data and another with five years of data. It highlights the flexibility of connecting through pgAdmin or other analytic tools. The goal is to show how to access and utilize the dedicated database for querying relevant data effectively.

Keywords

PostgreSQL

pgAdmin

database querying

read-only access

data analysis

KGConcept: PostgreSQL Database (10)

KGConcept: Database Connection Credentials (8)

KGConcept: pgAdmin (9)

KGConcept: Query Tool (8)

KGConcept: SQL Query (10)

KGConcept: Table (8)

KGConcept: Course Data (6)

KGConcept: Join (7)

KGConcept: Database Access (8)

KGConcept: Analytics Tool (5)

KGConcept: Data Warehouse Tool (5)

KGConcept: Full Data Database (7)

KGConcept: Five-Year Data Database (7)

KGConcept: Read-Only Access (9)