Langkau ke kandungan utama
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
Laman utama
Previous Academic Sessions
2022/2023 Academic Session
2021/2022 Academic Session
2020/2021 Academic Session
Bahasa Melayu (ms)
Bahasa Melayu (ms)
English (en)
العربية (ar)
Log masuk
Categories
Tutup
Buka
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
Laman utama
Previous Academic Sessions
Tutup
Buka
2022/2023 Academic Session
2021/2022 Academic Session
2020/2021 Academic Session
Maklumat kursus
Test Course Restore
Skill Level
:
Beginner
