Lesson 1 of 21 • 3 upvotes • 9:21mins
21 lessons • 2h 34m
Introduction
9:21mins
View of Data
7:12mins
Database Language
6:18mins
The Entity Relationship Model
7:51mins
Attributes and Cardinality
8:12mins
How to make entity relationship
10:14mins
Relational Database
6:13mins
Different types of Keys
10:47mins
Primary key and Foreign Key
7:50mins
Constraints
6:31mins
Generalisation and specialisation
5:41mins
Relational Algebra
9:20mins
Union and intersection
6:03mins
Cartesian Product
5:54mins
Join Operation
10:32mins
Outer join
6:15mins
Introduction to SQL
5:47mins
Examples and where clause
6:10mins
Rename operator and comparison operator
6:55mins
Order by clause and aggregate functions
5:08mins
Group by and having clause
6:34mins