Technical library

  • spacer Filter by products, topics, and types of content

    (115 Products)

    (113 Topics)

    (15 Industries)

    (15 Types)

 

1 - 6 of 6 results Show Summaries | Hide Summaries Subscribe to search results (RSS)

View Results
Title up Type none Date none
DB2 10.1 fundamentals certification exam 610 prep, Part 2: DB2 security
This tutorial introduces authentication, authorization, privileges, and roles as they relate to IBM DB2 10.1. It also introduces granular access control and trusted contexts. This is the second in a series of six tutorials designed to help you prepare for the DB2 10.1 Fundamentals certification exam (610). It is assumed that you already have basic knowledge of database concepts and operating system security.
Articles 05 Jun 2014
DB2 10.1 fundamentals certification exam 610 prep, Part 3: Working with databases and database objects
This tutorial shows you the basic steps and requirements to create and connect to a database in DB2 10.1. Also, this tutorial introduces you to the objects that make up a DB2 database as well as how to create and manipulate them. This tutorial prepares you for Part 3 of the DB2 10.1 fundamentals certification exam 610.
Also available in: Chinese  
Tutorial 18 Oct 2012
DB2 10.1 fundamentals certification exam 610 prep, Part 1: Planning
This tutorial introduces you to the basics of the DB2 10.1 product editions, functionalities and tools, along with underlying concepts that describe different types of data applications such as OLTP, data warehousing / OLAP, non-relational concepts and more. It will briefly introduce you to many of the concepts you’ll see in the other tutorials in this series, helping you to prepare for the DB2 10.1 Fundamentals certification test 610.
Also available in: Chinese  
Tutorial 18 Oct 2012
DB2 10.1 fundamentals certification exam 610 prep, Part 4: Working with DB2 Data using SQL
This tutorial shows you how to use SQL statements such as SELECT, INSERT, UPDATE, DELETE, and MERGE to manage data in tables of a SAMPLE database. It also shows how to perform transactions by using the COMMIT, ROLLBACK, and SAVEPOINT statements, how to create stored procedures and user-defined functions, and how to use temporal tables. This is the fourth tutorial in the DB2 10.1 fundamentals certification exam 610 prep series of total six tutorials.
Articles 16 Jan 2014
DB2 10.1 fundamentals certification exam 610 prep, Part 6: Data concurrency
This tutorial is designed to introduce you to the concept of data consistency and to the mechanisms DB2uses to maintain data consistency in both single- and multi-user database environments. This tutorial will also help you prepare for Section 6 of the DB2 10.1 Fundamentals certification exam (Exam 610).
Also available in: Chinese   Portuguese  
Tutorial 30 Aug 2012
DB2 10.1 Fundamentals certification exam 610 prep: Part 5: Working with tables, views, and indexes
This tutorial discusses IBM DB2 10.1 support for data types, tables, views, triggers, constraints and indexes. It explains the features of these objects, how to create and manipulate them using Structured Query Language (SQL), and how they can be used in an application. This tutorial is the fifth in a series that you can use to help prepare for the DB2 10.1 Fundamentals certification exam 610.
Also available in: Chinese  
Tutorial 25 Oct 2012

1 - 6 of 6 results Show Summaries | Hide Summaries Subscribe to search results (RSS)