Learn about Aggregate Processing in SQL Fundamentals for DB2
- 13 years ago
http://www.gogotraining.com, 1-877-546-4446
This video discusses:
• Column functions
• The GROUP BY clause
• The HAVING clause
• Workshop: Column functions and grouping
This video is part of the SQL Fundamentals for DB2 course which is designed for the database professional who wants to get more "bang for the buck" out of DB2. This DB2 course presents basic and intermediate SQL syntax in an easy-to-understand format, demystifying even some of the more complex features. It will enable you to return to work much better prepared to avail yourself of the power of the DB2 engine.
Course Prerequisites:
There are no DB2 or SQL specific prerequisites for this course. However, any prior experience with DB2 or other relational database management systems should prove valuable.
Proficiency with Windows, Notepad (or another Windows-based text editor), the mouse, and the PC in general is assumed. For a Linux/UNIX audience, familiarity with equivalent tools and concepts is assumed.
Course Objectives:
As a result of taking this DB2 online training course, you will be able to:
• Use relational database concepts and terminology fluently, particularly that of the DB2 family of database management systems
• Identify the various types and components of Structured Query Language (SQL)
• Code simple to complex SELECT, INSERT, UPDATE, and DELETE statements
• Distinguish between DB2's various built-in data types and use scalar functions to transform data types
• Code simple inner join statements and understand the concepts of an outer join
• Perform aggregate processing with column functions and the GROUP BY and HAVING clauses
• Distinguish between and code both correlated and non-correlated sub-queries
• Combine result sets with the UNION and UNION ALL set operators and understand the related concepts of intersection and difference
• Code CASE expressions and outer joins as appropriate alternatives to UNION ALL
http://www.gogotraining.com, 1-877-546-4446
This video discusses:
• Column functions
• The GROUP BY clause
• The HAVING clause
• Workshop: Column functions and grouping
This video is part of the SQL Fundamentals for DB2 course which is designed for the database professional who wants to get more "bang for the buck" out of DB2. This DB2 course presents basic and intermediate SQL syntax in an easy-to-understand format, demystifying even some of the more complex features. It will enable you to return to work much better prepared to avail yourself of the power of the DB2 engine.
Course Prerequisites:
There are no DB2 or SQL specific prerequisites for this course. However, any prior experience with DB2 or other relational database management systems should prove valuable.
Proficiency with Windows, Notepad (or another Windows-based text editor), the mouse, and the PC in general is assumed. For a Linux/UNIX audience, familiarity with equivalent tools and concepts is assumed.
Course Objectives:
As a result of taking this DB2 online training course, you will be able to:
• Use relational database concepts and terminology fluently, particularly that of the DB2 family of database management systems
• Identify the various types and components of Structured Query Language (SQL)
• Code simple to complex SELECT, INSERT, UPDATE, and DELETE statements
• Distinguish between DB2's various built-in data types and use scalar functions to transform data types
• Code simple inner join statements and understand the concepts of an outer join
• Perform aggregate processing with column functions and the GROUP BY and HAVING clauses
• Distinguish between and code both correlated and non-correlated sub-queries
• Combine result sets with the UNION and UNION ALL set operators and understand the related concepts of intersection and difference
• Code CASE expressions and outer joins as appropriate alternatives to UNION ALL
http://www.gogotraining.com, 1-877-546-4446