Java Script needs to be enabled for Video to Load.

File Organization

Loading Video Lesson
In this 51 mins Lesson you will Learn about following concepts.
File Organization

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.

Related Video Lessons in this Series

File Organization
File Organization

File Organization

51 mins Video Lesson

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.

Database Indexing
Database Indexing

Database Indexing

50 mins Video Lesson

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.

Database Hashing
Database Hashing

Database Hashing

55 mins Video Lesson

Introduction, Hash Function, Hash File Organization, Handling Overflow, Hash Index, Dynamic Hashing, Extendible Hashing, and other topics.

SQL - Basic Concepts and Queries
SQL - Basic Concepts and Queries

SQL - Basic Concepts and Queries

56 mins Video Lesson

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.

Data Definitions, Schemas and Views
Data Definitions, Schemas and Views

Data Definitions, Schemas and Views

39 mins Video Lesson

Table Creation, Domain Creation, Deleting a table - Drop Table, Modifying a Table - Alter Table, Views, and other topics.

NULL Comparisons, Nested and Co-related Queries
NULL Comparisons, Nested and Co-related Queries

NULL Comparisons, Nested and Co-related Queries

41 mins Video Lesson

Introduction, NULL Comparison, Nested Queries - In/ Some/ Any/ All, Co-Related Query - Exist/ Not Exist, and other topics.

Joins, Aggregate Functions, Group By, Having clause and DB Modifications
Joins, Aggregate Functions, Group By, Having clause and DB Modifications

Joins, Aggregate Functions, Group By, Having clause and DB Modifications

33 mins Video Lesson

Joins , Aggregate Functions, Grouping, Having Clause, Insert, Delete, and other topics.

Assertions, Triggers, Roles and Embedded SQL
Assertions, Triggers, Roles and Embedded SQL

Assertions, Triggers, Roles and Embedded SQL

43 mins Video Lesson

Assertions, Triggers, Privileges, Roles, Embedded SQL, and other topics.

Member's Zone