Advance Database Management Syllabus :
BE- IT
Unit I Overview
PL/SQL – Introduction to PL/SQL – Declare, begin statements, Variables, Control Structure, PL/SQL Transactions – Savepoint, Cursor, PL/SQL Database Objects – Procedures, Functions, Packages, Triggers. Programmatic SQL – Embedded SQL, Dynamic SQL, and ODBC Standard.
Unit II Transaction processing and concurrency control
Definition of Transaction and ACID properties. Transaction Processing - Transaction-processing monitors, transactional workflows, main-memory databases, real-time transaction systems, long-duration transactions,
transaction management in multi-databases. Concurrency Control – Locks, Optimistic Concurrency Control (Backward and Forward validations), Timestamping Concurrency Control.
Unit III Object-based databases and xml
Object-based databases – Complex data types, structured types and inheritance in SQL, table inheritance, array and multiset types in SQL, objectidentity and reference types in SQL, implementing O-R features, Persistent programming languages, OO vs OR. XML – Structure of XML, Document Schema, Querying and Transformation, API in XML, XML applications.
Unit IV Data warehousing
Introduction to Data Warehousing – Concepts, Benefits and Problems, DW Architecture – Operational Data, load manager, meta data, DW Data flows – inflow, upflow, meta flow, DW tools and technologies – Extraction, cleansing and transformation tools, DW DBMS, admin and management tools, data marts – reasons and issues, Data Warehousing using Oracle. Data Warehousing Design – Designing, Dimensionality modeling, Design methodology, DW deign using Oracle.
Unit V Olap and data mining
On-line Analytical Processing – OLAP BenchMarks, applications, benefits, tools, categories, extensions to SQL, Data mining – introduction, techniques, predictive modeling, tools. Data mining algorithms – Apriori, Decision tree, k-means, Bayesian classifier.
Unit VI Database security
Security and integrity threats, Defence mechanisms, Statistical database auditing & control. Security issue based on granting/revoking of privileges, Introduction to statistical database security. PL/SQL Security – Locks – Implicit locking, types and levels of locks, explicit locking, Oracles’ named
Exception Handlers.
Unit
|
Download Link
|
Unit 1
|
|
Unit 2
|
|
Unit 3
|
|
Unit 4
|
|
Unit 5
|
|
Unit 6
|
Books to Download for ADBMS
Database System Concepts
Korth, Sudarshan,Silberschatz
--------------------------------------------------
Fundamentals of Database Systems
Elmasari , Navathe
Elmasari , Navathe
---------------------------------------------------
Data Warehousing for dummies
------------------------------------------
Database Management Systems
Raghu Ramkrishnan, Gehrke
Handbook of Database Security
Applications and Trends
Gertz, Jajodia,
Database Management Systems
Raghu Ramkrishnan, Gehrke
---------------------------------------
Database Systems
A Practical Approach to Design, Implementation & Management
Thomas Connolly, Carolyn Begg
--------------------------------
Data Mining : Concepts Techniques
Han, Kamber, Pei
-----------------------------------
Applications and Trends
Gertz, Jajodia,
----------------------------------------------
Data Warehousing : OLAP & Data Mining
====================================
Video Lectures
====================================
====================================
Introduction to Database Systems
What is relational Database
Data Warehousing - Basics
Introduction to Data Warehousing
& OLAP
Data Warehousing - Definition
What is Data Mining?
Database Security
What is OLAP?
-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-x-
