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


About the author

Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 11 SQL Server database books, 25 Pluralsight courses and has written over 5000 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years of hands-on experience, he holds a Masters of Science degree and a number of database certifications.

Ready to upskill? Get started