Skip to Main Content

Office Hours - Past Sessions

Archive

If you weren't able to attend an Office Hours session live, you can still learn from the presentations and Q&A by watching a replay of the session.

DateDescendingSessionFocusDescription
September 19, 2020استخدام خدمات نقل تمثيل الحالة وأوراكل أبيكس - RESTful Servicesأبيكس بالعربييعد الأوراكل أبليكيشن إكسبريس (أبيكس) منصة منخفضة الشيفرة تمكنك من إنشاء تطبيقات مذهلة مرنة وآمنة ، مع ميزات عالمية المستوى ، يمكن نشرها في أي مكان. انضم معنا إلى مطوري أبيكس ومديري المنتجات للتدريب والتعليمات ، حتى تتمكن من تحقيق أقصى استفادة من هذه الأداة المدهشة!

في هذه الحلقة يستعرض الخبير أحمد السعيد خدمات نقل تمثيل الحالة RESTful Services مع أوراكل أبيكس.

لتبقى على تواصل مع سلسلة أبيكس بالعربي يرجى الضغط على "اشترك" في أعلى هذه الصفحة ومن ثم "الدخول للاشتراك".

Joel Kallman, Senior Director, Software Development
Salim Hlayel - سليم هليّل, Principal Product Manager for Oracle Application Express (APEX) مدير منتج رئيسي - أوراكل أبليكيشن إكسبريس
September 18, 2020Oracle Analytics Live!Oracle Analytics Live!Oracle Analytics Live! Webinar. Discover Oracle Analytics and the latest features!

Benjamin Arnulf, Senior Director
September 18, 2020Explore Backup/RecoveryDatabase Backup and Recovery Office HoursAskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Join us for answers to any and all questions on Oracle Database Backup and Recovery technologies, including Zero Data Loss Recovery Appliance (ZDLRA), Recovery Manager (RMAN), Database Backup Cloud Service (DBBCS), and Oracle Secure Backup (OSB).

Kelly Smith, Senior Principal Product Manager
Marco Calmasini, Senior Principal Product Manager
Tim Chien, Senior Director of Product Management
September 17, 2020Exadata Maximum Availability Architecture with Lawrence To's teamExadata Office HoursJoin Gavin and Cris for a chat with Lawrence To and his team about Maximum Availability Architecture (MAA) and Exadata. Exadata is the ultimate embodiment of the principles, technologies, and best practices of MAA, and Lawrence's team is central to developing and applying them.

About the Exadata Office Hours

A monthly opportunity to interact with the Oracle Exadata development experts and technical leadership. Exadata is engineered to deliver dramatically better performance, cost effectiveness, and availability for Oracle databases. Learn how to make the most of Exadata and get your questions answered by Exadata experts!

Cris Pedregal, Senior Technologist
Gavin Parish, Senior Principal Product Manager
Lawrence To, Senior Director Maximum Availability Architecture
September 17, 2020Location matters! Map Visualization for APEX developersOracle Application Express (APEX) Office HoursLocation Data, visualized on a map, is a common requirement for application developers these days. Of course, this is also true for APEX apps: But what's the best way of creating them? In this session, you'll learn everything about the Oracle Maps technology and how to use it in APEX applications.

We will be joined by Honglei Zhu, who is a Principal Member of Technical Staff in the Oracle Spatial product development team, and Carsten Czarski from the APEX development team. Honglei will introduce Oracle Maps and demonstrate how to easily use its JavaScript API to visualize location and analytic data. Then it will be time to integrate this in the APEX application. One way is to use the APEX Plug-Ins contained in the Sample Geolocation Showcase packaged application: Provide a SQL query, configure map attributes and you're ready to go. After that, attendees will learn how to keep full control, by embedding the Oracle Maps JavaScript API, into the APEX application.

This session is for both new and existing APEX developers.

Carsten Czarski, Consulting Member of Technical Staff
Honglei.x.Zhu, Principal Member of Technical Staff
Joel Kallman, Senior Director, Software Development
September 17, 2020Location matters! Map Visualization for APEX developersLocation matters! Map Visualization for APEX developersLocation Data, visualized on a map, is a common requirement for application developers these days. Of course, this is also true for APEX apps: But what's the best way of creating them? In this session, you'll learn everything about the Oracle Maps technology and how to use it in APEX applications.

We will be joined by Honglei Zhu, who is a Principal Member of Technical Staff in the Oracle Spatial product development team, and Carsten Czarski from the APEX development team. Honglei will introduce Oracle Maps and demonstrate how to easily use its JavaScript API to visualize location and analytic data. Then it will be time to integrate this in the APEX application. One way is to use the APEX Plug-Ins contained in the Sample Geolocation Showcase packaged application: Provide a SQL query, configure map attributes and you're ready to go. After that, attendees will learn how to keep full control, by embedding the Oracle Maps JavaScript API, into the APEX application.

This session is for both new and existing APEX developers.

Carsten Czarski, Consulting Member of Technical Staff
Honglei.x.Zhu, Principal Member of Technical Staff
Joel Kallman, Senior Director, Software Development
September 17, 2020General Database Office HoursDatabase Administration Office HoursIn this edition of General Database topics, we explored:

- The ins and outs of setting columns to UNUSED, and why DROP COLUMN is almost never needed.

