Chapter 6. SQL for DB2: Part 1

A great deal of database work revolves around writing queries to do everything from populating your data to performing complex reports. The best place to start with a crash course or quick refresher on SQL is by learning about the data manipulation statements and seeing the additional capabilities DB2 offers with these statements. They then become the building blocks for further statements for object creation, database management, and more.

Manipulating Data with SQL

I've covered a range of SQL statements so far that are specific to DB2; for example, database creation, unique features of table and index creation, and other DB2-centric aspects of SQL. When it comes to manipulating the data in your database, there are ...

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.