Micro-Credential in Advanced Database System
Programme Overview
The course offered by Lincoln University College (LUC) is focused to have developed the self-reflective mindset, the analytic mindset, the collaborative mindset, the worldly mindset and the action mindset. The course presupposes a basic knowledge of conceptual modelling for data base systems and implementation using relational DBMS and SQL. The course aims to a more profound understanding of database theories, models, and methods and an ability to use these in different situations. This module consists of a detailed description of advanced subjects in databases like object-relational databases and data warehouses along with data analysis methods such as data mining, techniques for developing database systems, the fundamentals of data warehousing and data mining techniques, and the utilization of data mining tools.
Learning Outcomes
On completion of the course participants should be able to:
- Recognize the contemporary logical design methods and tools for
- Derive a physical structure for a database from its logical design in group assignment
- Implement a database solution to an information technology problem
- Develop sophisticated queries to extract information from large
Course Progression
Credits from this Micro-Credential Programme are transferable to the following full academic programme:
- Master of Computer Science
Assessments
- Test (20%)
- Lab Reports (20%)
- Written Assignment (10%)
- Final Examination (50%)
Study Plan for Micro-Credential in Advanced Database System
Week 1
| Introduction Database System · Disadvantage of file management system · Data · Database and its purpose · Characteristics of the database approach · Advantages and disadvantages of database systems | Seminar Session Simulations |
Week 2
| Classification of DBMS Users · Actors on the scene · Database Administrators · Database Designers · System Analysts DBMS Architecture · The External level · The conceptual level · The internal level · Mappings · Architecture Advantages, Disadvantages | Assignment Practical exercise |
Week 3
| Query Processing · General strategies for query processing · Transformations statistics in estimation · query improvement · View processing query processor Data Definition Language (DDL) · Data Manipulation Language (DML) · Credit, Drop, alter, Insertion commands · Select command with WHERE clause using conditional and Boolean · operator, group by Clause Like operator · Grouping Data joins, sub queries union, Intersect, Minus Clause. · Sorting and updating the Data | Practical exercise |
Week 4
| Recovery · Reliability · Transactions · Recovery in centralized dbms · Reflecting updates · Buffer management · Logging schemes · Disaster recovery | Test |
Week 5
| Concurrency · Introduction · Serializability · Concurrency control · Locking schemes · Timestamp based order · Optimistic scheduling · Multisession techniques · Deadlocks | Practical exercise |
Week 6
| Object Oriented Data Base Development · Introduction · Object definition language · Creating object instances · Object query language Distributed Databases · Basic concepts · Options for distributing a database · Distributed DBMS | Practical exercise |
Week 7
| Data warehousing · Introduction basic concepts · Data warehouse architecture · Data characteristics · Reconciled data layer data transformations · Derived data layer user interface | Submission of Assignments Submission of Lab Report |
Week 8
| Final Examination | Conclusion Session Awarding of Certificates Presentation by VC or Representative of VC |
Why Micro-Credential in Lincoln University College (LUC), Malaysia?
Micro-credentials in Lincoln University College (LUC), Malaysia offer a flexible, targeted, and accelerated pathway of acquiring industry-relevant skills that meet the demands of today’s evolving job market. Designed for students, professionals, and individuals seeking to upskill or reskill, credentials offer learning experiences and formally recognized certifications, with enhanced employability, and serving as stepping stones to higher qualifications. LUC’s micro-credential programs are supported by strong academic frameworks and offer clear progression pathways into full-fledged degree programs. After completing this Micro-credential course, professionals can use their updated skills to apply for promotions or switch to a different job role.