Chapter 7. SQL for DB2: Part 2
With databases, tablespaces, and buffer pools mastered, you might want to get back to the real business of databases—working with data! I'm not one to stand in the way of progress, so let's examine the capabilities DB2 provides to the aspiring data wrangler (that'd be you), in terms of creating tables to hold your data and then working to insert, select, update, and delete your data.
Creating and Managing DB2 Tables
In earlier chapters, you dealt with the
SAMPLE database and took a whirlwind tour of SQL to select, insert, update, and delete data. This might have been a refresher or a brief introduction if you are new to SQL. All the examples relied on the existing tables in the
SAMPLE database, but knowing how those ...