DB2 9.7 - Database Administration & Certification Workshop

A complete course on becoming a highly paid DB2 Professional. Get loaded, Get Certified, Get Hired !
4.7 (33 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
110 students enrolled
$180
Take This Course
  • Lectures 244
  • Length 29.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2015 English

Course Description

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?

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 certification questions 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.

What are the requirements?

  • Basic concepts of DBMS i.e. what's a database used for, what are tables in relational databases etc.
  • Basic knowledge of SQL i.e. what are DDL and DML statements and how to write basic SQL Queries (Although it's covered in the course)

What am I going to get from this course?

  • Understand the Architecture of DB2
  • Install & Configure DB2 on Windows and Linux platforms
  • Work on various GUI and Command Line Tools of DB2
  • Create and Manage various database objects in DB2
  • Understand and Execute SQL statements in DB2
  • Create and Manage DB2 Instances & Databases
  • Administer and Manage Database Storage
  • Administer DB2 Security
  • Administer and Manage Data Concurrency
  • Perform Backup and Recovery operations
  • Prepare for Professional IBM DB2 Certification Exams

What is the target audience?

  • This course is for people wanting to be Database Administrators for DB2
  • Students, who are not comfortable with programming, can choose this course for a highly paid career in the field of databases
  • People looking for careers in Database Development
  • Already experienced DBAs (from other databases), can take up the course to increase their horizon for better paid DBA jobs

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
About Me - Your Instructor
Preview
07:57
Welcome to the course !
Preview
04:45
Introduction to DB2
Preview
10:33
DB2 Versions & Editions
10:51
DB2 Editions - Differentiation
11:19
Quiz Time
6 questions
Section 2: Installing DB2 9.7 on Windows OS
Understanding system requirements
08:48
Preparing machine for installation
06:22
05:15
  • Another link to Download DB2 9.7 for Windows OS:

  • https://www.dropbox.com/s/q8ygv27f0ck3oga/SERVER.rar?dl=0
  • Installing DB2 9.7 on Windows
    15:11
    Installing DB2 9.7 using RESPONSE FILE
    07:59
    Section 3: DB2 Architecture
    Section Overview
    03:24
    DB2 Enviroment - The Big Picture
    07:43
    DB2 Environment - Instances
    15:31
    DB2 Environment - Databases
    10:20
    Process Model
    21:50
    Memory Model
    15:37
    Storage Model
    18:05
    Quiz Time
    10 questions
    Section 4: Exploring DB2 Tools
    First Steps - creating our first database
    07:29
    Control Center
    08:15
    Command Window
    07:10
    Command Line Processor (CLP)
    05:29
    CLP - Running Scripts in DB2
    08:31
    CLP - Obtaining Help Information
    05:16
    Command Line Processor Plus (CLP Plus)
    07:49
    Command Editor
    14:43
    Configuration Assistant - Connecting to Remote Databases
    18:14
    Journal
    07:22
    Task Center
    08:33
    Activity Monitor
    11:57
    Event Analyser
    09:20
    Health Center
    07:50
    DB2 Data Server Clients
    11:57
    Other Tools
    06:34
    Quiz Time
    9 questions
    Section 5: Working with DB2 Database Objects - Part 1 - Tables & Views
    Section Overview
    01:31
    Definitions & Classification of Tables
    17:19
    Create Table statements
    10:26
    Tables with Identity Columns
    08:52
    Unique Constraints
    06:18
    Referential Integrity Constraints - Part I
    09:44
    Referential Integrity Constraints - Part II
    09:50
    Check Contraints
    08:51
    Alter & Drop Table statements
    09:56
    Materialized Query Tables (MQTs)
    06:18
    Quiz Time
    20 questions
    Section 6: Working with DB2 Database Objects - Part 2 - Views
    Views - Introduction & Create View statement
    04:28
    DML operations on Views
    05:35
    Creating view(s) from multiple tables
    03:50
    Creating Views with Local Check Option
    08:08
    Creating views with Cascaded Check Options
    04:09
    More on Views
    09:13
    Quiz Time
    5 questions
    Section 7: Working with DB2 Database Objects - Part 3 - Other Objects
    Aliases
    01:53
    Indexes - Concept
    11:08
    Indexes - Demo
    Preview
    07:45
    Schemas - Concept
    07:23
    Schemas - Demo
    09:19
    Triggers - Concept
    09:48
    Triggers - Demo
    12:14
    Sequences - Concept
    09:30
    Sequences - Demo
    08:38
    Buffer Pools - Concept & Demo
    09:43
    Tablespaces - Concept
    09:52
    Tablespaces - Demo
    19:30
    Quiz Time
    12 questions
    Exercise 1 - Working with Database Objects
    12 pages
    Section 8: DATA Types in DB2
    Data Types - Classification
    05:27
    Numeric data types
    11:13
    String data types
    11:49
    CLOB & DBCLOB data types
    06:41
    BLOB - Inserting Images in Tables
    05:51
    Date, Time & Timestamp - Part 1
    Preview
    06:59
    Date, Time & Timestamp - Part 2
    02:53
    XML data type
    06:04
    Section 9: Querying DB2 Data - SELECT Statement & Clauses
    SELECT statement - clauses
    01:51
    Retrieving Specific Columns
    03:24
    ORDER BY clause
    03:17
    GROUP BY clause
    05:43
    GROUP BY ... HAVING clause
    01:37
    FETCH FIRST n ROWS ONLY clause
    01:14
    DISTINCT clause
    03:51
    Working with NULL values
    02:45
    Sub-Queries or Inner Queries
    08:16
    Exercise 2 - Working with Sub-Queries or Inner-Queries
    7 pages
    Section 10: Limiting Data - WHERE clause
    Comparison Operators
    03:47
    AND / OR predicate
    05:11
    BETWEEN & NOT BETWEEN predicate
    03:53
    IN & NOT IN predicate
    02:28

    Students Who Viewed This Course Also Viewed

    • Loading
    • Loading
    • Loading

    Instructor Biography

    Mohammad Adnan Khan, IBM Certified DB2 Specialist & Consultant

    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.

    Ready to start learning?
    Take This Course