- Critical things you need to be aware of this when using DBMS_JOB and upgrading to 19c

- How to estimate the space gains you'll make from doing a reorganisation after data maintenance, and how to decide if you will really benefit...

Connor McDonald, Developer Advocate
September 9, 2020Getting Started with Serverless Apps on Oracle Cloud InfrastructureOracle Cloud Services Office HoursServerless Computing is now available in the Oracle Cloud. Join us for an overview of Oracle Cloud's Functions-as-a-Service and learn how you can use Oracle Cloud’s serverless building blocks - Functions, Events, and API Gateway - to build modern, event-driven microservices.

Dusko Vukmanovic, Product Manager
Greg Verstraeten, Senior Principal Product Manager
Sachin Pikle, Product Strategy Director
September 8, 2020PL/SQL and the Art of OCI ManagementExplore Oracle PL/SQLSpecial guest Robert Pastijn, a member of the Database Platform Technology Solutions group, will share with us how he went about building a set of PL/SQL APIs to help manage Oracle Cloud accounts and services. He initially did this to help the database team manager upwards of 60 different cloud accounts under OCI Classic. Then he upgraded his API to take advantage of APEX_WEB_SERVICE package and apply it to OCI services. These APIs are used in Oracle LiveLabs.

01:46 Introduction and overview
02:50 The backstory: managing 60+ domains for database team
05:36 Making to move to PL/SQL, REST and APEX APIs
06:58 The joy of APEX_WEB_SERVICE, with jokes!
09:09 Using JSON_TABLE to make your JSON data relational
05:40 Quick review of REST
11:05 Encapsulating inside a PL/SQL function, adding screens in APEX
15:12 Downside of OCI Classic REST APIs
16:38 Making the switch from OCI Classic to OCI
19:06 Implementing signing via PL/SQL (and Java)
27:36 Improving signing with DBMS_CLOUD
30:37 Always Free Oracle Cloud reminder
30:58 Summary
33:13 Q & A: Use terraform? Access APIs from C++? And more

Chris Saxon, Oracle Developer Advocate for SQL
Robert Pastijn, Senior Principal Technologist (Product Manager/Strategy ProdDev)
September 3, 2020Hands on Lab: Deploying Oracle WebLogic Server on Kubernetes and Oracle CloudExtending APEX Applications with Autonomous DatabaseThis workshop will show you how to set up WebLogic on a Kubernetes cluster, using the Operator to manage the WebLogic domains.

Casey Ross, Cloud Engineer
Leah Bracken, Associate Cloud Engineer
Sasanka Abeysinghe, Senior Cloud Engineer
August 27, 2020Graph Algorithms: The Core of Graph AnalyticsGraph Algorithms: The Core of Graph Analytics (Pacific time zone)Graph algorithms are the foundation of graph analytics. When you model your data as a graph you can run powerful algorithms on the graph for new insights into your data. A few examples: Centrality algorithms (such as pagerank) can identify influencers in a social network, community detection algorithms (such as sccKosaraju) can identify similar buying patterns, path analysis (evaluating reachability) can identify the impact of changing the design of one component on connected components.

The Property Graph feature of Oracle Database includes over 50 built-in graph algorithms. We will discuss the usefulness of these algorithms in a variety of industries such as financial services, manufacturing, retail, and security. We will give an overview of some of the key algorithms, demonstrate how to use these algorithms in your applications, and show how you can visualize and query the results of a graph algorithm.

Jean Ihm, Product Manager
Melli Annamalai, Senior Principal Product Manager
Ryota Yamanaka, Regional Product Manager, Spatial and Graph
August 27, 2020Oracle APEX India Community Office Hours 2020 #3: Exploring Faceted Search and Key APIsOracle APEX India CommunityFeatured topics for this edition:

1. Exploring the Power of Faceted Search in Oracle APEX - Prashanth Raju, Oracle
2. Oracle APEX APIs that Everyone Should Know! - Srihari Ravva, Oracle

Highlights:

00:16: Introduction by Chaitanya Koratamaddi
01:46: Exploring the Power of Faceted Search in Oracle APEX by Prashanth Raju
03:09: What is Faceted Search?
04:31: Faceted Search - Example
06:10: How Does Faceted Search Work?
09:10: Faceted Search - Demo
28:21: Faceted Search Enhancements in APEX 20.1 - Demo
38:59: Summary
40:56: Oracle APEX APIs that Everyone Should Know! by Srihari Ravva
42:21: Exploring Few Useful APIs with Practical Examples
43:10: Sample APEX APIs - Demo

Chaitanya Koratamaddi, Senior Principal Product Manager, Oracle Application Express - Database Tools | Server Technologies
Joel Kallman, Senior Director, Software Development
Prashanth Kumar, Principal Member of Technical Staff
August 26, 2020LiveLabs Database In-Memory WorkshopDatabase In-Memory Office HoursIn this session Andy Rivenes (@TheInMemoryGuy) and Maria Colgan (@SQLMaria) reviewed the new LiveLabs Database In-Memory Fundamentals workshop. How to access the LiveLabs workshop, Oracle Cloud options and some tips on setting up the Lab were discussed.

