| Presentation Title: | Advanced SQL Features |
| Speaker: | Mr Daniel Fink |
| Company: | OptimalDBA |
| Co-presenter: | |
| Presentation abstract: | At the core of any database application are SQL statements. They can be simple select from queries to very complex (and long) statements. In recent releases, Oracle has added new functions and features that enable developers and users to write powerful statements in SQL that used to require PL/SQL or external tools. This session will cover advanced SQL topics, including analytical functions, the modeling clause, regular expressions and ansi standard joins. We will cover the theory and implementation of these features and how they can be used to decrease the complexity of a statement. |
| Presentation begins: | 05/12/2008 12:15 |
| Presentation duration: | 120 |
| Presentation content level: | 2 (1 = indepth, 5 = strategic overview) |
| Audience experience: | Experienced (2-3 years) |
| Audience function: | Analysts, DBA's, Developers, End Users |
| Speaker biography: | Daniel Fink is an independent consultant specializing in Oracle performance diagnosis and optimization, monitoring, training and data recovery. He has been in IT for over 17 years, first as a Cobol programmer on the Vax VMS platform. In 1995, he transitioned to Oracle, first as a developer, then dba...on DEC Alpha OpenVMS and Oracle Parallel Server 7.0.13. He has been both a development and production dba (often at the same time). For the past 5 years, Daniel has focused on Oracle performance diagnosis and optimization. He has been a member of the Oak Table Network (www.oaktable.net) since 2004. |
| Related topics: | Design and Development Engineering: Designing and Development Applications with Oracle Tools |
| Hall: | 10b |
