GupShup Study
Database Engineering Lecture Notes and Ebook download
Rajan Sharma

Database Engineering Lecture Notes and Ebook download

Rajan Sharma | 18-Jan-2016 |

Hi friends, here Rajan Sharma uploaded notes for Database and Database Engineering with title Database Engineering Lecture Notes and Ebook download. You can download this lecture notes, ebook by clicking on the below file name or icon.

MODULE – I (10 Lectures)
Lecture 1: Introduction to Database Systems and its Applications
Lecture 2: Database System Architecture
Lecture 3: Data Abstraction, Data Independence
Lecture 4: Data Models – Network, Hierarchical and Relational Data Models
Lecture 5: Data Models – Relational and Object Oriented Data Models
Lecture 6: Entity Relationship (ER) Model
Lecture 7: Mapping ER Model to Relational Model
Lecture 8: Data Definitions Languages
Lecture 9: Data Manipulation Languages
Lecture 10: Integrity Constraints and Data Manipulation Operations
MODULE – II (08 Lectures)
Lecture 11: Relation Query Language, Fundamental Relation Algebra Operations
Lecture 12: Extended Relation Algebra Operations
Lecture 13: Tuple and Domain Relational Calculus
Lecture 14: SQL
Lecture 15: QBE, Domain and Data Dependency
Lecture 16: Armstrong’s Axioms, Dependency Preservation, Lossless Design
Lecture 17: Normal Forms – 1NF, 2NF, 3NF, BCNF
Lecture 18: Higher Normal Forms – 4NF, 5NF, Comparison of Oracle and DB2
MODULE – III (08 Lectures)
Lecture 19: Introduction to Query Processing
Lecture 20: Translating SQL Queries into Relational Algebra
Lecture 21: Algorithms for External Sorting
Lecture 22: Algorithms for SELECT and JOIN Operations
Lecture 23: Algorithms for PROJECT and SET Operations
Lecture 24: Query Equivalence, Join Strategies
Lecture 25: Overview of Query Optimization
Lecture 26: Query Optimization Algorithms
MODULE – IV (12 Lectures)
Lecture 27: Storage Strategies – Indices, B-Trees
Lecture 28: Storage Strategies – Hashing
Lecture 29: Introduction to Transaction Processing, Transaction and System Concepts
Lecture 30: Desirable Properties of Transactions
Lecture 31: Schedules and Recoverability
Lecture 32: Serializability of Schedules
Lecture 33: Locking Techniques for Concurrency Control, Time-stamp based schedules
Lecture 34: Multi-version and Optimistic Concurrency Control Schemes
Lecture 35: Database Recovery Techniques
Lecture 36: Advanced Topics – Object-Oriented and Object Relational Databases, Logical Database
Lecture 37: Advanced Topics – Web Databases, Distributed Databases
Lecture 38: Advanced Topics – Data Warehouse and Data Mining


Database Engineering Lecture Notes and Ebook download

    Attachment Lists

    If download doesn't start in application like IDM then press Alt + click on download button to start download
  • Database Engineering.pdf (Size: 495.34KB) Dowland
Share With Friends :  

No any Comment yet!