The easiest way to skyrocket your YouTube subscribers
Get Free YouTube Subscribers, Views and Likes

L3.10 Rename Operator in Relational Algebra | DBMS | Shanu Kuttan

Follow
Shanu Kuttan CSE Classes

#RenameOperator #RelationalAlgebraOperators #RenameOperation

This video explains Rename Operator in Relational Algebra, Rename Operation in Relational Algebra, Rename Operator syntax, Rename Operator Examples, Rename Operator Examples in Relational Algebra, Rename Operator in SQL, Rename Operator in DBMS, Use of Rename Operator in Relational Algebra.

00:00 Rename Operator in Relational Algebra: Notation 1
04:38 Rename operator in SQL
06:13 Examples: Rename operator for Table Name
08:39 Notation 2, 3 for Rename operator for Table name & attributes
09:58 Example Queries

This is a lecture 30 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 & Relational Algebra  

Lecture 1: Database Management System (DBMS) Introduction    • L1.1 Database Management System |DBMS...  
Lecture 2: View of Data in DBMS | Three Levels of Abstraction | Schema & Instance | Data Independence    • L1.2 View of Data|Data Abstraction|Sc...  
Lecture 3: Data Models | Relational Model | ER Model |Object Based Model | SemiStructured Model    • L1.3 Data Models | Relational, ER, Ob...  
Lecture 4: Database Languages | DDL, DML, DCL, TCL    • L1.4 Database Languages | DDL, DML, D...  
Lecture 5: Database Access from Application Programs | SQL | APIs ODBC & JDBC | Embedded SQL    • L1.5 Database Access from Application...  
Lecture 6: Database Users and Administrators    • L1.6 Database Users and Administrator...  
Lecture 7: Transaction Management & Storage Management    • L1.7 Transaction Management & Storage...  
Lecture 8: Database System Structure, Query Processor, Storage Manager    • L1.8 Database System Structure | DBMS...  
Lecture 9: DBMS Architecture: 1tier 2tier 3tier Architecture    • L1.9 DBMS Architecture | 1tier 2tie...  
Lecture 10: History of Database Systems    • L1.10 History of Database Systems | D...  
Lecture 11: Introduction to ER Model, EntityAttributesRelationships    • L2.1 Introduction to ER Model | Entit...  
Lecture 12: Types of Attributes in ER Model    • L2.2 Attributes Types in ER Model |Si...  
Lecture 13: Mapping Cardinalities & Participation Constraints    • L2.3 Mapping Cardinalities (Cardinali...  
Lecture 14: Keys in DBMS Super Key, Candidate Key, Primary Key, Foreign Key, Alternate Key, Composite Key    • L2.4 Keys in DBMS | Super Key, Candid...  
Lecture 15: Strong Entity & Weak Entity in DBMS    • L2.5 Strong Entity & Weak Entity in D...  
Lecture 16: Extended ER Features: Generalization, Specialization, Aggregation in DBMS    • L2.5 Strong Entity & Weak Entity in D...  
Lecture 17: Converting ER Diagrams to Tables with Examples | Rules    • L2.7 Converting ER Diagrams to Tables...  
Lecture 18: Questions on Conversion of ER Diagrams to Tables | Part 1    • L2.8 Questions on ER Diagrams Convers...  
Lecture 19: Questions on Conversion of ER Diagrams to Tables | Part 2    • L2.9 Questions on ER Diagrams Convers...  
Lecture 20: How to draw ER diagram| ER Diagram for Banking System | ER Notations    • L2.10 How to draw ER Diagram? | Banki...  
Lecture 21: Relational Model in DBMS | RDBMS    • L3.1 Relational Model in DBMS | RDBMS...  
Lecture 22: Relational Model Mathematical Structure in DBMS    • L3.2 Relational Model Mathematical St...  
Lecture 23: Integrity Constraints    • L3.3 Integrity Constraints | Domain, ...  
Lecture 23: Relational Query Language    • L3.4 Relational Query Language | Proc...  
Lecture 25: Relational Algebra    • L3.5 Relational Algebra in DBMS | Rel...  
Lecture 26: Selection Operator in Relational Algebra    • L3.6 Selection Operator in Relational...  
Lecture 27: Projection Operator in Relational Algebra    • L3.7 Projection Operator in Relationa...  
Lecture 28: Set Operators: Union Set Inetrsection and Set Difference    • L3.8 SET Operators in Relational Alge...  
Lecture 29: Cartesian Product in Relational Algebra    • L3.9 Cartesian Product in Relational ...  
Lecture 30: Rename Operator    • L3.10 Rename Operator in Relational A...  
Lecture 31: Relational Algebra Example Questions    • L3.11 Relational Algebra Example Ques...  
Lecture 32: Join Operator and its types    • L3.12 Join Operator & its Types | Inn...  
Lecture 33: Inner Join: Theta Join, Equi Join, Natural Join    • L3.13 Inner Join: Theta Join, Equi Jo...  
Lecture 34: Natural Join Example Questions    • L3.14 Natural Join | Example Question...  
Lecture 35: Outer Joins: Left Outer, Right Outer, Full Outer    • L3.15 Outer Join: Left Outer, Right O...  

Welcome to this YouTube 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  

posted by schilderke