Skip to main content
SEM2 INFO 2303 Section 01 DATABASE PROGRAMMING
0%
Previous
Course data
GENERAL
Announcements
Course Information
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
WEEK 5 - Conditional Expression and Group Function
Week 6 - Subqueries
WEEK 7: VIEWs, SEQUENCE and INDEXEs
WEEK 8: Introduction to PL/SQL
WEEK 9: Writing Executable Statements
WEEK 10: PROCEDURES
WEEK 11: FUNCTIONS
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
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
ARTS PROGRAMME
LANGUAGES
SCIENCES PROGRAMME
Home
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
ARTS PROGRAMME
LANGUAGES
SCIENCES PROGRAMME
Home
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
