NYLXS - Free Software Events

Enhance your job skills, learn from some of the best Oracle professionals in the world. Join NYOUG!

New York Oracle Users Group

Get involved with other NYOUG professionals and gain valuable information from participation in these webinars, meetings, and other events!

Check Out The NYOUG Website

Online Learning Opportunities Abound

While in-person meetings and conferences have been canceled or postponed, there are many webinars, online "office hours" and virtual conferences being offered to provide a way to connect with the global Oracle community and get introduced to new products and features, learn new skills, and get your questions answered.

While we're practicing social distancing, why not take advantage of some of these opportunities to stay connected with the Oracle community, and please, stay safe.

NYOUG Webinars

Application UI Design in a Mobile Device World

Tuesday, September 22, 2020 12:00 noon - 1:00 pm EDT

Featured Speaker: Peter Koletzke

Mobile app design has raised the bar for the design of modern business applications. Business users now expect the speed and intuitiveness of mobile apps to be in the applications they run at work. In addition, modern business applications may need to support multiple display devices and their mobile capabilities such as orientation change.

This session examines why our application user interfaces using popular development environments--such as APEX, JET, MAF, MAX, VBCS/VB Studio, JavaScript, Java, ADF, or even Oracle Forms--need to comply with principles used in mobile apps. It then reviews standards available from sources such as Oracle Alta UI for guiding user interface design of new or existing applications so they fulfill expectations for device support and intuitiveness. The discussion includes the role of and principles used for the Oracle Redwood theme.

The presentation also shows examples that demonstrate mobile design principles, and it closes with suggesting resources for further study.

Click here for registration and more information

Let's Build An Automated Anomalous DB Activity Detector Using Machine Learning

Tuesday, October 13, 2020 12:00 noon - 1:00 pm EDT

Featured Speaker: Craig Shallahamer, OraPub

Developing new and adjusting existing monitoring rules in today's database environments is an impossible task. There are too many databases and highly dynamic workloads. Sure, you can survive. But I think we can do better and are being asked to do better. Machine learning (ML) systems are a fantastic solution because they can be trained to detect pre-existing patterns, new and even highly unusual patterns.

In this presentation I will demonstrate how you can build a simple machine learning system that will pull the most recent AWR sysmetric data from Oracle, build an unsupervised cluster model and then determine if the activity is highly unusual... anomalous.

To ensure you can easily do everything I do, I will use industry standard Python ML libraries and the industry standard Jupyter notebook. You can experiment with the demonstration materials "as is" and then use them to push your ML and anomaly detection knowledge deeper.

If you have ever wondered how ML can be applied in an IT environment, you don't want to miss this presentation.

After a brief machine learning introduction, in this presentation you will learn how to build a simple machine learning anomaly detection system focused on Oracle database activity. A key objective is for you to take the demonstration materials, run them yourself, and have fun exploring and learning!

Click here for registration and more information

Reverse Engineer Machine Learning To Develop Performance Monitoring Rules

Tuesday, October 27, 2020 12:00 noon - 1:00 pm EDT

Featured Speaker: Craig Shallahamer, OraPub

Tired of continuously adjusting your performance monitoring and alerting rules? How about using machine learning to create the rules instead! Sure, we can train a supervised ML model to recognize patterns of poor performance. But what if your IT department is not ready to embrace it?

A novel solution is to train a supervised machine learning model to recognize patterns of poor performance, but then extract the rules in plain English and then manually enter them into your existing monitoring and alerting platform. Is this possible? Yes it is! And, I will demonstrate how you can do this.

To ensure you can easily do everything I do, I will use industry standard Python ML libraries, the industry standard Jupyter notebook, AWR and support ticket data. You can experiment with the demonstration materials "as is" and then use them to push your ML and rule creation knowledge deeper.

After a brief ML introduction, we begin with learning how to build a supervised ML decision tree model using industry standard Python libraries, a Jupyter notebook, AWR and support ticket data. I'll show you where to get the data, how to load it into the model. Then, we'll focus on training and evaluating the model. Finally, I'll detail to how to extract and convert the ML "poor performance" model decision tree internals into rules that we can use in your existing monitoring and alerting systems.

Click here for registration and more information

ODTUG Webinars

Polymorphic Table Function Deep Dive

Part 2: Tuesday, September 22, 2020 12:00 noon - 1:00 pm EDT

Featured Speaker: Darryl Hurley, ImpleStrat Solutions

Introduced in Oracle 18, Polymorphic Table Functions (PTFs) are the next step in the evolution of table functions. They provide detailed PL/SQL access to the inner workings of SQL query functionality (parse, open, fetch, and close) to create flexible data access and control. This session will be presented in two parts and begins at the surface of PTFs but quickly delves into the details to give attendees everything they need to create effective PTFs.

Part 2: Click here for registration and more information

Oracle Enterprise Manager: Seven Robust Features to Put in Action

Thursday, October 8, 2020 12:00 noon - 1:00 pm EDT

Featured Speaker: Rakesh Nagdev, Datavail

Oracle Enterprise Manager (OEM) brings your Oracle deployments together in a single management, monitoring, and automation dashboard. Oracle developed this solution, so it offers deep integration with many of its technologies. The ease of integration, coupled with the support of both on-premise and cloud-based Oracle databases, allows it to fit into many enterprise infrastructures. Oracle Enterprise Manager can also monitor and manage non-Oracle databases, making it a cost-effective and central tool to manage IT environments with a mix of database platforms.

The single point of control is appealing for complex enterprise infrastructures, especially when they’re heavily invested in Oracle technologies. Out-of-the-box monitoring and reporting templates cover many common use cases, and simplifies the configuration of management automation for databases, applications, and more.

This presentation takes on a brief history of OEM and then does a deep dive into seven robust features organizations should consider implementing:

1. Intelligent Incident Compression (Smart Alerting)

2. Chief Job Support

3. Always-ON Monitoring

4. Notification Blackouts

5. System Broadcast

6. Export & Import Incident Rule Sets

7. Metric Enhancements

Click here for registration and more information

SQL and PLSQL with Relational Data and JSON

Tuesday, October 13, 2020 12:00 noon - 1:00 pm EDT

Featured Speaker: Darryl Hurley, ImpleStrat Solutions

JSON data is different from relational data. This means that things are different when accessing them via SQL and PLSQL. This session demonstrates what to be aware of when working with mixed JSON and relational data.

Click here for registration and more information

Ask TOM Office Hours

Click here for more information

or to subscribe to Ask TOM Office Hours

Write Great SQL : Explore SQL

Tuesday, September 15, 2020 9:00 am - 10:00 am EDT

DATE 2020-09-01

HANGOUT