
Learn about several basic database concepts, including schemas, tables, and column data types, and get a simple introduction to SQL. This article--focusing on the database developer role--presents the basic data types you can use to <A HREF="http://www-128.ibm.com/developerworks/library/os-ad-trifecta3/index.html?ca=drs-">store data in an Apache Derby database,</A> and then you'll use them to create a simple schema with two tables in Apache Derby for a fictitious store. To view the schema contents of a database, you'll use the Apache Derby tool, dblook, to dump the contents of the database. The article wraps up with a brief discussion on dropping tables.