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