|
|
|
 |
IN611Relational Database Design
This course is fine introduction in terminology and the concept of relational databases. On the basis of a plenty of exercises students are trained in simulation of operation of commercial firm with usage of a method of main links at designing a relational database. You are trained in techniques of normalization of the data, and also methods of sentence, an estimation and a choice of alternate constructions of a relational database. Besides you will gain practical experience of creation of databases and tables with the help of the Data definition language (Data Definition Language) - "sublanguage" SQL.
After learning course you can
- To understand relational technology and its advantages
- To understand concepts of designing of relational databases and appropriate terminology
- To create diagrams of main links for simulation of operation of firm
- To understand forms of normalization of the data and their advantages
- To use in your data models SQL of a construction and a rule of reference integrity
Contents of course
- Introduction in designing relational databases
- the Approach essence-link. Concepts and terms
- Diagrams essence-link
- Definition of properties of attributes
- Data types of server INFORMIX
- Normalization
- SQL Operators for creation of a database
- Usage of utility DB-Access for creation of a database diagram
- Input and extract of the data
- Group laboratory operation on designing a relational database
Preliminary preparation
the General education in the field of information technologies.
This course will help you to prepare for the next tests:
660-111 ?????? ??? ??????
Given cource inserted in next comlex programs:
Dadabases Basics Complex programm
Education coast on cource - USD 260
Cource duration (days) - 2
|
|
