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 ...

Get Beginning DB2: From Novice to Professional now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.