Andy Rivenes, Product Manager
Maria Colgan, Master Product Manager
August 25, 2020Python and Autonomous Database: Better together for Location AnalyticsSpatial and Maps in Oracle Database Office HoursIn August we discussed the use of Python, and geospatial analysis libraries, in conjunction with the Autonomous Database's spatial features. David walked through a Jupiter notebook and outlined two scenarios. The first used spatial analysis, on a national scale dataset of vehicle accidents, to identify hot spots and cold spots where speeding was a factor or not a factor in the accident. The second scenario involved a spatio-temporal analysis of unemployment statistics. Here's a quick guide to the highlights:

1:00 David provides an overview of Spatial features in the Oracle Database
6:42 He discusses the vast ecosystem of geospatial analysis libraries for Python
8:44 He provides the URL for a PDF version of the Jupiter notebook with the demos
11:35 David introduces the first demo scenario
29:00 He discusses the second demo scenario

David Lapp, Product Manager - Spatial and Graph
Jayant.Sharma, Product Manager
August 25, 2020Why Is the Optimizer Estimating the Wrong Number of Rows?Write Great SQL Office HoursThe optimizer uses statistics to estimate how many rows it'll fetch from each table. This drives its decisions to on how to access the tables and join them. So the key to a good plan is good row estimates.

So why - even with fully up-to-date stats - does the optimizer sometimes get its estimates so badly wrong?

In this session we investigate two common causes: data skew and correlation. We look at why these lead to inaccurate estimates and what you can do to improve them.

Highlights include:

01:20 - Demo of SQL statements where the optimizer's row estimates are (badly) incorrect
05:40 - Value skew: some values appearing more often than others
06:20 - Frequency histograms
09:25 - Top-frequency histograms
14:25 - Height-balanced histograms
18:00 - Hybrid histograms
23:15 - Range skew: gaps between values
29:45 - Correlation between columns
32:15 - Demo: histogram creation during stats gathering based on column usage
42:40 - Demo: stats for correlated columns
46:00 - Demo: stats on expressions
51:55 - Demo: stats for subqueries
57:10 - Demo: disabling histograms
58:00 - Using table preferences to set non-standard stats gathering options

Chris Saxon, Oracle Developer Advocate for SQL
Keith Laker, Senior Principal Product Manager
August 25, 2020Oracle Developer Talk: Why choose Cloud Native?Oracle Cloud Services Office HoursBusiness are increasingly adapting a cloud native approach, including but not limited to Kubernetes and micro services oriented architecture. What are the benefits to IT-Ops and developers? What does businesses get out of it?

Watch this video to learn how Oracle Cloud Native services empower modern application development using technologies such as Kubernetes, Docker, serverless functions, APIs, and Kafka.

Ettore Volpicelli, Head of Developer Marketing - Europe, Middle East and Africa
Hassan Ajan, Principal Producty Strategy Manager
August 21, 2020Reduce Cyber Risk with Zero Data Loss Database ProtectionDatabase Backup and Recovery Office HoursLearn about the importance of protecting mission-critical Oracle databases against cyber attacks and how Zero Data Loss Recovery Appliance provides a holistic solution for end-to-end cyber risk protection and recovery.

Kelly Smith, Senior Principal Product Manager
Marco Calmasini, Senior Principal Product Manager
Tim Chien, Senior Director of Product Management
August 20, 2020The Top 12 New Features in APEX 20.1 that Everyone Should Know!Oracle Application Express Office HoursOracle Application Express (APEX) is a low-code development platform that enables you to build stunning, scalable, secure apps, with world-class features, that can be deployed anywhere. Join APEX developers and product managers for trainings and how-to's, so you can make the most of this amazing tool!

Chaitanya Koratamaddi, Senior Principal Product Manager, Oracle Application Express - Database Tools | Server Technologies
Joel Kallman, Senior Director, Software Development
Marc Sewtz, Senior Software Development Manager
August 20, 2020Are Database features broken?Database Administration Office HoursThere is a difference between not understanding how a feature works, and calling that feature "broken". Of course, occasionally bugs can throw a spanner into the works as well. In this Office Hours session, we looked at common misunderstandings of how database features work.

AskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts.

Connor McDonald, Developer Advocate
August 14, 2020Learn, Connect, and Collaborate!Oracle APEX Pakistan CommunityOracle APEX Pakistan Community: Learn, Connect, and Collaborate!

The goal of this special series of Office Hours is to bring together the Oracle APEX Pakistan Community, and provide a platform to learn, connect, and collaborate!

In this session, we host some of the top enthusiastic members of the APEX community in Pakistan.
Join us to directly hear from them about their experience with Oracle APEX.

00:11 Introduction by Salim Hlayel
01:19 Oracle APEX Pakistan Community by Joel Kallman
13:14 Agenda for the session by Salim Hlayel
13:57 Oracle for Startups by Numan Majeed
20:49 Let's explore the power of APEX by Farid Ghori
42:58 Digital Banking with Oracle APEX by Shoaib Ahmed
56:49 POS and ERP demonstrations by Gul Rehman
1:14:22 Books and Cloud Financials demonstration by Riaz Ahmed
1:25:36 APEX Experience and eCommerce demonstration by Abdul Rehman
1:34:34 APEX in Pakistan by Shayan Ahmed

