SQL Aliases | Column & Table Alias | How to use SQL Aliases? | DBMS Lecture-50 | Shanu Kuttan |Hindi

#SQL #SQLAliases #ColumnAlias #TableAlias #DBMS

@ShanuKuttanCSEClasses

This video covers:
SQL Aliases, Column Alias, Table Alias
How to use SQL Aliases?
SQL Aliases with Example

This is lecture 50 for Database Management System (DBMS) Unit 3 according to CSVTU Bhilai.

For more videos on DBMS follow the given link:

DBMS Playlist: https://www.youtube.com/playlist?list=PL3R9-um41Jsw8hAUYOfNmWNjUr73H6ee0

ER Model Playlist: https://www.youtube.com/playlist?list=PL3R9-um41JsxPg4WAPeEZgH6oAk2oti0Q

Relational Model Playlist: https://www.youtube.com/playlist?list=PL3R9-um41JszwZtQ91SlFbBw8Vx5Pb340

SQL Playlist: https://youtube.com/playlist?list=PL3R9-um41JszTUtBchCr98IwblWL2jiYf

Lecture 1: Database Management System (DBMS) Introduction https://youtu.be/nSVzOyT5M8E
Lecture 2: View of Data in DBMS | Three Levels of Abstraction | Schema & Instance | Data Independence https://youtu.be/kawRbAyNSRo
Lecture 3: Data Models | Relational Model | ER Model |Object Based Model | Semi-Structured Model https://youtu.be/b-D1D35R4io
Lecture 4: Database Languages | DDL, DML, DCL, TCL https://youtu.be/b_zSq3bEX3s
Lecture 5: Database Access from Application Programs | SQL | APIs - ODBC & JDBC | Embedded SQL https://youtu.be/dme--Cf8NK0
Lecture 6: Database Users and Administrators https://youtu.be/Q7t5guleBVw
Lecture 7: Transaction Management & Storage Management https://youtu.be/YawKHraWp_w
Lecture 8: Database System Structure, Query Processor, Storage Manager https://youtu.be/wVJ9tJAKy1U
Lecture 9: DBMS Architecture: 1-tier 2-tier 3-tier Architecture https://youtu.be/oPOMZQe3lgE
Lecture 10: History of Database Systems https://youtu.be/BvPws8s2Y9w
Lecture 11: Introduction to ER Model, Entity-Attributes-Relationships https://youtu.be/_riISaqXpQs
Lecture 12: Types of Attributes in ER Model https://youtu.be/g-Bh36AI78w
Lecture 13: Mapping Cardinalities & Participation Constraints https://youtu.be/TX2fhj8Xrj8
Lecture 14: Keys in DBMS - Super Key, Candidate Key, Primary Key, Foreign Key, Alternate Key, Composite Key https://youtu.be/RRUeFwuJ39Q
Lecture 15: Strong Entity & Weak Entity in DBMS https://youtu.be/ZV5xnTaLLgM
Lecture 16: Extended ER Features: Generalization, Specialization, Aggregation in DBMS https://youtu.be/ZV5xnTaLLgM
Lecture 17: Converting ER Diagrams to Tables with Examples | Rules https://youtu.be/GiLpCYekYmw
Lecture 18: Questions on Conversion of ER Diagrams to Tables | Part 1 - https://youtu.be/luFjZEmzLN0
Lecture 19: Questions on Conversion of ER Diagrams to Tables | Part 2 -https://youtu.be/G-KfeUijycQ
Lecture 20: How to draw ER diagram| ER Diagram for Banking System | ER Notations https://youtu.be/dXXBzelJ6sE
Lecture 21: Relational Model in DBMS | RDBMS https://youtu.be/EwEY_Y2Zz0s
Lecture 22: Relational Model Mathematical Structure in DBMS https://youtu.be/ygcJPWnxTls
Lecture 23: Integrity Constraints https://youtu.be/rXaxmKFvfmY
Lecture 23: Relational Query Language https://youtu.be/DZKIyMgC_KQ
Lecture 25: Relational Algebra https://youtu.be/rWGiEWqv3Xo
Lecture 26: Selection Operator in Relational Algebra https://youtu.be/x5naOGMpy7c
Lecture 27: Projection Operator in Relational Algebra https://youtu.be/pqHm5n2iOBk
Lecture 28: Set Operators: Union Set Inetrsection and Set Difference https://youtu.be/TxtjfAt71h4
Lecture 29: Cartesian Product in Relational Algebra https://youtu.be/SCHEU--CgA4
Lecture 30: Rename Operator https://youtu.be/wjcqTF7FJ0A
Lecture 31: Relational Algebra Example Questions https://youtu.be/kV2H25o5rGs
Lecture 32: Join Operator and its types https://youtu.be/28V421ajsQI
Lecture 33: Inner Join: Theta Join, Equi Join, Natural Join https://youtu.be/C1LAD-01-A8
Lecture 34: Natural Join Example Questions https://youtu.be/zVZzJHSQlSw
Lecture 35: Outer Joins: Left Outer, Right Outer, Full Outer https://youtu.be/1_SfkKZzPUY
Lecture 36: Division Operator https://youtu.be/0N8EEM3myTE
Lecture 37: Assignment Operator https://youtu.be/FG0ndNastu4
Lecture 38: Extended Relational Algebra Operations https://youtu.be/LqbOImBBHUk
Lecture 39: NULL Values https://youtu.be/qdE8M1nz-uw
Lecture 40: Modification of Database https://youtu.be/J7GBA1asPL8
Lecture 41: Views in DBMS https://youtu.be/U9rRR8ZpHaM
Lecture 42: Relational Calculus: Tuple and Domain Relational Calculus https://youtu.be/mDSDdDSJqts
Lecture 43: SQL Introduction https://youtu.be/NtnD4YjhAjo
Lecture 44: SQL DDL Commands https://youtu.be/N8l5b6yQzDg
Lecture 45: SQL DML Commands https://youtu.be/SxTcwWY0hqQ
Lecture 46: SQL: SELECT DISTINCT https://youtu.be/sLJDBZqw6F8
Lecture 47: SQL: AND, OR, NOT Operator https://youtu.be/r-pInL5sLRk
Lecture 48: SQL: IN, BETWEEN, LIKE Operator & WILDCARD character https://youtu.be/qx8QyD4auj8
Lecture 49: SQL: NULL Values, IS NULL, IS NOT NULL Operator https://youtu.be/dXg9qte1Fdg
Lecture 50: SQL Aliases https://youtu.be/DGVIQpnA7b8

Contact Link in Facebook:
https://www.facebook.com/shanukuttan.cseclasses
es

Видео SQL Aliases | Column & Table Alias | How to use SQL Aliases? | DBMS Lecture-50 | Shanu Kuttan |Hindi канала Shanu Kuttan CSE Classes