Gupta's blog

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)

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)

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)

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)

Mastering PL/SQL : Syntax, Identifiers , Comments , Declaration , Datatypes (Part-1) .

Dec 24, 20233 min read

What PL/SQL ? PL/SQL is nothing but a combination of SQL along with the procedural features of programming language. It means that in SQL we run query...

Mastering PL/SQL : Syntax, Identifiers , Comments , Declaration , Datatypes (Part-1) .

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)