Joel Kallman, Senior Director, Software Development
Salim Hlayel - سليم هليّل, Principal Product Manager for Oracle Application Express (APEX) مدير منتج رئيسي - أوراكل أبليكيشن إكسبريس
August 13, 2020Introducing Audit Vault and Database Firewall 20AskTOM Database Security Office HoursIn this session we introduced Audit Vault and Database Firewall release 20. This major release of Audit Vault and Database Firewall (AVDF) comes with increased audit target support, improved usability, and better interoperability with other enterprise systems. During the session we discussed what has changed in the new release and the upgrade path to move from AVDF 12 to AVDF 20. Note that current AVDF 12 customers will want to upgrade before the end of March 2021 and we are offering an early adopter program for customers deploying AVDF20 before the end of September, 2020

Here is a guide to the recording;
01:15 Product Announcements - Data Safe now available on-premises
04:27 Support corner
06:55 History of Audit Vault and Database Firewall (AVDF)
12:15 What's new in AVDF 20
13:57 New user interface
18:35 Expanded target support
30:15 Simplified Database Firewall
32:43 Enhanced enterprise support
37:30 Upgrading to AVDF 20
39:50 Early adopter program
43:08 Database auditing and audit collectin
45:45 Using Database Firewall
51:42 Reporting and alerting
52:35 Active Directory integration
53:14 Third-party integration (SIEM, Splunk)
54:10 High availability

Angeline Janet Dhanarani, Principal Product Manager - Core Database Auditing, Audit Vault and Database Firewall
Russ Lowenthal, Senior Director of Database Security Product Management
August 8, 2020أوراكل أبيكس، نظرة أكثر شموليةأبيكس بالعربييعد الأوراكل أبليكيشن إكسبريس (أبيكس) منصة منخفضة الشيفرة تمكنك من إنشاء تطبيقات مذهلة مرنة وآمنة ، مع ميزات عالمية المستوى ، يمكن نشرها في أي مكان. انضم معنا إلى مطوري أبيكس ومديري المنتجات للتدريب والتعليمات ، حتى تتمكن من تحقيق أقصى استفادة من هذه الأداة المدهشة!

انضم معنا في حلقة خاصة مع المحترف فاتح المسدي ونظرة أكثر شمولية لأوراكل أبيكس.تعرف لماذا يعتبر أبيكس من أفضل المنصات ليس فقط للمبرمجين الجدد و لكن أيضا للشركات الناشئة بالإضافة إلى بعض النصائح لأفضل الممارسات.

يرجى الضغط على اشترك في أعلى هذه الصفحة ومن ثم الدخول للاشتراك لتبقى على تواصل مع سلسلة أبيكس بالعربي.

00:11 – مقدمة الحلقة
06:47 – الرؤية
07:32 – هدف أكبر من مجرد امتلاك عملك الخاص
09:22 – نقاط هامة لتأسيس شركة ناشئة أو صغيرة
10:13 – الإبداع
11:03 – من أين أحصل على الفكرة؟
14:11 – مثال لحل مشكلة تصلح كمنتج مستقل
17:12 – التغلب على التحيز في التفكير
19:03 – كيف أتأكد من أن المنتج نافع؟
20:33 – المنتج بأبسط شكل
22:22 – أمثلة منتج بسيط
25:16 – قياس النجاح
26:36 – في حال لا يوجد تقدم
27:01 – أمثلة منتجات غيروا الاستراتيجية
28:31 – أين أبيكس من هذا؟
35:11 – أفضل الممارسات
50:41 – السلوك الصحيح
52:56 – Agile Project Management
55:34 – الخاتمة وأسئلة وأجوبة

Joel Kallman, Senior Director, Software Development
Salim Hlayel - سليم هليّل, Principal Product Manager for Oracle Application Express (APEX) مدير منتج رئيسي - أوراكل أبليكيشن إكسبريس
August 5, 2020Hands on Lab: Low Code Development with Oracle Autonomous DatabaseDeveloper PlaygroundThis hands on lab will get you started by helping you to sign up for an Oracle Free Tier, create an Autonomous Transaction Processing instance, create an APEX Workspace, create your first APEX App from a spreadsheet, use Quick SQL to create database objects, use SQL Developer Web to enhance your database objects and finally create and enhance an APEX Application.

Bo English-Wiczling, Director of Program Management, Application Express
Marcie Samuelsen, Developer Marketing Manager
August 4, 2020Machine Learning 102: RegressionOracle Machine Learning Office HoursHave you always been curious about what machine learning can do for your business problem, but could never find the time to learn the practical necessary skills? Do you wish to learn what Classification, Regression, Clustering and Feature Extraction techniques do, and how to apply them using the Oracle Machine Learning family of products?

Join us for this special series “Oracle Machine Learning Office Hours – Machine Learning 101”, where we will go through the main steps of solving a Business Problem from beginning to end, using the different components available in Oracle Machine Learning: programming languages and interfaces, including Notebooks with SQL, UI, and languages like R and Python.

In this fourth session in the series we covered Regression 102, with a look at multiple input attributes, attribute selection, feature generation, and a deeper look into diagnosis and potential problems

