Official Introduction to DB2® for z/OS®, The, 2nd Edition

Chapter 5. Working with SQL: The language of DB2

• Executing SQL 113

• Writing SQL queries to answer questions: The basics 120

• Modifying data 162

• For more information 164

• Practice exam questions 166

• Answers to practice exam questions 174

Exam topics that this chapter covers Accessing DB2 UDB data: Ability to access and manipulate DB2 UDB objects Working with DB2 UDB data: Given a DDL SQL statement, knowledge to identify results Given a DCL SQL statement, knowledge to identify results Given a DML SQL statement, knowledge to identify results Ability to use SQL to SELECT data from tables Ability to use SQL to SORT or GROUP data Ability to use SQL to UPDATE, DELETE, or INSERT data Working with DB2 UDB objects Ability to demonstrate use of DB2 UDB data types ...