Relational Algebra | Relational Algebra Operators | DBMS | Lecture-25 | Shanu Kuttan | in Hindi
HTML-код
- Опубликовано: 8 окт 2024
- #RelationalAlgebra #RelationalAlgebraOperators #RelationalModel #DBMS
This video explains Relational Algebra, What is Relational Algebra, Relational Algebra Operations, and Relational Algebra Operators:
Basic/Fundamental Operations:1. Select (σ),2. Project (∏), 3. Union (∪), 4. Set Difference (-), 5. Cartesian product (X), 6. Rename (ρ)
Derived Operations: 1. Natural Join (⋈), 2. Left outer join, Right outer join, Full outer join (⟕, ⟖, ⟗), 3. Intersection (∩), 4. Division (÷)
Also explains Relational Calculus, What procedural query language, non-procedural query language, SQL, Relational Algebra in Hindi, Relational Algebra in DBMS in Hindi.
This is a lecture 25 for Database Management System (DBMS) unit 2 according to CSVTU Bhilai.
For more videos on DBMS follow the given link:
DBMS Playlist: • DBMS Playlist
ER Model Playlist: • ER Model in hindi
Relational Model Playlist: • Relational Model & Rel...
SQL Playlist: • SQL
Lecture 1: Database Management System (DBMS) Introduction • Database Management Sy...
Lecture 2: View of Data in DBMS | Three Levels of Abstraction | Schema & Instance | Data Independence • View of Data in DBMS |...
Lecture 3: Data Models | Relational Model | ER Model |Object Based Model | Semi-Structured Model • Data Models | Relation...
Lecture 4: Database Languages | DDL, DML, DCL, TCL • Database Languages | D...
Lecture 5: Database Access from Application Programs | SQL | APIs - ODBC & JDBC | Embedded SQL • Database Access from A...
Lecture 6: Database Users and Administrators • Database Users and Adm...
Lecture 7: Transaction Management & Storage Management • Transaction Management...
Lecture 8: Database System Structure, Query Processor, Storage Manager • Database System Struct...
Lecture 9: DBMS Architecture: 1-tier 2-tier 3-tier Architecture • DBMS Architecture | 1-...
Lecture 10: History of Database Systems • History of Database Sy...
Lecture 11: Introduction to ER Model, Entity-Attributes-Relationships • Introduction to ER Mod...
Lecture 12: Types of Attributes in ER Model • Types of Attributes in...
Lecture 13: Mapping Cardinalities & Participation Constraints • Mapping Cardinalities ...
Lecture 14: Keys in DBMS - Super Key, Candidate Key, Primary Key, Foreign Key, Alternate Key, Composite Key • Keys in DBMS | Super K...
Lecture 15: Strong Entity & Weak Entity in DBMS • Strong Entity & Weak E...
Lecture 16: Extended ER Features: Generalization, Specialization, Aggregation in DBMS • Strong Entity & Weak E...
Lecture 17: Converting ER Diagrams to Tables with Examples | Rules • Converting ER Diagrams...
Lecture 18: Questions on Conversion of ER Diagrams to Tables | Part 1 - • Questions on Conversio...
Lecture 19: Questions on Conversion of ER Diagrams to Tables | Part 2 - • Questions on Conversio...
Lecture 20: How to draw ER diagram| ER Diagram for Banking System | ER Notations • How to draw ER Diagram...
Lecture 21: Relational Model in DBMS | RDBMS • Relational Model in DB...
Lecture 22: Relational Model Mathematical Structure in DBMS • Relational Model Mathe...
Lecture 23: Integrity Constraints • Integrity Constraints ...
Lecture 23: Relational Query Language • Relational Query Langu...
Lecture 25: Relational Algebra • Relational Algebra | R...
Welcome to this RUclips channel "Shanu Kuttan CSE Classes " by Shanu Kuttan. This is a technical educational channel for subjects of computer science and engineering subjects (CSE) as per university syllabus and also cover GATE topics. It provides Computer Science and engineering classes in Hindi. This channel’s video helps Computer Science and Engineering students to understand different subjects like Computer System Architecture (CSA) i.e. Computer Organization and Architecture (COA) or simply Computer Architecture, Database Management System (DBMS), Advance Computer Architecture (ACA), Parallel Processing and Computing (PPC) unit wise as per the CSVTU syllabus i.e. Chhattisgarh Swami Vivekanand Technical University, Bhilai
Contact Link in Facebook:
/ shanukuttan.cseclasses
Normalization,Transaction Processing,Concurrency Control,File organization, mam please cover these topics . your dbms playlist is best .
Very, Nice, Clear and Amazing explanation with smooth and beautiful content created
S = Simple
H = Hugely detailed
A = Amazing
N = Nice
U = Unbelievable
i was searching for these videos for many days,,,, finally got,,,,, NICE EXPLANATION, LOVED IT......I wish I could get all the relational model PPTs...
Thanks.........u can share the videos to others also.....as for now u can take screenshots
Thank you mam for the video😊
Thank you much ma'am ❤❤
Thank you so much mam 😊😘
Excellent explanation mam. Thanks🌹
Thank u soo mch maam ❤️
Great video, thanks 👍🏼
Thank you mam
Thank you ma'm
i love it so much
Wonderfully explained ma'am. Please share the PPT or pdf notes also.. please
Very helpful video
Your language is very quit and lovely
Thanks.....do subscribe and share to others also that they can be benefited
Thank you so much mam..... 😊😊😊
Thanku 😊
Your way of teaching is too nice ,can you please provide your notes because this would be very helpful
Thank you mam..
Thankyou mam ❤️
Awesome mam
nice explaination mam .......
Tnx ji🌿🌿
Thanks mam
mam if u don't mind plx agr normalization pr vedio bna dy iski forms or ecah and every thing bcz exam hai after 1 week so maza hi a jay ga 😋😉
Thank you mam..
But can u pls share the ppt it will help us to take notes
Ma'am can you please share these ppts as well
cool
can we get notes of whole DBMS , would be really greateful
Ma'am ap iska notes bhi description Mai daal dijiye 🙏
ma'am pr ye relational algebra procedural kaise ho ra h isme bhi to hm sirf query likh re h ki kya data retrieve krna h...kaise krna h wo hmne kaha likha?
Relational Algebra m Kaise karna h ye bhi batate h using different relation algebra operators, joins, etc
Ispe assignment kase bnaye plc help me
from where i can download these ppts
Mam can you provide these PPT 🙏
Mam please provide these ppts
Video starts at 2:05
Thank you mam
Thank you mam