Application Development on Oracle Database: A Year-long CodeTalk Series

    Sponsored by ODTUG and IOUG, provided by Oracle Developer Advocates

    Oracle Database is the most powerful, flexible relational database in the world, but it’s way more than “just” a database. Packed into Oracle Database are features designed to make it easier for developers (whether writing in PL/SQL or JavaScript) to build highly secure, high performance, maintainable applications. Oracle Developer Advocates has a mission to make the user community more aware of all these features and how best to use them.

    This webcast series will feature presentations followed by discussions with a featured user of the relevant technology.

    2017 Sessions:

    2017 CodeTalk Series: Get Your Money's Worth Out of Your Database
    March 30, 2017, 11:00am - 12:00pm CT 

    The 2017 CodeTalk Series Webinars are Co-sponsored by ODTUG and IOUG. 

    Stop treating your database as a bit bucket and start using the advanced features available in the database. If you use the database to its full extent, you will not only see an increase in performance of your application, but also an increase of the productivity of the developers.

    The database is one of the most important assets to your application. It is also one of the most expensive parts in your application. Most organizations don’t get the most out of their database license and treat it like a simple bit bucket. The modern Oracle database can do so much more than just store data. Features you can use ‘in the database’ include:

    • Flashback queries (what did my data look like at a certain moment in time)
    • Data Security (only read and write data you are authorized for)
    • Identity columns (12c)
    • Invisible columns (12c)

    And many more, of which Chris and Patrick will cover as many as they can.

    Featured Speakers:

    • Chris Saxon, Oracle Corporation
    • Patrick Barel, AMIS

    | Register Today |

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 

    2017 CodeTalk Series: Modern ETL with Node.js and Oracle Database, D. McGhan, Oracle Corporation and "Soyuka," F.G.R. DS-RESTA
    April 13, 2017, 1:00pm - 2:00pm CT 

    The 2017 CodeTalk Series Webinars are Co-sponsored by ODTUG and IOUG. 

    In this CodeTalk, Dan McGhan will interview Soyuka, a software engineer and lead developer at F.G.R. DS-RESTAURATION. Soyuka will show how to build a modern, maintainable, real-time ETL. From asynchronous database polling to data extraction based on streams, we will study a real-life use-case with Oracle Database and Node.js. With the help of a well-known process manager, we will see how we can combine micro services to do so. 

    Featured Speakers: 

    • Dan McGhan, Oracle Corporation
    • Soyuka, Software engineer and Lead Developer, F.G.R. DS-RESTAURATION. 

    | Register Today |

    Past Sessions

    View the On-Demand Recordings

    2017 CodeTalk Series: The PL/SQL Ninja: PL/SQL Can Do WHAT? 
    February 16, 2017, 3:00 pm - 4:00 pm CT

    How do we make PL/SQL as easy and fun to develop in as Node/Ruby/Python/[flavor of the day]? What are the things that make a language “cool” to build stuff in? Apart from being hip or used by Facebook/Google/Apple, what is the core functionality that should be available in any language and what are the core parts of the ecosystem around a language that makes it easier to pick up and start building? Looking at PL/SQL, what are the must-know packages that will get you started doing fun, useful libraries or applications? 

    In this CodeTalk session, Steven Feuerstein interviews Morten Egan, aka the PL/SQL Ninja, who has been asking himself – and then answering via code – these very questions. We’ll take a look at some of the utilities and libraries he has built for and to see what is possible and discover the sources of Morten’s inspiration and creativity. And time permitting, he’ll demonstrate with some “live” coding as well! 

    Featured Speakers:

    • Steven Feuerstein
    • Morten Egan


     Security Issues for Developers

    Join Steven Feuerstein, Architect at Oracle Corporation, and Rob Lockard, database security expert and winner of a 2015 Oracle Database Developer Choice award, as they discuss the top security issues facing Oracle developers today and how they can harden their applications against attack. This session will feature their conversation from COLLABORATE 16, followed by a live Q&A session.Join Steven Feuerstein, Architect at Oracle Corporation, and Rob Lockard, database security expert and winner of a 2015 Oracle Database Developer Choice award, as they discuss the top security issues facing Oracle developers today and how they can harden their applications against attack. This session will feature their conversation from COLLABORATE 16, followed by a live Q&A session.


    Oracle Database Developers: The Most Important Programmers on Earth

    Almost all eyes are focused on UI development these days, leveraging JavaScript to build intuitive apps and more. Yet underneath it all, we still rely heavily on databases generally, and Oracle Database in particular. Join IOUG for the launch of a twelve month series of discussions with experts like Steven Feuerstein and Connor McDonald, as we explore how to fully leverage all the application development features in Oracle Database.

    In this first webcast, a community expert will interview Steven Feuerstein about the importance of SQL and PL/SQL when building secure, high performance and maintainable applications on Oracle Database.



    Future Topics Include:

    Oracle Database Developers: The Most Important Programmers on Earth

    We launch the series with an unusual and possibly provocative presentation by Steven Feuerstein that delves deeply into the nature of data and how it ties to evolution and sets, the need for a data-centric, set-oriented language (go, SQL!) and finally the critical role that PL/SQL plays as a secure, performant, maintainable API to the data.

    Deep Dive: The Function Result Cache

    The Function Result Cache, added in Oracle Database 11g, offers developers a way to dramatically reduce the amount of time it takes to retrieve data that is requested repeatedly by database sessions (specifically: when the same rows of a table are fetched much more frequently than they are changed). This cache is stored in the SGA, shared across all sessions in the instance, and automatically purged of "dirty data" by the Oracle Database. Every application running on 11.1 or higher should be taking advantage of this feature.

    Best of all, there is minimal impact on your code to start using this feature!

    Avoiding Spaghetti Code in PL/SQL

    Spaghetti code is a nightmare – especially when one someone else wrote it and you have to maintain it. The good news is that PL/SQL is inherently a highly readable language, and on top of that offers several features that make it easy to avoid spaghetti code. In this webcast, we'll obsess over modularization, discuss the value of information heading, and get you well on the way to never have to serve up spaghetti for code review again!

    Git, Git hosting services, and Oracle's role in OpenSource

    Git has quickly become one of the dominant version control systems. Git can be intimidating at first, but understanding some of the basic functionality is all that's needed to get started. We'll talk about what Git is and explore the must-know features to get you productive quickly. We'll also explore the major Git repositories GitHub and BitBucket, and help you get started with each. Finally, we'll take a look at some of the 100's (???) of Oracle open source projects available on You'll learn how to fork these repositories, pull them to your local machine, and eventually become a valuable contributor to the open source community.

    Oracle Database 12c for Developers

    At first glance, 12c seemed to be all about the DBA. Multi-tenancy pluggable database, the In-memory option, automatic ILM just to name a few of the new features. But look more closely - and there's an incredible list of new features for developers. Hundreds of improvements and new facilities have arrived in Oracle Database 12c. This session redresses the balance and excites developers with all the new Oracle Database 12c features that will make them more productive, and let them build better faster apps.

    Analytic Functions

    Analytics have been with us since Oracle 8i Database Release 2 (8.1.6), but they are still dramatically underused by application developers. This session looks at the syntax and usage of analytic functions, including new features in 12c, and how they can supercharge your SQL skill set.

    SQL Tuning 101

    It's the age-old problem: the SQL statement that needs to run in 5 seconds unfortunately runs in 10 seconds or 10 minutes, or 10 hours. A SQL statement is e-mailed to you with the simple subject line "Make it faster!". This presentation starts from this point in the process and looks at what you can do to tackle this common issue.

    An Introduction to the Node.js Driver for Oracle Database

    Node.js, the platform that allows JavaScript to run on the server, has become very popular over the last few years. To best support this rapidly growing community, Oracle developed a new driver to allow Node.js to connect to Oracle Database. Now it’s possible to put the power of Node.js to work on your data! In this webinar attendees will learn the basics of the new driver before diving into some of the more advanced features that were recently added. Along the way attendees will see interesting use cases that make Node.js a valuable asset in your development toolset.

    Simplifying Effecitve Date Range Queries with Temporal Validity

    Storing changes to data over time is a common requirement. For example, many businesses like to keep a historic record of customer address changes or product price updates. Data warehouse developers frequently need to store history in slowly changing dimensions.

    Typically these requirements are implemented by adding effective from and to date columns to tables. This requires developers to write convoluted select statements to find the rows active at a given point in time. This is error prone and open to interpretation by developers, making applications harder to maintain.

    Introduced in 12c, temporal validity provides a standard way to write queries using effective date ranges. Implementing this helps improve developer productivity by simplifying SQL and providing a consistent method for managing time series data. Watch this session to see how you can easily adopt this on your 12c databases.

    Zero Downtime PL/SQL Releases Using Edition Based Redefinition

    Releasing PL/SQL to an environment with high uptime requirements brings many challenges. Objects may be invalid while you perform the release. You can't compile changes to packages while they're executing. There's no time to test the release unless you take an outage.

    This talk discusses methods of tackling these problems before Oracle 11g Release 2. It then introduces edition-based redefinition (EBR), a feature included in 11.2. This allows you to deploy multiple versions of PL/SQL objects in the same database. Using EBR, you can deploy PL/SQL easily with no application downtime.

    The talk shows you how to create and use editions with a live demo. It also draws on real world experience using EBR. This highlights some of the issues you can run into when using it and methods you can adopt to reduce these.

    SQL Magic Show - Tricks to Demonstrate SQL Features You've Probably Never Used

    In this fun session you'll see SQL versions of classic magic tricks. These include the cup and balls trick, where rows inserted into one table magically reappear in another and the magically changing row trick where the value returned by a query changes just by issuing a select statement!

    Unlike real magicians however, I'll show you how the tricks are done. This will enable you to perform your own SQL “magic” and apply these principles when building Oracle database applications.

    This session is intended for developers, DBAs and data modelers looking to expand their SQL skills, highlighting features that are new to 12c as well as little used existing options.

    Independent Oracle Users Group
    330 N. Wabash Ave., Suite 2000, Chicago, IL 60611
    phone: 312-245-1579 | email:

    Copyright © 1993-2017 by the Independent Oracle Users Group
    Terms of Use | Privacy Policy