Hons IV DBMS
Government Degree College::Tiruvuru
II B.Sc., SEMESTER –IV
Data Base Management Systems
UNIT-I
Overview of Database Management System
DBMS introduction - PDF click here
File Based Systems - Drawbacks (PDF) click here
-----------------------------------------------------------------------------
Evolution of DBMS (PDF) click here
------------------------------------------------------------------------------
Advantages of DBMS (PDF) click here
--------------------------------------------------------------------
Classification of DBMS PDF click here
--------------------------------------------------------------------
Data Models PDF click here
--------------------------------------------------------------------
ANSI-SPARC Data Model click here
--------------------------------------------------------------------
Components and Interfaces of DBMS click here
--------------------------------------------------------------------
DBMS Architecture click here
--------------------------------------------------------------------
Situations where DBMS is not Necessary, DBMS Vendors and Their Products. click here
--------------------------------------------------------------------
UNIT-2
Relational Data Model - introduction click here
ER Model Introduction: click here
-------------------------------------------------------------------------------
Relationship degree,classification,ER to Rel Model etc: click here
-------------------------------------------------------------------------------
EER Model: click here
--------------------------------------------------------------------
UNIT-3
Relational Model
Relational Model - introduction click here
Relational Data Model, Concept of Key click here
Relational Algebra click here
UNIT-4
History of SQL & Datatypes in SQL click here
--------------------------------------------------------------------
SQL Commands click here
-------------------------------------------------------------------
SQL Selection and Projection Operations click here
-------------------------------------------------------------------
SQL Aggregate Functions click here
-------------------------------------------------------------------
SQL Imposition of constraints click here
-------------------------------------------------------------------
SQL Joins click here
-------------------------------------------------------------------
SQL Set Operations click here
-------------------------------------------------------------------
SQL Views click here
-------------------------------------------------------------------
Subquery , Embedded SQL click here
--------------------------------------------------------------------
UNIT-5
PL/SQL introduction click here
--------------------------------------------------------------------
PL/SQL Language Elements click here
-------------------------------------------------------------------
Operator Precedence, Control Structures click here
------------------------------------------------------------------
Cursors click here
------------------------------------------------------------------
Procedures , Functions click here
------------------------------------------------------------------
Packages, Exception Handling click here
------------------------------------------------------------------
Database Triggers click here
------------------------------------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
🍒🍒~ Advertisement ~🍒🍒
Want to Learn Cooking
in a simple way?????
👍👍LIKE #### SHARE #### SUBSCRIBE👍👍
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Comments
Post a Comment