Video Highlights
00:39 Next Session Announcement: 101 Clustering
01:27 Today's Session: Machine Learning 102
04:10 Demo Part I of IV - Data Preparation
12:15 Sampling Data for using MatPlot Lib with OML4Py
16:10 How to identify the actual attributes that make sense to use
19:55 Data Cleaning
20:50 Data Transformation
23:24 Demo Part II of IV - Data Analysis
23:39 Random sampling for MatPlot Lib visualizations
28:25 Split data into Train and Test
29:40 Demo Part III of IV - Model Building
30:45 Linear Regression
41:00 Support Vector Machines
41:22 Neural Networks
41:50 List of Top Models for prediction
42:44 Demo Part IV of IV - AutoML
43:28 AutoML algorithm selection
44:13 AutoML Neural Networks
46:57 AutoML SVM
47:40 Final ranking of model quality
48:49 AutoML Neural Networks: Predicted vs. Actuals and Residuals
50:00 Machine Learning eXplainability for AutoML Neural Network
51:00 Visualizations in 3-D
52:40 Final conclusions
55:05 Q&A

Marcos Arancibia, Product Manager, Data Science and Big Data
Mark Hornick, Senior Director, Product Management, Data Science and Machine Learning
August 4, 2020A Preview of Oracle Database 20c PL/SQL EnhancementsExplore Oracle PL/SQLChris Saxon will take you on a tour of some of the most interesting new features added in Oracle Database 20c, which is currently available as a Preview Release on the Oracle Cloud.

Highlights of this session include:

05:15 - Extended Iterators - more powerful looping constructs
06:00 - Demo of extended iterators
21:50 - Extended iterators recap
24:00 - Aggregate qualified expressions (array type constructors)
25:10 - Demo of aggregate qualified expressions
40:00 - Aggregate qualified expressions recap
45:45 - SQL macros
47:00 - SQL macro performance comparison to other
53:21 - Pragma suppress_warning_6009

Chris Saxon, Oracle Developer Advocate for SQL
Steven Feuerstein, Developer Advocate for PL/SQL
July 30, 2020PGQL Introduction and Deep DiveGraph Database and Analytics Office HoursPGQL is a graph query language built on top of SQL, bringing graph pattern matching capabilities to existing SQL users as well as to new users who are interested in graph technology but who do not have an SQL background. This session includes the introduction and deep dive.

Jean Ihm, Product Manager
Melli Annamalai, Senior Principal Product Manager
Ryota Yamanaka, Regional Product Manager, Spatial and Graph
July 23, 2020Oracle APEX para Dispositivos MóvilesAPEX En Español Office HoursEn esta sesión exploramos los aspectos más importantes a considerar cuando necesitamos dotar a las aplicaciones APEX de funcionalidades móviles.

03:45 - Noticias
05:45 - Desarrollo Móvil con Oracle APEX
09: 11 - Tipos de Aplicaciones
14:00 - Consideraciones
19:00 - Componentes de APEX para el desarrollo móvil
28:30 - apex.storage
32:00 - Demo
39:15 - Integración de APEX con GoNative.io
52:00 - Q&A

Joel Kallman, Senior Director, Software Development
Mónica Godoy, Principal Product Manager
July 22, 2020Base Level Feature on Oracle Database 19cDatabase In-Memory Office HoursAskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Explore the Database In-Memory option with Andy Rivenes (@TheInMemoryGuy) and Maria Colgan (@SQLMaria). In this session we will show you the new Base Level feature on Oracle Database 19c with the new 19.8 RU.

Andy Rivenes, Product Manager
Maria Colgan, Master Product Manager
July 21, 2020Machine Learning 101: RegressionOracle Machine Learning Office HoursHave you always been curious about what machine learning can do for your business problem, but could never find the time to learn the practical necessary skills? Do you wish to learn what Classification, Regression, Clustering and Feature Extraction techniques do, and how to apply them using the Oracle Machine Learning family of products? Join us for this third chapter of the series “Oracle Machine Learning Office Hours – Machine Learning 101”.

In this "ML Regression 101" we learned how to set up a data set for regression modeling, build machine learning models that predict numeric values such as home prices, evaluate model quality and compare algorithms, as well as use AutoML for Regression.

Video Highlights
01:01 Next session announcement: 102 Regression
02:01 Machine Learning 101 - Regression
03:07 What is Regression
05:31 History of Regression
08:00 Data for our example
10:30 Terminology
11:11 Data preparation
13:43 Linear Regression model intuition
19:35 Model evaluation
22:47 AutoML
23:12 Demo for Machine Learning 101: Regression
23:50 Data Exploration
33:53 Regression model build
38:12 Linear Regression: Predicted vs. Actuals and Residuals
40:02 Computing the goodness-of-fit statistics in OML4Py
42:08 Linear Regression with feature creation and feature selection
43:57 Support Vector Machines Regression
47:35 Neural Networks Regression
49:25 Ranking of models so far
49:40 AutoML algorithm selection
51:04 AutoML GLM Ridge
52:37 Final ranking of models
53:20 Q&A

Marcos Arancibia, Product Manager, Data Science and Big Data
Mark Hornick, Senior Director, Product Management, Data Science and Machine Learning
July 21, 2020Which Indexes Should I Create?Write Great SQL Office HoursMany indexing examples examine a single SQL statement, suggesting the best method for that query.

But in the real world your application will query a table in many different ways. This means you need to look at the overall workload when choosing which indexes to create. This session highlights how to assess this.

Highlights include:

