IDUG CENTRAL PA RUG jUNE 6TH, 2013 - DB2 10 APPLICATION FEATURES & ADVANCED SQL - $165 - THEMIS iNC. - TONY ANDREWS

Event Details

IDUG CENTRAL PA RUG jUNE 6TH, 2013 - DB2 10 APPLICATION FEATURES & ADVANCED SQL -  $165 - THEMIS iNC. - TONY ANDREWS

Time: June 6, 2013 from 9am to 4:30pm
Location: Giant Super Food Store Community Rooms .
Street: 3301 Trindle Road
City/Town: Camphill, PA 17011
Phone: lori.galluzzo@hp.com
Event Type: central, pa, rug, brings, themis, inc., for, fee, based, class
Organized By: Lori Galluzzo
Latest Activity: May 20, 2013

Export to Outlook or iCal (.ics)

Event Description

   WHO :  DBA’s, Data Architects, DB2 Developers, DBA System Programmers – anyone that works with SQL or DB2 Tuning

   PRESENTER – TONY ANDREWS – Tony Andrews has more than 23 years’ experience in the development of IBM DB2 relational database applications. Most of this time, he has provided development and consulting services to Fortune 500 companies and government agencies. Tony has written literally thousands of queries and programs during his development years, and he has also served as a DB2 database analyst. For the past 10 years, Tony has been splitting his time between consulting engagements and training. His main focus is to teach today’s developers the ways of RDMS application design, development, and SQL programming— always with a special emphasis on improving performance.  Tony is a current IBM champion and regular lecturer at industry conferences and local user groups. You may have seen him present at such events as IDUG NA and EMEA, and many regional users groups. He is well known for his “Top 25+ Tuning Tips for Developers” presentation.

    COSTS : :$165.00 – payable check to Themis, Inc.  – Bring it the day of class (or day before at RUG meeting June 5th).  AM – 9-12:30   DB2 10  APPLICATION FEATURES - 

     This course introduces the attendee to the new SQL and application features of DB2V10 for z/OS.  It covers all the new SQL and Optimization features.  SQL Enhancements -Recap of OLAP Features, OLAP Moving Sum, Avg, Extended Null Indicators, Implicit Casting, New Timestamp Precisions. Currently Committed Processing, Hash Access Processing, SQL PL UDF Enhancements, Temporal Table.  V10 Optimization Features - Transitive Closure, Single Matching ‘OR’ Predicates, Cursor / Scrolling Feature, New ‘IN’ Lists. Safe Query Optimization, Index Include, Explain Package Feature  LUNCH -  12:30 – 1:00  PM – 1:00-4:30  ABSTRACT :    DB2 z/OS Advanced SQL – Working with Complex Queries  : Get ready to go deep with Structured Query Language (SQL) and become a power user. Whether you are being asked to solve complicated problems with SQL or you need to read and understand complex SQL that is already written, this session is for you! We’ll look at some of the features in the latest releases of DB2 that allow us to solve even more business and performance problems.

Agenda - •Review of Joins, Subqueries, Nested Table, Expressions, Common Table Expressions, •Quota Queries for Ranking and Top 10 List, •OLAP Ranking Functions, Solving Complex Problems with SQL. Evaluating Options
, Looking at multiple ways to get the same answer,-Looking at Intersect and Except for solutions, •Merge Statement – what did it do? . New SQL : Currently Committed, Skip Locked Data, Uncommitted Reads, Extended Null Indicators, Stored Procedures ‘With Return to client’, Select From Update, Insert, Delete 
SIGN – UP  by ASAP or by May 29th – EMAIL TO lori.galluzzo@hp.com  : $165 check payable to Themis, Inc. due the day of class. 

Comment Wall

Add a Comment

RSVP for IDUG CENTRAL PA RUG jUNE 6TH, 2013 - DB2 10 APPLICATION FEATURES & ADVANCED SQL - $165 - THEMIS iNC. - TONY ANDREWS to add comments!

Join The World of DB2

Attending (1)

Not Attending (1)

Latest Activity

William Shipley liked Surekha Parekh's blog post Live Db2 12 Client Panel 30th June 2021 - Sign Up today!
yesterday
A blog post by Surekha Parekh was featured
Tuesday
Daniel Luksetich posted a blog post
Monday
Gulfem Ogutgen liked Annette Zawacki's event Garanti-BBVA shares Db2 Analytics Accelerator migration and operational experiences
Monday
Gulfem Ogutgen liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Monday
edmundo nascimento liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Monday
Michael Tiefenbacher posted an event
Thumbnail

30. DeDUG User Group Meeting at virtual

September 24, 2021 from 9am to 1:30pm
Monday
Earl Dugan posted an event

Virtual New England DB2 User's Group Thursday, June 24th, 2021. at Virtual Meeting

June 24, 2021 from 9am to 12pm
Monday
Willy Unger liked Annette Zawacki's event Garanti-BBVA shares Db2 Analytics Accelerator migration and operational experiences
Saturday
carol goldberg liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Jun 17
Adrian Collett liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Jun 17
ONLO posted a discussion
Jun 16
GABRIEL FAJARDO liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Jun 15
Pedro Diaz liked Surekha Parekh's event Interactive Db2 12 Client Panel with John Campbell IBM DE
Jun 14
An event by Surekha Parekh was featured
Thumbnail

Interactive Db2 12 Client Panel with John Campbell IBM DE at https://ibm.biz/Db212ClientPanel

June 29, 2021 from 11am to 12:30pm
Jun 14
Carol Davis-Mann posted a blog post
Jun 11

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

Forum

ADM10501W - Health indicator "Database Automatic Storage Utilization"

Started by ONLO in Application Development and DB2 Jun 16. 0 Replies

AIX Version 6.1DB2 10.5.6Hi every body,I got the above error:MESSAGE : ADM10501W Health indicator "Database Automatic Storage Utilization" ("db.auto_storage_util") breached the "upper" warning threshold of "80 %" with value "88 %" on "database"…Continue

DB2 Future

Started by Peter E Saxe in Application Development and DB2 May 20. 0 Replies

Has anyone ever submitted ideas of new functions in DBMS software like DB2?   have an idea for a future enhancement to DB2 that I would like to see.  Is this discussion area a good place to discuss this ?  Thanks.Continue

Tags: Enhancements, Future, DB2

© 2021   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service