Enterprise Development
Know the basis of building an enterprise solution
Know the purpose of IBM's Application Framework for e-business
Be able to recognize enterprise level databases and n-tier architectures
Know ho wDB2 UDB fits in the enterprise
Know how Java fits in the enterprise
Know the logical architecture used
Know how to test the application
DB2 Universal Database
Differentiate between DB2 UDB Editions
Understand the components of DB2 UDB
Understand the main features of DB2 UDB
Work with the DB2 UDB tools and understand their functions
Differentiate between DB2 CLP and System Commands
DB2 and Windows NT
Create users in Windows NT and grant privileges/permissions
Be familiar with how DB2 UDB is installed in notebooks
Work with Instances/Database Manager
Understand the link between DB2 UDB and Windows NT
Manipulate the Windows NT operating system to work with DB2
Explore DB2's SAMPLE database through simple queries
Introduction to Database Design
Apply some techniques of RAD methodology
Apply some techniques of database design
Analyze and interpret a business narrative to determine a client's business
requirements
Data Modeling
Perform data modeling
Apply CASE methodology principles to data modeling
Normalize Data
Create Entity Relationship Diagrams (ERDs)
Create Logical Data Models
Differentiate among Conceptual, Logical, and Physical Data Models
Working with Structured Query Language (SQL)
Use the basic pars of SQL
Identify the objects that make up a database, and know how they interact
with one another
Identify several data types and know their uses
Explain the differences among rows, columns, tables, and views
Recognize the keywords SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER
BY
Know how to use the keywords AND, OR, IS NULL, LIKE, and BETWEEN in a
query
Build simple and complex queries, using single and multiple tables
Create joins and subqueries
Use the newly acquired SQL skill set to interact with databases
SQL Commands
Use CREATE TABLE, ALTER TABLE, DROP TABLE, and CREATE VIEW DDL commands
Understand naming conventions, keys, and constraints
Recognize the DML commands INSERT, UPDATE, and DELETE
Explain the difference between the Transaction Control commands COMMIT,
SAVEPOINT, and ROLLBACK
Know how to create triggers
Functions
Use built-in string, number, date, and time scalar functions
Use the CHAR conversion function
Use the scalar functions to perform date and time calculations
Use the TRANSLATE and CASE functions to perform complex queries
|
