Loading Revision Notes. Please Wait, it may take upto a minute
Introduction to Files and Blocks, Fixed Length Records, Variable Length Records, Byte Strings, Slotted Page Structure, Reserved Space Representation, List Representation, Organization Of Records, and related Topics.
Introduction to Files and Blocks, Fixed Length Records, Variable Length Records, Byte Strings, Slotted Page Structure, Reserved Space Representation, List Representation, Organization Of Records, and other topics.
Index, Quality of an Index, Types of Index, Ordered Index, Primary Index- Def., Secondary Index- Def., Dense Index- Def., Sparse Index- Def., MultiLevel Index, Insertion in an Index, Deletion from an Index, Secondary Index, and other topics.
Introduction, Hash Function, Hash File Organization, Handling Overflow, Hash Index, Dynamic Hashing, Extendible Hashing, and other topics.
Introduction, Data Types, Schema And Catalog, Select-From-Where, Cross Product, Aliasing / Rename, Star Symbol (*), SQL results as MultiSet, Set Operations, Generalized Projection - Use of Math. Ops, Order By, String Comparison - Like, and other topics.
Table Creation, Domain Creation, Deleting a table - Drop Table, Modifying a Table - Alter Table, Views, and other topics.
Introduction, NULL Comparison, Nested Queries - In/ Some/ Any/ All, Co-Related Query - Exist/ Not Exist, and other topics.
Joins , Aggregate Functions, Grouping, Having Clause, Insert, Delete, and other topics.
Assertions, Triggers, Privileges, Roles, Embedded SQL, and other topics.