Expanded Library

PostgreSQL: Introduction to SQL Queries

by Pinal Dave

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

What you'll learn

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.

Table of contents

Introduction
5mins
Summary
2mins

About the author

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 21 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 45 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,500 database tech articles on his blog at https://blog.sqlauthority.com.

Ready to upskill? Get started