dbms complete unit 2 | database management systems | DBMS | unit 2

Описание: Complete DATABASE MANAGEMENT SYSTEMS ( DBMS ) SUBJECT PLAYLIST:
   • database, characteristics, features, tasks...  

DBMS unit 2 study material pdf:
https://drive.google.com/file/d/1LTQN...

MY INSTAGRAM ID :
https://instagram.com/nagendrasai_che...


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