DB2 For Beginners

Execute SQL Queries on an IBM DB2 Database Server

Created by: Bluelime Learning Solutions
Making Learning Simple

What Will I Learn?

• Installing IBM DB2 Server
• Installing IBM Data Studio
• Basic Database Concepts
• Creating Database
• Creating Tables
• Inserting Records into Tables
• Reading data from a database
• Updating database records
• Deleting Records
• Truncating Table
• Dropping Table
• Sorting Data
• Filtering Data
• Excluding Duplicate Records
• Using LIKE Operator and WHERE clause
• Aggregate Functions

Requirements

• Basic knowledge of SQL
• Basic knowledge of Databases

Target audience

• Beginners to DB2