January 21, 2021 | General Database Office Hours | General Database Office Hours | In this Q&A session we discussed:
- Cool new features in 21c PLSQL - Understanding date implications when you move your database to the cloud - How to control the volume of audit information with unified auditing - How indexes can have an impact on Views - How much free space you need when reorging a table (a surprising discovery was made)
Connor McDonald, Developer Advocate
|
January 21, 2021 | Hands on Lab: Deploy a Kubernetes Cluster Using Oracle Cloud Shell | Hands on Lab: Deploy a Kubernetes Cluster Using Oracle Cloud Shell | Oracle Cloud Infrastructure Container Engine for Kubernetes is a fully-managed, scalable, and highly available service that you can use to deploy your containerized applications to the cloud. Use Container Engine for Kubernetes when your development team wants to reliably build, deploy, and manage cloud-native applications. You specify the compute resources that your applications require, and Container Engine for Kubernetes provisions them on Oracle Cloud Infrastructure in an existing OCI tenancy.
Oracle Cloud Infrastructure Cloud Shell is a web browser-based terminal accessible from the Oracle Cloud Infrastructure Console. Cloud Shell provides access to a Linux shell, with a pre-authenticated Oracle Cloud Infrastructure CLI. In addition to the CLI, Cloud Shell provides the following commonly used Kubernetes tools:
- A preinstalled version of kubectl, a command line tool for controlling Kubernetes clusters. - A preinstalled version of Helm, a package manager used to deploy applications to Kubernetes clusters.
In this tutorial, you set up the Kubernetes configuration file for the cluster (the cluster's 'kubeconfig' file) to enable you to use kubectl to access the cluster from the Cloud Shell environment.
IMP: To execute the lab you will need access to an Oracle Cloud Account. If you don’t already own please get your Oracle Cloud Free Tier Account clicking here: http://bit.ly/free_tier_21jan You will benefit of a special offer using the same email address used to register for this Virtual Lab.
NB. Please create your Oracle Cloud Free Tier Account the day before of this Virtual Lab.
Please provision your cloud account and instance the day before the Virtual Lab or as soon you get this message. We advice to choose London South or Frankfurt as Cloud Home Region.
Here you can find Pre-requisites/Setup info: http://bit.ly/lab_steps_21jan
Ettore Volpicelli, Head of Developer Marketing - Europe, Middle East and Africa
|
January 15, 2021 | Accelerate Cross-Platform Database Migration with Recovery Appliance | Accelerate Cross-Platform Database Migration with Recovery Appliance | Learn the latest techniques using Recovery Appliance to simplify and speed up cross-platform database migration activities, including moving from non-Multitenant to modern Multitenant Database architectures.
Kelly Smith, Senior Principal Product Manager Marco Calmasini, Senior Principal Product Manager Tim Chien, Senior Director of Product Management
|
January 14, 2021 | Hands on Lab: Build a Fully Functional APEX App from a Spreadsheet in 45 minutes! | Hands on Lab: Build a Fully Functional APEX App from a Spreadsheet in 45 minutes! | Get 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
Mónica Godoy, Principal Product Manager
|
January 11, 2021 | Oracle Cloud Coaching: Compute Fundamentals | Oracle Cloud Coaching: Compute Fundamentals | In this session, learn how to set up Bare Metal, Virtual Machine, and Dedicated Hosts instances and hear about the advanced features and performance OCI compute provides, with a variety of image and shape options.
Cloud Coaches are highly skilled solution engineers ready to assist you in your Oracle Cloud development journey.
Cloud Coaching Office Hours provides a way for you to get your questions answered. The schedule is as follows:
- Learn about a tip or best practice - Ask a question - Pre-submit your questions to cloudcoach_us_grp@oracle.com or ask during the office hours - Learn how to get additional help for your organization.
Marcie Samuelsen, Developer Marketing Manager Mark Smith, Manager, Cloud Engineering Tara Van Cleave, Business Development Consultant
|
December 21, 2020 | Visual Builder - What’s New | Visual Builder - What’s New | Learn about the new features added to Oracle Visual Builder in the latest release and how they benefit you. We’ll demonstrate Redwood UI and Oracle JET 9 updates, Improved development experience, and Visual Builder Studio integration for team development and CI/CD.
We’ll also discuss what you need to know about upgrades, and the latest learning resources published for developers.
Shay Shmeltzer, Director of Product Management
|
December 17, 2020 | Machine Learning 101: Feature Extraction | Machine Learning 101: Feature Extraction | Have 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.
This seventh session in the series covered Extraction 101, and we learned about the methods to extract meaningful attributes from a large number of columns in datasets, explore Dimensionality Reduction and how it can be beneficial as a pre-processing for Machine Learning models.
Video Highlights 00:53 Oracle Machine Learning Office Hours - next Session 01:59 Machine Learning 101 - Feature Extraction 02:20 Feature Extraction 101 - Introduction 04:20 Feature Selection 06:28 Feature Extraction algorithms 08:25 Attribute Importance 10:05 Singular Value Decomposition (SVD) 11:24 Non-negative Matrix Factorization (NMF) 12:30 Intuition on NMF 15:10 Explicit Semantic Analysis (ESA) 15:47 Feature Extraction 101 Demo 19:32 Explore the data 18:18 Data used for the Demo 20:03 Basic visualization on the data 21:05 Build Attribute Importance (AI) model 23:30 Logistic Regression: Full Model vs. Feature Selection via AI 26:43 Build Singular Value Decomposition (SVD) model 30:00 Relationship between SVD feature vectors and attributes 33:16 Logistic Regression: Full Model vs. Feature Selection via SVD 34:55 Create Principal Components (PCA) projections for test data using the SVD model 35:55 Plot 3-D of top 3 attributes on original data vs. Projected PCA components 39:50 Build Non-negative Matrix Factorization (NMF) model via PL/SQL 41:45 Relationship between SVD feature vectors and attributes 43:20 Logistic Regression: Full Model vs. Feature Selection via NMF 44:44 Create NMF projections for test data using the NMF model 45:10 Plot 3-D of top 3 attributes on original data vs. Projected NMF features 46:54 Comparison with Build Logistic Regression using the built-in Feature Selection 49:20 Comparison with AutoML: Auto Algorithm Selection, Auto Feature Selection and Auto Tune for Logistic Regression 51:15 Q&A
Marcos Arancibia, Product Manager, Data Science and Big Data Mark Hornick, Senior Director, Product Management, Data Science and Machine Learning
|
December 17, 2020 | Consumiendo datos remotos en nuestras aplicaciones de APEX | Consumiendo datos remotos en nuestras aplicaciones de APEX | En esta sesión, Adrián Arguello nos mostrará como consumir datos de bases de datos remotas usando REST Enabled SQL y como utilizar este servicio para crear componentes nativos de APEX.
Adrián es Principal Solution Engineer en Oracle y está orientado en promover la transformación de las empresas mediante la innovación utilizando Oracle Cloud y Tecnologías Autónomas.
Joel Kallman, Senior Director, Software Development Mónica Godoy, Principal Product Manager
|
December 17, 2020 | Flows for APEX - Model & run process flows within APEX! | Flows for APEX - Model & run process flows within APEX! | Flows for APEX is an open source solution enabling you to design and run process flows within your APEX application. This was developed by expert members of the Oracle APEX community, and it has quickly evolved into a functionally rich process modeling solution.
In this special edition of Oracle APEX Office Hours, we will be joined by the creators of Flows for APEX, where they will present and demonstrate the latest version 5 of Flows for APEX.
Learn more here: https://apex.mt-ag.com/en/flowsforapex
Joel Kallman, Senior Director, Software Development Marc Sewtz, Director of Software Development
|
December 14, 2020 | Oracle Cloud Coaching: Networking and Connectivity | Oracle Cloud Coaching: Networking and Connectivity | Cloud Coaches are highly skilled solution engineers ready to assist you in your Oracle Cloud development journey.
Cloud Coaching Office Hours provides a way for you to get your questions answered. The schedule is as follows:
- Learn about a tip or best practice - Ask a question - Pre-submit your questions to cloudcoach_us_grp@oracle.com or ask during the office hours - Learn how to get additional help for your organization.
In this session, learn how to set up a virtual cloud network with firewall rules and communication gateways that you can choose. Highly skilled solution engineers will show you how to:
- Define public or private subnets within your VCN - Add virtual routers to control traffic flow to outside destinations - Secure your cloud network and compute instances
Mark Smith, Manager, Cloud Engineering
|
December 9, 2020 | Database In-Memory Duplicate Feature | Database In-Memory Duplicate Feature | AskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. In this session we will explore the Database In-Memory DUPLICATE feature with Andy Rivenes (@TheInMemoryGuy) and a special guest from Oracle Database devlopment, Jesse Kamp. Jesse is an Architect in the Database In-Memory development group and has been part of Database In-Memory since the beginning of the product. This will be a great opportunity to learn about the DUPLICATE feature and ask any questions you have about Database In-Memory.
Andy Rivenes, Product Manager Maria Colgan, Master Product Manager
|
December 9, 2020 | What’s New in Oracle Spatial Studio 20.1 | What’s New in Oracle Spatial Studio 20.1 | Want to learn about the latest features in this release to help you create interactive maps and perform spatial analysis on your data? In this session, we will present and demonstrate some of Spatial Studio’s new capabilities like simplified data uploading, GeoRaster visualization, 3D city model and point cloud visualization, new Spatial Analytics category, and access token support.
Find out how to get the most out of this self-service application for visualizing and analyzing spatial features in Oracle Database without writing any code.
Carol Palmer, Senior Principal Product Manager Jean Ihm, Product Manager LJ Qian, Director of Software Development
|
December 1, 2020 | PL/SQL: The Good Parts | PL/SQL: The Good Parts | Morten Braten will close out a year of PL/SQL Office Hours sessions presenting his favorite aspects of this wonderful database programming language.
"In a world where programming languages and frameworks come and go, I like the simplicity and stability of PL/SQL. I have worked with it for over 20 years, and I still have code that was originally written for Oracle 7 that runs happily in production to this day. If used properly and to its full capability, PL/SQL is a powerful, elegant and fun tool. Let's see how..."
Steven Feuerstein, Developer Advocate for PL/SQL Morten Braten, Systems Architect and Owner, Educatia AS
|
November 27, 2020 | Creating and Utilizing Custom Templates in Oracle APEX | Creating and Utilizing Custom Templates in Oracle APEX | Oracle APEX templates are centralized, declarative, reusable and customizable components. Universal Theme provides a variety of templates including Classic report ( Alerts, Badge List, Cards, Comments, Search Results, Timeline), Interactive report, and Interactive Grid. Developer can create new and customize existing ones to make more user loving. In this session, Ashish will walk you through different templates and demo how to customize to fit your specific needs.
Ashish Sahay is a passionate APEX developer, frequent blogger and an Oracle ACE associate. He is an active contributor to apex.world for various open-source plugins. Founder of Ontoor solutions, where you can find great learning stuff, list of blogs ( Rated content) people writing around the world, Open source Projects and queries. Twitter: @imapexianashish
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
|
November 26, 2020 | Integrando los servicios REST a nuestras aplicaciones APEX | Integrando los servicios REST a nuestras aplicaciones APEX | En esta sesión , Adrián Arguello nos mostró como crear y consumir servicios con Oracle Rest Data Services (ORDS) y Oracle APEX en un primer demo. En la siguiente sesión se mostrará el segundo demo.
La presentación la encuentran en https://www.slideshare.net/adrianarguello/integrando-los-servicios-rest-a-nuestras-aplicaciones-apex
Joel Kallman, Senior Director, Software Development Mónica Godoy, Principal Product Manager
|
November 24, 2020 | How to Use SQL Plan Baselines and SQL Profiles | How to Use SQL Plan Baselines and SQL Profiles | The Oracle optimizer has many tools and tricks for finding the best plan for each query. But in some cases, it may struggle to find a fast plan. Luckily Oracle Database has many tools to help the optimizer pick a good plan for each query.
This session gives an overview of plan baselines and profiles to assist the optimizer. It shows you how they work, explains the differences between them and why you would use one over the other.
Highlights of this session include:
01:20 - SQL Profiles, how to create them, why, and what they are 05:00 - SQL Plan Management and baselines, how to create them, why, and what they are 07:30 - SQL Profiles alternative usage - tricks to constraint SQL plans 11:00 - Licensing for SQL Plan Management 12:25 - Using SQL baselines when migrating databases 14:00 - Why should you avoid hints in SQL? 19:15 - Evolving plans with SQL plan management 22:30 - Demo showing how to create SQL Profiles and SQL Baselines and how they're different 29:08 - Using SPM with Real Application Testing 31:00 - Dealing with large data changes 34:10 - Using SQL Profiles and SQL Plan Baselines together 38:20 - Dealing with variable numbers of bind variables for an IN list (e.g. IN (:b1, :b2), IN (:b1, :b2, :b3) 40:30 - How many SQL plan baselines can you have? 42:35 - Managing profiles when changing the columns in a table 45:25 - Using SPM on a few SQL statements 47:05 - Using SPM with Database In-Memory 48:50 - Using SPM on overloaded databases 50:40 - How to get in touch with Nigel with your SPM questions 52:00 - Final recap and comparison
Chris Saxon, Oracle Developer Advocate for SQL Nigel Bayliss, Optimizer Product Manager
|
November 20, 2020 | RMAN backup validation: are your backups ready for recovery? | RMAN backup validation: are your backups ready for recovery? | This session reviewed techniques available in RMAN to ensure that backups are valid. Building these steps into regular operations is critical to ensure you are ready for database recovery. Also highlighted is the Zero Data Loss Recovery Appliance ability to automate these RMAN techniques, reduce production database resource overhead, and provide real-time reporting.
Kelly Smith, Senior Principal Product Manager Marco Calmasini, Senior Principal Product Manager Tim Chien, Senior Director of Product Management
|
November 19, 2020 | Super Easy Report Printing in Oracle APEX 20.2! | Super Easy Report Printing in Oracle APEX 20.2! | In the Oracle APEX 20.2 release, there have been substantial improvements made in support of printing and native data export. This includes Built-in PDF printing and Excel download, APIs to programmatically generate PDF, CSV, Excel, HTML, JSON and XML files, more language support, and even enhanced integration with BI Publisher and the printing capabilities of Oracle Analytics Cloud. In this session, the product developer and architect of these features, Menno Hoogendijk, will present and demonstrate all of these rich capabilities.
Joel Kallman, Senior Director, Software Development Marc Sewtz, Director of Software Development Menno Hoogendijk, Principal Member of Technical Staff
|
November 19, 2020 | Answering all of your questions | Answering all of your questions | In this Office Hours session we discussed:
- How to compare large data sets efficiently - How to achieve massive performance even when you need to lock critical resources for serialisation - The anomaly of DML error logging versus triggers on the underlying tables - How to avoid SQL injection with the new SQL Macro features in 19c - Why pipelined functions might slow down even if the SQL within them is fast
Connor McDonald, Developer Advocate
|
November 17, 2020 | 19 Critical Features Customers Lose When the Leave the Oracle Database | 19 Critical Features Customers Lose When the Leave the Oracle Database | The Oracle database is the world's leading converged database for a variety of reasons, but the biggest is unique features critical to customer requirements, especially uptime and performance management, that only Oracle has. In this talk, Franck Pachot describes 19 features customers lose when they leave the Oracle database.
As always, we start with announcements, then move into a technical presentation and then open the lines for your questions related to the Oracle database including features, use cases, best practices, and more. The sessions are recorded and the recordings are usually available a few days after the session is held.
Franck Pachot, Principal Consultant & Database Evangelist Matthew OKeefe, Senior Corporate Technologist
|
November 16, 2020 | Oracle Cloud Coaching: Identity and Access Management | Oracle Cloud Coaching: Identity and Access Management | In this session, learn how to set up consistent identity enforcement and manage employee, partner, and consumer access to cloud resources with Oracle Identity and Access Management. Highly skilled solution engineers will show you how to:
• Log in and navigate through the web console • Configure users and groups • Create compartments and Policies
Pre-submit your questions to cloudcoach_us_grp@oracle.com
Mark Smith, Manager, Cloud Engineering
|
November 14, 2020 | 12 ميزة تدفعك لترقية إصدارتك القديمة من أوراكل أبيكس الآن! | 12 ميزة تدفعك لترقية إصدارتك القديمة من أوراكل أبيكس الآن! | يعد الأوراكل أبليكيشن إكسبريس (أبيكس) منصة منخفضة الشيفرة تمكنك من إنشاء تطبيقات مذهلة مرنة وآمنة ، مع ميزات عالمية المستوى ، يمكن نشرها في أي مكان. انضم معنا إلى مطوري أبيكس ومديري المنتجات للتدريب والتعليمات ، حتى تتمكن من تحقيق أقصى استفادة من هذه الأداة المدهشة!
في هذه الحلقة الخاصة يستعرض سليم هليّل 12 ميزة وسببا تدفعك لترقية إصدارتك القديمة من أوراكل أبيكس والترقية إلى الإصدارة 20.2
لتبقى على تواصل مع سلسلة أبيكس بالعربي يرجى الضغط على "اشترك" في أعلى هذه الصفحة ومن ثم "الدخول للاشتراك".
00:11 المقدمة 04:27 New Cards Region - قسم البطاقات 25:44 Redwood UI - واجهة ريدوود 28:32 Automations - الأتمتة 35:23 Faceted Search Enhancements - تحسينات البحث متعدد الأوجه 42:52 Report Printing - طباعة التقرير 50:06 REST Data Source Synchronizations - تزامن مصدر بيانات نقل تمثيل الحالة 53:01 REST Data Source Connector Plug-ins - إضافات برمجية لمصادر نقل تمثيل الحالة 57:22 New Web Credential Types - أنواع اعتمادات ويب جديدة 57:49 Developer Experience - تجربة المطور 59:21 New and Improved Items - عناصر جديدة ومحدثة 1:00:33 Miscellaneous - متنوعات 1:01:14 JavaScript Library Upgrades - تحديثات مكتبات الجافاسكريبت 1:01:29 Desupported Features - المزايا الغير مدعومة 1:03:27 الخاتمة
Joel Kallman, Senior Director, Software Development Salim Hlayel - سليم هليّل, Principal Product Manager for Oracle Application Express (APEX) مدير منتج رئيسي - أوراكل أبليكيشن إكسبريس
|
November 12, 2020 | Security Basics - Passwords and the Oracle Database | Security Basics - Passwords and the Oracle Database | In this session we focused on passwords, including how to control the strength of passwords, how they are stored in the database, how database clients use passwords to authenticate to the database, and how to securely change a password or create a user with a password.
Slides for this presentation are available at: https://oradocs-prodapp.cec.ocp.oraclecloud.com/documents/link/LD4A0AB9812EF0ABBB6CD3B97C3AED9B5641AEFFD193/fileview/DFA9FCB4F38C5090A8980D84885AC896FF99C3770277/_AskTom_20201112_Passwords.pptx
Here is a guide to the recording; 01:25 Product Announcements - October CPU, Data Safe update, Audit Vault and Database Firewall 20.2, and Oracle Live Labs 09:30 Database authentication options 12:10 Controlling password strength 22:57 Managing password storage and hashing algorithms 36:27 Protecting passwords over the network 38:51 Safely changing a user's password 42:22 The secure way to create a database user
Alan Williams, Database Security Product Manager Hakim Loumi, Product Manager/Field Engineer - Database Security Russ Lowenthal, Senior Director of Database Security Product Management
|
November 10, 2020 | Time zone file upgrade | Time zone file upgrade | In the November session, we continued the discussion about datetime handling in the Oracle Database that we started in the October session. In particular, we went through the process of updating the time zone file version. Before viewing the recording for November session, we recommend watching the October session to learn the background of the time zone file upgrade issues.
Sergiusz Wolicki, Database Globalization Architect Weiran Zhang, Director of Development
|
November 10, 2020 | Tips for Analyzing PL/SQL Code | Tips for Analyzing PL/SQL Code | How do you deal with PL/SQL code maintenance and code analysis ? An effective code management strategy emphasizes code tracing, profiling, testing and reporting. In this session, Shashank Bark returns to offer best practices and useful techniques to analyze PL/SQL code using various data dictionary views, initialization parameters, and built-in packages.
1. Tracking exceptions in PL/SQL code 2. Tracing and generating reports on PL/SQL source code using DBMS_METADATA package 3. PL/Scope toola 4. Getting the most out of DBMS_UTILITY.FORMAT_CALL_STACK
Shashank Barki, Senior Principal Data Engineer Steven Feuerstein, Developer Advocate for PL/SQL
|
November 8, 2020 | Exploring Oracle APEX APIs | Exploring Oracle APEX APIs | Oracle APEX Pakistan Community
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, Shoaib Ahmed will expose some of the APIs that come with Oracle APEX and how to use them.
Join us to directly hear from them about their experience with Oracle APEX.
00:11 Introduction by Salim Hlayel 02:11 Intro and Topics by Shoaib Ahmed 03:21 What is an API? 03:47 APEX_AUTOMATION 25:54 APEX_COLLECTION 34:41 APEX_WEB_SERVICE.MAKE_REST_REQUEST 40:51 APEX_UTIL.GET_SINCE 45:44 APEX_UTIL.PREPARE_URL 51:44 Conclusion
Joel Kallman, Senior Director, Software Development Salim Hlayel - سليم هليّل, Principal Product Manager for Oracle Application Express (APEX) مدير منتج رئيسي - أوراكل أبليكيشن إكسبريس
|
November 5, 2020 | Machine Learning 102: Clustering | Machine Learning 102: Clustering | Have 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.
This sixth session in the series covered Clustering 102, where we learn more about the methods on multiple dimensions, how to compare Cluster techniques, and explore Dimensionality Reduction and how to extract only the most meaningful attributes from datasets with lots of attributes (or derived attributes).
Session highlights: 00:39 Oracle Machine Learning Office Hours - next Session 01:28 Machine Learning 102 - Clustering 02:00 Clustering 102 - Demo Introduction 03:25 Dataset for Demo 03:45 Dataset view 04:40 2-D visualization of subset of Dataset 06:40 k-Means model demo build with k=2 clusters 08:10 k-Means cluster prediction 09:15 k-Means prediction visualization in 2-D and 3-D 11:20 Identify Attributes that explain the prediction for cluster 13:15 Elbow Method to identify ideal number of clusters for k-Means 15:45 Function to build, score and plot k-Means clusters 16:49 Visualizing k-Means from k=2 to k=7 in 3-D 18:05 O-Cluster algorithm demo 21:45 Materializing OML4Py proxy object to a Database table 23:21 O-Cluster model build using PL/SQL 24:55 O-Cluster model settings and attributes 25:45 O-Cluster model views 27:52 O-Cluster cluster prediction 29:20 O-Cluster prediction visualization in 2-D and 3-D 32:00 Expectation-Maximization clustering demo introduction 33:10 E-M clustering model build 37:43 E-M clustering scoring and Attribute Importance 38:13 Identify Attributes that explain the prediction for cluster 39:14 Create a function to build, score and plot an E-M clustering model 39:38 Several E-M clustering results using several available settings 41:20 E-M clustering with Model Search Enable 45:19 E-M clustering models and model views 47:10 E-M clustering scoring via Python and SQL 50:55 Q&A
Marcos Arancibia, Product Manager, Data Science and Big Data Mark Hornick, Senior Director, Product Management, Data Science and Machine Learning
|
November 3, 2020 | Hands on Lab: Extending APEX Applications with Autonomous Database | Hands on Lab: Extending APEX Applications with Autonomous Database | The 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
|
October 29, 2020 | Spend Less Time Debugging Code with ML-based Log Analytics | Spend Less Time Debugging Code with ML-based Log Analytics | Let’s face it. You love to code but debugging pesky problems is always in the way. Join us in this session to learn how to identify business flows that are behaving abnormally and use machine learning techniques, including pattern recognition, trend analysis, cluster compare and links, among others, to quickly troubleshoot code defects and application performance issues. Speaker: Zubair Ansari, Director of Product Management, Oracle Cloud Observability and Management Platform
Marcie Samuelsen, Developer Marketing Manager
|
October 29, 2020 | Modernización de Oracle Forms a Oracle APEX | Modernización de Oracle Forms a Oracle APEX | En esta sesión tuvimos un panel de expertos en proyectos de modernización donde discutimos:
- Los beneficios que brinda APEX para la modernización de Forms. - Los retos que pueden presentarse. - Mejores prácticas. - Herramientas propias que han desarrollado para agilizar la modernización o para estimar los costos del proyecto.
Enlaces Compartidos en la Sesión:
Nueva versión de APEX disponible: 20.2 https://blogs.oracle.com/apex/announcing-oracle-apex-202
#APEXHACK20 https://www.insuminsider.com/apexhack20
Serie de Artículos sobre la Modernización de Oracle Forms a Oracle APEX: http://bit.ly/BPFormsToAPEX Aplicación Final: http://bit.ly/ModernizingFormsToAPEX
Proyecto de migración de Forms a APEX: https://github.com/franklingjr/oracle-forms-migration
Sesiones Relacionadas: Consejos prácticos para proyectos de modernización de Forms: https://www.youtube.com/watch?v=cs-VeTQU8hc&t=681s
Convirtiendo Forms a Apex sin morir en el intento: https://www.youtube.com/watch?v=B-kXZNqZeQE
Joel Kallman, Senior Director, Software Development Mónica Godoy, Principal Product Manager
|
October 29, 2020 | Graph Analytics Using the Python API | Graph Analytics Using the Python API | Graph analytics is a powerful tool to analyze your data based on connections and relationships between data entities. With the new Python API in Oracle Graph Server and Client 20.4 you can use Python to access the rich features available with property graph support in Oracle Database. You create a graph from database tables, run PGQL graph queries, analyze the graph with over 50 pre-built graph algorithms, and more. We will demo this new API and show how this can be used with popular data science tools like Jupyter Notebook.
Jean Ihm, Product Manager Melli Annamalai, Senior Principal Product Manager Ryota Yamanaka, Regional Product Manager, Spatial and Graph
|
October 28, 2020 | Database In-Memory Pushing Down into Scans | Database In-Memory Pushing Down into Scans | AskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. This session will explore how Database In-Memory is able to perform function-based aggregations, filter predicates and single table group bys during the scan of the data. This is very different from the way the row store works and is another example of how Database In-Memory achieves orders of magnitude performance gains for analytic queries. Join Andy Rivenes (@TheInMemoryGuy) and Database In-Memory developer Allison Holloway for some examples and discussion of how this works and how to tell if you're getting benefits.
Andy Rivenes, Product Manager Maria Colgan, Master Product Manager
|
October 28, 2020 | Oracle Machine Learning for R: An Introduction | Oracle Machine Learning for R: An Introduction | Join us for a look at Oracle Machine Learning for R (OML4R) – the R interface to in-database machine learning and R script deployment from Oracle. R is the top statistical programming language for data science and computational statistics.
OML4R enables you to work with database tables and views using familiar R syntax and functions. For scalable and performant data exploration, data preparation, and machine learning, leverage Oracle Database as a high performance compute engine. Build machine learning models using parallelized in-database algorithms using R Formula-based specification.
Invoke user-defined R functions from SQL for deployment in applications and dashboards, where R engines are dynamically spawned and controlled by Oracle Database. Even take advantage of running your R functions in a data-parallel and task-parallel manner.
We’ll include a demonstration of OML4R that takes us through the transparency layer, in-database machine learning, and embedded R execution functionality.
Video highlights: 01:08 Oracle Machine Learning Office Hours - next Session 02:24 Oracle Machine Learning for R: an Introduction 03:40 Machine Learning Pain Points 04:06 Oracle Machine Learning 05:16 Oracle Machine Learning for SQL 06:11 Traditional Analytics and data source interaction 07:35 Oracle Machine Learning for R 09:45 Proxy objects 10:25 Data types 10:56 OML4R Algorithms 11:35 Scalable Data Analysis - Model Building 14:06 Demo - OML4R Tour in RStudio 18:15 Demo - OML4R overloaded dplyr 18:49 Demo - OML4R Join Data tables 19:50 Demo - OML4R overloaded graphic functions 20:17 Demo - OML4R Machine Learning classification 23:20 Demo - OML4R Embedded R execution 25:13 Demo - OML4R Embedded R execution from SQL Developer 29:34 Demo - OML4R groupApply 31:20 R Consortium 32:07 Why Oracle for Machine Learning with R? 33:35 Q&A
Marcos Arancibia, Product Manager, Data Science and Big Data Mark Hornick, Senior Director, Product Management, Data Science and Machine Learning
|
October 22, 2020 | RoCE 101: RDMA over Converged Ethernet | RoCE 101: RDMA over Converged Ethernet | Wondering about RDMA over Converged Ethernet? Join us as Craig Brown tells us what Oracle learned from incorporating RoCE into a high-performance engineered system. Craig will discuss what RoCE is; how it improves performance, availability, and security; and what's next in networking advances. Craig is the head of Exadata Systems Development, Integration and Program Management at Oracle Development.
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!
Craig Brown, Senior Director and Exadata Program Manager Cris Pedregal, Senior Technologist Gavin Parish, Senior Principal Product Manager
|
October 22, 2020 | What's new in APEX 20.2 | What's new in APEX 20.2 | There are many new features coming in APEX 20.2. In this session, we will present and demonstrate the marquee features of this latest release.
Joel Kallman, Senior Director, Software Development Marc Sewtz, Director of Software Development
|
October 22, 2020 | Data loading, Hakan factor, Scheduler Timezones and more | Data loading, Hakan factor, Scheduler Timezones and more | In this Office Hours session we discussed loading data without suffering an out, understanding the scheduler timezones, and using the little known Hakan factor to improve the space utilisation of workflow style database tables.
Connor McDonald, Developer Advocate
|
October 20, 2020 | Getting Started with JSON Document Collections in the Autonomous JSON Database | Getting Started with JSON Document Collections in the Autonomous JSON Database | In this session, I’ll introduce you to the Autonomous JSON Database (AJD). AJD is exciting because it represents the very first time we are offering a dedicated solution for JSON document collection persistence in the Oracle Cloud. It represents our commitment to offering developers tools and solutions that help them solve the problems they face when developing microservices and applications instead of trying to convince them to use a tool that might not be the best fit for them. Like all good solutions, it is scalable and adaptable which means that it can transform into a full-blown Autonomous Transaction Processing database if your needs dictate that in the future. We’ll get hands on in this session and I’ll show you how to launch a new AJD instance and immediately persist and retrieve JSON documents and collections via SQLcl. I’ll also show you how to use the SODA module for Node.JS to work with your AJD instance. Of course, you’re not limited to just Node.JS - we also offer SODA packages for Java, Python, C, REST and PL/SQL so you can choose the package that best fits your needs.
Todd Sharp, Developer Advocate
|
October 20, 2020 | Create Drive Time Areas and Perform Drive Time Distance Analysis | Create Drive Time Areas and Perform Drive Time Distance Analysis | Want to find the nearest pizza place, check if all homes in the city can be reached by fire stations within 10 minutes, or understand the market areas covered by store locations? Drive time/drive distance analysis can answer these and many more business planning questions. For example, defining a trade area requires accurate estimations of travel time and distance of customers to-and-from business location(s).
In this session, you'll learn how to conduct large-scale drive distance/drive time analysis using the Network Data Model (NDM), a part of Oracle Database spatial features. We'll show how to generate network buffers from NDM data models and how to perform queries on them. We'll discuss some use cases of network buffers on trade area analysis and geofencing. We'll also talk about finding the nearest point of interest (a restaurant, a convenience store, or a gas station) in a location-based service and discuss vehicle deviation detection in fleet management to ensure a driver follows a planned route.
Carol Palmer, Senior Principal Product Manager Jack Wang, Director of Software Development - Spatial and Graph Xiangtai Hou, Senior Member of Technical Staff
|
October 20, 2020 | Finding the Longest Common Substring and Gestalt Pattern Matching | Finding the Longest Common Substring and Gestalt Pattern Matching | In this session Stew Ashton joins Chris Saxon to discuss a recent question on Ask TOM: implementing the Ratcliff-Obershelp similarity algorithm to rank how similar two strings are.
This works by recursively finding common substrings in the source words. Stew and Chris discuss how to do this using SQL and PL/SQL, comparing the performance of various solutions to find the fastest method.
The winner may surprise you (hint it's not SQL).
Chris Saxon, Oracle Developer Advocate for SQL Stew Ashton,
|
October 15, 2020 | Moving Logs with Oracle Service Connector Hub | Moving Logs with Oracle Service Connector Hub | Enterprise customers need the ability to move, mask, filter and validate data i.e. Logs, Metrics, Stream messages, etc. in near real time from many Oracle Cloud Infrastructure services to destination sinks like Object Storage, Streaming, Monitoring for additional processing or compliance storage needs. In addition, Developers need the ability to build event driven applications which react to these events or messages, process the data to take actions in near real time via target services like Functions (for custom processing) and Notifications. In this webinar, we will demonstrate how the Service Connector Hub addresses the above needs, specifically in the context of Observability by moving logs from the Logging Service to Oracle Cloud Infrastructure services such as Object Storage, Streaming, Monitoring, Functions and Notifications for the purposes of archival, integration with 3rd party tools for running analytics, alarming in near real-time, lightweight data transformations and notifications.
Vimal Kocherla is the Product Manager for the OCI Service Connector Hub.
Marcie Samuelsen, Developer Marketing Manager
|
October 15, 2020 | Ingest, Analyze, and Manage Your Logs with OCI Logging | Ingest, Analyze, and Manage Your Logs with OCI Logging | Learn how to get started with OCI Logging!
OCI Logging is natively integrated with your OCI resources to provide you a centralized view for all your logs – Infrastructure, Audit, Application, and Database. Logging lets you to ingest and manage logs generated by your resources and applications. You can use the powerful analytics engine to search and analyze logs, and use the intuitive rules engine to act in near real-time on any log event.
Mohamed Sleem is a Product Manager in the OCI Observability team where he is responsible for shaping the long-term roadmap & strategy for OCI Logging, Events, Audit, and SIEM. He joined OCI in October 2018, and was previously a Product Manager in Azure. He has also previously been in Product Manager roles working on Search, Indexing, and Analytics technologies in products such as Bing and Microsoft Office.
Marcie Samuelsen, Developer Marketing Manager
|
October 15, 2020 | Continuous Database Migrations with PL/SQL | Continuous Database Migrations with PL/SQL | Database migrations need to happen frequently to apply changes in database applications. Those migrations can be small, like adding new objects or changing some procedures or functions. Migrations can also be more extensive, like migrating large tables. In both cases, the database migrations need to be robust and repeatable if something goes wrong. In this PL/SQL Office Hours, we will explore practices to ensure high quality in your PL/SQL database migrations. We will have a look which elements make your database migrations repeatable and give an introduction on how to get started with automated database migrations if you have never done any before.
Highlights
00:00 Introduction from Steven 02:10 Overview of database migrations 06:24 challenges with deployments 10:18 Team performance and delivery 12:37 Characteristics of good migrations 17:49 Maximizing automation of deployments 21:50 Q&A deployment vs migration, release every day?, ebr 25:03 Code for repeatable and non-repeatable database objects 27:26 Migrating tables 36:05 Requirements for migration scripts 38:50 Use an existing logging framework! 40:13 Q&A: Recompile invalid objects after migration; 24x7 shop should use EBR; rely on flashback for undo; CI/D tools
Jasmin Fluri, Data Engineer Steven Feuerstein, Developer Advocate for PL/SQL
|
October 15, 2020 | Oracle APEX India: Email Templates in Oracle APEX | Oracle APEX India: Email Templates in Oracle APEX | This Office Hours focused on Email Templates in Oracle APEX. Oracle APEX comes with many pre-loaded email sample templates. Developers can use these to build from and they indeed save a lot of development time. Ajay explained about email template options and demonstrated how to use them in your apps.
In the second part of the session, Srihari demonstrated how to leverage Email Templates framework for different requirements such as including images, conditional display of email content, including dynamic tabular data and more.
Demo App: https://github.com/hari639/apex-email-templates
00:36 - Intro by Chaitanya Koratamaddi 08:10 - Exploring Email Templates by Ajay Periwal 25:25 - Q/A 25:35 - Get the Most Out of Email Templates by Srihari Ravva 56:18 - Q/A
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
|
October 14, 2020 | RackWare Enables Container Migration to Oracle Cloud Container Engine for Kubernetes | RackWare Enables Container Migration to Oracle Cloud Container Engine for Kubernetes | RackWare, a leader in Cloud Migration and DRaaS, presents an important update to its product portfolio, adding support for Oracle Kubernetes Engine. Pre-existing Container/Kubernetes deployments can now be seamlessly moved to OKE. In addition to minimizing downtime during a Migration, other challenges addressed by RackWare’s new SWIFT solution include overcoming Container version/format mismatches and storage incompatibilities, and conversion to PaaS. This webinar covers the key features of SWIFT, including a live demonstration.
Gilson Melo, Director of Product Management Marcie Samuelsen, Developer Marketing Manager
|
October 13, 2020 | How Oracle stores datetime values and time zone file upgrades | How Oracle stores datetime values and time zone file upgrades | In this session, we talked about how Oracle stores datetime values in table columns. We looked at the internal storage format of DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, and TIMESTAMP WITH LOCAL TIME ZONE values. We discussed what time zone regions are and why we may need to update stored datetime values, if a new time zone file version is installed. In the next month, we will continue with description of the time zone file upgrade process.
Sergiusz Wolicki, Database Globalization Architect Weiran Zhang, Director of Development
|
October 8, 2020 | Virtual Lab - Extending your APEX App with Autonomous Database Features | Virtual Lab - Extending your APEX App with Autonomous Database Features | Build enterprise apps 20x faster with 100x less code.
You'll learn hands-on how you can extend your APEX applications with new functionality by leveraging the new features that the Autonomous Database brings.
Objectives
We will provision an ATP instance and create an APEX workspace and APEX application, and then add the following features to your APEX application:
- Geospatial functionality - Machine learning - Security
We'll go straight into these exciting topics and you'll be doing a lot of coding yourself in the exercises. Participants will get access to an Oracle Cloud Free Tier account.
To execute the lab you will need access to an Oracle Cloud Account.
Please provision your cloud account and ATP instance on the day before the workshop, the provisioning process will take approximately 10 minutes. During the sign-up process We advice to choose London South or Frankfurt as Cloud Home Region.
You can get your Oracle Cloud Free Tier Account clicking here: http://bit.ly/freetier_8oct NB. Please create your Oracle Cloud Free Tier Account before to join the workshop using the email address you used to register.
Here you can find Lab steps: https://bit.ly/oracle_APEX_labsteps
Priscila Iruela, Database Business Developement Victor Martin, Principal Cloud Engineer
|
October 8, 2020 | Auditing PostgreSQL and MongoDB with Audit Vault and Database Firewall | Auditing PostgreSQL and MongoDB with Audit Vault and Database Firewall | In this session we focused on the flexibility of Audit Vault and Database Firewall - with specific examples of auditing PostgreSQL, MongoDB, Azure SQL, and Oracle Rest Data Services (ORDS) with Oracle Audit Vault and Database Firewall. Using the collector framework, almost any audit source can be captured within the Audit Vault repository, and then used for reporting,analysis, and alerting.
Here is a guide to the recording; 01:50 Product Announcements - October CPU, Data Safe update, and Key Vault 18.5 05:40 Audit Vault and Database Firewall - Beyond Oracle 14:44 PostgreSQL 22:38 MongoDB 30:41 Custom JSON Audit Collection 38:35 Azure SQL - Managed Instance 43:25 REST audit collection 43:45 Oracle Rest Data Services (ORDS)
Angeline Janet Dhanarani, Principal Product Manager - Core Database Auditing, Audit Vault and Database Firewall Ashok Swaminathan, Sr. Director Product Management, Database Security Russ Lowenthal, Senior Director of Database Security Product Management
|
October 6, 2020 | Hands on Lab: Low Code Development with Autonomous Database | Hands on Lab: Low Code Development with Autonomous Database | Learn how to create an Autonomous Transaction Processing instance, create an APEX workspace, create an APEX application, create Database objects, use SQL Developer Web to access the data and view a data model.
Bo English-Wiczling, Director of Program Management, Application Express
|
October 4, 2020 | Modernize Forms Apps and Extend oracle SaaS ERP | Modernize Forms Apps and Extend oracle SaaS ERP | Oracle APEX Pakistan Community: Office Hours 2020 #2
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 two enthusiastic members of the APEX community in Pakistan covering the following featured topics:
* Modernize your Oracle Forms Applications with Oracle APEX by Gul Rahman. Gul will show us how to use PLSQL in Oracle APEX. If you are migrating from Oracle Forms, then this is a great session for you.
* Demo for extending your Oracle SaaS ERP system using Oracle APEX by Imran Shahzad. Imran will demonstrate extending the Oracle HCM SaaS system using Oracle APEX.
Join us to directly hear from them about their experience with Oracle APEX.
00:11 Introduction by Salim Hlayel 01:16 Oracle Forms Modernization Overview by Gul Rahman 06:42 Practical Demo of using PLSQL in Oracle APEX by Gul Rahman 30:16 Extending Oracle Cloud SaaS service Overview by Imran Shahzad 34:35 Practical Demo for Extending Oracle Cloud SaaS by Imran Shahzad 1:05:52 Conclusion by Salim Hlayel
Joel Kallman, Senior Director, Software Development Salim Hlayel - سليم هليّل, Principal Product Manager for Oracle Application Express (APEX) مدير منتج رئيسي - أوراكل أبليكيشن إكسبريس
|
September 30, 2020 | Practical approach to Cloud Native | Practical approach to Cloud Native | Many IT teams are considering adapting cloud native but often find it challenging to take the first steps as the technology landscape can be overwhelming as well as the starting point.
In this webinar we will discuss a practical approach to getting started with Kubernetes and Helm Charts, two central cloud native technologies.
Ettore Volpicelli, Head of Developer Marketing - Europe, Middle East and Africa Hassan Ajan, Principal Product Strategy Manager
|