Præsentationer fra DOUG-dagen 22. oktober 2019
- Sandesh Rao: The Machine Learning behind Autonomous Database
- Martin Jensen: Nyt fra OpenWorld
- Sai Penumuru: Harness the Power of Oracle Autonomous Database
- Kim Berg Hansen: Twisting Data in Cloud and On-Prem SQL
- Rita Nuñez: First Steps with Oracle Autonomous Transaction Processing Database
- Sai Penumuru:Accelerate Your Application Development Using Oracle Developer Cloud
- Daniel Overby Hansen & Frank Vidtfeld Larsen: Use AWR to save resources
- Kim Berg Hansen: MATCH_RECOGNIZE – All-round Tool for Cloud and On-Prem Development
- Sandesh Rao: 19 troubleshooting tips and tricks for Database 19c
- Jeanette Holland & Daniel Overby Hansen: Test your PL/SQL with utPLSQL
Program for DOUG-dagen 22. oktober 2019
Her er planen DOUG-dagen tirsdag 22. oktober 2019. DOUG-dagen er som sædvanlig del af et nordisk samarbejde (Oracle GroundBreakers Nordic Tour), så vi kan tiltrække de bedste internationale talere.
Oracle Danmark lægger som sædvanlig velvilligt lokaler til, denne gang i deres nye lokation i The Cube i Hellerup. Se abstracts og talere længere nede på siden.
Før frokost tilbyder Rita Nuñez at hjælpe dig med at registrere din gratis Cloud account hos Oracle – det tager 5 minutter og kan klares fra din smartphone! Hvis du har din laptop med, kan du efter få minutter oprette din gratis Oracle Cloud-database.
Parallelt med foredraget efter frokost holder Oracle også en hands-on workshop fra 13.00 til 14.30. Hvis du tager en laptop med, kan du få lov at lege med din egen instance af Oracle Autonomous Database. Af hensyn til Oracle er der separat tilmelding til denne workshop. Hvis man skal deltage i denne skal man være lidt hurtig med frokosten.
DOUG takker vores sponsorer:
|0900-0930||Registrering og morgenmad|
|0945-1045||Sandesh Rao: The Machine Learning behind Autonomous Database|
|1055-1125||Martin Jensen: Nyt fra OpenWorld|
|1140-1240||Sai Penumuru: Harness the Power of Oracle Autonomous Database||Kim Berg Hansen: Twisting Data in Cloud and On-Prem SQL||1130-1300: Rita Nuñez: Get Your Free Cloud Database|
Getting Started Workshop for Autonomous Data Warehouse
(separat tilmelding nødvendig)
|1330-1430||Rita Nuñez: First Steps with Oracle Autonomous Transaction Processing Database||Sai Penumuru:Accelerate Your Application Development Using Oracle Developer Cloud|
|1445-1545||Daniel Overby Hansen & Frank Vidtfeld Larsen: Use AWR to save resources||Kim Berg Hansen: MATCH_RECOGNIZE – All-round Tool for Cloud and On-Prem Development|
|1615-1715||Sandesh Rao: 19 troubleshooting tips and tricks for Database 19c||Jeanette Holland & Daniel Overby Hansen: Test your PL/SQL with utPLSQL|
Pr. 2019-10-20. Ret til ændringer forbeholdes.
The Machine Learning behind Autonomous Database
We are entering a new era in the database with the introduction of the Oracle Autonomous Database. AI and Machine Learning are center stage to most projects and assist in making complex decisions which
Harness the Power of Oracle Autonomous Database
Like an autonomous car, Oracle Autonomous Database provides a level of performance and reliability that manually managed databases can’t deliver. Compared to a manually managed database, Autonomous Database costs less to run, performs better, is more available, and eliminates human error. This session covers various benefits, includes an end-to-end live demo, and discusses how we can see Autonomous Database as an opportunity to take on new responsibilities—and move into
Twisting Data in Cloud and On-Prem SQL
Quite often you have data in rows and need to display or output it in columns, or vice versa. You can also often have delimited data in strings and need them separated out, or conversely aggregate rows of data into delimited strings. In a Cloud
First Steps with Oracle Autonomous Transaction Processing Database
An autonomous database is a cloud database that automatically executes tasks as database tuning, security, backups, updates, and other routine management tasks traditionally performed by database administrators. This session focus on Oracle Autonomous Database Transaction Processing, that is optimized for transactions, so it can run simple transactions, complex transactions, batch programs, reportings, and mixed workloads. Autonomous Database comes with two deployment choices Serverless and Dedicated and we will explore uses cases that fit better for each one. You’ll learn also the first steps to start using in it, how to sign-in Oracle Cloud Service, provisioning an Autonomous Database Transaction Processing and connecting with it. This database has drivers for the main development languages as java, python, node.js, .net. This session includes a DEMO of Provisioning and Connecting to an ATP.
Accelerate Your Application Development Using Oracle Developer Cloud
Want to easily develop your apps in a fully provisioned environment that helps you code, test, deploy, and manage them in the cloud? Oracle Developer Cloud provides an integrated platform that combines DevOps and agile features to help manage development teams, software, and infrastructure from a single location. This session covers various benefits of using DevOps, microservices, and Oracle Developer Cloud, and includes a live demo.
Use AWR to save resources
At SimCorp there are hundreds of databases running various types for workload spanning multiple platforms and RDBMS versions. In such a landscape and during a busy day it is impossible to keep up with all the databases. The AWR is a treasure chest of valuable instrumentation data but it is not very easy to get a good overview and identify issues without digging into the details of every single database. SimCorp decided to build an AWR data warehouse wherein the data could be aggregated and presented to a DBA in a consolidated fashion.
Join this session to hear about the experiences gained at SimCorp by looking at AWR data from
MATCH_RECOGNIZE – An All-round Tool for Cloud and On-Prem Development
Row pattern matching is useful for recognizing patterns in rows of data, as the name implies. But the uses of MATCH_RECOGNIZE extends beyond the obvious – it can be applied to grouping consecutive data, merging overlapping periods, bin fitting, child number calculations in hierarchies, and more. Being part of SQL it should be part of any Cloud developer’s toolkit to avoid pulling the data to the client (which of course applies to on-premises too.)
19 troubleshooting tips and tricks for Database 19c
This part of the workshop will focus on 19 troubleshooting tips and tricks for DBA’s covering tools from the Oracle Autonomous Health Framework (AHF) like Trace File Analyzer (TFA) to collect , organize and analyze log data , Exachk and
Test your PL/SQL with utPLSQL
Unit testing provides a mean of fast feedback to a developer. Modern programming has a lot of focus on continuous integration, and with utPLSQL there is a great framework for easily create and run unit tests on your PL/SQL code. Join this presentation to see a demo of the utPLSQL unit test framework, and learn how to use it, and get started with testing your own code. The presentation will follow a test driven development (TDD) approach and thus it starts out with creation of a unit test. Next, a new PL/SQL package is created that applies conditional compilation to expose otherwise private functions to the unit test framework. Finally, the feedback from the failing unit tests can be used to continuously improve the PL/SQL until it passes all tests, and are ready for being saved. We promise there will be code or examples on (almost) all slides.
If time allows there is also a demo of a full CI pipeline with PL/SQL being created in SQL Developer, saved in GitHub, and tested by utPLSQL via Team City build agents.
Kim Berg Hansen
Kim Berg Hansen is a database developer from Middelfart in Denmark. Originally wanting to work with electronics, he almost coincidentally tried computer programming and discovered where his talent lay, as the programs he did worked well – unlike the electronics projects he soldered that often failed. After that experience he progressed from Commodore Basic on VIC-20 over Modula-2 and C at Odense University to Oracle SQL and PL/SQL, which last two languages he now has worked with extensively since the year 2000. His professional passion is to work with data inside the database utilizing the SQL language to the fullest to achieve the best application experience for the users.
Kim shares his experience and knowledge by blogging, presenting at various Oracle User Group conferences, and being the SQL quizmaster at the Oracle Dev Gym. His motivation is when peers go “now I understand” after his explanations, or when end users “can’t live without” his application coding. He is certified Oracle OCE in SQL as well as awarded Oracle ACE Director. Outside the coding
Rita Nuñez is an Oracle ACE Director, Oracle Database and Oracle Cloud Specialist. University Graduated as a Systems Engineer. Instructor of Oracle University. She is CEO and Founder of Tecnix Solutions, leads the Consulting and Training services in Oracle Products. She collaborates with the Oracle Community by writing articles for OTN and on their blog. Keeps the Oracle community informed through their twitter. She has been giving presentations at Oracle events since 2013 in Argentina, Brazil, Uruguay, Chile, Paraguay, Panama, and Costa Rica. He also gave presentations at Oracle Code Buenos Aires 2018, Oracle Code Paris 2018, Oracle Open World 2016 and 2017. She is a member of the board of Directors and Coordinator of SIG Database & RAC of ArOUG.
Sai is an expert in industry-leading technology trends: Cloud & DevOps and having more than 17 years of experience in driving technology innovations and helping customers. He spent past six years evangelizing an industry-wide shift to the cloud. In his current role as Chief Technologist focusing on building solutions maximizing use of emerging technologies to help customers transform their applications to a digital platform. Strong client facing personality and experience engaging Senior Stakeholders He is also an accredited Oracle ACE Director and Oracle Groundbreaker Ambassador an honor bestowed on him by Oracle because of his community contributions. Sai is a well-known and respected technologist within the Oracle community. He is one of the founding members of All India Oracle Users Group (www.aioug.org) and currently serves as President. He has been invited to present regularly speaker at industry conferences across the globe including Oracle Open World (2013 to 2018), Tech UKOUG (2014,2016,2017), OUGN (2016 to 2018), AMIS – Beyond the Horizon (2016), DOAG (2016), Oracle Cloud World (2016), Oracle Code 2017 (New Delhi, Moscow), Oracle Code 2018 (Hyderabad, Bengaluru), Oracle Code 2019 (Bengaluru), Sangam (2009 to 2018), OTNYathra (2012 to 2018) and many TechDays. Sai holds a Master’s degree in computer science from the University of Madras and is a member of Toastmasters International. His LinkedIn profile – https://www.linkedin.com/in/saipenumuru/
Sandesh Rao is a VP running the AIOps Automation for the Autonomous Database Group at Oracle Corporation specializing using AI/ML for different