Description: |
Designing relational models and RDBMS usage |
Audience: |
Programmers - analysts |
Prerequisites: |
No previous experience other than basic IT terms |
Material covered: |
- The relationαl model, terms and concepts
- Logical Models
- Entities/Attributes
- Relationship Types
- E-R Diagrams and Tools
- Physical designing of DB2 Database
- Solving relations Many to Many
- Normalization Forms
- Denormalization
- Data Types DB2/Constant-Variable Lengths
- Datatypes/lengths/Fixed/Variable
- NULLS
- Keys(Primary,Unique)
- Referential Integrity (Foreign Keys)
- Other Tables rules/Columns(Check Constraints)
- Indexes
- Introduction to SQL
- Commands Select, insert, update, delete
- Stored procedures-Reference on SQL PL
- Triggers
- Recursive SQL
|
Duration: |
The duration of this seminar is 5 Days from 9:30 to 14:30
|
|