RSS
Select Language


Course DB2 - TSQL


Duration (days): 4
Price (CZK): 16000

DB2 - TSQL topics:



    DB2 concepts
  • Identify DB2 family products
  • Explain DB2 workstation component functions
  • Identify DB2 objects
  • Identify the key differences between static SQL and other application alternatives for accessing DB2 data

    • Program structure I
  • Embed INSERT, UPDATE, DELETE and single-row SELECT statements in application programs
  • Effectively communicate with DB2 when processing NULL values and determining the success of statement execution
  • Demonstrate use of DB2 coding aids
  • Code CONNECT statements within an application program
  • Identify connection types and impacts on a unit of work

    • Program preparation
  • Identify the additional steps necessary to prepare a program that contains embedded SQL for execution
  • Describe the functions of the DB2 PRECOMPILE and BIND processes
  • Describe factors relevant to the BIND process, including RUNSTATS positioning, package status, parameters, and authorization requirements

    • Program structure II
  • Use DECLARE, OPEN, FETCH, and CLOSE CURSOR statements to handle select criteria that may return multiple rows in application programs
  • Issue positioned UPDATE and DELETE statements
  • Use compound SQL

    • Recovery and locking concepts
  • Define a unit of recovery
  • Identify the basic locking strategies used by DB2

    • Dynamic SQL introduction
  • Describe the difference between static and dynamic SQL
  • List the types of dynamic statements
  • Code dynamic SQL in a program

    • Managing test data
  • Identify methods to insert data into a table
  • Use the LOAD or IMPORT utility
  • Identify the purpose of the RUNSTATS utility
  • Identify the purpose of the REORG utility

    • Performance considerations
  • Use programming techniques that enhance DB2 application performance by following general guidelines, using indexable predicates, and avoiding unnecessary sorts
  • Identify the access paths available to DB2
  • List common causes of deadlocks and avoid such causes when possible
  • Use the EXPLAIN tools as aids to develop applications that emphasize performance

    • Stored procedures
  • Describe when the use of stored procedures is appropriate
  • Describe DB2s implementation of stored procedures
  • List the characteristics and specification requirements of the client application and the server procedure
  • Describe the communication structures used with stored procedures
  • Write stored procedures

    • Using object-relational capabilities
  • Describe and use programming options for handling large objects
  • Describe why a user-defined type may be used
  • Identify how to define a user-defined type
  • Describe why a user-defined function may be used
  • Identify how to register a user-defined function
  • Identify how a user-defined function is invoked
  • Determine which user-defined function will be invoked based on name, function path, and parameter types
  • Write a user-defined function

Nevyhovuje Vám osnova ?All course schedules I will make suitable according your individual requirements.
If course topics are not suitable for you then contact me contact and we will come to topics meet your individual bussiness needs