DB2 For Beginners

  • 4.3
2 hours on-demand video
$ 12.99

Brief Introduction

Execute SQL Queries on an IBM DB2 Database Server

Description

IBM Db2 is a family of related data management products,

including relational database servers, developed and marketed by IBM.

This course provides you the basic understanding of concepts of database, database installation and management.At the end of the course you should be equipped with some understanding of database management concepts.

In this course we will interact with the DB2 Server and run some SQL queries on the database. We will create a database and multiple tables and perform some data manipulation and CRUD operations on the database.


Topics include:

  • 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

  • Aggregate Functions

  • Sorting Data

  • Filtering Data

  • Excluding Duplicate Records

  • Using LIKE Operator and WHERE clause

Requirements

  • Requirements
  • Basic knowledge of SQL
  • Basic knowledge of Databases

Knowledge

  • 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
$ 12.99
English
Available now
2 hours on-demand video
Bluelime Learning Solutions
Udemy

Instructor

Share
Saved Course list
Cancel
Get Course Update
Computer Courses