• Code: ITP8TF291
• Extent: 3 cr (81 h)
• Timing: Semester week of intensive courses
• Language: English
• Level: professional studies
• Type: free-choice

This course follows the curriculum of BITe2007and TIKO05/HETI09.

Prerequisites

Good knowledge of SQL

Recommended reading Chapters 5, 6, 8, and 9 in the free e-book “Database Fundamentals” available at http://www.db2teamblog.com/2011/01/free-book-database-fundamentals.html

Learning objectives

Student is able to:

• Understand the concepts of the DBMS, database objects, tools and SQL implementation of IBM DB2 for Linux, Unix and Windows (LUW)
• To design and implement a small relational database
• Understand the performance and security issues in a DB2 LUW Environment

Course contents

Introduction on Monday 12 of March at 14-16 on Haaga-Helia Pasila Campus in classroom 5007M.

The course is offered as an onsite/classroom course at Haaga-Helia on intensive week 19-23 of March 2012 at 9-16 in classroom 5007M.  The same course is available also as free e-learning course AA001EN at http://www.DB2University.com, but for attending the certification test you need to enroll to the course at Haaga-Helia.  

The contents include DB2 Express-C 9 tutorials with exercises of  CE302A - DB2 Academic Training by IBM, including

• Relational database concepts
• Getting started with DB2 and Data Studio workbench
• Introduction to SQL and database objects
• Transactions, Concurrency and Locking
• Database security
• DB2 backup and recovery
• DB2 pureXML: XML and XQuery language in DB2
• DB2 Application Development.

Internal course exam for grades is on Friday 23 of March at 14-16.

DB2 Academic Associate Certification on-line test CE302A controlled by IBM on Friday 30 of March at 9-11 in Haaga-Helia classroom 5007M.

DB2 is a leading DBMS product in business world and its SQL implementation is very near the ISO SQL standard.  DB2 Academic Associate Certificate is valued internationally.  This course arranged with IBM Finland as part of IBM Academic Initiative programme provides students a unique opportunity to attend the course and IBM certificate test.  It may also open career paths on databases and software development in ICT industry.

Teaching and learning methods

35 h workshop contact hours + 1.5 h test.
average 45 h self-studies

Teacher responsible

Martti Laiho

Course materials

DB2 self-study tutorials (see above)
DB2 Express-C 9.7 virtual computer implementation
DB2 online documentation at
IBM DB2 Database for Linux, UNIX, and Windows Information Center
(http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp)

Assessment criteria

Exam for passing with course grades 0..4 on Friday 23.3.2012 at 14-16.
IBM DB2 Academic Associate Certification test on Friday 30.3.2012 at 9-11 for those who have passed the exam. Passing the certification test will upgrade the course grade to 5.