00:50 - Example queries
03:05 - Which indexes should we create for the demo queries?
07:00 - How databases search B*Tree indexes
11:10 - PRINCIPLE Ensure the leading columns of your index are in the where clause
15:00 - Discussion of possible indexes
17:00 - Issues with creating all the "best" indexes
28:00 - PRINCIPLE - create as few indexes as possible
31:50 - Index compression
37:00 - PRINCIPLE - put compressible columns first in an index
51:15 - Return to demo - automatic indexing has created the indexes!
54:20 - Session recap

Chris Saxon, Oracle Developer Advocate for SQL
Keith Laker, Senior Principal Product Manager
July 16, 2020Spatial Studio Demo:  Automated Spatial Analysis to Predict Electrical OutagesSpatial and Maps in Oracle Database Office HoursIn this webinar you will learn about Oracle Spatial Studio, which is a no-code application designed for users without geospatial or GIS expertise to visualize, analyze and manage your spatial data. This session will cover the basic concepts of Spatial Studio and how to interact with it. The focus will be on demonstrating how Spatial Studio can be used to create automated spatial analysis, with little to no SQL knowledge. This will be exemplified by demonstrating how to create an automatic, predictive network analysis using weather data.

Time stamps:

0:00 Introduction
1:34 Introduction spatial data and Oracle
6:54 Spatial Studio and how it can achieve automation
10:34 Demo background
12:00 Demo – Spatial analysis in Spatial Studio
19:40 Demo – Automation with Analytics Cloud & spatial analysis
27:55 Demo – Automatic notifications with Integration Cloud & spatial analysis
32:00 Demo summary
33:15 Q & A and wrap up
36:55 The end!

