Skip to main content
SEM2 INFO 2303 Section 01 DATABASE PROGRAMMING
0%
Previous
Course data
GENERAL
Announcements
Course Information
MIDTERM EXAMINATION - Thursday, 8th May 2025
IMPORTANT: MUST READ SECTION!
SQL Scripts
Link to download Oracle 10g XE
WEEK 1: Database Review and Managing Tables
Lecture Notes _ Review of Database Concepts (1%)
ER Diagram - Lab Assignment 1
Lecture Notes _ Managing Tables
Table Management
WEEK 2: Managing Constraints and Basic SELECT Statement
Hospital SQL Script
Lecture Notes _ Managing Constraints
Lecture Notes - Basic Select Statement
Mini Exercise on Managing Constraints and Basic SELECT Statement (2%)
WEEK 3: Single Row Functions and Date Functions
Lecture Notes _ Single Row Functions
Mini exercise - Single Row Function
Lecture Notes _ Date Functions
WEEK 4: Data Manipulation and Joining Multiple Tables
Lecture Notes _ Data Manipulation
Class exercise - Data Manipulation Language
Lecture Notes- Joining Multiple Tables
SAMPLE codes from 8th April 2025
Class Exercise - Joining Multiple Table
WEEK 5 - Conditional Expression and Group Function
Week 5 - Activity for Thursday, 17th April 2025
Lecture Notes - Conditional Expression and Group Function
Mini-Quiz on CASE and DECODE
Week 6 - Subqueries
Lecture Notes - Subquery and Advanced Subquery
Subquery and Advanced Subquery
Class Exercise
Notes from the Replacement class on Monday, 28th April 2025
WEEK 7: VIEW, SEQUENCE and INDEX
Lecture Notes - Views
Class Assignment: VIEW and SEQUENCE
WEEK 8: Introduction to PL/SQL
Lecture Notes - Introduction to to PLSQL
WEEK 9: Writing Executable Statements
Lecture Notes - Writing Executable Statement
AI example
WEEK 10: Control Structure (IF Statement) and PROCEDURES
Lecture Notes - Control Structure: IF Statement
class exforDS
Lecture Notes - Procedures
Mini Quiz: PROCEDURE
WEEK 11: FUNCTIONS
Lecture Notes - Functions
Anonymous block and Procedure _ CTY_BALANCE
Anonymous block and Function _ CTY_BALANCE_FN
WEEK 12: Control Structures (LOOP) and Composite Datatypes
WEEK 13: Exception Handling and Cursors
WEEK 14: Learning Enforcement and Revision
GROUP PROJECT GUIDELINES AND SUBMISSIONS
Group Project Registration
INFO 2303 Group Project guidelines
Submission of Database Proposal and ER Diagram
Final Submission of SQL codes and other required documentation
Next
Side panel
Categories
All categories
Miscellaneous
CPS Supervisory Training
Session 2024/2025 Semester 1
AHMAD IBRAHIM KULLIYYAH OF LAWS
ALLIED HEALTH SCIENCE
ARCHITECTURE & ENVIRONMENTAL DESIGN
ARTS PROGRAMME
CO-CURRICULAR ACTIVITY CENTRE
CREDITED CO-CURRICULAR 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
PLANETARY SURVIVAL FOR SUSTAINABLE WELL-BEING
SCIENCE
SCIENCES PROGRAMME
SEJAHTERA CENTRE FOR SUSTAINABILITY AND HUMANITY
Session 2024/2025 Semester 2
AHMAD IBRAHIM KULLIYYAH OF LAWS
ALLIED HEALTH SCIENCE
ARCHITECTURE & ENVIRONMENTAL DESIGN
ARTS PROGRAMME
CREDITED CO-CURRICULAR 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
PLANETARY SURVIVAL FOR SUSTAINABLE WELL-BEING
SCIENCE
SCIENCES PROGRAMME
SEJAHTERA CENTRE FOR SUSTAINABILITY AND HUMANITY
SUSTAINABLE TOURISM AND CONTEMPORARY LANGUAGES
Session 2024/2025 Semester 3
AHMAD IBRAHIM KULLIYYAH OF LAWS
ARCHITECTURE & ENVIRONMENTAL DESIGN
ARTS PROGRAMME
ECONOMICS AND MANAGEMENT SCIENCES
ENGINEERING
INFORMATION & COMMUNICATION TECHNOLOGY
ISLAMIC REVEALED KNOWLEDGE AND HUMAN SCIENCES
LANGUAGES
LANGUAGES & PRE-UNIVERSITY ACADEMIC DEVELOPMENT
PHARMACY
SCIENCE
SCIENCES PROGRAMME
SUSTAINABLE TOURISM AND CONTEMPORARY LANGUAGES
CREDITED CO-CURRICULAR CENTRE
NURSING
EDUCATION
ALLIED HEALTH SCIENCE
Home
ITaleem Tutorials
Previous Academic Sessions
2023/2024 Academic Session
2022/2023 Academic Session
2021/2022 Academic Session
2020/2021 Academic Session
English ‎(en)‎
Bahasa Melayu ‎(ms)‎
English ‎(en)‎
العربية ‎(ar)‎
Log in
Login using your CAS account
IIUM Student and Staff Login
Or enter your details to log in your account
Username
Username
Password
Password
Forgot your password?
Log in
Categories
Collapse
Expand
All categories
Miscellaneous
CPS Supervisory Training
Session 2024/2025 Semester 1
AHMAD IBRAHIM KULLIYYAH OF LAWS
ALLIED HEALTH SCIENCE
ARCHITECTURE & ENVIRONMENTAL DESIGN
ARTS PROGRAMME
CO-CURRICULAR ACTIVITY CENTRE
CREDITED CO-CURRICULAR 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
PLANETARY SURVIVAL FOR SUSTAINABLE WELL-BEING
SCIENCE
SCIENCES PROGRAMME
SEJAHTERA CENTRE FOR SUSTAINABILITY AND HUMANITY
Session 2024/2025 Semester 2
AHMAD IBRAHIM KULLIYYAH OF LAWS
ALLIED HEALTH SCIENCE
ARCHITECTURE & ENVIRONMENTAL DESIGN
ARTS PROGRAMME
CREDITED CO-CURRICULAR 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
PLANETARY SURVIVAL FOR SUSTAINABLE WELL-BEING
SCIENCE
SCIENCES PROGRAMME
SEJAHTERA CENTRE FOR SUSTAINABILITY AND HUMANITY
SUSTAINABLE TOURISM AND CONTEMPORARY LANGUAGES
Session 2024/2025 Semester 3
AHMAD IBRAHIM KULLIYYAH OF LAWS
ARCHITECTURE & ENVIRONMENTAL DESIGN
ARTS PROGRAMME
ECONOMICS AND MANAGEMENT SCIENCES
ENGINEERING
INFORMATION & COMMUNICATION TECHNOLOGY
ISLAMIC REVEALED KNOWLEDGE AND HUMAN SCIENCES
LANGUAGES
LANGUAGES & PRE-UNIVERSITY ACADEMIC DEVELOPMENT
PHARMACY
SCIENCE
SCIENCES PROGRAMME
SUSTAINABLE TOURISM AND CONTEMPORARY LANGUAGES
CREDITED CO-CURRICULAR CENTRE
NURSING
EDUCATION
ALLIED HEALTH SCIENCE
Home
ITaleem Tutorials
Previous Academic Sessions
Collapse
Expand
2023/2024 Academic Session
2022/2023 Academic Session
2021/2022 Academic Session
2020/2021 Academic Session
Session 2024/2025 Semester 2
Summary
Course info
SEM2 INFO 2303 Section 01 DATABASE PROGRAMMING
Skill Level
:
Beginner
