Školení a konzultace
Úvod
Školení
Novinky
Kontakt
Eshop
Š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.
Nabídka školení
SQL Server
Oracle
DB2 UDB
MySQL
C#, ASP.NET, C++, VB.NET, CodeGear, Crystal Reports
SharePoint
PostgreSQL
Security, hacking
Windows Server