Kscope13 Presentations

Check out the presentations listed below.



Data Modeling 101 with Oracle SQL Developer
Ashley Chen , Oracle Corporation
When: Jun 25, 2013, Session 9, 2:00 pm - 3:00 pm
Topic: Developer's Toolkit - Subtopic: IDEs

From entities to tables, see how SQL Developer allows you to get 'the data right,' before you even write a single line of application code. Learn how to build your logical model, forward engineer it to a relational model, split entities to multiple tables, design relationships, enforce business rules, tackle physical storage issues like partitioning, manage domains, and check your models for common design issues - all while versioning and coordinating your work with your fellow developers.

Back to Top
A Developer Platform for Database/Middleware Applications Using Virtualization
Arijit Das , Naval Postgraduate School
Co-presenter(s): Erik Lowney, Naval Postgraduate School
When: Jun 26, 2013, Session 15, 3:00 pm - 4:00 pm
Topic: Developer's Toolkit - Subtopic: Languages

A typical tech shop is at the mercy of "patch and pray," so to get out of this cycle one needs a development environment to try things out. Using virtualization we have a sandbox to test patches and upgrades for the Oracle Database and Middleware applications. This session will discuss the virtual offerrings from VMware and Oracle VM and how it applies to their production cycle.

Back to Top
Ready, Get Set, Go Mobile!
Susan Duncan , Oracle Corporation
When: Jun 25, 2013, Session 6, 8:30 am - 9:30 am
Topic: Developer's Toolkit - Subtopic: No Subtopic

iOS, Android, RIM, native, hybrid, web-based, ADF Mobile, device-native, HTML5, AMX, PhoneGap, Cordova, iTunes, GooglePlay, XCode - if you're looking into mobile application development, this is just some of the vocab you're probably trying to get your head around. The different mobile developer programs can seem daunting and vary in complexity; for instance with iOS you need to understand and consider developer licenses, developer certificates, profiles, device registration, and work within the iOS portal. What about your teams and the mobile paradigm; do you need new skills, processes, and IT procedures and even hardware to be successful in mobile? Are there best practices and design patterns to follow? How and where do you test and distribute your mobile applications? Are you ready for rolling updates of iOS/Android requiring instant fixes to your app? Join this session for a introduction to making the most of mobile. As lead of the Oracle Mobile Development Program office, Susan has first-hand experience in navigating and making sense of the terminology and challenges that face teams stepping into the mobile development world. Benefit from her insights and experience and learn how to quickstart your mobile development. And the good news? It's not as daunting as you think - if you're an Application Development Framework (ADF) or Fusion developer you are already a mobile developer. If not, come and see how you can be!

Back to Top
High Performance PL/SQL
Steven Feuerstein , Dell, formerly Quest Software
When: Jun 24, 2013, Session 4, 1:45 pm - 2:45 pm
Topic: Developer's Toolkit - Subtopic: No Subtopic

Users hate to wait - for anything. For our applications to be successful, they not only must be correct (meet user requirements) and maintainable, they must also execute efficiently enough to avoid user frustration. This session reviews the most important techniques for improving PL/SQL performance, including data caching, FORALL, and BULK COLLECT. After attending this session, you will be able to proactively identify opportunities for applying techniques that will most dramatically (generally, an order or magnitude or more) improve the performance of your PL/SQL code.

Back to Top
Oracle Database 12c New PL/SQL Features
Steven Feuerstein , Dell, formerly Quest Software
When: Jun 25, 2013, Session 8, 11:15 am - 12:15 pm
Topic: Developer's Toolkit - Subtopic: No Subtopic

Oracle Database 12c offers an array of exciting new features for PL/SQL developers. The function result cache has been enhanced to support functions defined with invoker rights. Use the ACCESSIBLE BY clause to define "whitelists" of the program units that can execute subprograms in a package. Grant roles to PL/SQL program units, rather than to schemas, giving you much greater flexibility over access control. Design a procedure to implicitly return a result set, much like you can do in SQL Server (useful for migration projects). Define a view with BEQUEST CURRENT_USER so that it behaves like an invoker rights unit. Declare and call PL/SQL functions entirely inside the WITH clause a SELECT statement. And more!

