SQL Fundamentals for DB2

View Your Course Transcript

Videos

There are several great features that come with this course. The Course Transcript tracks your progress and allows you to pick up where you left off. You can view or email your transcript. The course comes with documentation found in Downloads Tab. You have access to the course and all videos for 1 year. Full screen viewing option available (see icon on bottom right corner of video).

Start Learning SQL Fundamentals for DB2 Today!

Your Price: $695

Video Title	Minutes
01: Introduction to Relational Databases	39
01a: Workshop: Familiarization	19
02: Simple SELECT Statements	37
03: Simple Modification Statements	28
04: Data Types	28
05: Scalar Functions	33
06: Joining Tables	26
07: Aggregate Processing	24
08: Subqueries	31
09: Set Operations	28
10: CASE Expressions	25
11: Outer Joins	28
Total:	5 hours 46 minutes

Start Learning SQL Fundamentals for DB2 Today!

Your Price: $695

Course Materials

Want to be able to access these helpful materials? Contact Us!

• Workshop Environment
• Workshop Labs (see Related Training for Links Needed)
• Workshop Solutions
• Course Quiz

Related Links

• Workshop 8 SQL Script
• Course Survey

For more information, contact us or call 1-877-546-4446

Start Learning SQL Fundamentals for DB2 Today!

List Price: $995 Your Price: $695

Description

This SQL Fundamentals for DB2 online training course is designed for the database professional who wants to get more "bang for the buck" out of DB2. This DB2 course presents basic and intermediate SQL syntax in an easy-to-understand format, demystifying even some of the more complex features. It will enable you to return to work much better prepared to avail yourself of the power of the DB2 engine.

Once you have completed SQL Fundamentals for DB2 the next course in this series is Advanced SQL for DB2. The Advanced SQL for DB2 course will enhance your knowledge by presenting advanced SQL syntax formats and discussing the most complex new features. Click here to learn more about Advance SQL for DB2.

Objectives

As a result of taking this DB2 online training course, you will be able to:

• Use relational database concepts and terminology fluently, particularly that of the DB2 family of database management systems

• Identify the various types and components of Structured Query Language (SQL)

• Code simple to complex SELECT, INSERT, UPDATE, and DELETE statements

• Distinguish between DB2’s various built-in data types and use scalar functions to transform data types

• Code simple inner join statements and understand the concepts of an outer join

• Perform aggregate processing with column functions and the GROUP BY and HAVING clauses

• Distinguish between and code both correlated and non-correlated sub-queries

• Combine result sets with the UNION and UNION ALL set operators and understand the related concepts of intersection and difference

• Code CASE expressions and outer joins as appropriate alternatives to UNION ALL

Related Training

• Course: Advanced SQL for DB2
• Podcast: A Brief History Of DB2 And SQL
• Podcast: Installing DB2 On Windows
• Podcast: The Impact Of Relational Theory On Application Design

For more information, contact us or call 1-877-546-4446

Start Learning SQL Fundamentals for DB2 Today!

List Price: $995 Your Price: $695

SQL Fundamentals for DB2 Outline

Note: Workshop environment, labs, solutions and course quiz are now available in the Downloads section of this page.

Module 01: Introduction to Relational Databases

• Relational database concepts
• The DB2 family
• Structured Query Language (SQL)
• Workshop: Familiarization

Module 01 A: Familiarization Workshop

Module 02: Simple SELECT Statements

• Simple SELECT statements
• Column projection: The SELECT clause
• Row selection: The WHERE clause
• Sequencing the result: The ORDER BY clause
• Workshop: Data retrieval

Module 03: Simple Modification Statements

• Adding rows: The INSERT statement
• Changing column values: The UPDATE statement
• Removing rows: The DELETE statement
• Views and modification statements
• SQL return codes
• Workshop: Data modification

Module 04: Data Types

• Numeric, string, and chronological data types
• Special registers
• Nullable columns

Module 05: Scalar Functions

• Data-type conversion with scalar functions
• Scalar functions to change nullity
• Numeric, string, and chronological scalar functions
• Miscellaneous scalar functions
• Workshop: Customizing result sets

Module 06: Joining Tables

• Types of joins
• Joins for referential integrity
• Self-referencing joins
• Joining three or more tables
• Exceptions and outer joins
• Workshop: Inner joins

Module 07: Aggregate Processing

• Column functions
• The GROUP BY clause
• The HAVING clause
• Workshop: Column functions and grouping

Module 08: Subqueries

• Syntax elements
• Noncorrelated and correlated subqueries
• Subquery predicates
• Modification statements with subqueries
• Workshop: Subqueries

Module 09: Set Operations

• Union
• Intersection
• Difference
• Workshop: Combining result sets

Module 10: CASE Expressions

• Searched WHEN clause
• Simple WHEN clause
• More examples of CASE expressions

Module 11: Outer Joins

• Inner joins-Review
• Exception rows
• Outer joins-The old way
• Left, right, and full outer joins
• Filtering rows in outer joins
• Workshop: Alternatives to UNION ALL

For more information, contact us or call 1-877-546-4446

Start Learning SQL Fundamentals for DB2 Today!

List Price: $995 Your Price: $695

Prerequisites

There are no DB2 or SQL specific prerequisites for this course. However, any prior experience with DB2 or other relational database management systems should prove valuable.

Proficiency with Windows, Notepad (or another Windows-based text editor), the mouse, and the PC in general is assumed. For a Linux/UNIX audience, familiarity with equivalent tools and concepts is assumed.

For more information, contact us or call 1-877-546-4446

Start Learning SQL Fundamentals for DB2 Today!

List Price: $995 Your Price: $695

System Requirements

Hardware:

• Windows, Windows 64-bit, Linux, Linux 64-bit, Linux on Power, Solaris x 86-64 or Mac OS X
• For specific system requirements, download Getting Started with DB2 Express C

Software:

• IBM DB2 Express-C

 

For more information, contact us or call 1-877-546-4446

Start Learning SQL Fundamentals for DB2 Today!

List Price: $995 Your Price: $695

When you purchase a course from GogoTraining, you can submit comments or questions to our expert instructors.