DB2 Tech Talk: SQL Tips and Techniques, Leverage the Power of SQL

Presented by

Nick Ivanov (presenter), Rick Swagerman (host)

About this talk

SQL is a powerful language that you will learn to use to a greater extent in this talk! Join us to explore some of the less well-known features of SQL and see how they can help in some practical situations. We will also look at some common mistakes and misconceptions and discuss ways of avoiding them. Among the topics: - tricks with date and time values - use of common table expression and recursive queries - use of data change tables - use of nested tables - use of the MERGE statement - and more. Nick Ivanov is presenting this talk based on his consulting experience with many customers to maximize use of IBM DB2 and other products; move applications to DB2; and tune database and query performance.

Related topics:

More from this channel

Upcoming talks (0)
On-demand talks (59)
Subscribers (9935)
This one-stop webcast channel makes it fast and easy to build and extend your technical skills on the IBM DB2 product family. IDUG has joined forces with IBM to bring together a wide array of learning sessions on technical product features, related products, new product developments and more.