-
Chapter 1 - Introduction To Databases 1
-
Introduction To DatabasesLecture1.1
-
-
Chapter 7 - ER model 1
-
ER ModelLecture2.101 hour 30 min
-
-
Chapter 8 - Relational Database Design 3
-
New – 1445 -2 – Chapter 08 – Normalization- part 01Lecture3.101 hour 20 min
-
New – 1445 -2 – Chapter 08 – Normalization- part 02Lecture3.225 min
-
Chapter 8 – Functional dependenciesLecture3.301 hour 10 min
-
-
Chapter 9 - Relational Database Design 2
-
Chapter 9 – Par 1- Entity Relationship ModelLecture4.101 hour 40 min
-
Chapter 9 – Part 2 – Mapping ER model to Relational ModelLecture4.235 min
-
-
Chapter 2 - Relational Data Model 2
-
Chapter 2 – Relational data modelLecture5.101 hour 10 min
-
Exercises On ER mapping to Relational modelLecture5.230 min
-
-
Chapter 3 - Introduction to SQL 3
-
Chapter 3 – Introduction to SQL – Part 01Lecture6.101 hour 20 min
-
Chapter 3 – Introduction to SQL – Part 02Lecture6.201 hour 25 min
-
Chapter 3 – Introduction to SQL – Part 03Lecture6.301 hour 10 min
-
-
Chapter 04 - Intermediate SQL 2
-
Chapter 04 – Intermediate SQL – Part 01Lecture7.101 hour 35 min
-
Chapter 04 – Intermediate SQL – Part 02Lecture7.240 min
-
-
Course Labs 18
-
Lab 01 – Create Table StatementLecture8.101 hour 40 min
-
Lab 02 – Insert Into StatementLecture8.240 min
-
Lab 02 – Insert Into Statement – Exercises CodeLecture8.3
-
Lab 03 – Update , Delete and Select statementsLecture8.445 min
-
Lab 03 – Exercises CodeLecture8.5
-
Updated Lab 06 – Order by – Like , In , Between Operators + Exercises Solution (3 videos)Lecture8.601 hour 25 min
-
Lab 07 – Aggregate Functions – Group by – havingLecture8.745 min
-
Revision on Basic SQL statementsLecture8.801 hour 40 min
-
Revision Questions On SQL and their AnswersLecture8.9
-
Midterm Online RevisionLecture8.1055 min
-
Lab 08 – Join , Outer JoinLecture8.1125 min
-
Lab 08 – Join ExercisesLecture8.12
-
Lab 09 – SubQueriesLecture8.1345 min
-
Lab 09 – Subqueries – Exercises SolutionLecture8.14
-
Updated Lab 10 – Index – Alter Table and set operations + Exercise SolutionsLecture8.1540 min
-
Updated Lab 11 – SQL Views – Insert Into – Upper/Lower functionsLecture8.1620 min
-
Revision on SQL Statement – Join – Order by – Nested QueriesLecture8.1701 hour 10 min
-
Exercises on Aggregate Functions and Nested QueriesLecture8.1825 min
-
-
Final Exam revision 6
-
Final Exam RevisionLecture9.101 hour
-
New – Old Final ExamLecture9.217 min
-
New – Old Final ExamLecture9.335 min
-
باقى اسئلة الفاينلLecture9.430 min
-
تمارين خارجية – Exercises on NormalizationLecture9.527 min
-
Exercises on ERDLecture9.6
-