IBM DB2 Database Fundamentals

The IBM DB2 Database Fundamentals course provides step-by-step instructions on how to perform a variety of basic development and administrative tasks for activities based on real-life work scenarios. This database training for beginners 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 Instance Architecture
• Describe Database Architecture
• Describe and work with DB2 Database Management Tools
• Understand Data Modeling and Database Design
• State the purpose of a business model
• Identify an Entity-Relational Diagram (ERD) model
• State the purpose of referential integrity
• Creating Databases and Database Objects
• Using DML Statements - Using SELECT, INSERT, UPDATE and DELETE Statements
• Using Data Control Language
• Commit and Rolling Back Transactions
• Configuring Permissions on Database Objects
• DB2 Administration Fundamentals
• Understanding DB2 Security