What is your next education pathway?

A database is an integrated collection of logically related records and files. A Database Management System is a software package that can be used to create and maintain a database. Learning Database Management System is important because every software needs a back end to store its data.

This program is offered as a blended learning method, a combination of in-class and online learning in one course. A student might attend in classes, and some lessons are online when the learner can study at home or in the office.

Beginners who are willing to learn Database Management Systems. 

Department
Department
SCHOOL OF COMPUTING
Campus
Campus
Colombo Campus
Level
Level
Foundation Programmes
Method
Method
Online
Duration
Duration
Medium
Medium
English

Entry Requirements

  • Those who are interested in learning Database Management Systems especially for the beginners

  • Access to a computer with an Internet connection

Programme Fees

Current Fee Structure
  • Course Fee: LKR 25,000

*Subject to change without prior notice. Conditions apply.

Course Structure and Modules

  • Introduction to Database and Database Management System

  • Entity Relationship Diagram

  • Enhanced Entity Relationship Diagram

  • Schema Mapping

  • Set up Microsoft SQL Server

  • Introduction to Structured Query Language

  • Data Definition Language (Create, Alter, Drop, Truncate)

  • Data Manipulation Language (Insert, Update, Delete, Select)

  • Data Control Language (Grant, Revoke)

  • SQL with Group by and Having conditions

You’ll need to complete theory exam and practical test. Pass mark is 50 from all evaluations.