Month: March 2022

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 …

Tables as Relations Read More »

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 …

Normalization Principles Read More »

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 …

DML or CRUD Operations Read More »

Data Loading Utilities into Postgres Database¶ Let us understand how we can load the data into databases using utilities provided. Most of the databases provide data loading utilities. One of the most common way of getting data into database tables is by using data loading utilities provided by the underlying datatabase technology. We can load …

Data Loading Utilities into Postgres Database Read More »

Using psql to interact with Postgresql¶ Let us understand how to use psql utility to perform database operations. psql is command line utility to connect to the Postgres database server. It is typically used for the following by advanced Database users: Manage Databases Manage Tables Load data into tables for testing purposes We need to …

Using PSQL to interact with PostgreSQL Read More »