Gupta's blog
Series

Fundamentals & Core Concepts of Database Management System (SQL)

In this series I have whole heartedly explained all the concepts of dbms.

Articles in this series

CREATE , ALTER , INSERT , DROP , DELETE , PRIMARY KEY , FOREIGN KEY: Enhancing(SQL) (Part-2)

Dec 23, 202310 min read

PRE-REQUISTE Read Part 1st if you are not aware of all keys and anomalies in database PART-1 (Understand concept of all keys (theory) and what are...

CREATE , ALTER , INSERT , DROP , DELETE , PRIMARY KEY , FOREIGN KEY: Enhancing(SQL) (Part-2)

Super Key , Primary key , Candidate Key , Functional Dependency , Anomalies: Enhancing (SQL) (Part-1)

Dec 26, 20237 min read

What is Normalization? Normalization is the process of organizing the data in the database. It simply means there should be no redundancy . Redundancy...

Super Key , Primary key , Candidate Key , Functional Dependency , Anomalies: Enhancing (SQL) (Part-1)

1st Normal form , 2NF , 3NF , Partial Dependency , Transitive Dependency : Enhancing (SQL) (Part-3)

Dec 27, 20235 min read

PRE-REQUISTES If you are not familiar with keys , anomalies in database then read previous Blogs👇 PART-1 (Understand concept of all keys (theory)...

1st Normal form , 2NF , 3NF , Partial Dependency , Transitive Dependency : Enhancing (SQL) (Part-3)

How to group data , Sub-queries & questions: Enhancing(SQL) (Part-4)

Jan 11, 20245 min read

PRE-REQUISTES PART-1 (Understand concept of all keys (theory) and what are anomalies in database) PART-2 (CRUD operations in database , learn syntax &...

How to group data , Sub-queries & questions: Enhancing(SQL) (Part-4)

What is JOIN in SQL , Different types of JOIN: Enhancing(SQL) (Part-5)

Jan 22, 20243 min read

PRE-REQUISTES PART-1 (Understand concept of all keys (theory) and what are anomalies in database) PART-2 (CRUD operations in database , learn syntax &...

What is JOIN in SQL , Different types of JOIN: Enhancing(SQL) (Part-5)