Career Space Skill Definition

Database Concepts 

Skills Definition

Whenever large volumes of data need to be stored, or an ability to search or access part of the data is required, then a database will be used. Understanding database concepts means understanding the theory and practice of database systems, the different ways of storing and accessing large volumes of data, the different types of database management systems and the performance trade-offs in their selection and design. The ability to create a simple database and to be able to write queries and reports would be very useful.

Academic Pre-requisites
 

Academic Content

(based on  material taken from ACM's and IEEE's Computing Curricula 2001, volume  II Computer Science) 

Introductory level:
  • DB1 Principles of databases; data models (ER, relational, object oriented), transaction processing, security.
  • DB2 Database query  language; SQL, report generator
  • DB3 Database systems;
  • DB4 Application databases; hypertext and media, multimedia, information retrieval
    • Intermediate level:
  • DB5 Storage structures; physical design, performance and optimization, recovery
  • DB6 Distributed databases;
  • DB7 Data mining;

    •   
    Advanced level:


    Output Standard / Minimum Level of Achievement

    xxxx
     

    Mapping Academic Content into courses in  D (Computer Science and Engineering)-programme  at Linköpings universitet, Sweden.

    X - covers relatively large part of contents
    x - covers smaller part of contents
     
     
    Courses D
    DB1
    DB2
    DB3
    DB4
    DB5
    DB6
    DB7
    Database Technology
    X
    X
    x
    		  
    X
    x
    		  
    Distributed Systems
    		          
    x
    		  
    Comments on coverage
    Good
    Quite good
    Rather week
    Week
    Good
    Quite good
    Will come