• Advance Your Career Today
  • Learn New Skills
  • Save Money
  • Save Time
  • Get Certified
  • Get Promoted
  • Learn More
  • Advance Your Career Today

SQL Fundamentals for DB2 Enroll Today!

Select The Package That's Right for You
Standard Deluxe Premium
Videos
1 Year Access to Course
Transcript
Course Materials
Instructors Answer Your Questions
Course Completion Certificate
$195 $425 $695
Add to Cart Add to Cart Add to Cart

SQL Fundamentals for DB2

Key Course Benefits

  • Achieve Workplace Success by Learning from Real World Experts
  • Learn and Implement New Skills Faster With Real World Examples
  • Take High Quality Classroom Courses Without the Hassles of Travel
  • Student Guide Makes it Easy for You to Take Notes and Increase Learning
  • Course Demos and Exercises Help You Learn More
  • Eliminate Scheduling Conflicts by Training Anytime 24/7 for 1 year
  • Video Training with Materials, Exercises, and Instructor Support Maximizes Learning
  • 1 Year Course Access Gives You Time to Learn and Master Concepts
  • Use Your Course Completion Certificate to Build Your Resume
  • Responsive Customer Service Makes Independent Learning Easy and Smooth
  • Save Money and Learn More

Start Learning SQL Fundamentals for DB2 Today!

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
Course Survey
Total: 5 hours 46 minutes

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

Start Learning SQL Fundamentals for DB2 Today!

Course Purchase Options

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.

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.

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

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

Start Learning SQL Fundamentals for DB2 Today!

Course Purchase Options

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.

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!

Course Purchase Options

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

Important 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!

Course Purchase Options

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

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

Start Learning SQL Fundamentals for DB2 Today!

Course Purchase Options

System Requirements

Hardware:


Software:

 

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

Start Learning SQL Fundamentals for DB2 Today!

Course Purchase Options

When you purchase a Deluxe or Premium course from GogoTraining, you can use your transcript to view and monitor your progress and when you complete the course, you can print or email the transcript, or print a course completion certificate.


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

Start Learning SQL Fundamentals for DB2 Today!

Course Purchase Options

We show that you have been logged out, probably due to automatic session limits. Please Login to continue viewing content.

Sign up today for your FREE GogoTraining account to access hundreds of free resources.

Security Question

Answer this question to complete your registration.

Which one is NOT the name of an IT Programming language?

Perl Programming
Android Programming
C Programming
A swimming pool
A swimming pool
Android Programming
Perl Programming
Perl Programming
C Programming
Android Programming
A swimming pool
C Programming