Back to Top
Top Ten Cool Features in Oracle SQL Developer Data Modeler
Kent Graziano , Data Warrior
When: Jun 25, 2013, Session 10, 3:30 pm - 4:30 pm
Topic: Developer's Toolkit - Subtopic: No Subtopic

Oracle SQL Developer Data Modeler (SDDM) has been around for a few years now and is up to version 3.x. It really is an industrial-strength data modeling tool that can be used for any data modeling task you need to tackle. Over the years, the presenter has found quite a few features and utilities in the tool that he relies on to make him more efficient (and agile) in developing his models. This presentation will demonstrate at least ten of these features, tips, and tricks for you. He will walk through things like installing the reporting repository, building a custom report on the repository using Oracle SQL Developer, modifying the delivered reporting templates, how (and when) to use the abbreviations utility, how to create and apply object naming templates, how to use a table template and transformation script to add audit columns to every table, how to add custom design rules for model quality checks (heck how to use the built-in quality checks), and several other cool things you might not know are there. Since there will likely be patches and new releases before the conference, there is a good chance there will be some new things for the presenter to show you as well. This might be a bit of a whirlwind demo, so get SDDM installed on your device and bring it to the session so you can follow along.

Back to Top
Hands-on Training: Developing REST for on Premise or in the Cloud
Rick Greenwald , Oracle Corporation
When: Jun 26, 2013, Session 13, 11:15 am - 12:15 pm
Topic: Developer's Toolkit - Subtopic: Hands-on Training

This hands-on lab will teach the new Oracle APEX Listener and Oracle Apex 4.2 RESTful services. REST can be accessed from any client, any language making database applications more accessible than ever. The new RESTful services make this easier than ever compared to many other options. Labs Include: * Learn how to write REST services with the Apex Listener

Back to Top
Introduction to Java-PL/SQL Developers Take Heart
Peter Koletzke , Quovera
When: Jun 26, 2013, Session 14, 1:45 pm - 2:45 pm
Topic: Developer's Toolkit - Subtopic: Languages

Oracle is now in charge of the Java language and has implemented many database and development features based on the Java. So you may now be more interested in learning more about Java. If you are familiar with PL/SQL, your first view of Java may be a bit discouraging because its object-oriented core makes it look very different. Also, you may be wondering about where Java fits in the industry and how much Java you really need to know to create web applications. This presentation explains to PL/SQL developers who have had little or no exposure to Java, the basic concepts of and terms used in Java. The presentation provides an overview of the language and reviews the concepts of object orientation upon which Java is based. It also discusses the fundamental Java code structures -- classes and methods -- as well as control statements; exception handling; datatypes; and variables. Finally, it describes how Java is used in modern web applications.

Back to Top
Version Control the Database Development
Uri Margalit , dbMaestro
When: Jun 27, 2013, Session 19, 11:00 am - 12:00 pm
Topic: Developer's Toolkit - Subtopic: IDEs

Do you version control your database development? Do you use the file-based solution to work with the Database? This session will cover the benefits of implementing best practices that include working with Oracle SQL Developer and Version Control without using scripts. Learn how to generate the deploy scripts easily based on schema comparison, labels, and working by tasks.

Back to Top
SQL Developer for DBAs
Leighton Nelson , Mercy
When: Jun 26, 2013, Session 13, 11:15 am - 12:15 pm
Topic: Developer's Toolkit - Subtopic: No Subtopic

SQL Developer has become an invaluable tool for developers for database development. It has, however, improved significantly in recent versions and is now as valuable to database administrators and developers alike. This session will look at some of the new features in SQL Developer 3 that can simplify some otherwise mundane tasks for database administrators - Data Pump Import/Export, RMAN Backup & Recovery, Scheduler, Real-Time SQL Monitoring and Reports. The session will also take a look at some Oracle Database 12c features supported in SQL Developer.

