Diploma In Database Management System Abaseen Institute of Medical & Modern Sciences

Course details

Module1 (Diploma In Database Management System)

  • Introduction and overview 
  • Exploring Access 
  • Database Planning 
  • Design Document 
  • Database Architecture 
  • Entity-Relationship Model: Entities, Attributes, Keys 
  • Entity-Relationship Model: Relationships, Roles and Dependencies 
  • Advanced E-R Modeling 
  • Intro to the Relational Model 
  • Relational Algebra 
  • Views and Mapping the ER model to Relational DB 
  • Functional Dependencies 
  • Normal Forms 
  • Normalization Process 
  • Chapters 1-4, 6 
  • Decomposition Examples 
  • SQL Data Definition 
  • SQL Query sublanguage 
  • Modifying Relations in SQL 
  • Views 
  • Triggers Overview 
  • JDBC 
  • Embedded SQL 

Module2 (Diploma In Database Management System)

  • Object Data Model 
  • Universal Modeling Language 
  • Extended Entity Relationship Model 
  • PHP Notes 
  • Disk Organization 
  • Heap Files (optional) 
  • Sorted Files and Indexes 
  • ISAM and B-trees 
  • Hash Files 
  • DB Security 
  • ACID propertiesv 
  • Isolation in Transactions 
  • Recovery Atomicity and Durability 
  • Query Optimization Overviewv 
  • Sorting, Projection, Union, Difference 
  • Selection and Join Computation 
  • Distributed DB Overview 
  • Databases and the Internet 
  • Overview of XML 
  • Social and Ethical Issues 
  • OLAP and Data Mining 
  • NoSQL slide presentation 
  • Hadoop

About Abaseen Institute of Medical & Modern Sciences

AIMMS (Abaseen Institute of Medical & Modern Sciences) is the only ISO Certified, &  the biggest educational network of its kind in the country and spread throughout all provinces. It is to further clarify that AIMMS is affiliated institute with Trade Testing Board, Board of Technical Education KPK, Skill Development Council Punjab, Board of Technical Education,  and other national and international bodies of education like United Kingdom Association of Professionals(UKAP), American Learning Center Virginia of USA and  especially for international students, and is working as a registerd firm.  AIMMS does not issue its own certification, but it helps the prospective students issue various diplomas/certificates and awards with the collaboration of these affiliated bodies.

AIMMS, the only home of learning where your dream to get 1 & 2 year professional diploma of International standard, has become easier now. The ocean of learning & motivation, pioneer in Distance Learning, Assignment, Home Based Study and Experience Based education, and the only ISO certified and Govt recognized organization of its kind in the region, engaged in providing education under unique style at your door step and shape your skills into productive excellence. 

The launch of Abaseen Institute of Medical and Modern Science (AIMMS) is a hall-mark event in the educational history of Pakistan. In collaboration with well-reputed organizations of the country and abroad, and the liberal support of professionals, AIMMS is taking big strides on the way to unprecedented progress. It has brought in vogue education at your door steps through various strategies which includes Distance Learning Program (DLP), FAST Track Education System (FTES) and Experience based education program known as RPL. This will have tremendous impact on the socio-economic growth of the country.

AIMMS provides competency based, Skill-oriented  certification, Diplomas, Certified Professional Management (CPM) and  experienced professionals in the field of research, management, health, technical, vocational and computer related technologies to help the under privileged segments of the society. To bring prosperity through skill is the sole motto of AIMMS. For all technical and practical courses, previous experience is required, otherwise, we can arrange periodic workshop for the students if the required number of students get enrolled.

See all Abaseen Institute of Medical & Modern Sciences courses

Contact information not available.

Are you from Abaseen Institute of Medical & Modern Sciences ? Claim your course!
Courses you can instantly connect with... SPSS Appxone Training Center

Is this the right course for you?

Rate our content

Didn't find what you were looking for ?