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)