Cartesian Product In SQL Part-2

Duration: 6 min

This video lesson is available to enrolled students.

Return to /learn/RSSB-SENIOR-COMPUTER-INSTRUCTOR/paper-2-database-management-system/sql/set-operations-cartesian-product/asset-cartesian-product-in-sql-part-2 after enrolling

Inside: a video lesson and guided study material.

Module outline

  1. About the Course: About the Course
  2. Paper-1 & 2 | Basic Numeracy: Ratio and Proportion (Ratios), Divisibility Rules, Mixture and Alligation, Permutation and Combination, Logarithm, Number System, HCF LCM, Sequence and Series (Series), Speed Time and Distance, Percentage, Average, Mensuration and Geometry, Age Problems, Arithmetic, Statistics, Probability, Profit and Loss, Simple Interest and Compound Interest, Partnership, Speed Mathematics and Basic Mathematics, Algebra, Powers and Exponents (Surds and Indices), Time and Work, Pipe and Cistern, RSSB Specific Videos - Basic Numeracy
  3. Paper-1 & 2 | Data Interpretation: Data Interpretation
  4. Paper-1 & 2 | General Mental Ability: Mental Ability, RSSB Specific Videos - Mental Ability
  5. Paper-1 & 2 | Logical Reasoning and Analytical Ability: Series (Number and Letter Series) (Numerical Relations and Reasoning), Coding Decoding, Data Sufficiency, Non Verbal Reasoning (Spatial Aptitude) (Spatial Reasoning) (Visual Reasoning), Syllogisms, Seating Arrangements, Blood Relations, Directions (Direction Test), Analytical Reasoning (Counting Figures Reasoning), Puzzle Solving (Puzzles), Calendar, Clock, Cubes & Dices, Venn Diagram, Analogy, Ranking, Order and Sequence, Deductive and Inductive Reasoning (Logical Deduction and Induction) (Prepositional Reasoning), Data Arrangement, Logical Sequence Of Words, Crypt Arithmetic
  6. Paper-1 & 2 | Decision Making and Problem Solving: Selection Decision Table (Decision Making)
  7. Paper-1 | General Science: Physics, Biology, Chemistry, RSSB Specific Videos
  8. Paper-1 | General Awareness: State Wise GK, GK- Current Affairs
  9. Paper-2 | Fundamentals of Computer: Basics of COA, Number System, Floating Point Rep, Number Representation
  10. Paper - 2 | Digital Logic Systems: Digital Systems & Boolean Basics, Logic Gates & Hardware, Boolean Expression, Boolean Minimization, Combinational Circuit, Sequential Circuits
  11. Paper-2 | Operating Systems: Introduction to OS, Process Management, CPU Scheduling, Process Synchronization, Deadlock, Threads & Process Creation, Memory Management, Virtual Memory, Disc Scheduling, File Management, Linux OS, Distributed Systems
  12. Paper-2 | Database Management System: Basics of DBMS, ER Diagram, Relational Model & Functional Dependencies, Keys & Integrity Constraints, Normalization (1NF - BCNF), Decomposition Properties & 4NF, Relational Algebra, SQL, Relational Calculus, File Organization & Indexing, Transaction Management, Concurrency Control
  13. Paper-2 | Data Structures: Introduction to DS, Array, Stack, Queue, Linked List, Tree, Graphs, Hashing
  14. Paper-2 | C Programming: C Fundamentals, Control Flow, Functions, Arrays & Pointers, Storage Classes, Structures & Enums, DMA, Macros, Scoping & File Handling
  15. Paper 2 | Oops, C++, Java: Language Design, OOPS with C++, Java, .Net Programming, Java Fundamentals
  16. Paper 2 | Python: Introduction to Python, Tokens, Variables, Data Types, I/O, Operators & Expressions, Control Flow & Looping, Collections & Strings, Functions & Modules, File Handling & Data Analysis
  17. Paper 2 | Emerging Trends and AI: Emerging Tech Trends, Artificial Intelligence
  18. Paper-2 | Algorithms: Algorithm Analysis, Time Complexity Analysis, Sorting Algorithms, Greedy Algorithms, Advanced Algorithms
  19. Paper 2 | Data Communication and Network Security: Introduction to CN, Data Communication, DLL: Access Control, DLL: Flow Control, DLL: Error Control, Data Link Layer - Ethernet, Net Layer: IPv4 & Proto, Net Layer: IP Addressing, Net Layer:Routing Protocol, Transport Layer Services, TL: Congestion & UDP, Application Layer, Hardware basics, Network Security, Ethical Hacking
  20. Paper-2 I Software Engineering: Fundamentals of Software Engineering, Software Requirements and Quality Assurance, Software Design, Estimation and Metrics, Software Testing, Software Maintenance and Configuration Management
  21. Paper-2 | Computer Organization and Architecture: Cache Memory Organization, Input Output Organisation, Instr Formats & Modes, Control Unit Design, Register Transfer and Microoperations
  22. Paper-2 | Web Development: JavaScript-Basics, HTML Basics, CSS, XML
  23. Pedagogy: Child Development, Concept of Pedagogy, Psychology, Theories, Inclusive Education, Experiential Pedagogy, Curriculum Framework & Reforms, National Education Policy (NEP) 2020
  24. Live Sessions: RSSB Live Sessions
  25. RSSB Paper 1 - Full Mock Tests:
  26. RSSB Paper 2 - Full Mock Tests:
  27. SCI Previous Year Papers:
