Vamsi Penmetsa

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 …

Creating Table Read More »

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 …

CRUD Operations Read More »

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 …

Database Operations – Overview Read More »

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 »