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 …
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 …
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 …
Writing Basic SQL Queries¶ As part of this section we will primarily focus on writing basic queries. Standard Transformations Overview of Data Model Define Problem Statement – Daily Product Revenue Preparing Tables Selecting or Projecting Data Filtering Data Joining Tables – Inner Joining Tables – Outer Performing Aggregations Sorting Data Solution – Daily Product Revenue …
Exercises – Database Operations¶ Let’s create a table and perform database operations using direct SQL. Exercise 1 – Create Table¶ Create table – courses course_id – sequence generated integer and primary key course_name – which holds alpha numeric or string values up to 60 characters course_author – which holds the name of the author up …
