Welcome to DB2 SQL Workshop IBM Learning Services Course - - PowerPoint PPT Presentation

▶

Sep 03, 2022 569 likes •624 views

Welcome to DB2 SQL Workshop IBM Learning Services Course Objectives After completing this course, you should be able to: Write basic SQL statements Use SELECT statements to retrieve data Use INSERT, UPDATE and DELETE statements to manipulate

SLIDE 1

IBM Learning Services

Welcome to DB2 SQL Workshop

SLIDE 2

Course Objectives

After completing this course, you should be able to: Write basic SQL statements Use SELECT statements to retrieve data Use INSERT, UPDATE and DELETE statements to manipulate data Use simple CREATE TABLE and CREATE VIEW statements

SLIDE 3

Agenda - Day 1

Welcome Unit 1: Introduction Unit 2: Simple SQL Queries Lab Exercises Unit 3: Retrieving Data from Multiple Tables Lab Exercises Unit 4: Scalar Functions and Arithmetic Lab Exercises

SLIDE 4

Agenda - Day 2

Unit 5: Column Functions and Grouping Lab Exercises Unit 6: UNION Lab Exercises Unit 7: Using Subqueries Lab Exercises Unit 8: Maintaining Data Lab Exercises