View Printable Version

E15 - SQL Fundamentals: Writing SQL with Examples on 11.1 System Views and Table Functions

Session Number: 5059
Track: Application Development
Session Type: Podium Presentation
Primary Presenter: Ember Crooks [Xtivia]
Time: May 03, 2018 (08:00 AM - 09:00 AM)
Room: Congress B

Session Code: E15
Speaker Bio: Ember is a Db2 Lead DBA and Delivery Manager at XTIVIA. She is responsible for the design, build, and management of a wide range of Db2 databases for multiple clients. Ember has 16+ 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 herself and others through example and case study. Ember is an IBM Gold Consultant and IBM Champion in Information Management.
Audience experience level: Beginner
Presentation Category: Data Management
Presentation Platform: DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to: Database Administrators
Technical areas this presentation will apply to: SQL and XML Features
Objective 1: Understand the select list
Objective 2: Explore the variety of joins, and best practices for clear join syntax
Objective 3: Using subselects, both correlated and non-correlated

Objective 4: Understanding the group by clause and aggregate functions
Objective 5: A few more advanced concepts, including common table expressions and the merge statement

Abstract:  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 11.1. This session 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

For questions or concerns about your event registration, please contact support@idug.org