Hello BTech Computer Science & IT Engineering students, I am sharing the Database Engineering PDF class lecture notes, eBook, book as per the BTech CSE/IT Engineering course syllabus. These quick revision and summarized notes, eBook on Database Engineering will help you score more marks and help study in less time for your CSE/IT Engg. semester exams.
Key topics covered in Database Engineering quick revision PDF class notes, book, eBook for BTech Computer Science / IT Engineering:
MODULE I - Introduction to Database Systems and its Applications, Database System Architecture, Data Abstraction, Data Independence, Data Models, Network, Hierarchical and Relational Data Models, Data Models, Relational and Object Oriented Data Models, Entity Relationship (ER) Model, Mapping ER Model to Relational Model, Data Definitions Languages, Data Manipulation Languages, Integrity Constraints and Data Manipulation Operations
MODULE II - Relation Query Language, Fundamental Relation Algebra Operations, Extended Relation Algebra Operations, Tuple and Domain Relational Calculus, SQL, QBE, Domain and Data Dependency, Armstrong's Axioms, Dependency Preservation, Lossless Design, Normal Forms, 1NF, 2NF, 3NF, BCNF, Higher Normal Forms, 4NF, 5NF, Comparison of Oracle and DB2
MODULE III - Introduction to Query Processing, Translating SQL Queries into Relational Algebra, Algorithms for External Sorting, Algorithms for SELECT and JOIN Operations, Algorithms for PROJECT and SET Operations, Query Equivalence, Join Strategies, Overview of Query Optimization, Query Optimization Algorithms
MODULE IV - Storage Strategies, Indices, B-Trees, Storage Strategies, Hashing, Introduction to Transaction Processing, Transaction and System Concepts, Desirable Properties of Transactions, Schedules and Recoverability, Serializability of Schedules, Locking Techniques for Concurrency Control, Time-stamp based schedules, Multi-version and Optimistic Concurrency Control Schemes, Database Recovery Techniques, Advanced Topics, Object-Oriented and Object Relational Databases, Logical Database, Advanced Topics, Web Databases, Distributed Databases, Advanced Topics, Data Warehouse and Data Mining
Please click the download link below to get Database Engineering quick revision PDF class notes, book, eBook file for BTech Computer Science / IT Engineering syllabus.