Reference Series-Computer Engineering .


Advanced Database Management System

26 Video Lessons
11 Revision Notes

Data Warehousing And Mining , Query Processing and Optimization, Distributed and Parallel Database, Relational Database Design & Normalization, Object Oriented and Object Relational Database, Xml , and other topics.

All Lessons and Notes
Featured Video Lessons in Advanced Database Management System
Query Processing - Basic Concepts, Query Cost and Selection Algorithms
[56mins] : Query Processing - Basic Concepts, Query Cost and Selection Algorithms
Query Processing - Basic Concepts, Query Cost and Selection Algorithms
56 mins Video Lesson

Introduction, Query Processing Process, Measures of Query Cost, Disk Access Costs, Selection: Algorithms, Complex Selections: Algorithms, and other topics.

Distributed Database - Basic Concepts, Fragmentation and Allocation
[54mins] : Distributed Database - Basic Concepts, Fragmentation and Allocation
Distributed Database - Basic Concepts, Fragmentation and Allocation
54 mins Video Lesson

Distributed Computing System, Distributed DB, Distributed Database, Advantages of DDBMS, Special Functions of DDBMS, Fragmentation, Horizontal, Vertical, Mixed/ Hybrid Fragmentation, Fragmentation Schema, Allocation, Allocation Schema, and other topics.

Digital Electronics and Logic Design

40 Video Lessons
12 Revision Notes

Number System , Boolean Algebra, Logic Families, Combinational Logic, Sequential Logic : Flip Flops , Sequential Logic : Registers And Counters , Sequential Logic Design , ASM, VHDL, PLDs and Microprocessor, and other topics.

All Lessons and Notes
Featured Video Lessons in Digital Electronics and Logic Design
Characteristics of ICs and Introduction to TTL Family
[48mins] : Characteristics of ICs and Introduction to TTL Family
Characteristics of ICs and Introduction to TTL Family
48 mins Video Lesson

Characteristics of ICs, Propogation Delay, Power Dissipation, Figure of Merit, Fan In, Fan Out, Current and Voltage Parameters, Noise Margin, Operating Temprature, TTL Family, TTL Nand: Totem Pole, and other topics.

Registers - Part 2
[31mins] : Registers - Part 2
Registers - Part 2
31 mins Video Lesson

Shift Left Register, Serial In Parallel Out Register, Parallel In Serial Out Register, Bidirectional Shift Register, and other topics.

Database Management System

29 Video Lessons
12 Revision Notes

DBMS - Introduction , Entity Relationship Model, Relational Data Model and Relational Algebra , SQL , File Organization and Database Index, Transactions , Concurrency Control and Recovery Management, and other topics.

All Lessons and Notes
Featured Video Lessons in Database Management System
SQL - Basic Concepts and Queries
[56mins] : 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.

Timestamp based and Optimistic Protocols
[46mins] : Timestamp based and Optimistic Protocols
Timestamp based and Optimistic Protocols
46 mins Video Lesson

Timestamp based Protocols, Timestamp Ordering protocol, Thomas' Write Rule, Optimistic/ Validation Based Protocols, Multiversion Scheme, and other topics.

Discrete Mathematical Structures

41 Video Lessons
9 Revision Notes

Logic and Propositions, Set Theory, Algebraic Structures - Groups and Rings, Relations, Poset and Lattice, Functions , Recurrence Relations and Generating Functions, Graphs, Trees, Permutations, Combinations and Discrete Probability, and other topics.

All Lessons and Notes
Featured Video Lessons in Discrete Mathematical Structures
Inverse, Groups, Abelian Group, Cyclic Group and Cosets
[53mins] : Inverse, Groups, Abelian Group, Cyclic Group and Cosets
Inverse, Groups, Abelian Group, Cyclic Group and Cosets
53 mins Video Lesson

Inverse of an Element, Group, Abelian Group, Order of a Group, Order of An element, Cyclic Group, Product Group, Properties of a Group, Sub-Group, Cosets, Properties of a Coset, and other topics.

Tree - Basic Concepts, Rooted Tree, M-ary Tree
[50mins] : Tree - Basic Concepts, Rooted Tree, M-ary Tree
Tree - Basic Concepts, Rooted Tree, M-ary Tree
50 mins Video Lesson

Tree, Terminal / Internal Node, Rooted Tree, Level of a node, Height / Depth, Father / Son, Brothers, Ancestor / Descendant, M-ary Tree, Complete m-ary tree, Example, and other topics.

Member's Zone