Solutions Hero Image


IBM Cognos Analytics: Understanding and Applying SQL

Course Description:

This basic course is for everyone needing to write, support, or understand SQL queries. This includes but is not limited to end-users, programmers, application designers, database administrators, and system administrators who do not yet have knowledge of the SQL Data Manipulation Language for IBM Cognos Analytics.

Recommended Audience: 

Multi-role (consumers, business authors, professional authors, developers, administrators, modelers, project managers) 

Course Outline:

• Introduction to SQL 
• Simple SQL Queries
• Retrieving Data from Multiple Tables
• Scalar Functions and Arithmetic
• Column Functions and Grouping
• Insert, update, and delete rows
• Union and union all
• Using Subqueries
• Maintaining data
• Interaction with applications
• Additional report-building techniques


• An understanding of your organization’s business reporting needs
• Basic database knowledge and/or understanding


• This curriculum is based on the most recent version of IBM Cognos Analytics (v11.x)
• All our instructors are IBM Cognos Analytics certified
• Our training courses are aimed at self-study
• Database skills are not required
• CPE credits available upon completion

The Bottom Line:

Our SQL and IBM Cognos Analytics consultants can create a more valuable, tailored training experience to work for any environment, by functional area, and/or data source(s), including, but not limited to the ILT tutorials and exercises. Contact our training team below to learn more:

Contact Us

This site uses cookies to customize your experience and collect metrics. If you decline, these cookies will be disabled & removed. To find out more, read our privacy policy. Cookies are currently enabled.
This website requires javascript. Please enable it or visit to find a modern browser.