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 CBT
- Brand: Weblearning Publishing
- Product Code: IBM DB2 Database SQL Fundamentals CBT
- 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
Oracle Database SQL Workshop This course is a combination of Oracle Database: SQL Workshop ..
£72.99 £89.99
Oracle Database Design and Programming with SQL CBT
Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..
£59.99 £79.99
Oracle Database Design and Programming with SQL eLearning
Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..
£59.99 £79.99
Oracle Database Design and Programming with SQL Training Guide
Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..
£23.99 £29.99
Oracle Database 12c Performance Management and Tuning
Oracle Database 12c Performance Management and Tuning The Oracle Database 19c: Performance Manage..
£79.99 £99.99
Oracle Database 12/19c Essentials Certified Implementation
Oracle Database 12/19c Essentials Certified Implementation The Oracle Database 12/19c Essentials ..
£169.99 £329.99
Database Administration Unlimited
Database Administration Unlimited Cloud Learning SubscriptionThe Database Administration Unlimited C..
£320.00 £355.00
Oracle Database 23ai Data Warehousing Fundamentals
Oracle 23ai Data Warehousing Fundamentals This course introduces students to the Oracle Database ..
£110.99 £129.99
Oracle Database 23ai SQL Workshop
Oracle Database 23ai: SQL Workshop This course is designed for Developers and Database Administra..
£84.99 £99.99
Oracle Database 19c Data Warehousing Fundamentals CBT
Oracle Database 19c Data Warehousing Fundamentals This course introduces students to the Oracle D..
£79.99 £99.99
Oracle Database 19c Data Warehousing Fundamentals eLearning
Oracle Database 19c Data Warehousing Fundamentals This course introduces students to the Oracle D..
£79.99 £99.99
Data Science Unlimited
Data Science Unlimited Cloud Learning SubscriptionThe Data Science Unlimited Cloud Learning Sub..
£310.00 £348.00
AI & Machine Learning Unlimited
AI & Machine Learning Unlimited Cloud Learning SubscriptionThe Machine Learning Unlimited C..
£310.00 £348.00
Big Data Unlimited
Big Data Unlimited Cloud Learning SubscriptionThe Big Data Unlimited Cloud Learning Subsc..
£365.00 £399.00
Big Data & Data Science VM Training Appliance
Big Data & Data Science VM Training ApplianceThis Big Data & Data Science VM Training Applia..
£249.00 £279.00
Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171
Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171 This course introduces stude..
£124.00 £149.99
Tags: Database Management, Oracle Database, DB2, SQL, DBA