Back to Top
Mastering the Oracle Data Pump API
When: Jun 26, 2013, Session 16, 4:15 pm - 5:15 pm
Topic: Developer's Toolkit - Subtopic: No Subtopic

The Data Pump API is a set of functions and procedures in the dbms_datapump package, that can move data and metadata between Oracle databases. This presentation will take a detailed look at this package and its contents. There will be examples of how to use the various filtering options, how to stop, restart, and monitor running jobs. The audience will get an idea of how to use the Data Pump API in their own environments, and how to do more than just basic data exports and imports.

Back to Top
Extending the Oracle Data Dictionary for Fine-Grained PL/SQL and SQL Analysis
Philipp Salvisberg , Trivadis AG
When: Jun 26, 2013, Session 16, 4:15 pm - 5:15 pm
Topic: Developer's Toolkit - Subtopic: Languages

Oracle data dictionary views as DBA_IDENTIFIERS or DBA_DEPENDENCIES are in many cases sufficient to analyze static PL/SQL and SQL code within the Oracle database. But what if more detailed analysis are required, such as the use of tables or columns in PL/SQL package units, in SQL statements, or in SQL statement clauses? Wouldn't a DBA_OBJECT_USAGE view - showing DML and query operations on tables/views per database object -- be a helpful tool? This presentation shows how to extend the Oracle data dictionary views to support fine-grained PL/SQL and SQL analysis and demonstrates the capabilities using real-life examples.

Back to Top
What? You're Still Not Using Groovy?
David Schleis , Wisconsin State Laboratory of Hygiene
Co-presenter(s): Joe Aultman
When: Jun 24, 2013, Session 5, 3:00 pm - 4:00 pm
Topic: Developer's Toolkit - Subtopic: Languages

If you spend time writing Java code, and you're not using Groovy, you're spending too much time writing code. If you've ever pondered an Essbase automation problem and said, "I wish I knew how to write Java," and you haven't looked into Groovy, your answer is here. Groovy is an object-oriented dynamic language (also referred to as a scripting language) like Ruby or PHP. Like these languages, Groovy is much easier to use and has a simpler syntax than Java. However, what makes Groovy different than other scripting languages is that it compiles to Java bytecode. This means that Java programs can run Groovy, and Groovy programs can run Java. This seamless integration with Java and its concise syntax are why Groovy is the language of choice for scripting of ADF Business Components. This integration also means that writing in Groovy makes it easier to use existing Java libraries; including the Java libraries of the Essbase Java API. This session is an introduction to the Groovy programming language and how it can be used in conjunction with the Essbase JAPI to make advanced automation more accessible.

Back to Top
SQL Developer Tips & Tricks
Jeff Smith , Oracle Corporation
When: Jun 24, 2013, Session 3, 11:30 am - 12:30 pm
Topic: Developer's Toolkit - Subtopic: IDEs

More than two and a half million people use Oracle SQL Developer, but how many of those are really getting the most of the tool? SQL Developer's primary purpose is to save the developer and DBA time and energy without getting in their way. See the most popular features and productivity tips the product manager accumulated in this interactive session. Each attendee is guaranteed to pick up two to three new techniques that will improve their Oracle database experience.

Back to Top
Hands-on Training: SQL Tuning using SQL Developer
Jeff Smith , Oracle Corporation
When: Jun 25, 2013, Session 6, 8:30 am - 9:30 am
Topic: Developer's Toolkit - Subtopic: Hands-on Training

SQL Developer is used by millions of people and this lab will teach how to use some often missed features which help tune SQL statements. This includes using the SQL Tuning advisor, how to use various optimizer access path, and other features. Labs include: * Tune Your SQL with the SQL Tuning Advisor * Learn about Optimizer Access Paths Using Oracle SQL Developer * Working with Tuning Utilities in Oracle SQL Developer

