||Oracle ACE Director Daniel Morgan has more than 25 years of experience working with Oracle products. Daniel wrote the Oracle curriculum for the University of Washington, was the program's primary instructor for 10 years, and is the Morgan behind the MorgansLibrary.org website. Daniel, Principal Advisor at Forsythe Meta7, began his IT career in the early 1970s with Fortran IV on mainframes, spent more than a decade writing COBOL, and moved into relational databases in the 1980s, focusing primarily on the Oracle database. He brings to each engagement a wide range of industry experience, including high technology companies and ecommerce, telecommunications, finance, aerospace, biomedical, hospitality, retail, energy, manufacturing and distribution, travel and entertainment, and public sector. In addition to his work at the University of Washington, Daniel's academic credentials include teaching Oracle at Harvard University, guest lecturing at the University of Oslo (Norway) and University of Canterbury (New Zealand), and serving as an advisor to the outreach program at the University of California, Berkeley. Daniel's core competency is core database. He began his Oracle career coding SQL and PL/SQL, after almost a decade moved into the development and operations DBA role, and over the years expanded his focus to include servers, storage, networking, and their relationship to both stable architecture and Root Cause Analysis. Daniel has worked and lectured in North America, Latin America, EMEA, and APAC.
Everyone who has written SQL for more than a few weeks thinks they have mastered basic DML statements such as Insert, Update, and Delete: Unfortunately, this is not true. Most of the syntax elements available for these basic statements are not only unknown to developers, but are also unknown to DBAs with a decade or more of experience. This presentation will focus on optimizing DML by learning more about these capabilities. Using a laptop computer with a few GBs of RAM and a slow hard drive, it is possible to easily manage 500,000 inserts per second by taking advantage of documented DML techniques rarely used because they are little known. This presentation will expose the full range of available DML statements and how they can be used to optimize Oracle SQL.