DB2 Family Fundamentals

DB2 Family Fundamentals Course Description

Duration: 2.00 days (16 hours)

This Database Associate is an entry level DBA or a user of any of the DB2 family of products. This individual is knowledgeable about the fundamental concepts of DB2 9 through either hands on experience or formal and informal education. The database associate should have an in-depth knowledge of the basic to intermediate tasks required in day-to-day administration, basic SQL (Structured Query Language), understand how DB2 9 is packaged and installed, understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation.

Next Class Dates

Contact us to customize this class with your own dates, times and location. You can also call 1-888-563-8266 or chat live with a Learning Consultant.

Back to Top

This Course is also part of:

Back to Top

DB2 Family Fundamentals Course Outline

      1. Planning (14%)
        1. Knowledge of restricting data access
        2. Knowledge of the features or functions available in DB2 tools (just tools that come with product - distributed +space - i.e., control center, configuration advisor, configuration assistant, command line processor)
        3. Knowledge database workloads (OLTP vs warehousing)
        4. Knowledge of non-relational data concepts (extenders)
        5. Knowledge of XML data implications (non-shreading)
      2. Security (11%)
        1. Knowledge of DB2 products (client, server, etc.)
        2. Knowledge of different privileges and authorities
        3. Knowledge of encryption options (data and network)
        4. Given a DDL SQL statement, knowledge to identify results (grant/revoke/connect statements)
      3. Working with Databases and Database Objects (17%)
        1. Ability to identify and connect to DB2 servers and databases
        2. Ability to identify DB2 objects
        3. Knowledge of basic characteristics and properties of DB2 objects
        4. Given a DDL SQL statement, knowledge to identify results (ability to create objects)
      4. Working with DB2 Data using SQL (23.5%)
        1. Given a DML SQL statement, knowledge to identify results
        2. Ability to use SQL to SELECT data from tables
        3. Ability to use SQL to SORT or GROUP data
        4. Ability to use SQL to UPDATE, DELETE, or INSERT data
        5. Knowledge of transactions (i.e., commit/rollback and transaction boundaries)
        6. Ability to call a procedure or invoke a user defined function
        7. Given an XQuery statement, knowledge to identify results
      5. Working with DB2 Tables, Views and Indexes (23.5%)
        1. Ability to demonstrate usage of DB2 data types
        2. Given a situation, ability to create table
        3. Knowledge to identify when referential integrity should be used
        4. Knowledge to identify methods of data constraint
        5. Knowledge to identify characteristics of a table, view or index
        6. Knowledge to identify when triggers should be used
        7. Knowledge of schemas
        8. Knowledge of data type options for storing XML data
      6. Data Concurrency (11%)
        1. Knowledge to identify factors that influence locking
        2. Ability to list objects on which locks can be obtained
        3. Knowledge to identify characteristics of DB2 locks
        4. Given a situation, knowledge to identify the isolation levels that should be used

Back to Top

Do you have the right background for DB2 Family Fundamentals?

Skills Assessment

We ensure your success by asking all students to take a FREE Skill Assessment test. These short, instructor-written tests are an objective measure of your current skills that help us determine whether or not you will be able to meet your goals by attending this course at your current skill level. If we determine that you need additional preparation or training in order to gain the most value from this course, we will recommend cost-effective solutions that you can use to get ready for the course.

Our required skill-assessments ensure that:

  1. All students in the class are at a comparable skill level, so the class can run smoothly without beginners slowing down the class for everyone else.
  2. NetCom students enjoy one of the industry's highest success rates, and pass rates when a certification exam is involved.
  3. We stay committed to providing you real value. Again, your success is paramount; we will register you only if you have the skills to succeed.
This assessment is for your benefit and best taken without any preparation or reference materials, so your skills can be objectively measured.

Take your FREE Skill Assessment test »

Back to Top

Award winning, world-class Instructors

Our instructors are passionate at teaching and are experts in their respective fields. Our average NetCom instructor has many, many years of real-world experience and impart their priceless, valuable knowledge to our students every single day. See our world-class instructors.   See more instructors...

Back to Top

Client Testimonials & Reviews about their Learning Experience

We are passionate in delivering the best learning experience for our students and they are happy to share their learning experience with us.
Read what students had to say about their experience at NetCom.   Read student testimonials...

Back to Top