IBM DB2 Database SQL Fundamentals
This course provides students with the technical skills required to write SQL queries for IBM DB2 9.7 to 11.5. This course is the foundation for all DB2-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
On successful Completion of this course you will be able to:
Describe the basic architecture and concepts of IBM DB2
Understand the similarities and differences between SQL and other computer languages
Write SELECT queries
Query multiple tables
Sort and filter data
Describe the use of data types in DB2
Modify data using SQL
Use built-in functions
Group and aggregate data
Use subqueries
Use table expressions
Use set operators
Use window ranking, offset and aggregate functions
Implement pivoting and grouping sets
Execute stored procedures
Program with SQL
Implement error handling
Implement transactions
IBM DB2 Database SQL Fundamentals eLearning
Brand: Weblearning Publishing
Product Code: IBM DB2 Database SQL Fundamentals eLearning
Reward Points: 100
Availability: In Stock
£89.99
£59.99
Price in reward points: 1200
2 or more £54.99
3 or more £51.99
Related Products
Oracle Database SQL Workshop
This course is a combination of Oracle Database: SQL Workshop ..
£72.99 £89.99
Add to Cart
Oracle Database Design and Programming with SQL
This covers the Data Modelling and Database Devel..
£59.99 £79.99
Add to Cart
Oracle Database Design and Programming with SQL
This covers the Data Modelling and Database Devel..
£59.99 £79.99
Add to Cart
Oracle Database Design and Programming with SQL
This covers the Data Modelling and Database Devel..
£23.99 £29.99
Add to Cart
Oracle Database 12c Performance Management and Tuning
The Oracle Database 19c: Performance Manage..
£79.99 £99.99
Add to Cart
Oracle Database 12/19c Essentials Certified Implementation
The Oracle Database 12/19c Essentials ..
£169.99 £329.99
Add to Cart
Database Administration Unlimited Cloud Learning SubscriptionThe Database Administration Unlimited C..
£320.00 £355.00
Add to Cart
Oracle 23ai Data Warehousing Fundamentals
This course introduces students to the Oracle Database ..
£110.99 £129.99
Add to Cart
Oracle Database 23ai: SQL Workshop
This course is designed for Developers and Database Administra..
£84.99 £99.99
Add to Cart
Oracle Database 19c Data Warehousing Fundamentals
This course introduces students to the Oracle D..
£79.99 £99.99
Add to Cart
Oracle Database 19c Data Warehousing Fundamentals
This course introduces students to the Oracle D..
£79.99 £99.99
Add to Cart
Data Science Unlimited Cloud Learning SubscriptionThe Data Science Unlimited Cloud Learning Sub..
£310.00 £348.00
Add to Cart
AI & Machine Learning Unlimited Cloud Learning SubscriptionThe Machine Learning Unlimited C..
£310.00 £348.00
Add to Cart
Oracle Database 23ai: New Features for Developers
This course focuses on the latest advancements ..
£124.00 £149.99
Add to Cart
Tags:
Database Management ,
Oracle Database ,
DB2 ,
SQL ,
DBA