#15 Cartesian Product on two tables | Database Management | Class 12 CBSE Computer Science
Welcome to the Part 14 of the Unit on Database Management by Bhargab Kakati for CBSE Class 12 (XII) Computer Science (083) and Informatics Practices (IP) Examination. In this part, i have discussed about the concept of cartesian product on two tables along with SQL implementation.
Topics Covered:
00:30 what is cartesian product
01:35 Working of Cartesian product
03:06 implementation of cartesian product in SQL
If you haven't watched other parts of this unit , you may watch from the links below :
👉 Part 1 - Introduction to Databases
• #1 Introduction to Database Concepts | Dat...
👉 Part 2 - Keys and Its Types - Primary , Candidate , Alternate and Foreign Key
• #2 Keys and Its Types - Primary,Candidate,...
👉 Part 3 - Introduction to SQL
• #3 Introduction to SQL | Class 12 CBSE Com...
👉 Part 4 - Getting Started with SQL
• #4 Getting Started with SQL | Class 12 CBS...
👉 Part 5 - Data Filtering in SQL
• #5 Data Filtering in SQL | Database Manage...
👉 Part 6 - delete vs drop in SQL
• #6 Delete vs Drop in SQL | Database Manage...
👉 Part 7 - Pattern matching in SQL | like operator
• #7 Pattern Matching in SQL | like operator...
👉 Part 8 - Data Manipulation in SQL | alter vs update
• #8 Data Manipulation in SQL | alter vs upd...
👉 Part 9 - Sorting Data in SQL | order by
• #9 Sorting Data in SQL | order by | Databa...
👉 Part 10 - Aggregate Functions in SQL
• #10 Aggregate Functions in SQL | Database ...
👉Part 11 - Grouping Results in SQL | group by
• #11 Grouping Results in SQL | group by | D...
👉Part 12 - Joins in SQL | Equi Join and Natural Join
• #12 Joins in SQL | Equi Join and Natural J...
👉Part 13 - Constraints in SQL | Primary Key , Not Null , Unique and Default Constraint
• #13 Constraints in SQL | Not Null , Primar...
👉Part 14 - Foreign Key Constraint in SQL
• #14 Foreign Key Constraint in SQL | Class ...
Connect on these social media Handles:
👉 Instagram: / urja.academy
/ bhargab_kakati
👉 LinkedIn : / bhargabkakati
👉 Twitter : / bhargab008
#Database #SQL #Class12 #ComputerScience #MySQL #CartesianProduct #CrossJoin
Bhargab Kakati
PGT (Computer Science)