Course Image
Modules 6 6 Hours Beginner

Database Management System

Description

The main objective of this course is to provide students with the background to design, implement, and use database management systems. This course offers a good understanding of database systems concepts and prepares the student to be in a position to use and design databases for different applications. Behind the development and design of this course is to know.
1. How to design, manipulate and manage databases.
2. The course participants are exposed to the various forms, types and models of database systems to enable them make viable choices.
3. Supportive and complementary concepts of managing data and documents are thoroughly examined to give a wholesome view of data/information management.

What Will You Learn?
  • Fundamental elements of relational database management systems and non-relational database.
  • Design ER-models to represent simple database application scenarios.
  • Able to create SQL queries using multiple tables.
  • Improve the database design by normalization.
  • Database indexing ( B and B+ Trees).
Requirements

Basic knowledge of Computer.

The Course Curriculam
  • MODULE 1: Introduction to Database Systems:
  • MODULE 2: Relational Database
  • MODULE 3: Lets Start SQL
  • MODULE 4: Types of File Organization and Practice SQL
  • MODULE 5: Data Models in Database Management System and Practice SQL
  • MODULE 6: Normal Forms, Functional Dependency and ACID Properties