Announcements and Instructions
(will be added later)
... Offline lectures will be every Saturday from 9:00 AM- 11:00 AM. Location: Room
Online lectures will be through the following session (Teams)
My Email: ashahin@cu.edu.eg
google classroom(classroom)
Main Topics in This Course
Introduction to Databases Chapter 1 and Chapter 2 (Book_slide, Book_slide, lecture_notes, video1, video2, quiz1,quiz2)
Chapter 3: Data Modeling Using the Entity–Relationship (ER) Model (Book_slide, lecture_notes, video1, quiz1, quiz2, quiz3, quiz4, quiz5, quiz6, quiz7 ) Exam1
Chapter 5: The Relational Data Model and Relational Database Constraints (Book_slide, lecture_notes, video1, quiz1, quiz2, quiz3 ) Exam2
Chapter 9: Relational Database Design by ER- and EER-to-Relational Mapping (Book_slide, lecture_notes, video1, quiz1, quiz2 ) Exam3
Chapter 6: Basic Structured Query Language (SQL) (Book_slide, lecture_notes_part1 lecture_notes_part2, video1, video2, quiz1, quiz2, ) Exam4
Chapter 7: More SQL: Complex Queries, Triggers, Views, and Schema Modification (Book_slide, lecture_notes, video1, quiz1,quiz2, quiz3, quiz4, quiz5, quiz6, quiz7 )
Text Book
Book (3.8MB, password 123)
Tools
Oracle Express Edition (XE) 10g Windows (200MB, password 123)(video)
DbSchema 8.2.12 (150MB, password 123 )(video1, video2)
7-Zip(1.4MB)
Online Diagram Software for ERD (Draw.io tools )