Skip to main content
Test Course Restore
0%
Previous
Course data
WELCOME
Announcements
Announcements
Course Info
Important Matters, Must READ!
Getting Started with Oracle
Link to download Oracle 10g XE
Minicollege.sql
UPDATED_Minicollege dataset
Group Project
Group Registration
Group Project Guidelines
Submission 1 - Database Design Document - Group Project
Submission 2 - SQL Implementation Scripts - Group Project
Submission 3 - Final Report - Group Project
MIDTERM EXAM
WEEK 1: INTRODUCTION TO DATABASE AND ENVIRONMENT
Lecture 1 - Intro to DB and Environment
WEEK 2: DATABASE PLANNING, DESIGN AND ADMINISTRATION
Pre-Class activity: EXPLORE! Learn basic DB concepts using Generative AI
Lecture 2 - DB Plan Design Admin
WEEK 3: RELATIONAL MODEL AND RELATIONAL ALGEBRA
Lecture 3 - Relational Model and Relational Algebra
Lecture 3a - Relational Model
SELF-PACED LEARNING: RELATIONAL ALGEBRA
Mini Quiz
WEEK 4: ERD and ENHANCED ERD MODELING
Lecture 4 - ERD and Enhanced ERD Modeling
In class exercise: ER and ERD Clinic Database
Slides with annotations in class
ASSIGNMENT: ER and ERD E-Commerce Database
WEEK 5: SQL - DATA MANIPULATION (INTRODUCTION)
Basic Concepts on SQL Programming
Lecture 5 - Data Manipulation (Introduction)
Mini Quiz : SQL Basic Retrieval
WEEK 6: SQL - DATA MANIPULATION (INTERMEDIATE)
Lecture 6 - Data Manipulation (Intermediate)
SQL Programming OUTER JOIN: What and How?
WEEK 7: SQL - DATA MANIPULATION (ADVANCED)
Lecture 7 - Data Manipulation (Advanced)
WEEK 8: DATA DEFINITION
Lecture 8 - Data Definition
Class Assignment: Advanced SQL and Data Definition
Sales Company SQL script
WEEK 9: NORMALIZATION
Lecture 9 - Normalization
Slides with additional details _ Lecture 9 - Normalization
WEEK 10: LOGICAL DATABASE DESIGN
Lecture 10 - Logical DB Design
WEEK 11: TRANSACTIONS
Lecture 11 - Transactions
Intro to Database Transactions
WEEK 12: ADMINISTRATION AND SECURITY
Lecture 12 - Administration and Security
WEEK 13: XML
Lecture 13 - XML
Lecture Notes_ XML (Prof. Mira)
Notepad++
Video Tutorial: XML for Beginner
XML Documents
XML Exercise
WEEK 14: NoSQL
JSON Files
Lecture 14 - NoSQL
Link to Download MongoDB
QUIZ 1
QUIZ 2
QUIZZES
Exercises
Next
Side panel
Categories
All categories
Session 2023/2024 Semester 1
AHMAD IBRAHIM KULLIYYAH OF LAWS
ALLIED HEALTH SCIENCE
ARCHITECTURE & ENVIRONMENTAL DESIGN
ARTS PROGRAMME
CO-CURRICULAR ACTIVITY CENTRE
DENTISTRY
ECONOMICS AND MANAGEMENT SCIENCES
EDUCATION
ENGINEERING
INFORMATION & COMMUNICATION TECHNOLOGY
INTERNATIONAL INSTITUTE FOR HALAL RESEARCH AND TRAINING
INTERNATIONAL INSTITUTE OF ISLAMIC THOUGHT AND CIVILIZATION
ISLAMIC BANKING AND FINANCE
ISLAMIC REVEALED KNOWLEDGE & HUMAN SCIENCES (KTN)
ISLAMIC REVEALED KNOWLEDGE AND HUMAN SCIENCES
LANGUAGES
LANGUAGES & PRE-UNIVERSITY ACADEMIC DEVELOPMENT
LANGUAGES & PRE-UNIVERSITY ACADEMIC DEVELOPMENT (KTN)
LANGUAGES AND MANAGEMENT
MEDICINE
NURSING
PHARMACY
SCIENCE
SCIENCES PROGRAMME
SEJAHTERA CENTRE FOR SUSTAINABILITY AND HUMANITY
Session 2023/2024 Semester 2
AHMAD IBRAHIM KULLIYYAH OF LAWS
ALLIED HEALTH SCIENCE
ARCHITECTURE & ENVIRONMENTAL DESIGN
ARTS PROGRAMME
CO-CURRICULAR ACTIVITY CENTRE
DENTISTRY
ECONOMICS AND MANAGEMENT SCIENCES
EDUCATION
ENGINEERING
INFORMATION & COMMUNICATION TECHNOLOGY
INTERNATIONAL INSTITUTE FOR HALAL RESEARCH AND TRAINING
INTERNATIONAL INSTITUTE OF ISLAMIC THOUGHT AND CIVILIZATION
ISLAMIC BANKING AND FINANCE
ISLAMIC REVEALED KNOWLEDGE AND HUMAN SCIENCES
LANGUAGES
LANGUAGES & PRE-UNIVERSITY ACADEMIC DEVELOPMENT
LANGUAGES AND MANAGEMENT
MEDICINE
NURSING
PHARMACY
SCIENCE
SCIENCES PROGRAMME
SEJAHTERA CENTRE FOR SUSTAINABILITY AND HUMANITY
Session 2023/2024 Semester 3
AHMAD IBRAHIM KULLIYYAH OF LAWS
ALLIED HEALTH SCIENCE
ARCHITECTURE & ENVIRONMENTAL DESIGN
ARTS PROGRAMME
CO-CURRICULAR ACTIVITY CENTRE
ECONOMICS AND MANAGEMENT SCIENCES
EDUCATION
ENGINEERING
INFORMATION & COMMUNICATION TECHNOLOGY
ISLAMIC BANKING AND FINANCE
ISLAMIC REVEALED KNOWLEDGE AND HUMAN SCIENCES
LANGUAGES
LANGUAGES & PRE-UNIVERSITY ACADEMIC DEVELOPMENT
LANGUAGES AND MANAGEMENT
MEDICINE
NURSING
PHARMACY
SCIENCE
SCIENCES PROGRAMME
SEJAHTERA CENTRE FOR SUSTAINABILITY AND HUMANITY
Miscellaneous
CPS Supervisory Training
KOMCategory
Home
Previous Academic Sessions
2022/2023 Academic Session
2021/2022 Academic Session
2020/2021 Academic Session
English (en)
Bahasa Melayu (ms)
English (en)
العربية (ar)
Log in
Categories
Collapse
Expand
All categories
Session 2023/2024 Semester 1
AHMAD IBRAHIM KULLIYYAH OF LAWS
ALLIED HEALTH SCIENCE
ARCHITECTURE & ENVIRONMENTAL DESIGN
ARTS PROGRAMME
CO-CURRICULAR ACTIVITY CENTRE
DENTISTRY
ECONOMICS AND MANAGEMENT SCIENCES
EDUCATION
ENGINEERING
INFORMATION & COMMUNICATION TECHNOLOGY
INTERNATIONAL INSTITUTE FOR HALAL RESEARCH AND TRAINING
INTERNATIONAL INSTITUTE OF ISLAMIC THOUGHT AND CIVILIZATION
ISLAMIC BANKING AND FINANCE
ISLAMIC REVEALED KNOWLEDGE & HUMAN SCIENCES (KTN)
ISLAMIC REVEALED KNOWLEDGE AND HUMAN SCIENCES
LANGUAGES
LANGUAGES & PRE-UNIVERSITY ACADEMIC DEVELOPMENT
LANGUAGES & PRE-UNIVERSITY ACADEMIC DEVELOPMENT (KTN)
LANGUAGES AND MANAGEMENT
MEDICINE
NURSING
PHARMACY
SCIENCE
SCIENCES PROGRAMME
SEJAHTERA CENTRE FOR SUSTAINABILITY AND HUMANITY
Session 2023/2024 Semester 2
AHMAD IBRAHIM KULLIYYAH OF LAWS
ALLIED HEALTH SCIENCE
ARCHITECTURE & ENVIRONMENTAL DESIGN
ARTS PROGRAMME
CO-CURRICULAR ACTIVITY CENTRE
DENTISTRY
ECONOMICS AND MANAGEMENT SCIENCES
EDUCATION
ENGINEERING
INFORMATION & COMMUNICATION TECHNOLOGY
INTERNATIONAL INSTITUTE FOR HALAL RESEARCH AND TRAINING
INTERNATIONAL INSTITUTE OF ISLAMIC THOUGHT AND CIVILIZATION
ISLAMIC BANKING AND FINANCE
ISLAMIC REVEALED KNOWLEDGE AND HUMAN SCIENCES
LANGUAGES
LANGUAGES & PRE-UNIVERSITY ACADEMIC DEVELOPMENT
LANGUAGES AND MANAGEMENT
MEDICINE
NURSING
PHARMACY
SCIENCE
SCIENCES PROGRAMME
SEJAHTERA CENTRE FOR SUSTAINABILITY AND HUMANITY
Session 2023/2024 Semester 3
AHMAD IBRAHIM KULLIYYAH OF LAWS
ALLIED HEALTH SCIENCE
ARCHITECTURE & ENVIRONMENTAL DESIGN
ARTS PROGRAMME
CO-CURRICULAR ACTIVITY CENTRE
ECONOMICS AND MANAGEMENT SCIENCES
EDUCATION
ENGINEERING
INFORMATION & COMMUNICATION TECHNOLOGY
ISLAMIC BANKING AND FINANCE
ISLAMIC REVEALED KNOWLEDGE AND HUMAN SCIENCES
LANGUAGES
LANGUAGES & PRE-UNIVERSITY ACADEMIC DEVELOPMENT
LANGUAGES AND MANAGEMENT
MEDICINE
NURSING
PHARMACY
SCIENCE
SCIENCES PROGRAMME
SEJAHTERA CENTRE FOR SUSTAINABILITY AND HUMANITY
Miscellaneous
CPS Supervisory Training
KOMCategory
Home
Previous Academic Sessions
Collapse
Expand
2022/2023 Academic Session
2021/2022 Academic Session
2020/2021 Academic Session
Course info
Test Course Restore
Skill Level
:
Beginner
