DML or CRUD Operations

Lesson
Materials

Let us understand how to perform CRUD operations using Postgresql.

  • Normalization Principles

  • Tables as Relations

  • Database Operations - Overview

  • CRUD Operations

  • Creating Table

  • Inserting Data

  • Updating Data

  • Deleting Data

  • Overview of Transactions

  • Exercise - Database Operations

Here are the key objectives of this section.

  • What are the different types of Database Operations?

  • How DML is related to CRUD Operations?

  • How to insert new records into table?

  • How to update existing data in a table?

  • How the data is typically deleted from a table?

  • You will also get a brief overview about Database Operations?

  • Self evaluate whether you gain enough skills related to performing CRUD or DML operations or not using exercieses