Java Script needs to be enabled for Video to Load.

Relational Data Model

Loading Video Lesson
In this 27 mins Lesson you will Learn about following concepts.
Relational Data Model

Introduction, Degree / Arity, Domain, Domain Constraint, Key Constraint, Entity Constraint, Referntial Integrity, Integrity Constriants, and related Topics.


Related Video Lessons in this Series

Relational Data Model

27 mins Video Lesson

Introduction, Degree / Arity, Domain, Domain Constraint, Key Constraint, Entity Constraint, Referntial Integrity, Integrity Constriants, and other topics.

Relational Algebra - Selection, Projection and Set Operations

33 mins Video Lesson

Introduction, Select Operator, Project Operator, Set Operations, Union Operator, Intersection Operator, Set Difference Operator, and other topics.

Relational Algebra - Rename, Joins, Assignment and Division Operator

42 mins Video Lesson

Introduction, Rename , Cartesian Product, Natural Join, Outer Joins, Assignment Operator, Division Operator, and other topics.

Generalized Projection, Aggregate Functions, DB Modifications and Views

40 mins Video Lesson

Introduction, Generalized Projection, Aggregate Functions, Database Modification, Deletion, Insertion, Updation, Views, and other topics.

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

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

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

33 mins Video Lesson

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

Member's Zone