Database Application Developer Newsletter Technical news, how-to articles, best practices, and more. ___
March 2022 News Highlights • Oracle Database World 2022 and Oracle CloudWorld 2022 announced • In-database machine learning for MYSQL HeatWave • Oracle Machine Learning for Python (OML4Py) new capabilities • Oracle NoSQL Database - new on-demand mode available • MySQL Heatwave Machine Learning • Low-code development with Oracle APEX • Latest best practices and how-to resources for Oracle Database |
|
|
|
Don't miss Oracle Database World 2022 April 26, 2022 - Americas | April 28, 200 - EMEA June 8, 2022 - JAPAC Get the most out of your data. Gain practical, technical knowledge from the experts and architects behind Oracle Database. The event will feature a track dedicated to AppDev - Learn how Oracle database technologies help you develop apps that are available, scalable, and secure. Developer experts will provide tips, insights, and guidance into Oracle’s converged database, Oracle APEX, Microservices, MySQL HeatWave, and more. |
|
|
|
Save the date: Oracle CloudWorld 2022 October 16–20, 2022, Las Vegas, NV Mark your calendar and plan on joining us in Las Vegas, NV. You can explore the latest technical innovation as well as get product demos, advanced best practices, training, and insights from Oracle experts. Subscribe to get the latest news about event registration, keynote speakers, sessions, and more. |
|
|
|
MySQL HeatWave—New Machine Learning Capabilities New in-database machine learning capabilities include everything you need to build, train, deploy, and explain machine learning models within MySQL Heatwave. It eliminates the need for a separate machine learning tool or service. |
|
|
|
Now available: Oracle Machine Learning for Python (OML4Py) on Oracle Database 19c & OML4Py "Universal" Client Oracle Machine Learning for Python (OML4Py) is the open source Python programming language and environment that you can operate database data at scale. OML4Py enables you to run Python commands and scripts for statistical analysis and machine learning on data stored in Oracle Database and Oracle Autonomous Database. |
|
|
|
New capabilities Now Python users can extend the power of Python when analyzing data using on-premises Oracle Database 19c instances on Linux. – Mark Hornick
Users can now connect to Oracle Database 19c and 21c from separate Python engines using a single client package from Linux 7 or 8-based Python instances. – Mark Hornick
Get started with OML4Py and Machine Learning |
|
|
|
Focused topic: New on-demand capacity in Oracle NoSQL Database Cloud Service Oracle NoSQL Database Cloud Service is the world’s easiest multi-model NoSQL database cloud service for document, columnar and key-value based workloads. It offers ACID transactions, serverless scaling, comprehensive security, and low pay-per-use pricing, including 100% compatibility with on-premises Oracle NoSQL Database. |
|
|
|
Get to know NoSQL Database Cloud Service and on-demand capacity An overview and short demo of the NoSQL Database Cloud Service, describing its ease of use, flexible data and transaction models, and ultra–low latency design – with Dave Rubin
An overview webinar covering the NoSQL Database’s flexible options – data model, pricing, deployment, API, and more – with Michael Brey, Tim Goh
Technical how-to article: On-demand capacity Step-by-step guide on how to an on-demand capacity table and modify an existing table to use on-demand capacity mode.
Get started with NoSQL Database Cloud Service A guide that walks you through the steps to write a simple Hello World application using the Oracle NoSQL Database Cloud Service.
Try NoSQL Database Cloud Services for free |
|
|
|
Technology announcements One of the most requested features is now available: the ability to create Autonomous Database VM clusters and Exadata Database VM clusters on a single Exadata Cloud@Customer infrastructure. - Ranganath Srirangapatna Ramachandra and Robert Greene
New version of Oracle Zero Downtime Migration, which moves Oracle |
|
|
|
Database workloads to Oracle Cloud, supporting various Oracle Database versions as the source and most Oracle Cloud Database Services as targets. - Ricardo Alonso Gonzalez Acuna |
|
|
|
March quiz Question Which of these terms are part of loop syntax in PL/SQL?
Possible answers: |
|
|
|
1. for 2. exit when 3. repeat until 4. while |
5. continue 6. raise 7. forall
|
|
|
|
Continue reading this newsletter to find out the correct answers! |
|
|
|
Focused Topic: Low-code development with Oracle APEX Oracle Application Express (APEX) is a low-code development platform. Using APEX, you can quickly build scalable, secure enterprise apps without being a technology expert and deliver sophisticated solutions.
Get to know APEX See APEX 21 in action with a live demo of the new maps region, Faceted Search, new Smart Filters, Auto Scale and Progressive Web Apps (PWA) – with Sharron Kennedy and Shakeeb Rahman |
|
|
|
Enhance your skillsets with LiveLabs Learn how to take advantage of Oracle APEX components to create a Shopping Cart App that can be run on any device out of the box.
Quickly develop and deploy a compelling application that solves real problems and provides immediate value using Oracle APEX on Autonomous Database.
Technical how-to Vanity URL Blog series to learn how to extend your Vanity URL configuration so it can serve multiple domains from the same Autonomous Database - Todd Bottger
Cool use cases
|
|
|
|
Meet the APEX expert: APEX App Creator Spotlight Meet Shelley McNeill from the National Centers for Environmental Information (NCEI), who built the HOMR app used to track and manage station data for climate change – with Justine Kavanaugh-Brown
Start building apps for free |
|
|
|
What’s new in database application development Oracle Database and Oracle Autonomous Database |
|
|
|
SQL and PL/SQL
Machine Learning, Graph, Spatial
Scripting
.NET
JSON and Autonomous JSON Database
DevOps
… And the correct answers to the Dev Gym quiz are: Choices 1, 2, 4, and 5. For further explanations, visit the quiz page (requires Oracle login). For more quizzes, visit the Oracle Dev Gym. |
|
|
|
Thought-provoking success stories A look into the underlying requirements and Oracle’s approach in rapidly building pandemic-scale systems that enabled the most important data collection effort in modern history.
Read Oracle customer success stories in Financial Services as well as discover how Oracle data management solutions can help financial services firms around the world to rapidly create financial applications, manage high-volume transactions, and analyze data in real-time for personalized banking, fraud detection, and process optimization. |
|
|
|
Get your hands dirty… for free! 1. Oracle Cloud Free Tier plus 30-day free trial 2. $300 in credits for Cloud services
Get hands-on experience on hundreds of Oracle solutions 24x7, for free on Oracle LiveLabs.
Learn, Write, and share SQL at a free interactive Oracle Live SQL site, built with Oracle APEX running on Oracle Database.
Build your Oracle technology muscles at the Oracle Dev Gym by taking workouts, quizzes and even entire classes on SQL, PL/SQL, database design, logic and more. |
|
|
|
Useful links to keep your skills sharp
|
|
|
|
|
