Creating Table¶ Before getting into action with respect to basic DML and queries or CRUD operations, we need to prepare tables.At this time we have not covered DDL yet. All database operations related to managing tables come under DDL. For now, let’s just create the table by copy pasting below CREATE TABLE statement. We will …
CRUD Operations¶ Let us get an overview of CRUD Operations. They are nothing but DML and queries to read the data while performing database operations. CRUD is widely used from application development perspective. C – CREATE (INSERT) R – READ (READ) U – UPDATE (UPDATE) D – DELETE (DELETE) As part of the application development …
Database Operations – Overview¶ Let us get an overview of Database Operations we typically perform on regular basis. They are broadly categorized into the following: DDL – Data Definition Language CREATE/ALTER/DROP Tables CREATE/ALTER/DROP Indexes Add constraints to tables CREATE/ALTER/DROP Views CREATE/ALTER/DROP Sequences DML – Data Manipulation Language Inserting new data into the table Updating existing …
Tables as Relations¶ Let us understand details about relations and different types of relationships we typically use. In RDBMS – R stands for Relational. In the transactional systems, tables are created using normalization principles. There will be relations or tables created based on relationships among them. Here are the typical relationships among the tables. 1 …
Normalization Principles¶ Let us get an overview about Normalization Principles. Here are different normal forms we use. Provided links are from Wiki. 1st Normal Form 2nd Normal Form 3rd Normal Form Boyce Codd Normal Form Most of the well designed Data Models will be in either 3rd Normal Form. BCNF is used in some extreme …
DML or CRUD Operations¶ 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 …
