Please Join Us:
More of the 2017 CodeTalk Series coming in March! Please check back!
Steven Feuerstein, Oracle Corporation interviews Morten Egan, the PL/SQL Ninja
The 2017 CodeTalk Series Webinars are Co-sponsored by ODTUG and IOUG.
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 codemonth.dk and plsql.ninja 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!
Blaine Carter, Oracle Corporation, and Anton Nielsen, C2 Consulting
To say we live in an increasingly connected world is to state the obvious – and to entice developers to wonder how they can connect their devices to the Internet. Of course, that immediately begs the question of what to do with all the data gathered. We kick off the CodeTalk 2017 series with an interview with Anton Nielsen, longtime explorer of leading-edge technologies in and around Oracle Database. He’s got lots to say about the IoT, and Blaine Carter, Oracle Developer Advocate for Open Source, will make sure you hear all about it.
Toon Koppelaars and Chris Saxon, Oracle Corporation
Toon Koppelaars recently conducted an experiment comparing the performance of different ways of implementing a specific task. The NoPL/SQL approach treats the database as no more than a persistence layer, using only naive single-row SQL statements; it implements all business logic outside of it. The thick database approach treats the database as a processing engine; it uses a combination of sophisticated set-based SQL statements and PL/SQL to implement all business logic inside it. In this session, Chris and Toon investigate Toon’s findings and discuss their implications for database development. This session is a must-watch for anyone who builds applications using Oracle Database.
Blaine Carter, Oracle Corporation, Martin D'Souza, Insum
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 many Oracle open source projects available on https://Github.com/oracle. 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.
Chris Saxon and Stew Ashton, Oracle Corporation
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.
Application Development on Oracle Database: A Yearlong CodeTalk Series
Connor McDonald, Oracle Corporation; Scott Wesley, Sage Computing Systems
Analytic SQL in the Oracle Database has been there since 8.1.6, but is still dramatically underused by application developers. Rather than wade through syntax diagrams, let's spend a session solving what used to be considered complex problems, now made simple with the power of Analytics. Oracle ACE Scott Wesley will interview Oracle Developer Advocate Connor McDonald on how to get the best out the Analytic SQL facilities.
Oracle Database Developers: The Most Important Programmers on Earth
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.
Steven Feuerstein, Oracle Corporation
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.
Steven Feuerstein, Oracle Corporation and Oren Nakdimon, Moovit
Millions of people develop applications on top of Oracle Database. The most secure and optimized of those applications take full advantage of SQL and PL/SQL. In this CodeTalk webcast, Steven Feuerstein interviews Oren Nakdimon of Moovit (http://moovitapp.com), lead developer for the backend of this popular transit app, to find out just how he and his small team have made the most of PL/SQL, and how they manage their PL/SQL code base.