AI summary & chapters

AI Summary

An AI-generated summary of this video lecture.

The video features a lecture on SQL query formulation using a bank database schema. The instructor, Sanchit Jain Sir, demonstrates how to write queries involving multiple tables. He starts with a query to find customers with loans under 1000 or from a specific branch, then moves to finding customers with accounts in Delhi. He writes the queries step-by-step on a whiteboard, identifying necessary tables and join conditions.

Chapters

  1. 0:00 – 2:00 00:00-02:00

    The video begins with the instructor presenting a specific SQL problem: "Write a SQL query to find the name of all the customers, who have a loan in the bank of less than 1000 or loan from north_delhi branch?" He analyzes the database schema shown on the left, specifically focusing on the loan and borrower tables. He starts constructing the query by writing Select customer_name at the top. He then specifies the source tables in the from clause as Loan, borrower. To link these tables, he writes the where clause condition loan_ln = borrower_ln, indicating a join on the loan number. He then attempts to add the specific conditions from the question, writing and amt < 1000 or b_n = 'ND'. This part shows the initial setup for a query involving an OR condition across different attributes of the loan table. The instructor is seen writing in red ink on the whiteboard space above the schema diagram. The background schema shows loan table with loan_number, branch_name, amount and borrower table with customer_name, loan_number. The instructor is explaining the logic of combining conditions. He also points to the loan table in the diagram.

  2. 2:00 – 5:00 02:00-05:00

    The instructor moves to a new problem displayed at the top: "Write a SQL query to find the name of the customer who have an account in the branch situated in Delhi?" He identifies the necessary tables for this query as branch, account, and depositor. He writes Select customer_name and lists the tables in the from clause. He then meticulously writes the join conditions in the where clause: branch.bn = account.bn to link branches to accounts, and account.ano = depositor.ano to link accounts to depositors. He circles the relevant attributes on the schema diagram to visualize the data flow. Finally, he adds the filtering condition and branch.city = 'Delhi' to restrict the results to the specific location mentioned in the question. The instructor uses red ink to highlight the table names and attributes as he writes them. The schema shows branch with branch_name, branch_city, assets; account with account_number, branch_name, balance; and depositor with customer_name, account_number. He emphasizes the relationship between the tables. He points to the depositor table and circles customer_name.

  3. 5:00 – 5:31 05:00-05:31

    In the final segment, the instructor reviews the completed query structure for the Delhi account problem. He points specifically to the customer_name attribute within the depositor table, confirming it as the target column for the SELECT statement. He also highlights the branch_city attribute in the branch table, which serves as the filter condition. The board displays the full logical flow: selecting customer names from the depositor table, joining with account and branch tables, and filtering by city. This concludes the demonstration of writing multi-table SQL queries based on the provided entity-relationship diagram. The instructor is wearing a white shirt and speaking into a microphone. The query effectively navigates from the branch table to the depositor table to retrieve the desired customer information. The video ends with the full query visible on the screen. He points to the branch_city attribute.

The lecture systematically guides students through constructing complex SQL queries by breaking down the problem into table selection, join conditions, and filtering criteria. The instructor uses a whiteboard to visually map out the relationships between the branch, account, depositor, loan, and borrower tables, ensuring students understand how to traverse the schema to retrieve specific data like customer names based on loan amounts or branch locations.

Loading lesson…