Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Limited Period Offer :
Use CC 90_DB2 for flat 50% off.
"DB2 Certification sample questions added"
Why Learn DB2 ?
Better paid jobs and a great career choice !
An average DB2 DBA salary is $72,000 p.a. --(source-indeed dot com)
What are the chances of landing up with a DB2 Job?
Most people go for Oracle, MS SQL and other DBA jobs.
There are a good number of DB2 DBA jobs too (for freshers and exp.), but it's hard to find good DB2 Professionals.
Take the advantage, get hired by Big Companies and get a Better Compensation.
What companies use DB2?
To name a few
Dominos Pizza, Morgan Stanley, PricewaterhouseCoopers(PwC), American Express, Coca Cola, IBM, Deloitte, McDonald's, VISA, Mastech, Conexess Group, Accenture, Kforce, Open Systems Technologies , Walmart , TCS, Infosys, CSC, XEROX, HP, Guardian Life, CapGemini, WIPRO
and many more. (source - indeed dot com and glassdoor dot com)
What's the future of being associated with DB2?
DB2 is high competition to other databases and being IBM's biggest selling software in databases, its here to stay for ages.
With it's Oracle compatibility features in DB2 9.7, it's getting harder for competitors.
Is this course sufficient to get a DB2 DBA Job?
This course provides a strong conceptual knowledge (that most interviewers look for) backed by practical learning (that adds to your employment chances).
After completing the course, you will have the knowledge of DB2, equivalent to a 0.5-1.5 Years exp professional.
Will I be able to learn DB2?
You just need to have the zeal to learn. I've put in best of my efforts to make this course as simple as i could (from a beginners perspective) , by explaining concepts that should be easy to understand and the step-by-step tutorials (demos) will be really easy to follow.
The course has Quizzes, Exercises and Resources to back you up with your learning.
I am here to share my knowledge and experience on DB2, connect with you guys, participate in the discussion forums, answer questions you ask and make sure you learn DB2 like nobody else can do.
You'll be a pro at DB2 !
What about the Professional IBM DB2 Certification?
A professional DB2 certification ensures that you have been tested on the skills by the giant itself (IBM).
I have trained 12000+ students on DB2 and the certification success ratio has been over 95%.
This course covers all concepts and practicals that will help you clear the certification (if you choose to go for it) with good marks. There is a section dedicated completely towards clearing the DB2 Certification. The sample certification questions will help you in clearing the main DB2 exam.
It's good to have a basic understanding of DBMS concepts and SQL. Although, i've covered these concepts too during the lectures.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
About Me - Your InstructorPreview
Welcome to the course !Preview
Introduction to DB2Preview
DB2 Versions & Editions
DB2 Editions - Differentiation
|Section 2: Installing DB2 9.7 on Windows OS|
Understanding system requirements
Preparing machine for installation
Installing DB2 9.7 on Windows
Installing DB2 9.7 using RESPONSE FILE
|Section 3: DB2 Architecture|
DB2 Enviroment - The Big Picture
DB2 Environment - Instances
DB2 Environment - Databases
|Section 4: Exploring DB2 Tools|
First Steps - creating our first database
Command Line Processor (CLP)
CLP - Running Scripts in DB2
CLP - Obtaining Help Information
Command Line Processor Plus (CLP Plus)
Configuration Assistant - Connecting to Remote Databases
DB2 Data Server Clients
|Section 5: Working with DB2 Database Objects - Part 1 - Tables & Views|
Definitions & Classification of Tables
Create Table statements
Tables with Identity Columns
Referential Integrity Constraints - Part I
Referential Integrity Constraints - Part II
Alter & Drop Table statements
Materialized Query Tables (MQTs)
|Section 6: Working with DB2 Database Objects - Part 2 - Views|
Views - Introduction & Create View statement
DML operations on Views
Creating view(s) from multiple tables
Creating Views with Local Check Option
Creating views with Cascaded Check Options
More on Views
|Section 7: Working with DB2 Database Objects - Part 3 - Other Objects|
Indexes - Concept
Indexes - DemoPreview
Schemas - Concept
Schemas - Demo
Triggers - Concept
Triggers - Demo
Sequences - Concept
Sequences - Demo
Buffer Pools - Concept & Demo
Tablespaces - Concept
Tablespaces - Demo
Exercise 1 - Working with Database Objects
|Section 8: DATA Types in DB2|
Data Types - Classification
Numeric data types
String data types
CLOB & DBCLOB data types
BLOB - Inserting Images in Tables
Date, Time & Timestamp - Part 1Preview
Date, Time & Timestamp - Part 2
XML data type
|Section 9: Querying DB2 Data - SELECT Statement & Clauses|
SELECT statement - clauses
Retrieving Specific Columns
ORDER BY clause
GROUP BY clause
GROUP BY ... HAVING clause
FETCH FIRST n ROWS ONLY clause
Working with NULL values
Sub-Queries or Inner Queries
Exercise 2 - Working with Sub-Queries or Inner-Queries
|Section 10: Limiting Data - WHERE clause|
AND / OR predicate
BETWEEN & NOT BETWEEN predicate
IN & NOT IN predicate
Adnan has a Bachelors Degree in Electronics & Communications Engineering and has 7+ years of IT Experience.
He has a rich industry experience working on IBM technologies/tools like DB2 (IBM's database software), Lotus Domino (Mail Server), Rational Team Concert (Project Management tool) and Tivoli Directory Server (LDAP directory) and few others.
Following his passion for trainings and love for DB2, Adnan succesfully trained 12000+ students from IT and Non-IT backgrounds on DB2, as a part of IBM's Academic Initiative Program in India, and also got them certified.
Along with training University/College students, he has trained many working professionals from Fortune 500 companies, and helped them better their profiles in the field of database management for DB2 software.
After working for IBM's Academic Initiative Program, Adnan founded an IT services firm in New Delhi, and currently works as the CEO of SyncIT Services.
Adnan carries 7 professional IBM certifications, 3 of them are on IBM DB2.