Writing SQL with Examples on DB2 10.5 System Views and Table Functions

Presented by Ember Crooks, Xtivia

Some DBAs write SQL every day and others not as much. Come and learn the basics of writing SQL along with a few tips on more advanced features of SQL. Examples will use system views and table functions available in DB2 10.5. This video is geared towards DBAs who don’t write SQL on a regular basis and anyone who wants to take a basic look at writing SQL

1) Understand the SELECT list
2) Explore the variety of joins, and best practices for clear join syntax
3) Using subselects, both correlated and non-correlated
4) Understanding the GROUP BY clause and aggregate functions
5) A few more advanced concepts, including common table expressions and the MERGE statement

Ember Crooks is a DB2 UDB DBA Team Lead at Xtivia (www.xtivia.com). She is responsible for the design, build, and support of a wide range of DB2 databases for multiple clients. Ember has 13 years of experience with DB2 on Linux, Unix, and Windows platforms. She is the founder and principal author of the popular db2commerce.com technical blog where she educates others through example and case study. Ember is an IBM Gold Consultant and IBM Champion in Information Management.