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
Data Warehousing
[42mins] : Data Warehousing
Data Warehousing
42 mins Video Lesson

Introduction, Datewarehousing: Properties, Datawarehousing: Applications, Multidimensional Model/ Data Modelling in DW, Hierarchy of Data, Operations in Multidimensional Model, Multidimensional Schema , Star Schema, Snowflake Schema, Fact Constellation, and other topics.

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.

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
Ripple Adder, Fast Adder, Subtractor and  IC 7483
[50mins] : Ripple Adder, Fast Adder, Subtractor and IC 7483
Ripple Adder, Fast Adder, Subtractor and IC 7483
50 mins Video Lesson

Parallel/ Ripple Adder, Look Ahead Carry / Fast Adder, IC 7483, BCD Adder using IC 7483, Subtractor using IC 7483, Adder/ Subtractor using IC 7483, and other topics.

Microprocessor - Basic Concepts, Bus and Block Diagram
[43mins] : Microprocessor - Basic Concepts, Bus and Block Diagram
Microprocessor - Basic Concepts, Bus and Block Diagram
43 mins Video Lesson

Microprocessor: Introduction, Ideal Microprocessor, Bus, Bus Width, Data Bus, Address Bus, Control Bus, MP: Block Diagram, 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.

Concurrency and Concept of Schedules
[40mins] : Concurrency and Concept of Schedules
Concurrency and Concept of Schedules
40 mins Video Lesson

Introduction, Concurrency, Advantages of Concurrency, Schedule, Serial Schedule, Equivalence of Schedules, Conflicting Set of Operations, Conflict Serializability, Serializability, 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
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.

Sequence, Series, Generating Functions, Recurrence Relations
[41mins] : Sequence, Series, Generating Functions, Recurrence Relations
Sequence, Series, Generating Functions, Recurrence Relations
41 mins Video Lesson

Sequence, Series, Generating Functions, Standard Gen. Functions, Examples, Recurrence Relation, Order and Degree of a Rec. Relation, Homogeneos Rec. Relation, and other topics.

Member's Zone