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
26 сен 2024