Loading feeds...

RDBMS DB100

The target of the seminar is to transfer the necessary expertise to design and use Relational Database Systems with IBM DB2

  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
  • DataBlue
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