DB2 for i Advanced SQL workshop

DB2 for i Center of Excellence - Rochester, MN


Learn how to use advanced SQL features and syntax that can be leveraged from any programming language that supports SQL. Learn about advanced SQL DDL (Data Definition Language) features such as identity columns and constraints that enable data-centric programming. Learn how to take your SQL reports and query definitions to the next level with views, common table expressions, and OLAP specifications. Learn how to use SQL procedurally with user-defined functions, triggers, and advanced stored procedures.

This workshop provides lectures and hands on labs in a face-to-face classroom setting. The labs exclusively use the IBM i Navigator graphical interface.

Test drive videos

Skills taught

Audience and prerequisites

This advanced workshop is for experienced IBM i (including iSeries and AS/400e) programmers who design and write applications that use SQL to access the database.
You should complete the following courses (or have the equivalent skills taught in these courses):


North America Schedule

Outside of North America Schedule

Interested in future scheduling or a custom onsite workshop, contact IBM Systems Lab Services and Training.

Contact an IBM Sales Specialist

Next generation applications for big data and analytics and cognitive computing are providing unprecedented insights into opportunities, threats and efficiencies. IBM Power Systems is at the forefront of delivering solutions to gain faster insights from analyzing both structured information and unstructured big data. With the secure, flexible and open platform of IBM Power Systems plus solutions and software, organizations can outpace their competitors by delivering faster services, providing differentiated offerings and turning operational cost into investment opportunity.

To draw insights and make better decisions, businesses rely on the secure, flexible and open platform of IBM Power Systems. Built with the first processor designed for big data workloads, the design of Power Systems combines the computing power, memory bandwidth and I/O in ways that are easier to consume and manage, building on strong resiliency, availability and security.

IBM Power Systems deliver flexibility and choice of operating systems to enable your business to support the next generation applications for big data and analytics and cognitive computing that are transforming how organizations work today. Whether running 1, 2, or all 3 - coupled with PowerVM, they maximize the benefit of Power Systems in your business.

Transform your business with Systems Software that enables virtualization, high availability, flexibility, security and compliance on Power Systems™. IBM’s integrated approach to developing Systems and Systems Software together delivers optimized results with Power Systems.

As an open innovation platform, Power Systems is optimized for big data and analytics performance and to deliver scale-out economics and security for the cloud. IBM and IBM Business Partner solutions exploit key capabilities in IBM Power Systems.

Over the last five years thousands of clients have migrated to IBM Power Systems for choice and flexibility. Learn how Power Systems has helped them revolutionise the way IT is developed and delivered, optimise for big data and analytics, and support private, public and hybrid offerings for scale-out or scale-up implementations all while improving business performance, reducing risk, and establishing a platform for growth.

Additional information