Great overview of Apache HTTPD! Perfect for those who are Apache newbies.
More Testimonials »
Introduction to DB2 SQL Training
Delivery Options
- Live Online Training - Public Class (): $1,275.00
- Customized Onsite Training (3 days): Request a Proposal
Upcoming Live eLearning Classes
There are currently no upcoming Live eLearning classes. Please contact us if you would like us to schedule a class.
Class Description
Class Overview
This DB2 training class uses a hands-on approach to teach application programmers and designers the essential concepts of DB2 SQL. Upon completion of this DB2 class, students will understand DB2 relational databases, be able to execute both simple and complex queries using DB2 SQL, and be able to create and manipulate table data.
Class Goals
- Understand the basic concepts and facilities of DB2
- Be able to create and execute simple SQL statements
- Be able to create the desired results table using an SQL select statement
- Be able to restrict rows using WHERE clause
- Sort output data into desired sequence
- Learn basic CASE Expressions
- Learn the Data and Time formats
- Learn to format data using Scalar functions
- Be able to obtain aggregate data using GROUP Functions
- Learn the limitations and capabilities of SQL Group Functions
- Know how to use subqueries
- Create both simple and complex subqueries
- Be able to identify and use likely join column relationships
- Be able to show ownership of table columns
- Know how to use the WHERE clause conditions to limit the impact of
- Be able to combine the results from multiple queries using UNION
- Know how to execute a true Outer Join
- Be able to create a table and its columns
- Use both methods to Insert data
- Know the importance of the WHERE clause in Updates, and Deletes
- Be able to Insert, Update, and Delete rows
- Be able to use ROLLBACK / COMMIT when needed
Class Outline
- DB2 Overview
- DB2 Concepts & Facilities
- Relational Concepts
- Introduction to SQL
- Basic SQL SELECT Statement
- Using the Select Statement
- Full Syntax of SELECT Statement
- Result Tables
- ALL vs. DISTINCT
- Column Arithmetic
- WHERE Clause
- ORDER BY Clause
- Case Expressions
- Using CASE Expressions
- Scalar Functions
- DATE and TIME Formats
- Scalar Functions
- Special Registers
- SQL Group Functions, and Group By
- Group Functions
- GROUP BY
- HAVING
- Subqueries
- Simple Subqueries
- Subquery with IN, ANY/SOME, ALL, EXISTS
- Correlated Subqueries
- Joins
- Join Concepts and Keys
- Joins vs Subqueries
- Planning a Query
- Union
- Combining Result Tables
- UNION
- Outer Join using Subqueries
- Creating Tables
- CREATE TABLE
- Primary / Foreign Keys
- DROP TABLE
- ALTER TABLE
- SQL Data Manipulation
- INSERT Single Rows into a Table
- INSERT Multiple Rows into Tables with Queries
- UPDATE One or More Rows
- DELETE One or More Rows
- ROLLBACK / COMMIT
Class Materials
Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.
Technical Requirements
Our computer technical requirements and setup process is easy, with support just a click away.
Client Success
Join The Team
- Learn how you can become a Webucator Trainer
- Career Opportunities
Locations
- Where We've Trained
- We have trainers all over North America.
Compare Us
Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.