How This Course Is Organised

The IBM DB2 Database Fundamentals course provides step-by-step instructions on how to perform a variety of basic development and administrative tasks for activities based on real-life work scenarios. This database training for beginners introduces and defines the terminology, concepts, and skills you need to understand database objects, security requirements, graphical tools, basic database administration, SQL scripts and writing database queries, in addition to executing stored procedures.


It also helps you prepare for the IBM Database Associate certification. The database training course is designed for individuals seeking to learn database fundamentals, including relational databases, database management systems, and database components. Take this free course and expand your database skills and knowledge today.

Certification: This course will assist in preparation for the IBM Database Associate certification exams.


Audience:
Business Analysts
Functional Implementer
Semantic Layer Modellers
Database Administrators
Technical Consultant
Business Intelligence Developer
Application Developers


Prerequisites:
None


Course Outline:

Introduction to Databases and the Relational Model
Key DBMS Concepts   
Data Modelling and Database Design   
Stages of Database System Development   
Basic Types of Data Relationships

Relational Concepts
Normalization
Referential Integrity
Constraints
Relational Database Components

Introduction to DB2
DB2 Editions and Versions
DB2 Data Studio
DB2 Database Components

DB2 Database Development Tools
Introduction to DB2 Development Tools
Installing Data Studio
Navigate DB2 Data Studio    
Exploring Database Objects in Data Studio
Creating Projects and Solutions with Data Studio

Database and Instances
Terminology Concepts
Client Interaction with Database and Instance
Understanding Database Limits

Instance Architecture
Memory Architecture Overview
Understanding Processes and threads
Background Processes

Database Architecture
Schema and Data Storage
Data Files
Logging and Data Dictionary

Creating Databases and Database Objects
Data Types
Database Objects
DDL Statements

Using DML Statements
Introducing DML statements
Modifying data using DML Statements
Using SELECT, INSERT, UPDATE and DELETE Statements
Indexes and Triggers

Using DCL Statements
Data Control Language
Commit and Rolling Back Transactions
Configuring Permissions on Database Objects
Granting Access to Databases
Revoking Access to Databases
Granting Access to Database Objects
Revoking Access to Database Objects

DB2 Administration Fundamentals
Understanding DB2 Security
Creating a Login
Creating Database Users
Granting Access to a Database Instance
Securing DB2 databases and Objects
Backup and Recovery

     

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

What is a 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. Our 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 deliveredwith 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.

NOTE:WebLearning Publishing CBT and Courseware products are now delivered with FULL LICENCE KEY.

NOTE: For security reasons, we always ship CD-ROM's separately from the Installation Keys.On receipt of your CD-ROM, just email us using the eBay mail system and will send the Install key straight away.

 

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