Duration
4 hours
Overview
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.
Audience
Programmers, DBAs, business analysts, and any other personnel that require SQL coding skills to manage Db2 data.
Prerequisites
Completion of the ‘Manage Data Definitions’ course, or equivalent knowledge.
Objectives
After completing this course, the student should 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
Course Content
SQL – Selecting Data
Using the SELECT Statement to Obtain Data
Coding Predicates (WHERE Clauses)
Coding Simple Column Arithmetic
Coding for the Effects of Null Values
SQL – SCALAR and COLUMN Functions, ORDER BY Clause
Scalar Functions
Aggregate or Column Functions and Groupings
Coding the ORDER BY Clause
SQL – The INSERT, DELETE, UPDATE, and MERGE Statements
Inserting Rows into Tables
Deleting Rows from Tables
Modifying the Values of Columns in Rows