IBM DB2 Database Design & Development

This database training for beginners and advanced developers introduces and defines the terminology, concepts, and skills you need to understand database objects, security requirements, graphical tools, basic database administration, SQL scripts and writing database queries, in addition to executing stored procedures.

On successful Completion of this course you will be able to:

• Understand DB2 Terminology
• Describe the Basic Architecture and Concepts of IBM DB2
• Describe and work with DB2 Database Management Tools
• Install DB2 Data Studio
• Understand Data Modeling and Database Design
• State the purpose of a business model
• Identify an Entity-Relational Diagram (ERD) model
• List several DB2 column data types
• Identify non-standard column and table names
• Identify the characteristics of a primary key and a foreign key
• State the purpose of referential integrity
• State the purpose of triggers
• Write SELECT queries
• Query multiple tables
• Sort and filter data
• Describe the use of data types in DB2
• Modify data using SQL
• Use built-in functions
• Group and aggregate data
• Use subqueries
• Use table expressions
• Use set operators
• Use window ranking, offset and aggregate functions
• Implement pivoting and grouping sets