MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch

Genre: eLearning | Language: English + .srt | Duration: 25 lectures (1h 59m) | Size: 459.4 MB

Execute SQL Queries on an IBM DB2 Database Server

Execute SQL Queries on an IBM DB2 Database Server

What you'll 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

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

Who this course is for

Beginners to DB2