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
Number System - Basic Concepts and Introduction to Binary Numbers
[45mins] : Number System - Basic Concepts and Introduction to Binary Numbers
Number System - Basic Concepts and Introduction to Binary Numbers
45 mins Video Lesson

Number System: Introduction, Binary Number System, Decimal To Binary, One's Complement, Two's Complement, and other topics.

Sequential Design - Basic Concepts
[57mins] : Sequential Design - Basic Concepts
Sequential Design - Basic Concepts
57 mins Video Lesson

State Reduction, State Table, Equivalent States, Sequential Circuit Design (synchronous), Example , 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
Entity Relationship Model - Basic Concepts
[33mins] : Entity Relationship Model - Basic Concepts
Entity Relationship Model - Basic Concepts
33 mins Video Lesson

Introduction, Entity, Entity Set, Entity Type, Attributes, Null Values, Relationships, and other topics.

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.

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
Sets - Basic Concepts, Set Operations (Complement, Union and Intersection)
[47mins] : Sets - Basic Concepts, Set Operations (Complement, Union and Intersection)
Sets - Basic Concepts, Set Operations (Complement, Union and Intersection)
47 mins Video Lesson

Sets, Set Notations, Subset / Proper Subset, Universal Set, Set Operations: Complement, Set Operations: Union, Set Operations: Intersection, Disjoint Sets, Properties: Set Operations, and other topics.

Functions - Basic Concepts, Injective, Surjective Functions
[46mins] : Functions - Basic Concepts, Injective, Surjective Functions
Functions - Basic Concepts, Injective, Surjective Functions
46 mins Video Lesson

Functions, Types of relations (1:1 etc.), Domain, codomain, Range, Identity Function, Identical Function, Surjective / Onto Function, Injective Function, Composite Function, and other topics.

Member's Zone