Školení DB2 programování

Délka: 4 dny
Cena: 16000 Kč

Kurz DB2 UDB programování osnova

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

Termíny všech kurzů přizpůsobím Vašim individuálním požadavkům.
Pokud Vám nebude vyhovovat osnova nebo délka daného kurzu, kontaktujte mě kontakt a domluvíme se na osnově, která bude zohledňovat Vaše požadavky.