About this course

In this course, students will be introduced to database design and administration. Students will gain an understanding of core database concepts, creation of database objects, manipulation of data, data storage, and administration of a database.

Course Duration


Required Qualification

  • ICS (preferable)
  • Matric (Science)


The candidate should have the knowledge of computers basics and can operate easily, where if the candidate has the some minimal knowledge of Adobe Photoshop, HTML, and Dreamweaver then it is easier to learn.

Course Contents


Administering a Database

    • Securing Databases
    • Backing Up and Restoring Databases


Data Storage

    • Normalizing a Database
    • Primary, Foreign, and Composite Keys
    • Clustered and Non-Clustered Indexes


Manipulating Data

    • Using Queries to Select Data
    • Using Queries to Insert Data
    • Updating Data and Databases
    • Deleting Data


Creating Database Objects

    • Key Terms
    • Data Types
    • Creating and Using Tables
    • Creating Views
    • Creating Stored Procedures


Core Database Concepts

    • Database Concepts
    • Data Manipulation Language (DML)
    • Data Definition Language (DDL)