IBM® DB2® has been one of the world’s leading relational database management systems since its first release in 1983. Bascom Bridg’s DB2 SQL training course teaches students how to query and manipulate data stored in DB2 using SQL.
DB2 SQL OBJECTIVES
All students will learn:
Basic SQL Functions
The WHERE Clause
Distinct Vs. Group By
Aggregation Function
Join Functions
Date Functions
OLAP Functions
Temporary Tables
Sub-query Functions
Strings
Interrogating the Data
View Functions
Set Operators
Data Manipulation Language (DML)
Statistical Aggregate Functions
DB2 SQL PREREQUISITES
No prior experience is required.
DB2 SQL MATERIALS
All DB2 training students receive comprehensive courseware, available electronically.
SOFTWARE NEEDED FOR EACH PC:
We have multiple options for setting up this course using a mix of local and/or cloud resources that we provide. Please ask us for details.
For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor’s screen simultaneously with working on their own.