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 …
Exercise – Loading Data¶ As part of this exercise, you need to take care of loading data using COPY Command. You can connect to the database using following details in the environment provided by us. Host: localhost Port: 5342 Database Name: YOUR_OS_USER_hr_db User Name: YOUR_OS_USER_hr_user Password: YOUR_OS_USER_PASSWORD (provided by us). If you are using your …
Loading Data – Docker¶ Let us understand how you can take care of loading data into Postgres Database running using Docker Container. Make sure database is created along with the user with right permissions. Also the user who want to use COPY command need to have pg_read_server_files role assigned. Create file with sample data Copy …
