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, DEVELOPING AND ADMINISTRATING DB2 DATABASES. EXCELLENT FOR ORACLE 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 DATABASE DESIGN AND DEVELOPMENT E-LEARNING

How This Course Is Organised

The Weblearning IBM DB2 Database Design and Development course combines DB2 Database design, modelling and  Stored Procdures/PL/SQL development foundation courses into a single solution for students wanting to start a highly rewarding career in Database administration and development.

DB2 is a relational database management systems whose primary function is to store and retrieve data. As a database designer and developer you will be working closely with new and existing corporate databases as well as database administrators and business analysts to capture business requirements and implement them using ER modelling techniques; IBM SQL Queries and Procedural programming languages; ensuring performance, reliability and security.

You will also be filling the databases with new and updated information, backing up information and ensuring that databases have ample storage space.


Duration: 1 Year Access


Supported versions: DB2 9.7, 10 and DB2 11.5


Audience:
Business Analysts/End Users
Database Developers
Database  Administrators
Business Intelligence Developer
Reports Developer
Support Engineer


Course Objectives:

Understand Relational Database Concepts
Understand Types of  Databases Models
Understand  Gathering Requirements for Database Design
Understand the Stages of Database system Development
Writing SELECT queries
Sorting and filtering data
Using SQL aggregate functions
Using SET operators
Writing joins to query multiple tables
Using built-in functions
Using Subqueries
Inserting, updating, deleting and merging rows
Transaction control
Creating and using views
Using table expressions
Enhanced Grouping and Pivoting data
Using Windowing ranking, offset and ranking functions
Creating and using Stored Procedures
Controlling Program Flow
Using Dynamic SQL
Implementing Error Handling
Improving Query Performance
Understand Oracle PL/SQL Programming in DB2
Develop PL/SQL Stored Procedures



Courses Topics:

Database Design Topics:

Database Design
Introduction
Data vs. Information
History of the Database
Major Transformations in Computing

Entities and Attributes
Conceptual and Physical Models
Entities, Instances, Attributes, and Identifiers
Entity Relationship Modeling and ERDs

Relationship Basics
Identifying Relationships
ER Diagramming Conventions
Speaking ERDish & Drawing Relationships
Matrix Diagrams

Super/Sub Types and Business Rules
Supertypes and Subtypes
Documenting Business Rules
Relationship Fundamentals
Relationship Transferability
Relationship Types
Resolving Many-to-Many Relationships
Understanding CRUD Requirements

UIDs and Normalization
Artificial, Composite, and Secondary UIDs
Normalization and First Normal Form
Second Normal Form
Third Normal Form

Arcs, Hierarchies, and Recursive Modeling
Hierarchies and Recursive Relationships

Changes and Historical Modeling
Modeling Historical Data
Modeling Change: Time
Modeling Change: Price
Drawing Conventions for Readability

Mapping
Introduction to Relational Database Concepts
Basic Mapping: The Transformation Process
Relationship Mapping
Subtype Mapping

Creating Database Projects
System Development Life Cycle


Course Topics:

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 Windows 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 and PL/SQL
Introducing SQL PL and PL/SQL
Control of Flow Options
Implementing error checking
Understanding and implementing transactions

Retrieving DB2 Catalog Data and Improving SQL Performance
Querying system catalogs
Creating and executing stored procedures
Improving DB2 Query performance
Monitoring DB2 Performance

Duration: 1 Year Access

 

NOTE: THIS COURSE IS ALSO AVAILABLE IN SELF-STUDY CBT, TRAINING GUIDES OR DISTANCE LEARNING FORMATS. FEEL FREE TO ASK IF YOU PREFER DISTANCE, CBT OR TRAINING GUIDES E-BOOK LEARNING FORMATS. PRICES DIFFER.


What is eLearning?
eLearning is like CBT (Computer Based Training) training but eLearning is conducted over the internet with tutor support and is 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 eLearning Titles do NOT have voice.

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 eLearning format. 

These factors give eLearning a clear advantage over conventional, inconvenient and expensive Classroom and Hard-copy print training methods.

eLearning 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®  CBT,  eLearning and 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: ANEW, very effective and proven way of learning. 

FACT:

  • Material retention with eLearning are 45% better than with conventional training methods
  • Your learning curve with eLearning is 25%-55% less than conventional methods
  • The cost of eLearning training is over 65% less than Classroom training
  • eLearning are self-pacing, interactive and simulate the actual software being studied