PostgreSQL: Introduction to SQL Queries

In this course, we will go over various table and data operations. We will learn to retrieve and modify data efficiently.

PostgreSQL, commonly known as Postgress, is often called the world's most advanced open-source database. In this course, we will learn about various datatypes and their impact on performance and database designs. We will learn about various table operations, schemas, keys, and constraints. We will also learn how to efficiently retrieve data and make modification to data with insert, update, and delete operations.

• Introduction 4mins
• Introduction to Various Data Types 50mins
• Table Operations: Schemas, Constraints, and Keys 44mins
• Data Operations: Insert, Update, and Delete 38mins
• Summary 2mins