Carol Palmer, Senior Principal Product Manager
Jean Ihm, Product Manager
Rasmus Eduards, Solution Engineer
July 16, 2020Optimizing grocery delivery routes using Oracle APEX, Oracle Autonomous Database and Google Maps APIsOracle Application Express Office HoursIn this special edition of APEX Office Hours, we will be joined by Santhosh Jose, who is a Principal Applications Engineer in the Oracle HCM product development organization. During the pandemic, Santhosh volunteered his time to help deliver groceries to the elderly. After delivering groceries a few times, he quickly realized that the list of addresses were not as efficient as they could be. This is the classic "Traveling Salesman" problem in computer science ( https://en.wikipedia.org/wiki/Travelling_salesman_problem ) - what is the shortest possible route between a list of destinations?

To solve this problem, Santhosh turned to Oracle APEX & Oracle Autonomous Database to help solve this problem. In a short amount of time, Santhosh built a fully functional "Route Builder" application, which, given a list of addresses, will help determine the most efficient route between those addresses. To facilitate navigation by a driver, Santhosh also integrated Google Maps.

This session will be comprised of two parts - an introduction and background of Santhosh Jose and how he found Oracle APEX, and then a description, explanation and demonstration of the RouteBuilder app.

Joel Kallman, Senior Director, Software Development
Santhosh Jose, Principal Applications Engineer
July 16, 2020Pluggables, triggers, locks, redo and undo...Database Administration Office HoursIn this DBA Office Hours we looked at

- handling CPU peaks and troughs with pluggable databases
- locking impact of triggers
- better trigger code
- why standby redo logs are important
- how to detect heavy undo usage

blog: https://connor-mcdonald.com
twitter: https://twitter.com/connor_mc_d

Connor McDonald, Developer Advocate
July 14, 2020Explore Software GlobalizationSoftware Globalization Office HoursDo you have questions about internationalizing your Oracle Database applications, configuring globalization (NLS) settings in the database, or migrating the database character set to Unicode with the DMU utility? Do you want to know the various datetime data types or do you want to understand why you see all these funny characters on the screen in place of the expected non-English data? To find an answer, just join our session and ask -- we can answer most database globalization questions right away and we will be happy to search for an answer to the remaining ones. Within the limits of our expertise, we will also try to answer globalization questions about products other than Oracle Database.

Sergiusz Wolicki, Database Globalization Architect
Weiran Zhang, Director of Development
July 14, 2020Hands on Lab: Build a Fully-Functional APEX App from a Spreadsheet in 45 minutes!Developer PlaygroundGet your feet wet learning how to build a fully functional APEX app in less than an hour. In this lab, you learn how to:

- Create an APEX App from a Spreadsheet
- Navigating and making changes to the APEX Application

Bo English-Wiczling, Director of Program Management, Application Express
Marcie Samuelsen, Developer Marketing Manager
July 9, 2020Extending APEX Applications with Autonomous DatabaseDeveloper PlaygroundThe Developer Playground offers expert-led hands-on-labs on a variety of Oracle technologies. Learn how to extend your APEX Apps with new Autonomous Database features, such as spatial, machine learning and security.

Bo English-Wiczling, Director of Program Management, Application Express
Marcie Samuelsen, Developer Marketing Manager
July 9, 2020Data Redaction - preventing data proliferation with dynamic maskingAskTOM Database Security Office HoursIn this session we focused on Data Redaction, a feature of Oracle Advanced Security. We started with some basic background on masking and redaction. Then we discussed when redaction should be used and demonstrated several different use cases for redaction. We finished with a discussion of redaction benefits, competitition, and target use cases.

Here is a guide to the recording;
02:10 Product Announcements - Data Safe, TDE, AVDF
07:42 Support corner
08:30 Business problem of Data Redaction and Data Masking
13:20 Dynamic Data Masking, also known as Data Redaction
22:40 What and how to redact
25:50 Demonstration - simple redaction use case - Personal Data
33:45 Demonstration - conditional redaction using session information
36:45 Demonstration - multiple columns and conditions working together
46:30 Demonstration - Date Redaction using Label Security
54:00 Data Redaction target use cases
57:00 Data Redaction tips
58:15 Data Redaction benefits

Hakim Loumi, Product Manager/Field Engineer - Database Security
Pedro Lopes, Sr. Principal EMEA Field PM
Russ Lowenthal, Senior Director of Database Security Product Management
July 8, 2020What's new in node-oracledb 5.0 for Oracle DatabaseJavaScript and Oracle Database Office HoursThis month some highlights of the new features of node-oracledb 5.0 were demonstrated.

1:00 Top features in node-oracledb 5.0
3:32 Connection pool sizing best practices refresher
6:29 Connection pool queuing
9:15 Query row fetch tuning and prefetching: prefetchRows and fetchArraySize
14:00 Demo: Using initOracleClient() and other ways to specify the Oracle Client libraries (particularly on macOS)
19:35 Demo: Nested query
20:42 Demo: Query row fetch tuning and round-trip

For the node-oracledb 5.0 release announcement, see https://blogs.oracle.com/opal/node-oracledb-50-adds-nested-cursors-database-startup-and-prefetch-tuning

Anthony Tuininga, Consulting Member of Technical Staff
Blaine Carter, Developer Advocate for Open Source
Christopher Jones, Senior Principal Product Manager
July 7, 2020The Methods to Object Type MadnessPL/SQL Office HoursYou can use object types to follow an object-oriented paradigm for your database development. Or you can just make occasional use of object types for collection datatypes. Or you might just use some of the object types pre-defined in Oracle Database, such as those used in the spatial and graph technologies.

In all of those cases, it'll come in very handy to understand the differences between static, member, map and order methods, and also how to invoke methods of supertypes from within a subtype method.

00:00 Introduction
02:45 Overview of object types
10:45 Static methods
12:41 Member methods
15:37 User-defined constructors
19:10 Map and order methods
28:29 Q&A

Chris Saxon, Oracle Developer Advocate for SQL
Steven Feuerstein, Developer Advocate for PL/SQL
July 2, 2020Build Recommendation Systems Using a Graph DatabaseGraph Database and Analytics Office HoursRecommendation systems are useful for retail and other user-facing applications. A graph database provides key insights that can greatly improve results. In this session, we will show how to build a recommendation system based on historical purchase data. We will show how to extract a graph from transactional tables, how to run graph algorithms and graph queries to generate recommendations, and how to visualize the graph to understand the logic.

Caroline Chan, Developer
Melli Annamalai, Senior Principal Product Manager
Ryota Yamanaka, Regional Product Manager, Spatial and Graph
June 25, 2020From Low-code to Core-dev, Building Apps to Make Sense of the DataDatabase House Party #2There’s more than one approach to creating apps these days – knowing the options and how to choose one is critical. Low-code frameworks take a top-down approach, which can reduce complexity and development time significantly. On the other hand, core-dev frameworks are a better choice when control over every aspect of an app is essential. In this session, attendees will be introduced to a low-code framework (APEX) and a core-dev one (JET) to see how the approaches and results differ.

Duncan Mills, Architect
Marc Sewtz, Senior Software Development Manager
June 25, 2020Modern Application Development: the Path To Cloud ComputingDatabase House Party #2What does it mean to build modern applications and what is the recommended way to do so in 2020? IT is an ever-changing landscape of technologies and possibilities. Often we have forgotten where we came from and equally often we don’t know what’s even possible nowadays. Let us take you on a journey of the evolution that lead us to cloud computing and explain what it means to build modern, cloud-native, and data-driven applications.

Heli Helskyaho, CEO, Miracle Finland Oy
Holger Friedrich, CEO, sumIT AG
Todd Sharp, Developer Advocate
June 25, 2020Maps and Spatial Analyses: How to use themDatabase House Party #2The converged Oracle Database lets you store, manage, and query location information. Built-in SQL, REST, Java, and JavaScript APIs with JSON let you analyze addresses, GPS coordinates, coverage areas, territories and other geographic information. The first half of the session will describe the rich set of spatial analysis and spatial application development features of the database. The second half will be a case study of how these features are used in a Marketing Analytics platform that helps identify prospective customers and provide a compelling customer experience.

Jayant.Sharma, Product Manager
Nick Salem, Principal Software Architect
June 25, 2020Entornos APEX - OCIAPEX En Español Office HoursEn la sesión de Junio, Helen Trujillo y Juan Villarreal hicieron un recorrido sobre los pasos necesarios para tener APEX en OCI (Oracle Cloud Infrastructure).

1:55 Presentación Equipo Oracle APEX en México
5:00 Casos de éxito y experiencias: OCI en APEX
16:00 Recorrido técnico sobre OCI
53:00 Q&A

Joel Kallman, Senior Director, Software Development
Mónica Godoy, Principal Product Manager
June 25, 2020Loading, indexing and searching for recommendations in Text and JSONDatabase House Party #2This session will cover loading large JSON datasets into Oracle Database 19c, indexing the content and providing a RESTful search interface - all using Oracle Cloud features.

Roger Ford, Oracle Text Product Manager
Vikas Arora, Senior Director
June 25, 2020Data-driven Microservices Architecture with Converged Database, Kubernetes and Helidon on Oracle CloudDatabase House Party #2This talk provides an architecture overview of data-centric microservices illustrated with an example application. The following Microservices concepts are illustrated - domain driven design, event-driven services, Saga transactions, Application tracing and Health monitoring with different microservices using a variety of data types supported in the database - business data, documents, spatial, graph, and events. A running example of a mobile food delivery application (called GrubDash) is used, with a hands-on-lab that is available for attendees to work through on the Oracle Cloud after these sessions. The rest of the talks will build upon this Microservices architecture framework.

Martin Schmitter, Oracle ACE (RWE, Germany) will join us to discuss real world considerations and constraints of secure access/setup for each microservice with GDPR requirements.

KuassiM, Director of Product Management
Martin Schmitter, Database Solutions Architect, RWE Supply & Trading GmbH
Paul Parkinson, Data and Transaction Processing Dev Lead, Microservices Platform (Helidon)
June 25, 2020The Future is Data DrivenDatabase House Party #2This session will discuss the importance of data to an organisation and the need to build applications where the value within that data can easily be exploited. To achieve that aim we need to start building applications that benefit from the flexibility of new development paradigms but don't create artificial barriers of complexity that stop us from easily responding to change within our organisations.

Maria Colgan, Master Product Manager
Sanjay Goil, Vice President Product Management
June 25, 2020Next Level APEX - Exploring Exciting Ways to Extend Your APEX AppsOracle APEX India CommunityThis Office Hours edition includes two sessions:

Extended Use of Oracle APEX - Balamurugan Dharumar and Sathya Jegan, Doyensys
Smart Distancing using Social Authentication - Richard Dalvi, 4i Apps

Highlights

00:00 Agenda by Chaitanya Koratamaddi
01:29 Introduction by Balamurugan Dharumar
02: 56 Ways to Develop Exciting Apps
04:27 Use Cases
10:12 Faceted Search and Chart Integration
12:15 Demo by Sathya Jegan
12:54 Steps Involved - Creating, Rendering, and Maintaining QR Code
14:38 Download the BLOB
16:16 Creating and Using Dynamic Actions
19:08 Testing and improving QR Code Creator
20:41 Faceted Search
22:08 Q/A
25:18 Smart Distancing with Social Authentication by Richard Dalvi
28:58 Oracle APEX Authentication Schemes
30:10 Benefits of Social Authentication
30:51: Oracle APEX Social Sign-in Authentication
32:34 OAuth2
34:38 Authentication Setup Setps
35:34 Setting up Google Sign-In
45:15 Setting up Facebook Sign-In Steps
51:18 Case Study

Chaitanya Koratamaddi, Senior Principal Product Manager, Oracle Application Express - Database Tools | Server Technologies
Joel Kallman, Senior Director, Software Development
Prashanth Kumar, Principal Member of Technical Staff
June 24, 2020Getting Started with Spatial Studio on Oracle Cloud Free TierSpatial and Maps in Oracle Database Office HoursOracle Spatial Studio is a self service application that simplifies access to the spatial analysis capabilities of Oracle Database. Along with all other spatial features, Spatial Studio is provided with Oracle Database at no extra cost. In this session David Lapp showed how simple it is to deploy Spatial Studio in an Oracle Cloud Free Tier account.


0:0:10 Introduction to the spatial features in the database
5:39 What is Oracle Spatial Studio?
11:06 Requirements for Spatial Studio
14:14 Installing Spatial Studio on the Oracle Cloud - overview
25:39 Demo - Setting up the Cloud environment
42:49 Demo - Fine-tuning the Compute node
48:47 Demo - Running Spatial Studio
50:17 A few tips
51:09 Wrap up and Q & A

David Lapp, Product Manager - Spatial and Graph
Hans Viehmann, Product Manager - Spatial and Graph
Jean Ihm, Product Manager
June 20, 2020أوراكل أبيكس: بعض المفاهيم والأساسيات والحِيَل (الجزء الثاني)أبيكس بالعربيفي هذه الحلقة الخاصة نستضيف عمرو عابدين ليطلعنا على الجزء الثاني لبعض المفاهيم الأساسية والحِيَل المفيدة في أوراكل أبيكس.
لا تضيع فرصة حضور هذه الحلقة المميزة من أبيكس بالعربي.

00:11 – مقدمة الحلقة
01:16 – Dynamic Action كيف يعمل الفعل الدايناميكي
56:34 – الصفحة صفر، لماذا وكيف تعمل
1:09:48 – (Application Processes) عمليات التطبيق، لماذا وكيف تعمل
1:21:18 – (Debugging) كيف تقوم بالتنقيح
1:37:41 – الخاتمة

Joel Kallman, Senior Director, Software Development
Salim Hlayel - سليم هليّل, Principal Product Manager for Oracle Application Express (APEX) مدير منتج رئيسي - أوراكل أبليكيشن إكسبريس
  • 1 - 50