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