ADVANCE
YOUR CAREER. TRANSFORM YOUR LIFE WITH IN-DEMAND SKILLS FOR AN ON.DEMAND WORLD. EARN MINIMUM £55K WITH
YOUR DB2 ADMINISTRATION SKILLS.
EXCELLENT INTERACTIVE SELF-TEACH TRAINING COURSE . IDEAL FOR THOSE DESIGNING AND DEVELOPING DB2 DATABASES. EXCELLENT FOR CONSULTANTS, DEVELOPERS AND ADMINISTRATORS LOOKING TO UPSKILL OR CROSS OVER TO A DB2 DATABASE ENVIRONMENT.
VERY GOOD INTERACTIVE TRAINING MATERIAL WITH REAL-LIFE BASED TASKS, ACTIVITIES AND EXERCISES.
IBM DB2 SQL FUNDAMENTALS SELF-STUDY CBT
How This Course Is Organised
The IBM DB2 Database Querying using SQL Fundamentals course provides step-by-step instructions on how to perform a variety of database development tasks for activities based on real-life work scenarios. This course provides students with the technical skills required to write SQL queries for IBM DB2 9.7 to 11.5. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
This exam will be the underlying exam for all DB2-related disciplines; namely, Database Administration, Database Development and
Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI
professionals.
Note: This course is designed for students interested in learning DB2 9.7, DB2 10 or 11.5. It covers the new features in DB2 11.1 and
11.5, but also the important capabilities across the DB2 data platform.
Audience
Business Analysts
Report Writers
Database Developers
Database Administrators
Data Warehouse Developers
Business Intelligence Developers
Application Developers
Prerequisites:
Working knowledge of relational databases.
Basic knowledge of the IBM Windows operating system and its core functionality
Certification: IBM Certified Associate: DB2 11.1 Exam certification.
Objectives:
After completing this course, students will be able to:
Describe the basic architecture and concepts of IBM DB2 2014.
Understand the similarities and differences between SQL and other computer languages.
Write SELECT queries
Query multiple tables
Sort and filter data
Describe the use of data types in DB2
Modify data using SQL
Use built-in functions
Group and aggregate data
Use subqueries
Use table expressions
Use set operators
Use window ranking, offset and aggregate functions
Implement pivoting and grouping sets
Execute stored procedures
Program with SQL
Implement error handling
Implement transactions
Supported versions: IBM DB2 9.7, 10 and 11.5
Course Outline
Introduction to IBM DB2
The Basic Architecture of DB2
DB2 Editions and Versions
Getting Started with DB2 Data Studio
Introduction to SQL Querying
Overview of DB2 types of statements
Commands and Statement Elements
Understanding Sets
Understanding Predicate Logic
Understanding the Logical Order of Operations in SELECT statements
Basic SELECT Statements
Advanced SELECT Clauses
Using DISTINCT, Aliases and Scalar Functions
Using CASE and MERGE statements
Query Multiple Tables using JOIN statements
Filtering and sorting data
NULL values
DB2 Data Types and Functions
Introduce data types
Character data types
Date and Time data type
Built in Functions
Grouping and Aggregating Data
Aggregate Functions
GROUP BY and HAVING Clauses
Using Subqueries
Writing Self-Contained Subqueries
Writing Correlated Subqueries
Using the EXISTS Predicate with Subqueries
Working with Table Functions
Using Views
Using Inline Table-Valued Functions
Using Derived Tables
Using Common Table Expressions
SET Operators Grouping and Functions
SET Operators
Writing Queries with the UNION Operator
Using EXCEPT and INTERSECT
Using APPLY
Window Functions
Grouping Sets(PIVOT, UNPIVOT, CUBE, ROLLUP).
Modifying Data in DB2
DML Statements
INSERT, UPDATE, and DELETE statements
Working with defaults, constraints and triggers
Using the OUTPUT clause
Programming with SQL PL
Introducing SQL PL
Control of Flow Options
Implementing error checking
Understanding and implementing transactions
Retrieving Catalog Data and Improving SQL Performance
Querying system catalogs
Creating and executing stored procedures
Improving DB2 Query performance
Monitoring DB2 Performance
NOTE: THIS COURSE IS ALSO AVAILABLE IN SELF-STUDY TRAINING GUIDE, E-LEARNING OR
DISTANCE LEARNING FORMATS. FEEL FREE TO ASK IF YOU PREFER DISTANCE OR E-LEARNING OR CBT FORMAT. PRICES DIFFER
What is Computer Based Training - CBT?
CBT's are usually interactive with Software Simulations (behaves like you're using the real thing on the PC, therefore you don't even need the real software installed on your machine) and sometimes BUT NOT ALWAYS with voice. This Publisher's CBT Titles do NOT have voice.
Generally, CBT's tend to be more expensive. This Publisher's CBT Titles are NOT based on Flash. They are based on the latest technology which uses the: See It, Do It, and Try It learning paradigm. A very powerful new way of learning. All CBT and Courseware Learning formats are delivered with FULL LICENCE KEY.
Today's competitive business environment and frequent software updates by software vendors demands rapid skill acquisition. WebLearning Publishing helps you keep up-to-date by delivering quality Interactive Self-Study in CBT format. These factors give CBT's a clear advantage over conventional, inconvenient and expensive Classroom and Hard-copy print training methods.
CBT's not only offers the advantage in terms of convenience and lower cost, but it also facilitates improved subject-matter comprehension.
The WebLearning unique Methodology
All WebLearning® Training Guide courses are based on the latest materials available at the time of publishing and are regularly updated every 3 months with FREE UPGRADES to the LATEST EDITION: A NEW, very effective and proven way of learning.
FACT:
- Material retention with CBT’S are 45% better than with conventional training methods
- Your learning curve with CBT is 25%-55% less than conventional methods
- The cost of CBT training is over 65% less than Classroom training
- CBT’S are self pacing, interactive and simulate the actual software being studied