Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

This beginner-friendly online course is dedicated to aspiring database administrators, business professionals working with PostgreSQL, and more. We assume you know the basic PostgreSQL concepts introduced in our PostgreSQL Basics online course.

PostgreSQL (pronounced "post-gress-Q-L") is an open-source relational database management system supporting the SQL standard language. There are four types of PostgreSQL statements based on their functionality. In this online course, you'll learn about one type – the data manipulation language (DML). Using the DML, you will retrieve, modify, and update PostgreSQL data like a professional. Moreover, you will have the opportunity to test newly acquired skills in practice.

Expand your PostgreSQL toolkit and unlock new career possibilities. Start our online course for free, and see how easy it is.

What Are the Requirements?

  • A web browser and an internet connection.
  • Understanding of basic PostgreSQL concepts that we present in our SQL Basics in PostgreSQL online course.

Learn How To:

  • Work with PostgreSQL INSERT, UPDATE, and DELETE commands.
  • Deal with auto-filling values and combine PostgreSQL DML commands with IDENTITY, SEQUENCE, and NEWID().
  • Combine PostgreSQL DML commands with NULL values.
  • Combine PostgreSQL DML commands with JOIN functions.
  • Update PostgreSQL data using default values in columns.

What's in It for Me?

  • 52 interactive, real-life-inspired exercises designed to help you practice PostgreSQL. Learn at your own pace, from anywhere and at any time.
  • Lifetime access to the course. When you purchase the course, you'll get instant personal access to all of its content.
  • Online certificate. If you complete all of the exercises successfully, you'll get a certificate. You can publish the certificate on your LinkedIn profile (here's how).
  • 30-day money-back guarantee. If you're not satisfied with the quality of the course, you can receive a refund within 30 days of your purchase.
  • Hints for the exercises. Utilize our ready-made hints for the exercises, or ask questions and share insights with other members of our community through the Discuss tab.

Who Can Take This Course?

  • Aspiring database administrators (DBAs)
  • Software testers
  • Programmers dealing with databases
  • Business professionals working with PostgreSQL
  • PostgreSQL enthusiasts
  • Anyone who'd like to get the hang of PostgreSQL DML skills
    Start this course

    Table of contents

    Progress: 0% completed 0 of 80 exercises done

    1. The basics of INSERT, UPDATE, and DELETE

    Learn the basic data manipulation operations in PostgreSQL: INSERT, UPDATE, and DELETE

    More details Less
    Start now

    0% completed 0 of 18 exercises done

    2. Advanced features of INSERT, UPDATE, and DELETE

    Practice the advanced version of data manipulation operations in PostgreSQL. Get to know how to return rows from INSERT, UPDATE and DELETE with RETURNING clause.

    More details Less
    Start now

    0% completed 0 of 20 exercises done

    3. Working with DEFAULT values in INSERT and UPDATE

    Learn how you can use default values in a database.

    More details Less
    Start now

    0% completed 0 of 16 exercises done

    4. Referring to other tables in INSERT, UPDATE, and DELETE

    Learn to use other tables in INSERT, UPDATE, and DELETE operations in PostgreSQL.

    More details Less
    Start now

    0% completed 0 of 13 exercises done

    5. Final Quiz

    Do you remember how to insert, delete, and update in PostgreSQL?

    More details Less
    Start now

    0% completed 0 of 13 exercises done


    Average rating

    5/5100.0 (3)


    5 Stars 100%
    4 Stars 0%
    3 Stars 0%
    2 Stars 0%
    1 Stars 0%
      Load more reviews