Will teach you end-to-end DB2 LUW DBA course. Contact me for more information
Contrast the DB2 Family of products
• Identify the DB2 Tools
• Functions of DB2 components
• Explore installation and parameters
Use the Command Line Processor
• Explore the GUI environment
• Describe the DAS role with GUI tools
Key features of an Instance
• Create and drop an Instance
• Use db2start and db2stop
• Distinguish b/w types of Config
• Describe and modify the Database Manager Configuration
Creating a Database
• Explore system Catalog tables, views
• Compare DMS Vs SMS table Spaces
• Database with Automatic Storage
• Differentiate between table spaces, containers, extents, and pages
• Define table spaces
• Get snapshot for table spaces
• Explore Database Config. Parameter.
List DB2 object hierarchy and physical directories & files
• Creating objects: Schema, Table, View, Alias, and Index
• Explore the use of table partitioning
• Review the use of Temporary Tables
• Implementation of Check Constraints, Referential Integrity and Triggers
• Exploring the use of Large Objects
ETC...
View this Course
Certified
You have 
