Brief Introduction
Execute SQL Queries on an IBM DB2 Database ServerDescription
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
Bluelime Learning Solutions
4.3 Raiting
SQL Tutorial: Learn SQL with MySQL Database -Beginner2Expert
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Learn SQL and Database Development to work effectively in DBMS like MySQL, SQL Server, Oracle, PostgreSQL, DB2 etc. SQL Tutorial: Learn SQL with MySQL Database -Beginner2Expert...
DB2 For Beginners
- 4.3
-
![]()
![]()
![]()
![]()
![]()
Execute SQL Queries on an IBM DB2 Database Server IBM Db2 is a family of related data management products, including relational database servers, developed and marketed by IBM....
Db2 LUW - Database Administration & Certification Workshop
- 4
-
![]()
![]()
![]()
![]()
![]()
A complete beginner course on becoming a highly paid Db2 Professional. Get loaded, Get Certified, Get Hired! Course upgraded to DB2 10....
MySQL MariaDB From Scratch - Become an App Developer in 2020
- 4.4
-
![]()
![]()
![]()
![]()
![]()
The Ultimate MySQL MariaDB Beginner Course with EXAMPLES and PROJECT that will take you towards becoming an SQL Master The Ultimate MySQL MariaDB Beginner Course...
