Introduction to DB2 SQL

Introduction to DB2 SQL

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.

DB2 SQL OUTLINE

• Introduction
• The Basics of SQL
• The WHERE Clause
• Aggregation
• Join Functions
• Using Nexus for DB2
• Date Functions
• OLAP Functions
• Temporary Tables
• Sub-query Functions
• Strings
• Interrogating the Data
•  View Functions
• Set Operators Functions
• Table Create and Data Types
• Data Manipulation Language (DML)
• Statistical Aggregate Functions