Back to Top
The 80's Called, They Want Their Command Line Interface Back
Jeff Smith , Oracle Corporation
When: Jun 26, 2013, Session 12, 9:45 am - 10:45 am
Topic: Developer's Toolkit - Subtopic: IDEs

I only use SQL*Plus. I say that graphical IDEs are the best. Who is right? How can an old-school database pro be convinced to use newer technology, and more importantly, why SHOULD they be convinced? Tools are designed to do one thing - increase productivity. If your tool is slowing you down, you're doing it wrong, or you're using the wrong tool. Watch Oracle's SQL Developer product manager debate himself on why SQL Developer can be good for both the new and advanced Oracle user.

Back to Top
Can Your IDE Do This? Oracle JDeveloper vs. Eclipse, What is in it for ADF Developers?
Greg Stachnick , Oracle Corporation
Co-presenter(s): Duncan Mills, Oracle Corporation
When: Jun 24, 2013, Session 5, 3:00 pm - 4:00 pm
Topic: Developer's Toolkit - Subtopic: No Subtopic

Oracle ADF applications can be developed in Eclipse (through Oracle Enterprise Package for Eclipse) and - traditional - in Oracle JDeveloper. This session compares the ADF support in both IDEs in a entertaining and refreshing "can-you-do-that" battle-style. Besides learning about the capabilities of both IDEs you learn about the joint points that allow developers of both IDEs to work together on a shared ADF application project.

Back to Top
An Oracle Geek's Guide to Successful Dating
Sean Stuber , American Electric Power
When: Jun 26, 2013, Session 15, 3:00 pm - 4:00 pm
Topic: Developer's Toolkit - Subtopic: Languages

This session will be a short examination of Oracle's date/time datatypes and best practices for manipulating them in SQL and PL/SQL.

Back to Top
Do I Need to Migrate / Re-develop My Oracle Forms Applications? (Experts Panel)
Mia Urman , OraPlayer
Co-presenter(s): Michael Ferrante, Oracle Corporation
When: Jun 25, 2013, Session 10, 3:30 pm - 4:30 pm
Topic: Developer's Toolkit - Subtopic: Forms and Beyond

Join Mia, Michael Ferrante, John King, Lynn Munsinger, David Peake, and Christian Shay in an Expert Panel. Hearing conflicting reports about the future of Oracle Forms? Do you get the feeling you MUST re-develop / migrate your Forms applications ASAP? This session will help set the record straight. Oracle Forms applications contain hundreds of man-years of investment; this session will present your options going forward. And answer the burning question - Can you squeeze a few more years out of your systems or do you need to migrate to a new technology today? And if you must migrate then which next generation development technology should you choose? Come to this session to meet with some of the leading Oracle Forms experts for an open Q&A about if, when, why, and how you should migrate, including the options, costs, risks, and benefits of migration from Oracle Forms. The presenters will do their best to represent all major development technologies including Java, Oracle ADF, Oracle APEX,.NET, or new third-party development tools.

Back to Top
Strategies to Move Forward with Oracle Forms: What Now? What's Next?
Mia Urman , OraPlayer
When: Jun 26, 2013, Session 14, 1:45 pm - 2:45 pm
Topic: Developer's Toolkit - Subtopic: Forms and Beyond

How can we preserve our Oracle Forms investment while still achieving modern applications? This question will be answered in this session. As Today's IT landscape is moving to new cloud and mobile environments, organizations are looking to create modern applications, using cutting-edge technologies. Companies with large Forms investments are facing difficulties moving their legacy systems into the next generation. This session will provide Oracle Forms developers/managers with the essential information on preserving their Forms investment going forward. The session will explore how to extend your existing systems by modernizing and integrating them with Oracle's next generation technologies. The session will start with a review of the future of Oracle Forms, then discuss what we can do now; including upgrading to Forms 11g - WebLogic, UI modernization, incorporating Java/JavaScript, and creating and building integrated systems of Forms and ADF. The session will then review what's next with future considerations and third-party solutions for running Oracle Forms on the cloud and on mobile devices.

Back to Top
Find us on Facebook
Follow Us