PRIVATE GROUP FEE:
$ Based upon a class size of six students.
Scheduling can be adjusted to employee work hours and incorporate client assignments.
SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.
CONTENT AND OBJECTIVES:
Become familiar with the features and concepts of Db2 and SQL.
Learn the characteristics of a relational model and a RDMS.
Structured Query Language
Utilize DB2I/SPUFI or Db2 Control Panel to run queries.
Execute simple queries from sample tables.
Understand and utilize multiple table queries.
Execute queries which perform an inner join.
Execute simple data modification DML and DDL statements.
Utilities and Commands
Examine the characteristics of a relational model and RDMS.
Gather statistics, determine SQL execution attributes, and load and unload data.
Db2 Security and Integrity
Examine the attributes serving as the foundation of security and integrity in Db2.
Example sample control cards.
Review a scenario for locks and data integrity.
Db2 Releases and Related Products
Become familiar with the current releases of Db2 and related software.
Physical Design and Efficiency Techniques
Examine the concepts and features serving as the foundation for physical design and an efficient implementation.
Given a basic system design for a funds transfer system, perform the physical design for an online real-time system.
Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.
Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.
SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.