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

2-Months

Required Qualification

  • ICS (preferable)
  • Matric (Science)

Eligibility

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

Unit-01

Administering a Database

    • Securing Databases
    • Backing Up and Restoring Databases

Unit-02

Data Storage

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

Unit-03

Manipulating Data

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

Unit-04

Creating Database Objects

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

Unit-05

Core Database Concepts

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