Gupta's blog

Tag

BlogsWithCC

#blogswithcc

More content

Read more stories on Hashnode

Articles with this tag

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)

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)

#2 Computer Architecture: Computational Model and its Types.

Dec 10, 20232 min read

What is Computational Model? Computational Model is nothing but different hardware components connected with each other and how they perform...

#2 Computer Architecture: Computational Model and its Types.