• learningmonkey01@gmail.com
Follow Us :
cropped-Learning-Monkey-Logo-1.jpg
  • Home
  • Courses
  • About Us
  • FAQs
  • Blog
  • Contact

Nested Query 3 in SQL

  • Home
  • Nested Query 3 in SQL
Database Management Systems Nested Query 3 in SQL

Nested Query 3 in SQL

For Complete YouTube Video: Click Here

In this class, we will try to understand SQL Query on Multiple Tables.

We have already discussed the concepts of Cartesian Product in SQL.

Nested Queries in SQL

A clear understanding of the query is made in the above youtube link.

The queries and the outputs of the queries are as shown below.

Query 1:

Nested Query 3 in SQL
Nested Query in SQL
Previous Lesson
Back to Course
Next Lesson
Course Home
Introduction
Understanding the Definition of Data and Database
Definition of Database Management Systems DBMS
File System v/s Database Management System DBMS
An Example Database – Company Database
Entity Relationship Model
Database Design using Entity-Relationship Model ER-Model
Definitions of Entity Attribute and Entity Type
Simple and Composite Attributes
Single-Valued and Multi-Valued Attributes
Stored and Derived Attributes
Key Attributes of an Entity Type
Identifying the Entity Types and Attributes from the Requirements
Identifying the Relationship Types between the Entity Types
Relationship Instance and the Degree of a Relationship Type
Identifying another Relationship Type and Understanding Attributes of a Relationship Type
Cardinality Ratio of a Binary Relationship
Participation Constraint
Many to Many Relation on Works_On Relationship Type
One to Many Relation on Controls Relationship Type
Role Names of an Entity Type in a Relationship Type
Recursive Relationships
Weak Entity Types
Relational Database Management Systems
Requirements to ER Diagrams to Database Schema
Relation Attributes and Tuples in RDBMS
Domain Relation Schema and Relation State in RDBMS
ER Diagram to Database Scheme 1
How to Download and Install Oracle 18c
CREATE TABLE Command in SQL
INSERT INTO command in SQL
Understanding the use of NOT NULL and Primary Key
Relational Model Constraints Domain constraints
Key Constraints and NULL Value Constraints
Referential Integrity constraints and Foreign Keys
Implementation of Referential Integrity Constraint Using Foreign keys
One-to-One Relationships in ER Diagram to Database Schema
Multivalued Attributes to Database Schema
One-to-Many Relationships to Database Schema
Structured Query Language - SQL
Implementing the Complete Company Database
ALTER TABLE Command in SQL
ADD and DROP a Constraint using ALTER TABLE command in SQL
TRUNCATE TABLE and DROP TABLE Commands in SQL
SELECT Command in SQL
WHERE Clause in SQL
UPDATE Command in SQL
DELETE Command in SQL
COMMIT and ROLLBACK Commands in SQL
Equal to Greater than Less than Not Equal to Operators in SQL
LIKE Operator in SQL
IS NULL and IS NOT NULL Operators in SQL
IN and NOT IN Operators in SQL
BETWEEN and NOT BETWEEN Operators in SQL
AND OR NOT Logical Connectors in SQL
CONCAT in SQL
UPPER LOWER INITCAP in SQL
RPAD and LPAD in SQL
LTRIM and RTRIM Functions in SQL
LENGTH SUBSTR INSTR Functions in SQL
ABS CEIL FLOOR functions in SQL
MOD POWER SQRT functions in SQL
ROUND and TRUNC functions in SQL
NVL Function in SQL
AVG COUNT MAX MIN SUM Functions in SQL
SYSDATE CURRENT_DATE SYSTIMESTAMP Functions in SQL
DATE Arithmetic Difference between the dates
ADD_MONTHS GREATEST LEAST TO_DATE Functions in SQL
NEXT_DAY LAST_DAY MONTHS_BETWEEN Functions in SQL
ORDER BY in SQL
DISTINCT in SQL
CARTESIAN PRODUCT in SQL
Aliasing and AS Operator in SQL
SQL Query 1 on Multiple Tables
SQL Query 2 on Multiple Tables
SQL Query 3 on Multiple Tables
INTERSECT Operator in SQL
UNION UNION ALL MINUS Set Operators in SQL
Nested Queries 1 in SQL
Nested Query 2 in SQL
Nested Query 3 in SQL
Nested Query 4 in SQL
GROUP BY and HAVING in SQL
Example 1 of GROUP BY and HAVING in SQL
Example 2 on GROUP BY and HAVING in SQL
INNER JOIN in SQL
LEFT JOIN RIGHT JOIN and FULL JOIN in SQL
Correlated Nested Queries in SQL
EXISTS and NOT EXISTS in SQL
Understanding ALL ANY or SOME in SQL
Example 1 on Correlated Nested Queries in SQL
Example 2 on Correlated Nested Queries in SQL
Introduction to Relational Algebra and its operators in DBMS
Rename Union Intersection Set Difference and Cartesian Product Operators in Relational Algebra
Inner join Theta join Equi join Natural join
Outer join Left outer join Right outer join Full outer join
Understanding Division Operator in Relational Algebra
Solving Examples on Relational Algebra
Understanding Relational Calculus and Types of Relational Calculus
Existential Quantifier and Universal Quantifier
Transforming Universal and Existential Quantifiers
Relationally Complete Language, Safe and Unsafe Expressions
Examples 01 on Tuple Relational Calculus
Examples 02 on Tuple Relational Calculus
Domain Relational Calculus
GATE Bits 07 on Relational Algebra and Relational Calculus
GATE Bits 08 on Relational Algebra and Relational Calculus
GATE Bits 09 on Relational Algebra and Relational Calculus
Introduction to Normalization
Redundancy and Anomalies
Understanding Functional Dependencies
Understanding Super Key, Key, Candidate Key and Primary key
Armstrong’s Axiom
Closure of the Functional Dependency
Determining Candidate Keys
Example 01, 02 on Determining Candidate Keys
GATE Bits 10 on Determining Candidate Keys
Equivalence of Functional Dependencies
Minimal Cover or Canonical Cover
First Normal Form 1NF
Lossless Decomposition
Dependency Preserving Decomposition
Second Normal Form 2NF
Examples on Second Normal Form 2NF
Third Normal Form 3NF
Examples on Third Normal Form 3NF
Boyce Codd Normal Form BCNF
Examples on Boyce Codd Normal Form BCNF
GATE Bits 11 on Normalization
GATE Bits 12 on Normalization
GATE Bits 13 on Normalization
GATE Bits 14 on Normalization
Return to Database Management Systems
Final LOGO PNG

Learning Monkey is perfect platform for self learners.

Contact Us

 

learningmonkey01@gmail.com
www.learningmonkey.in

© 2021Learning Monkey. All rights reserved.