Objectives

• Learn the basic design process.
• Learn to create an iBase database
• Create record types
• Create fields, datasheets, and code lists.
• Learn how to import and export data.
• Learn how to upsize and manage a SQL database through iBase
• Learn how to set-up SQL functionality
• Learn how to generate reports.
• Learn how to manage the security of the database.
• Learn how to schedule a data import
• Learn how to administer and audit the database.

Students should have completed IBM iBase Essentials (9I130).

Database design experience is helpful but not required.

• Create and administer an i2 iBase database.
• Import and export data into a iBase database.
• Create fields, datasheets, and code lists.
• Upsize an iBase database to a SQL database.
• Manage users and access control.