dbms complete unit 2 | database management systems | DBMS | unit 2
HTML-код
- Опубликовано: 28 сен 2024
- Complete DATABASE MANAGEMENT SYSTEMS ( DBMS ) SUBJECT PLAYLIST:
• database, characterist...
DBMS unit 2 study material pdf:
drive.google.c...
MY INSTAGRAM ID :
...
unit-2 topics:
00:34 - Relational model
03:34 - Database languages (DDL, DML, DQL, DCL, TCL)
35:31 -Types of keys ( primary key, foreign key, super key, candidate key, alternate key, composite key)
57:17 - Views( simple & complex views, creating, updating and deleting views)
01:07:39 - Aggregate functions ( count(), max(), min(), sum() , avg() )
01:15:28 -integrity constraints ( domain constraints, entity integrity constraints, referential integrity constraints, key constraints)
01:39:14 -logical database design( converting entity sets, weak entity sets, relationship sets to tables)
01:49:38 -Relational algebra ( all operations and examples)
02:18:08 -Relational calculus(tuple and domain relational calculus)
#DBMS#Databasemanagementsystem#btechDBMS#Databasemanagementsystems#DBMSforbtech#Databasemanagementsystemforbtech#DBMSforbtech#Databasemanagementsystemsforbtech#btech#cse#aiml#datascience#cse#UNIT1#completeunit1#r18#r20#r22#jntuh#jntuk#jntua#database#databasemanagementsystem#logical#database#design#logicaldatabasedesign#in#dbms#logicaldatabasedesignindbms#converting#entityset#weakentityset#relationshipset#to#tables#convertingentitysettotables#convertingweakentitysettotables#convertingrelationshipsettotables#constraints#integrityconstraints#domainconstraints#entityintegrityconstraints#referentialintegrityconstraints#keyconstraints#relational#model#relationalmodel#relationaldatabase#dbms#distinct#keyword#distinctkeyword#groupby#clause#groupbyclauseindbms#aggregatefunctions#aggregatefunctionsindbms#sum#min#max#count#avg#sumfunction#minfunction#maxfunction#countfunction#avgfunction#dbms#unit#2#unit2#keysindbms#keys#typesofkeys#primarykey#foreignkey#superkey#candidatekey#alternatekey#compositekey#typesofkeysindbms#views#view#simpleview#complexview#creatingview#updatingview#deletingview#viewstopic#viewsindbms#viewindbms#simpleviewindbms#complexviewindbms#creatingviewindbms#updatingviewindbms#deletingviewindbms#viewstopicindbms#viewsfromsingletable#viewsfrommultipletables#databaselanguages#sqllanguages#datadefinitionlanguage#datamanipulationlanguage#dataquerylanguage#transactioncontrollanguage#datacontrollanguage#ddl#dml#dql#tcl#dcl#create#alter#drop#truncate#rename#insert#update#delete#select#commit#rollback#grant#revoke#commands#command#createcommand#altercommand#dropcommand#truncatecommand#renamecommand#insertcommand#updatecommand#deletecommand#selectcommand#commitcommand#rollbackcommand#grantcommand#revokecommand#ddlcommands#dmlcommands#dqlcommands#tclcommands#dclcommands#unit2#dbms#jntih#r18#r20#r22#relationalclaculus#tuplerelationalcalculus#domainrelationalcalculus#relationalclaculusindbms#tuplerelationalcalculusindbms#domainrelationalcalculusindbms#dbmsunit2#unit2#relationalclaculusexamples#tuplerelationalcalculusexamples#domainrelationalcalculusexamples#examples#relationalalgebra#dbms#relationalalgebraindbms#dbmsrelationalalgebra#variousoperations#alloperations#relationalalgerbra#select#selection#project#projection#rename#cartesianproduct#setoperations#union#intersection#difference#setdifference#joins#innerjoin#outerjoin#equijoin#thetajoin#naturaljoin#leftouterjoin#rightouterjoin#fullouterjoin#selectoperation#selectionoperation#projectoperation#projectionoperation#renameoperation#cartesianproductoperation#setoperations#unionoperation#intersectionoperation#differenceoperation#setdifferenceoperation#joinsoperation#innerjoinoperation#outerjoinoperation#equijoinoperation#thetajoinoperation#naturaljoinoperation#leftouterjoinoperation#rightouterjoinoperation#fullouterjoinoperation#selectoperationinrelationalalgebra#selectionoperationinrelationalalgebra#projectoperationinrelationalalgebra#projectionoperationinrelationalalgebra#renameoperationinrelationalalgebra#cartesianproductoperationinrelationalalgebra#setoperationsinrelationalalgebra#unionoperationinrelationalalgebra#intersectionoperationinrelationalalgebra#differenceoperationinrelationalalgebra#setdifferenceoperationinrelationalalgebra#joinsoperationinrelationalalgebra#innerjoinoperationinrelationalalgebra#outerjoinoperationinrelationalalgebra#equijoinoperationinrelationalalgebra#thetajoinoperationinrelationalalgebra#naturaljoinoperationinrelationalalgebra#leftouterjoinoperationinrelationalalgebra#rightouterjoinoperationinrelationalalgebra#fullouterjoinoperationinrelationalalgebra#relationalalgebraoperators#relationalalgebraoperations
Best 🤌💯💯💯
Pls explain unit 3,4,5 in one shot
This type of one shot deserves million views
Broo exams are coming soon please send overview of the unit-3,4,5 also
Sir ,Topic -3 is missing in this...
"Querying relational data "
Querying is nothing but, DQL Language - u can see database languages topic
Sir digital design subject can explain ha
Bro edi 5 th sem syllabus aa
Bro please post 3,4,5 chapters also...
Waiting for unit 3
Sir please sir...unit 3,4,5 kuda pettandi sir please 😢🙏🙏
Bro edi degree 5th sem syllabus aa
🫡@@THE_FIGHTERS
Sir your teaching is excellent
And hatsoff to your dedication teaching students like a small kid .from basics u cover everything
Please give notes and videos for sql
Sir ,please help with these units Basics of SQL, Database Transactions Management ,Parallel Databases ,Distributed Databases .
Anna unit-3,4,5 kuda pettandi please
sir its a humble request on the behalf of all the students of aktu university to make one shot of unit 3,4,5 of dbms 😟
Anna koncham fast ga 3,4,5 units kuda upload chyyandii
Bro plz keep 3,4,5 units also
sir atleast keep all units notes sir pls 3 4 5
Unit3,4,5 PDFs leva bro repu aftnoon ah exm
Your explanation is super sir please send unit-3,4,5
3rd unit
Sir can u make a shot of 3 4 5 units
Marvellous sir
thank u so much sir