- 4 hours
The DB2 SQL Fundamentals course looks at some of the more common SQL statements used by programmers when starting out. It addresses the code used to obtain DB2 table data, sort it, as well as methods used for inserting, deleting, updating and merging table data.
Programmers, DBAs, business analysts, and any other personnel that require SQL coding skills to manage DB2 data.
Completion of the 'Manage Data Definitions with DB2' course, or equivalent knowledge.
After completing this course, the student will be able to:
- Code Simple SQL SELECT statements used to obtain DB2 table data
- Describe how data can be sorted
- Describe how to insert, update, and delete DB2 data by using SQL
Using the SELECT Statement to Obtain Data
Coding Predicates (WHERE Clauses)
Coding Simple Column Arithmetic
Coding for the Effects of Null Values
Aggregate or Column Functions and Groupings
Coding the ORDER BY Clause
Inserting Rows into Tables
Deleting Rows from Tables
Modifying the Values of Columns in Rows