 | Level: Intermediate Matthew Bennett , Marketing Specialist, IBM
Pat Moffatt (pmoffatt@ca.ibm.com), WW Education Offering Manager, IBM
17 Apr 2008 Here's a fun way to learn about IBM® Informix®! Learn
or teach the basics of Informix Dynamic Server (IDS) and relational databases with
an interactive game called "The IDS Detective Game." The game teaches relational
database concepts and shows how technology can be applied to solving real-life
problems (the game's theme is a crime investigation). The IDS Detective Game is
based on the DB2® Detective Game created by Joanna Kubasta and Joanne Moore. Objectives - Gain an understanding of database concepts such as tables, rows
(records), columns (fields), and values.
- Learn about relational databases, data models, unique keys, primary keys,
foreign keys, and table joins.
- Gain a working knowledge of the primary SQL statements: select, update,
insert, and delete.
- Use the IDS command window to import a database.
- Use dbaccess to create and execute SQL code.
Prerequisites
None. This tutorial assumes that you have no prior knowledge of relational
databases or SQL.
System requirements
This tutorial was written assuming users are using Informix Dynamic Server
Developers Edition running on MS Windows. To play this game, you should have IBM
IDS 11 installed, the IDSGame database loaded, and the clue file running.
Duration
Formats html, pdf
Tutorial overview
This tutorial introduces new users of IDS 11 to relational database concepts
through a fun and interactive game called "The IDS Detective Game." The recommended
audience is small business owners, students, teachers/professors, or anyone
wanting to gain an understanding of data management.
| | | |
