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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.