+92 42 99029450

Courses & Certifications

Database Management System

Duration: 05 Days

DBMS can house a wealth of information in one place. Data can be stored for a variety of purposes and many of us use DBMS on a daily basis without realizing it. DBMS and its application is very valuable course for those who want to enhance their skill in record keeping and in databases.

After studying this course students will be able to understand the basic concepts of Database Management System and its used in all large and small organizations for managing and handling data. Students will be able to know that there are various benefits of using DBMS in companies. The prime benefit of DBMS is that it allows the integration of data. Secondly, DBMS reduces the duplication of data and helps the organizations in managing, collecting and manipulating information. Information can be easily accessed by the users through DBMS and current information can be easily updated.

Target Audience:The interested candidate must be of intermediate level with little bit know how about databases.
Course Content:

Topic Outline:

  • Overview of Databases - 10%
    •         Database Management System overview
    •         Database advantages and disadvantages
    •         Database Models : Hierarchical, Network, Relational, Object-oriented Relational, Object-oriented
  • Relational Model - 5%
    •         Terminology: File-based (file, record, field) versus data model (entity, attribute, relationship) versus relational model (relation, tuple, attribute) versus relational database (table, row, column)
    •         Relational Algebra Operators: Select, Project, Join
  • Database Design Methodology - 20%
    •         Information-Level (Logical) versus Physical-level Design
    •         Identification of User Views
    •         Logical Database Design: Entity Relationship Diagram, entity/relation, attribute, relationships, cardinality
    •         Physical Database Design: tables, primary keys, foreign keys
    •         Top-down versus Bottom-up Design: use of both approaches for correct, complete result
  • Detailed Logical Design - 25%
    •         Functional Dependence
    •         Primary Key
    •         First Normal Form (1NF)
    •         Second Normal Form (2NF)
    •         Third Normal Form (3NF)
    •         Relational Schema
    •         Update and Delete Data Anomalies
  • Structured Query Language(SQL) Overview - 20%
    •         Introduction to using DB2 on the AS/400
    •         Create a DB2 table and view using SQL CREATE statement
    •         Add data using SQL INSERT statement
    •         Query data in DB2 using simple SELECT statement
    •         Modify database structure using SQL ALTER statement
    •         Query DB2 data dictionary tables using SELECT statement
    •         Preserve database integrity using SQL's NOT NULL, CHECK,
    •         PRIMARY KEY and FOREIGN KEY constraints
    •         Enforce uniqueness by UNIQUE INDEX
  • Detailed Physical Database Design - 15%
    •         Identify views, indexes, security, integrity constraints, and additional constraints: uniqueness, mandatory/optional, default value, validation criteria
  • Database Management System Features - 3%
    •         Maintain data dictionary - 'metadata'
    •         Maintain application data
    •         Manage integrity constraints for application data
    •         Manage shared access to data
    •         Facilitate backup and recovery of database
    •         Provide security: passwords, views, encryption
    •         Facilitate data availability through replication of database
    •         Provide utilities for common tasks
  • Database Administrator Responsibilities - 2%
    •         Selection, installation and maintenance of DBMS
    •         Training
    •         Manage data dictionary tables
    •         Monitor and improve DBMS performance
    •         Manage end user access to DBMS
    •         Approve application database design
    •         Develop and administer database policies