PostgreSQL - Installation and Overview

Course:
SQL

Today we show you how to install PostgreSQL (aka “Postgres”). In addition to installing the database, we will install the pgAdmin GUI tool. Once Postgres and pgAdmin are installed, we will take a tour of the pgAdmin interface and learn how to create a new database.

Today we show you how to install PostgreSQL (aka “Postgres”). In addition to installing the database, we will install the pgAdmin GUI tool. Once Postgres and pgAdmin are installed, we will take a tour of the pgAdmin interface and learn how to create a new database.

Lessons
Course Info
SQL - A Quick Overview
Choosing a Relational Database
PostgreSQL - Installation and Overview
SELECT Queries - Part 1
SQL Queries - Part 2
INSERT Queries
UPDATE Queries
DELETE Queries
JOINS Explained
JOINS Examples
VIEWS - Complex Queries, Cross Joins, Unions, and more
Indexes
Course Page
SQL
Course Description
In this Introduction to SQL Course, you will learn the essential queries needed to work with a relational database: How to create data (INSERT), change existing data (UPDATE), and find data (SELECT and JOINs). You will also learn how to choose a database, install PostgreSQL, speed up queries with indexes, and more.