Db2 LUW - Database Administration & Certification Workshop (Udemy.com)

A complete beginner course on becoming a highly paid Db2 Professional. Get loaded, Get Certified, Get Hired!

Created by: Mohammad Adnan Khan

Produced in 2021

icon
What you will learn

  • Understand the Architecture of DB2 (you will learn about various DB2 components that work together as a database engine)
  • Install & Configure DB2 on Windows and Linux platforms (you will learn to install & configure DB2 in multiple ways)
  • Work on various GUI and Command Line Tools of DB2 (you will explore different DB2 tools available to perform various administration tasks like creating databases, performing backup and recovery etc )
  • Create and Manage various database objects in DB2 (you will learn about db objects like tables, views, indexes etc, and there properties. you will learn how to create, access, alter and drop them)
  • Understand and Execute SQL statements in DB2 (you will learn to write basic and advanced SQL queries to manage your databases and db objects)
  • Create and Manage DB2 Instances & Databases (you will learn about instances and related concepts. you will create, list and drop instances and databases with DB2 c

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 86 / 100

icon
Course Description

************************************************************************************************Most thorough DB2 DBAcourse on Web : 40hours of video contentHighest rated DBA course on Udemy The top most relevant DB2 DBAcourse on Udemy************************************************************************************************

Course upgraded to DB2 10.
x and DB211.
x on LinuxDB2 10.
5 Certification 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?

High !
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?

Yes.

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?

Sure ! 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 certificationquestions will help you in clearing the main DB2 exam.

Any Pre-Requisites?

It's good to have a basic understanding of DBMS concepts and SQL. Although, i've covered these concepts too during the lectures.
Who this course is for:
This course if for those who want to start their careers in the field of Database Administration on IBM DB2Students, who are not comfortable with programming, can choose this course for a highly paid career in the field of databasesPeople looking for careers in Database DevelopmentAlready experienced DBAs (from other databases), can take up the course to increase their horizon for better paid DBA jobs

icon
Instructor Details

Mohammad Adnan Khan

Mohammad 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, Mohammadsuccesfully 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.
Mohammad carries 7 professional IBM certifications, 3 of them are on IBM DB2.

icon
More other courses

Aprende matemticas desde cero - Aritmtica

$11.99

Unofficial Udemy Student Guide: Courses Free or Dirt Cheap

$11.99

Poi Dancing: The Beginner Series

$11.99

Professional Advanced Angelic Healing Practitioner Course

$11.99

Professional Accredited Earth Angel Course

$11.99

Cours signe bb tout le vocabulaire autour du bb

$11.99

icon
Reviews

4.3

92 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Rodrigo Euzebio Ferreira on 11/15/2020

Curso muito bom, objetivo e aborda muitos itens do DB2

By Neeraj Goyal on 9/25/2020

Highly discouraging , The any course should be update with the latest version and latest info ..

By Alejandro Lopez Avila on 8/15/2020

Interesting so far.

By Kranthi Kiran Gandi on 8/11/2020

vedios not working

By Mohamed Shafi on 8/8/2020

Ok, but i am facing problems today, that i am not getting audio, it is running only video..

By Saurabh Dhiman on 8/5/2020

Great learning tutorials

By Piyush Agarwal on 8/5/2020

Instructor is very good and explain the concepts brilliantly well. Instead of control center which has been deprecated in version 10.1 and above, we wish to learn data studio or any other third party tool available for DB2 database like we have TOAD for Oracle.
I loved the training videos on database logging, backup and restore, concurrency, compression, other advanced features like HADR & RCAC and those concepts were demonstrated in excellent fashion.
Introduction to linux environment is welcome and would be quite helpful.
Overall a very engaging and very good learning experience.

By Lynnette Stinnett on 7/20/2020

Very informative

By Shivaraj on 6/26/2020

Its very good course. I am Oracle DBA expert and this course helped me to understand the DB2 very well.

By Tung Nguyen on 6/20/2020

Very good course!

By Rajeev Ranjan on 6/15/2020

So far it is going good.

By Mennatallah Ammar on 6/14/2020

the instructor is not answering any questions. which is weird !