Dallas-Ft Worth, TX
El Paso, TX
Kansas City, MO
Los Angeles, CA
This course is designed for the SQL professional who wants to get more "bang for the buck" out of DB2, especially DB2 Universal Database. A common complaint is that so much money is sunk into relational database management systems, only to have them end up as glorified flat-file processors due to inefficient SQL and misguided application design. Why select all the columns and all the rows only to have your application program (or third-party tool) do the filtering? Why select detail-level rows when what you want to see is summarized results? And what about all the new advanced features added to SQL on the DB2 Universal Database platforms?This course presents advanced SQL syntax in an easy-to-understand format, demystifying even the most complex of the new features. It enables the attendee to return to work much better prepared to avail him- or herself of the full power of the DB2 engine.
3 Days/Lecture & Lab
This course is designed for application programmers; database administrators, sophisticated end users, and anyone who needs to know more about the intricacies of SQL.
Before taking this course, you should be able to code basic to intermediate SQL statements and have real-world experience coding such statements. You can develop these skills by attending either Introduction to DB2 and SQL or DB2 and SQL Fundamentals. Proficiency with Windows, Notepad (or another Windows-based text editor), the mouse, and the PC in general is also assumed.
Last Update: May 22, 2013