-
Learning by doing
-
Trainers with practical experience
-
Classroom training
-
Detailed course material
-
Clear content description
-
Tailormade content possible
-
Training that proceeds
-
Small groups
In the course Database Design participants learn the techniques and considerations for creating a well-structured database. Design is a crucial part of an effective implementation of a relational database. Modeling data is the basis of building and developing a database. The course uses various case tools to create diagrams.
The course Database Design starts with a discussion of the basic architecture of Database Management Systems. Attention is paid to the Database Schema and the differences between the conceptual, logical and physical model. The role of SQL, Data Definition Language (DDL) and Data Manipulation Language (DML) is also discussed.
Subsequently the phases of Database Design and the components of a database are treated. The ERD Model and the UML Model are covered here. Possible design errors and the application of constraints are also reviewed.
In the ER Modeling section participants learn how to discover the entities and their relationships and map them to tables. They learn the principles of Entity Relationship Modeling. Also treated is how to find and model attribute domains.
Then attention is paid to how entities and their relations can be translated into tables in a relational database. The different mapping strategies for hierarchies of entities are also covered such as table per class, table per hierarchy and the use of discriminator columns.
Next to the use of Unified Modeling Language UML for database design is treated. The UML syntax is discussed as well as UML elements such as interfaces, associations, composition, generalization and dependencies.
The process of normalization, the different normal forms and the removal of duplicate data are explained by means of practical examples. Finally, a number of optimization techniques, such as the use of indexes, that can improve the speed of databases are discussed.
The course Database Design in intended for Web developers, web application developers, database administrator, webmasters and web project managers.
To join the course Database Design no specific skills or knowledge is required. General knowledge of system design is helpful to a proper understanding.
The theory is treated using presentation slides. Demos are used to clarify the theory. There is ample opportunity to practice. The course material is in English. The course times are from 9.30 up and to 16.30.
Participants receive an official certificate Database Design after successful completion of the course.
Module 1 : Intro DBMS |
Module 2 : Database Design |
Module 3 : Entity Relationship Modeling |
| What is a DBMS? DBMS Abstraction Levels Data Independence Database Model Types of Databases Database Schema Conceptual Model Logical Model Physical Model SQL Language DDL and DML Language Application Interfaces Transactions DBMS Architecture |
What is Database Design? Database Design Phases Benefits of Phases Conceptual Data Model Entity Relationship Model UML Model Structuring the Model Design Errors Data Errors Constraints Database Constraints Naming Schema Elements Data Interpretation CASE Tools |
E-R Model Components Identification Guidelines Entities versus Entity Classes Attributes Entities versus Attributes Classification of Attributes Attribute Domains Relationships Degree of relationships Relationship Cardinalities Notation of Cardinalities Removing M:N relations Requirement Analysis Resulting ER Diagram |
Module 4 : Advanced Er Modeling |
Module 5 : Mapping ERD to Tables |
Module 6 : UML Modeling |
| Weak Entity Set Generalization and Specialization Design Constraints Total and Partial Participation Disjoint Constraints Overlapping Constraints Aggregation ER Design Decisions Mapping ERD to Tables Composite Attributes Multivalued Attributes Redundancy As Tables |
Entity Set Table Translation Relationship Table Translation Mapping Key Constraints Map Relationship Set to Table Combine Relationship and Entity Set Weak Entity Sets Mapping Weak Entity Sets Mapping Subclasses Table per Subclass Table per Hierarchy Discriminator Columns Joining Tables |
What is UML? Structural Modeling? Core Elements Core Relationships Structural Diagrams Classes and Objects Class Diagrams Interfaces Associations Composition Generalization Dependencies |
Module 7: Normalization |
Module 8: Database Optimization |
|
| What is Normalization? Unnormalized form Moving towards 1NF First Normal Form Moving to 2NF Second Normal Form Third Normal Form Other Normal Forms Benefit of Normalization Relationship Cross Tables |
Optimization Process Use Ranges Denormalize Denormalization Issues Combine Tables Store Derived Data Add Indexes Index Operation Sorting Clustered Indexes |
These companies already made use of our courses:
These companies used our courses:
