Unit 2: Building Database Driven Applications with Java

 Home / MG2I-C0125
Unit 2: Building Database Driven Applications with Java

This unit forms part of the Course in MCAST Award in Developing Applications of the Java Platform. Once a learner complete all the units in this course satisfactorily; that is has obtained a pass mark in the assessment and respected the 80% attendance s/he will achieve an award pegged at MQF Level 4, 6 ECVET Credits

This course is intended for people who would like to be introduced to the Java Programming Language and its technologies for both console and Web Applications.  Throughout the course the students will learn how to Design and Implement Applications using the Object Oriented paradigm and the use of Databases

The second unit will cover in depth Object Oriented Programming concepts such as encapsulation, inheritance and polymorphism. The student will be given an overview of the Java Collections Framework and will be focusing on the most popular data structures such as ArrayLists and HashMaps. An introduction to File I/O will cover reading and writing to text files. The unit ends with an in-depth coverage of Database access from Java applications using JDBC.


This is a 30 hr guided learning course.  Students need to invest further hours in the course, which will include private study and home assignments.

Lessons are held as indicated on the prospectus and website.


Learning Outcome 1: Apply object-oriented programming techniques in code development

Unit Content

  • Encapsulation
  • Inheritance
  • Abstraction
  • Interfaces
  • Polymorphism
  • Access Levels
  • Static vs non-static


Learning Outcome 2: Develop applications that make use of the Java Collections Framework

Unit Content

  • Lists
  • Sets
  • Maps

Learning Outcome 3: Develop code that involves simple File I/O

Unit Content

  • Writing to a text file
  • Reading from a text file

Learning Outcome 4: Create and modify data in RDBMS using SQL

Unit Content

  • Databases - RDBMS
  • Tables, rows, columns
  • DDL – Create, Alter, Drop, …
  • DML – Select, Update, Delete, Insert

Learning Outcome 5: Develop applications that use the JDBC API

Unit Content

  • JDBC Architecture
  • Creating a connection to Database
  • Sending DB queries
  • Processing result sets
  • Transactions


The following are the suggested pre-requisites and/or entry requirements needed:


  • Basic computer knowledge (ECDL-level, even though ECDL is not a requirement)
  • Functional skills in the English Language
  • Functional skills in Basic Mathematics

Entry Requirements:

  • Completed compulsory education
  • Completed Successfully - Unit 1: Fundamentals of the Java Programming Language

Course participants may be awarded either an MCAST Certificate of Attendance or an MCAST Certificate of Achievement.


MCAST Certificate of Attendance

  • An MCAST Certificate of Attendance will be awarded to those candidates who attend at least 80% of the lessons.


MCAST Certificate of Achievement

  • An MCAST Certificate of Achievement will be awarded to those candidates who satisfy the 80% attendance criteria and also choose to sit and pass the course assessment/s.

  • Students who opt not to sit for the assessment or fail (the assessment/s) will however be awarded the MCAST Certificate of Attendance provided that they fulfill the minimum attendance criteria as stated above.

If the student intends to obtain a Certificate of Achievement, she/he is required to sit for an assessment/s.  Assessment/s may take various forms such as a home assignment, class assignment, practical test and time constrained test.  However, the assessment/s is not compulsory and an applicant may choose not to sit for it.

There are no additional costs or special materials/equipment to bring.

js files